public void getallemployee()
{
List<EmployeeAJAX> listemployees = new List<EmployeeAJAX>();
string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("select * from tblemployee", con);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
EmployeeAJAX employee = new EmployeeAJAX();
employee.ID = Convert.ToInt32(rdr["Id"]);
employee.name = rdr["name"].ToString();
employee.gender = rdr["gender"].ToString();
employee.salary = Convert.ToInt32(rdr["salary"]);
listemployees.Add(employee);
}
}
// This code returns the object in XML format if we want to return a JSO then make the following changes
/* we will not return from the function and hence set the return type to VOID */
JavaScriptSerializer js = new JavaScriptSerializer();
Context.Response.Write(js.Serialize(listemployees)); //and delete the return employee
// return employee; use this code in case u would like to send a xml object from teh webservice
}
public void addemployees(EmployeeAJAX emp)
{
string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("spinsertemployees", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@name",
Value = emp.name
});
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@gender",
Value = emp.gender
});
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@salary",
Value = emp.salary
});
con.Open();
cmd.ExecuteNonQuery();
}
}
public void getemployeebyid(int employeeid)
{
EmployeeAJAX employee = new EmployeeAJAX();
string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("spgetemployeebyid", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter parameter = new SqlParameter();
parameter.ParameterName = "@Id";
parameter.Value = employeeid;
cmd.Parameters.Add(parameter);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
employee.ID = Convert.ToInt32(rdr["Id"]);
employee.name = rdr["name"].ToString();
employee.gender = rdr["gender"].ToString();
employee.salary = Convert.ToInt32(rdr["salary"]);
}
}
// This code returns the object in XML format if we want to return a JSO then make the following changes
/* we will not return from the function and hence set the return type to VOID */
JavaScriptSerializer js = new JavaScriptSerializer();
Context.Response.Write(js.Serialize(employee)); //and delete the return employee
// return employee; use this code in case u would like to send a xml object from teh webservice
}