public DataTable SaveData(PL_RetirmnetBenfit plobj)
{
DL_RetirmnetBenfit dl = new DL_RetirmnetBenfit();
DataTable dt = new DataTable();
dt = dl.DL_SaveRecord(plobj);
return(dt);
}
internal DataTable DL_SaveRecord(PL_RetirmnetBenfit plobj)
{
try
{
con = Connection.SetConnection();
cmd = new SqlCommand("SPRetirmentBenfit", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", plobj.Ind);
cmd.Parameters.AddWithValue("@CityCode", plobj.CityCode);
cmd.Parameters.AddWithValue("@Month", plobj.Month);
cmd.Parameters.AddWithValue("@GraduityTotalMonth", plobj.GraduityTotalMonth);
cmd.Parameters.AddWithValue("@EmpNo", plobj.EmpNo);
cmd.Parameters.AddWithValue("@BasicAmt", plobj.BasicAmt);
cmd.Parameters.AddWithValue("@GradePayAmt", plobj.GradePayAmt);
cmd.Parameters.AddWithValue("@SelectType", plobj.SelectType);
cmd.Parameters.AddWithValue("@DOJ", plobj.DOJ);
cmd.Parameters.AddWithValue("@DOR", plobj.DOR);
cmd.Parameters.AddWithValue("@NoOfLeave", plobj.NoOfLeave);
cmd.Parameters.AddWithValue("@DaPer", plobj.DaPer);
cmd.Parameters.AddWithValue("@PayableAmt", plobj.PayableAmt);
cmd.Parameters.AddWithValue("@DaAmt", plobj.DaAmt);
cmd.Parameters.AddWithValue("@NoOfYears", plobj.NoOfYears);
cmd.Parameters.AddWithValue("@NoOfMonths", plobj.NoOfMonths);
cmd.Parameters.AddWithValue("@NoOfDays", plobj.NoOfDays);
cmd.Parameters.AddWithValue("@Status", plobj.Status);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return(dt);
}
catch
{
return(dt);
}
finally
{
con.Close();
con.Dispose();
}
}
