Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

DAL in oracle

Answer Posted / guest



public List<EEmployeeDetails> GetDetails(int
intEmpId, DateTime fromDate, DateTime toDate, int
intPageNo, int intPageSize, out int intTotalRecords, string
strOrderBy)
{
List<EEmployeeDetails> ListDetails = new
List<EEmployeeDetails>();
intTotalRecords = 0;
try
{
using (OracleDataReader objReader =
DataClient.ExecuteReader(ConnectionString,
CommandType.StoredProcedure, PROCEDURE_GET, GetDetailParams
(intEmpId, intReconciledstatus, fromDate, toDate,
intPageNo, intPageSize, strOrderBy)))
{
while (objReader.Read())
{
EEmployeeDetails
objEEmployeeDetails = new EEmployeeDetails();
if (!string.IsNullOrEmpty(objReader
["Employee_ID"].ToString()))
objEEmployeeDetails.EMPLOYEEId =
Convert.ToInt32(objReader["Employee_ID"]);
if (!string.IsNullOrEmpty(objReader
["EMPLOYEE_NUMBER"].ToString()))
objEEmployeeDetails.EMPLOYEENumber
= (string)(objReader["EMPLOYEE_NUMBER"]);
if (!string.IsNullOrEmpty(objReader
["EMPLOYEE_DATE"].ToString()))
if (!string.IsNullOrEmpty(objReader
["AMOUNT"].ToString()))
objEEmployeeDetails.Amount =
Convert.ToInt32(objReader["AMOUNT"]);
if (!string.IsNullOrEmpty(objReader
["TOTAL"].ToString()))
objEEmployeeDetails.Total =
Convert.ToInt32(objReader
["TOTAL"]);

intTotalRecords = Convert.ToInt32
(objReader["TOTAL"]);

ListDetails.Add
(objEEmployeeDetails);
}
}

}
catch (Exception ex)
{
bool rethrow =
ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw ex;
}
}
return ListDetails;
}



///<summary>
///helper class for get details
///
/// </summary>
public static OracleParameter[] GetDetailParams(int
intEmpId, DateTime fromDate, DateTime toDate, int
intPageNo, int intPageSize, string strOrderBy)
{
OracleParameter[] sqlParams = null;
try
{
sqlParams = DataClient.GetCachedParameterSet
(ConnectionString, PROCEDURE_GET);
if (sqlParams == null || sqlParams.Length
== 0)
{
sqlParams = new OracleParameter[]
{
new OracleParameter(PARAM_ID,
OracleDbType.Int32),
new OracleParameter(PARAM_STATUS ,
OracleDbType.Int32),
new OracleParameter(PARAM_FROMDATE,
OracleDbType.Date),
new OracleParameter(PARAM_TODATE,
OracleDbType.Date),
new OracleParameter
(PARAM_RETURN,OracleDbType.Int32),
new OracleParameter(PARAM_REFCURSOR,
OracleDbType.RefCursor),
new OracleParameter(PARAM_PAGENUM,
OracleDbType.Int32),
new OracleParameter(PARAM_PAGESIZE,
OracleDbType.Int32),
new OracleParameter (PARAM_TOTALCOUNT,
OracleDbType.Int32),
new OracleParameter(PARAM_ORDERBY,
OracleDbType.Char)
};
DataClient.CacheParameterSet
(DataClient.CONN_STRING, PROCEDURE_GET, sqlParams);

sqlParams
[0].Direction=ParameterDirection.InputOutput;
sqlParams[0].Value = intEmpId;

sqlParams[2].Value = fromDate;
sqlParams[3].Value =
toDate;
sqlParams
[4].Direction=ParameterDirection.Output;
sqlParams
[5].Direction=ParameterDirection.Output;
sqlParams[6].Value = intPageNo;
sqlParams[7].Value = intPageSize;
sqlParams[8].Direction =
ParameterDirection.Output;
sqlParams[9].Value = strOrderBy;
}
}
catch (Exception ex)
{
var rethrow =
ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw ex;
}
}
return sqlParams;
}

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Write code to make an object work like a 2-d array?

