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;
}

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’)

2518

---

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

2391

---

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

2927

---

Could u please tell me any UNIX scripts that 'll lead to find the network latency of the servers.?or else any unix command to find the network latency of a server?Thnx in advance...

2147

---

Write code that allows to create only one instance of a class?

846

---

Write a program that implements a date class containing day, month and year as data members. Implement assignment operator and copy constructor in this class.

870

---

Write a program to Print the Pascal triangle

835

---

Write code to add functions, which would work as get and put properties of a class?

853

---

1.What type of material can be sent from a Java servlet to a browser ? How does the browser know how to deal with the material? 2.Explain what happens to a servlet when a servlet engine is sent a GET request.

2715

---

I have a file which contains so many lines and variable number of lines are treated as a record. For example *first ooooo xxxxx ttttt mmmm vvvvvvv *end uuu bbbb *first kkkkvvvvvv nnnn mmmmm kkkkk fffff gggg ffff kkkk lllll *end. Here the lines from *first to *end are treated as a record. The number of lines between *first and *end is not same for all the records. Suppose there are 100 records (or number of records are not predefined)like the format given in the above example. Now the entire file needs to split into two files, first having 40 and remaining in the second file. Can we split using sort utility? If possible then what is the sort card?

2150

---

How to get the version(major,minor,revision ) of VB6.0 delphi code .I am able to fetch dll file of vb6.0 but not vba file .Can u send me the code snippet in delphi to get the value for vb6.0.

3808

---

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.

2546

---

plzzzzzzzzz xplain this code 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(); } } } plzzzzzzzzz xplain this code

1909

---

Write a Program to find whether the given number is a Armstrong number.

827

---

Write a Program to find the number of words in a sentence.

880

---