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 PostEmployee(employee_manager _e) { employeeParameters e = new employeeParameters(); cmd.CommandText = "employee_recruit_insert"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue(e.Id, _e.p_Id); cmd.Parameters.AddWithValue(e.f_name, _e.p_f_name); cmd.Parameters.AddWithValue(e.m_name, _e.p_m_name); cmd.Parameters.AddWithValue(e.l_name, _e.p_l_name); cmd.Parameters.AddWithValue(e.qualification, _e.p_qualification); cmd.Parameters.AddWithValue(e.school, _e.p_school); cmd.Parameters.AddWithValue(e.intv_no, _e.p_intv_no); cmd.Parameters.AddWithValue(e.adr1, _e.p_adr1); cmd.Parameters.AddWithValue(e.adr2, _e.p_adr2); cmd.Parameters.AddWithValue(e.adr3, _e.p_adr3); cmd.Parameters.AddWithValue(e.st_no, _e.p_st_no); cmd.Parameters.AddWithValue(e.st_name, _e.p_st_name); cmd.Parameters.AddWithValue(e.city, _e.p_city); cmd.Parameters.AddWithValue(e.state, _e.p_state); cmd.Parameters.AddWithValue(e.pin, _e.p_pin); cmd.Parameters.AddWithValue(e.employment_type, _e.p_employment_type); cmd.Parameters.AddWithValue(e.interview_date, _e.p_interview_date); cmd.Parameters.AddWithValue(e.online_diary_no, _e.p_online_diary_no); cmd.Parameters.AddWithValue(e.dispatch_no, _e.p_dispatch_no); cmd.Parameters.AddWithValue(e.join_date, _e.p_join_date); cmd.Parameters.AddWithValue(e.dated, _e.p_dated); cmd.Parameters.AddWithValue(e.gen_applied_post, _e.p_gen_applied_post); cmd.Parameters.AddWithValue(e.gen_basic_pay, _e.p_gen_basic_pay); cmd.Parameters.AddWithValue(e.gen_pay_scale_level, _e.p_gen_pay_scale_level); cmd.Parameters.AddWithValue(e.gen_payscale, _e.p_gen_payscale); cmd.Parameters.AddWithValue(e.addhoc_net_salary, _e.p_addhoc_net_salary); cmd.Parameters.AddWithValue(e.addhoc_tenure, _e.p_addhoc_tenure); cmd.Parameters.AddWithValue(e.addhoc_from_date, _e.p_addhoc_from_date); cmd.Parameters.AddWithValue(e.addhoc_to_date, _e.p_addhoc_to_date); if (con.State != ConnectionState.Open) { con.Open(); } int r = cmd.ExecuteNonQuery(); con.Close(); return(r); }