895


Dear sirs, Hi, I would like to inform you that I want to perform a project using MLP neural network to recognize binary images containing three types of geometric shapes such as squares,rectangels and circles. Furthermore,each image includes only one geometric type. The output of network would be: '1' if the network detects square shape. '2' if the network detects rectangle shape. '3' if the network detects circle shape. '4' if none of these shapes detected. Would you please send me a matlab source code for this project? Your prompt reply would be so appreciated. regards,

2178


plzzzzzzzzz xplain this code import java.awt.*; import java.awt.event.*; //import java.awt.MenuItem.*; public class MenuForm extends Frame implements ActionListener { MenuBar mb=new MenuBar(); Menu m1=new Menu("Master"); Menu m2 =new Menu("Transactions"); Menu m3=new Menu("Queries"); Menu m4=new Menu("Reports"); Menu m5=new Menu("Daily/Weekly"); Menu m6=new Menu("Housekeeping"); Menu m7=new Menu("About"); Menu m8=new Menu("Utilities/Tools"); Menu m9=new Menu("exit"); MenuItem m11=new MenuItem("consumer master"); MenuItem m12=new MenuItem(""); MenuItem m13=new MenuItem(""); MenuItem m21=new MenuItem("New Connection"); MenuItem m22=new MenuItem("Refill Booking"); MenuItem m23=new MenuItem("Shop Delivery"); MenuItem m51=new MenuItem("Mrk Dlry"); MenuItem m91=new MenuItem("Quit"); /*MenuItem m131=new MenuItem(" "); MenuItem m132=new MenuItem(" "); MenuItem m134=new MenuItem(" ");*/ Font f=new Font("TimesRoman",Font.BOLD,16); Frame f1; public static void main(String args[]) { new MenuForm().setVisible(true); } public MenuForm() { super("Gas Agency Main Menu"); setSize(1280,800); setBackground(Color.lightGray); setLayout(null); setMenuBar(mb); /*m1.setFont(new Font("TimesRoman", Font.BOLD,16)); m2.setFont(new Font("TimesRoman", Font.BOLD,16)); m3.setFont(new Font("TimesRoman", Font.BOLD,16));*/ mb.add(m1); mb.add(m2); mb.add(m3); mb.add(m4); mb.add(m5); mb.add(m6); mb.add(m7); mb.add(m8); mb.add(m9); m1.add(m11); m1.add(m12); m1.add(m13); m2.add(m21); m2.add(m22); m2.add(m23); m5.add(m51); m9.add(m91); //m3.add(m31); /*m13.setEnabled(false); m13.add(m131); m13.add(m132); m13.add(m133); m13.add(m134); m13.add(m135);*/ setVisible(true); /*m11.addActionListener(this); m12.addActionListener(this); m13.addActionListener(this); m2.addActionListener(this); m3.addActionListener(this);*/ m21.addActionListener(this); m22.addActionListener(this); m23.addActionListener(this); /*m31.addActionListener(this); m131.addActionListener(this); m132.addActionListener(this); m133.addActionListener(this); m134.addActionListener(this); m135.addActionListener(this);*/ m51.addActionListener(this); m91.addActionListener(this); } public void actionPerformed(ActionEvent e) { /*if(e.getSource()==m11) { } if(e.getSource()==m12) { } if( (e.getSource()==m131) || (e.getSource() ==m132) || (e.getSource()==m133) || (e.getSource()==m134) || (e.getSource()==m135) ) { }*/ if(e.getSource()==m21) { NewConnection nc=new NewConnection (); nc.setVisible(true); this.dispose(); } if(e.getSource()==m22) { RefillBooking rb=new RefillBooking (); rb.setVisible(true); this.dispose(); } if(e.getSource()==m23) { ShopDelivery sd=new ShopDelivery(); sd.setVisible(true); this.dispose(); } if(e.getSource()==m51) { MarkDelivery mrk=new MarkDelivery(); mrk.setVisible (true); this.dispose(); } if(e.getSource()==m91) { this.dispose(); System.exit(0); } } }

2057


