public DataTable CalculateFun(PL_ManualPatrak plobj)
{
DataTable dt = new DataTable();
DL_ManualPatrak dlobj = new DL_ManualPatrak();
dt = dlobj.DL_CalculateFun(plobj);
return(dt);
}
public DataTable SaveManualPatrak(PL_ManualPatrak plobj)
{
DataTable dt = new DataTable();
DL_ManualPatrak dlobj = new DL_ManualPatrak();
dt = dlobj.DL_Save(plobj);
return(dt);
}
internal DataTable DL_Save(PL_ManualPatrak plobj)
{
try
{
con = Connection.SetConnection();
cmd = new SqlCommand("SpManualPatrak", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@flag", plobj.flag);
cmd.Parameters.AddWithValue("@citycode", plobj.CityCode);
cmd.Parameters.AddWithValue("@Month", plobj.Month);
cmd.Parameters.AddWithValue("@EmpNo", plobj.EmpNo);
cmd.Parameters.AddWithValue("@EffMonth", plobj.EffectiveMonth);
cmd.Parameters.AddWithValue("@tblTypeManualPatrak", plobj.dt_Grid);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return(dt);
}
catch { return(dt); }
finally { con.Close(); con.Dispose(); }
}
internal DataTable DL_CalculateFun(PL_ManualPatrak plobj)
{
try
{
con = Connection.SetConnection();
cmd = new SqlCommand("SpManualPatrakCalculate", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@flag", plobj.flag);
cmd.Parameters.AddWithValue("@citycode", plobj.CityCode);
cmd.Parameters.AddWithValue("@MonthCd", plobj.Month);
cmd.Parameters.AddWithValue("@EmpNo", plobj.EmpNo);
cmd.Parameters.AddWithValue("@Sus", plobj.SuspendLeave);
cmd.Parameters.AddWithValue("@totalLeave", plobj.TotalNoOfLeave);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return(dt);
}
catch { return(dt); }
finally { con.Close(); con.Dispose(); }
}