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