Is it possible to write JAVA program without including any of the packages,such as "import java.io.*"; bcoz I instantly wrote a code without "import..." statement and runned the program on command Line & it worked. the code is: class Person { String name; int age; Person(String s,int a) { name = s; age = a; } accept() { System.out.println(name+"Hi!!!!!"); System.out.println(age); } } class Demo { public static void main(Strings args[])throws IOException { String name = args[0]; int age = Integer.parseInt(args[1]); Person p = new Person(name,age); p.accept(); } }

2179


In LSMW , what does the following error mean and how to rectify it : Incorrect interface data for set 78 in method C . This error is occuring in idoc processing step of LSMW.

2644


You have been asked to install a servlet engine (tomcat, glassfish, etc.) for a companies servlets. Assuming the company has an existing web/DBMS server (which may or may not be on the same server), explain in detail how would you implement the development project and a deployment solution.

2609


How many digit have a Polaris 1995 300c.c. 2x4 nad how many have a Polaris 2007 300 c.c 2x4? And what site I can check this information???

2652


how to test the orientation of the layout in android.to note any changes in the ui design when change orientation

3002


Write a Program to truncate a given floating point value (e.g.16.25=16).

967


Write a Program to find the sum of digits of a given number until the sum becomes a single digit.

920


Hi, I want the code to fetch multiple rows in REXX using RLX and CURSOR. Can anyone help me?

2460


Write a Program to find the sum of digits of a given number until the sum becomes a single digit. (e.g. 12345=>1+2+3+4+5=15=>1+5=6)

898


1.Explain what happens to a session object when the browser associated with it is closed? 2.Explain how a session object is created and used. (Note: you are not required to provide the Java statements such as ‘getAttribute’)

2593


import java.awt.*; import java.awt.event.*; public class Agency extends Frame implements ActionListener { Label l1,l2,l3,l4; Button b1; TextField t1,t2; String s1,s2,s3,s4; public static void main(String args[]) { new Agency().setVisible(true); } public Agency() { super("Gas Agency Package"); setSize(1280,800); setBackground(Color.lightGray); setLayout(null); // setLayout(new BorderLayout()); t1=new TextField(20); t1.setBounds(440,150,200,30); t1.setBackground(Color.white); t2=new TextField(20); t2.setBounds(440,180,200,30); t2.setBackground(Color.white); t2.setEchoChar('*'); l1=new Label("Gas Agency Package"); l1.setBounds(400,30,300,50); l1.setFont(new Font("TimesRoman",Font.BOLD,25)); l1.setAlignment(Label.CENTER); l2=new Label("Enter your ID and Passoword"); l2.setFont(new Font("TimesRoman",Font.BOLD,20)); l2.setBounds(270,80,300,50); l3=new Label("Enter ID"); l2.setFont(new Font ("TimesRoman",Font.BOLD,20)); l3.setBounds(270,150,120,50); l4=new Label("Enter Passoword"); l2.setFont(new Font ("TimesRoman",Font.BOLD,20)); l4.setBounds(270,180,140,50); add(l1); add(l2); add(l3); add(t1); add(l4); add(t2); b1=new Button("Login"); b1.setBackground(Color.white); b1.setBounds(400,280,100,70); b1.addActionListener(this); add(b1); } public void actionPerformed(ActionEvent e) { if(e.getSource()==b1) { s3="svce"; s4="svce"; s1=t1.getText(); s2=t2.getText(); if(s1.equals(s3) && s2.equals(s4)) { //System.out.println("password is correct"); MenuForm m= new MenuForm(); m.setVisible(true); //this.dispose(); } else { System.out.println("password not correct"); } this.dispose(); } } } plzzzzzzz xplain me this java code like why i m including this packages n the whole code plzzzzzz

2465


i am doing my final year project about programming use verilog ,i am new about it so got problem,i want to record the readings of a waveform every 2us use the verilog code ,every ten readings i need to add them together after that i need to compare this series of number to get which one is the biggest , right now i don't know how to use code to store the readings every 2us on a waveform ,pls help me thanks a lot .

2139