public DataTable NewExtensionHistory(int nPackageID) { TblPackageExtension packageExt = new TblPackageExtension(); packageExt.NExtensionID = -1; DataTable table = packageExt.SelectOne(); DataRow row = table.NewRow(); row["nPackageID"] = nPackageID; row["nEmployeeID"] = ACMSLogic.User.EmployeeID; row["nStatusID"] = 0; row["strRemarks"]=""; table.Rows.Add(row); return table; }
public void UpdateExtensionHistory(int last_nExtensionID, DateTime startDate, DateTime endDate, int nReasonID, DateTime newExpiryDate) { int iReasonID = 0; TblPackageExtension packageExt = new TblPackageExtension(); packageExt.NExtensionID = last_nExtensionID; DataTable packageExtensionTable = packageExt.SelectOne(); if (packageExtensionTable.Rows.Count == 0) throw new Exception("This extension row has been deleted by others"); if (packageExt.NStatusID.Value == 1) throw new Exception("This extension row has been deleted by others"); packageExt.DtStartDate = startDate; packageExt.DtEndDate = endDate; packageExt.NReasonID = nReasonID; SaveExtensionHistory(packageExt.NPackageID.Value, packageExtensionTable, newExpiryDate,false, startDate, endDate, iReasonID); }
public DataTable GetExtensionHistoryBaseExtensionID(int nExtensionID) { TblPackageExtension packageExt = new TblPackageExtension(); packageExt.NExtensionID = nExtensionID; return packageExt.SelectOne(); }