internal DataTable DL_SearchEmployee(PL_AmendmentErDd plobj) { try { con = Connection.SetConnection(); cmd = new SqlCommand("AmendmentErDd", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Ind", plobj.Ind); cmd.Parameters.AddWithValue("@CityCode", plobj.CityCode); cmd.Parameters.AddWithValue("@Edcd", plobj.Edcd); cmd.Parameters.AddWithValue("@DesgCd", plobj.DesiCode); cmd.Parameters.AddWithValue("@DeptCd1", plobj.DeptCode); cmd.Parameters.AddWithValue("@Class", plobj.ClassCode); cmd.Parameters.AddWithValue("@EmpType", plobj.EmpType); cmd.Parameters.AddWithValue("@OldAmt", plobj.OldAmt); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); return(dt); } catch { return(dt); } finally { con.Close(); con.Dispose(); } }
internal DataTable DL_UpdateAmendmentErDd(PL_AmendmentErDd plobj) { try { con = Connection.SetConnection(); cmd = new SqlCommand("AmendmentErDd", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Ind", plobj.Ind); cmd.Parameters.AddWithValue("@CityCode", plobj.CityCode); cmd.Parameters.AddWithValue("@Empno", plobj.EmpNo); cmd.Parameters.AddWithValue("@Edcd", plobj.Edcd); cmd.Parameters.AddWithValue("@Month", plobj.Month); cmd.Parameters.AddWithValue("@NewAmt", plobj.NewAmt); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); return(dt); } catch { return(dt); } finally { con.Close(); con.Dispose(); } }
public DataTable SearchEmployee(PL_AmendmentErDd plobj) { DL_AmendmentErDd objdl = new DL_AmendmentErDd(); DataTable dt = new DataTable(); dt = objdl.DL_SearchEmployee(plobj); return(dt); }
public DataTable UpdateAmendmentData(PL_AmendmentErDd plobj) { DL_AmendmentErDd objdl = new DL_AmendmentErDd(); DataTable dt = new DataTable(); if (plobj.Ind == 0) { return(dt); } else { dt = objdl.DL_UpdateAmendmentErDd(plobj); return(dt); } }