public int DeleteEmployee(string id)
{
employeeParameters e = new employeeParameters();
cmd.CommandText = "employee_recruit_delete";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(e.Id, id);
if (con.State != ConnectionState.Open)
{
con.Open();
}
int r = cmd.ExecuteNonQuery();
con.Close();
return(r);
}
public int PutEmployee(employee_manager _e, string _id)
{
employeeParameters e = new employeeParameters();
cmd.CommandText = "employee_recruit_update";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(e.Id, _id);
cmd.Parameters.AddWithValue(e.f_name, _e.f_name);
cmd.Parameters.AddWithValue(e.m_name, _e.m_name);
cmd.Parameters.AddWithValue(e.l_name, _e.l_name);
cmd.Parameters.AddWithValue(e.qualification, _e.qualification);
cmd.Parameters.AddWithValue(e.school, _e.school);
cmd.Parameters.AddWithValue(e.intv_no, _e.intv_no);
cmd.Parameters.AddWithValue(e.adr1, _e.adr1);
cmd.Parameters.AddWithValue(e.adr2, _e.adr2);
cmd.Parameters.AddWithValue(e.adr3, _e.adr3);
cmd.Parameters.AddWithValue(e.st_no, _e.st_no);
cmd.Parameters.AddWithValue(e.st_name, _e.st_name);
cmd.Parameters.AddWithValue(e.city, _e.city);
cmd.Parameters.AddWithValue(e.state, _e.state);
cmd.Parameters.AddWithValue(e.pin, _e.pin);
cmd.Parameters.AddWithValue(e.employment_type, _e.employment_type);
cmd.Parameters.AddWithValue(e.interview_date, _e.interview_date);
cmd.Parameters.AddWithValue(e.online_diary_no, _e.online_diary_no);
cmd.Parameters.AddWithValue(e.dispatch_no, _e.dispatch_no);
cmd.Parameters.AddWithValue(e.join_date, _e.join_date);
cmd.Parameters.AddWithValue(e.dated, _e.dated);
cmd.Parameters.AddWithValue(e.gen_applied_post, _e.gen_applied_post);
cmd.Parameters.AddWithValue(e.gen_basic_pay, _e.gen_basic_pay);
cmd.Parameters.AddWithValue(e.gen_pay_scale_level, _e.gen_pay_scale_level);
cmd.Parameters.AddWithValue(e.gen_payscale, _e.gen_payscale);
cmd.Parameters.AddWithValue(e.adhoc_net_salary, _e.adhoc_net_salary);
cmd.Parameters.AddWithValue(e.adhoc_tenure, _e.adhoc_tenure);
cmd.Parameters.AddWithValue(e.adhoc_from_date, _e.adhoc_from_date);
cmd.Parameters.AddWithValue(e.adhoc_to_date, _e.adhoc_to_date);
if (con.State != ConnectionState.Open)
{
con.Open();
}
int r = cmd.ExecuteNonQuery();
con.Close();
return(r);
}
