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