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);
}
}
