internal DataSet DL_SalProcessing(PL_Proc_FrmSalaryProcessing plobj)
{
try
{
con = Connection.SetConnection();
cmd = new SqlCommand("Sp_SalaryProcessing", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CityCode", plobj.CityCode);
cmd.Parameters.AddWithValue("@MonthCd", plobj.MonthCd);
cmd.Parameters.AddWithValue("@MOnth", plobj.Month);
cmd.Parameters.AddWithValue("@DeptCd1", plobj.DepartmentCd);
cmd.Parameters.AddWithValue("@LotNoF", plobj.Lotnofrom);
cmd.Parameters.AddWithValue("@LotNoTo", plobj.Lotnoto);
cmd.Parameters.AddWithValue("@EmpNoFrom", plobj.Empnofrom);
cmd.Parameters.AddWithValue("@EmpNoTo", plobj.Empnoto);
cmd.Parameters.AddWithValue("@Classind", plobj.ClassInd);
cmd.Parameters.AddWithValue("@EmpType", plobj.EmpType);
da = new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds);
return(ds);
}
catch { return(ds); }
finally { con.Close(); con.Dispose(); }
}
public DataSet SalProcessing(PL_Proc_FrmSalaryProcessing plobj)
{
DataSet ds = new DataSet();
DL_Proc_FrmSalaryProcessing dlobj = new DL_Proc_FrmSalaryProcessing();
ds = dlobj.DL_SalProcessing(plobj);
return(ds);
}
public DataTable AmendmentProcessing(PL_Proc_FrmSalaryProcessing plobj)
{
DataTable dt = new DataTable();
DL_Proc_FrmSalaryProcessing dlobj = new DL_Proc_FrmSalaryProcessing();
dt = dlobj.DL_AmendmentProcessing(plobj);
return(dt);
}