public DataSet Create(Employee employee)
{
DataSet ds = new DataSet();
string message = "";
if (HttpContext.Current.Request.HttpMethod == "POST")
{
SqlConnection conn = EmpWS.GetDBInstance();
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "AddEmployeeReturnID";
cmd.Parameters.AddWithValue("@title", employee.title.ToString());
cmd.Parameters.AddWithValue("@first_name", employee.first_name.ToString());
cmd.Parameters.AddWithValue("@last_name", employee.last_name.ToString());
cmd.Parameters.AddWithValue("@designation", employee.designation.ToString());
cmd.Parameters.AddWithValue("@dob", Convert.ToDateTime(employee.dob));
cmd.Parameters.AddWithValue("@father_name", employee.father_name.ToString());
cmd.Parameters.AddWithValue("@department", employee.department.ToString());
cmd.Parameters.AddWithValue("@gender", employee.gender.ToString());
cmd.Parameters.AddWithValue("@spouse_name", employee.spouse_name.ToString());
cmd.Parameters.AddWithValue("@permanent_address", employee.permanent_address.ToString());
cmd.Parameters.AddWithValue("@temporary_address", employee.temporary_address.ToString());
cmd.Parameters.AddWithValue("@avatar_path", employee.avatar_path);
cmd.Parameters.AddWithValue("@created_at", DateTime.Now);
cmd.Connection = conn;
try {
object obj = cmd.ExecuteNonQuery();
message = "Record inserted successfully. ID = " + obj.ToString();
// Read the employee and return
string query = "SELECT * from employee WHERE id=" + obj.ToString();
SqlDataAdapter da = new SqlDataAdapter(query, conn);
da.Fill(ds);
}
catch (SqlException err) {
message = "Error inserting record:";
message += err.Message;
throw new Exception(message);
} finally {
conn.Close();
}
}
return(ds);
}
public DataSet Get(string column, string value)
{
SqlConnection conn = EmpWS.GetDBInstance();
DataSet ds = new DataSet();
string query = "SELECT * from employee";
if (column != "" && value != "")
{
query += " WHERE " + column + " LIKE '%" + value + "%'";
}
try {
SqlDataAdapter da = new SqlDataAdapter(query, conn);
da.Fill(ds);
} finally {
conn.Close();
}
return(ds);
}