private void SaveExtensionHistory(int nCreditPackageID, string strMembershipID, DateTime dtOldExpiry, DateTime dtNewExpiry, DateTime dtStartDate, DateTime dtEndDate,
int nDaysExtended, int nStatusID, int nReasonID, string strRemarks, int nEmployeeID, DateTime dtCreateDate)
{
int nCreditPackageStatusID = -1;
if (DateTime.Compare(dtNewExpiry, DateTime.Now) > 0)
{
nCreditPackageStatusID = 0;
}
ACMSDAL.ConnectionProvider connProvider = new ConnectionProvider();
TblMemberCreditPackage myMemberCreditPackage = new TblMemberCreditPackage();
TblCreditPackageExtension myCreditPackageExtension = new TblCreditPackageExtension();
myMemberCreditPackage.MainConnectionProvider = connProvider;
myCreditPackageExtension.MainConnectionProvider = connProvider;
connProvider.OpenConnection();
connProvider.BeginTransaction("SaveCreditPackageExtension");
try
{
//Update MemberCreditPackage - New Expiry Date & Status ID by nCreditPackageID
myMemberCreditPackage.MemberCreditPackage_ExtensionUpdate(nCreditPackageID, nCreditPackageStatusID, dtNewExpiry, strMembershipID);
//Add Record to Credit Package Extension
myCreditPackageExtension.NCreditPackageID = nCreditPackageID;
myCreditPackageExtension.DtOldExpiry = dtOldExpiry;
myCreditPackageExtension.DtNewExpiry = dtNewExpiry;
myCreditPackageExtension.DtStartDate = dtStartDate;
myCreditPackageExtension.DtEndDate = dtEndDate;
myCreditPackageExtension.NDaysExtended = nDaysExtended;
myCreditPackageExtension.NStatusID = nStatusID;
myCreditPackageExtension.NReasonID = nReasonID;
myCreditPackageExtension.StrRemarks = strRemarks;
myCreditPackageExtension.NEmployeeID = nEmployeeID;
myCreditPackageExtension.Insert();
//Commit Transaction
connProvider.CommitTransaction();
//*** Remember to Disable the Update Expiry Button for Credit Packages
}
catch
{
//RollBack Transaction
connProvider.RollbackTransaction("SaveCreditPackageExtension");
}
finally
{
//connProvider.CurrentTransaction.Dispose();
//connProvider.DBConnection.Close();
if (connProvider.CurrentTransaction != null)
{
connProvider.CurrentTransaction.Dispose();
}
if (connProvider.DBConnection != null)
{
if (connProvider.DBConnection.State == ConnectionState.Open)
{
connProvider.DBConnection.Close();
}
}
myMemberCreditPackage.MainConnactionIsCreatedLocal = true;
myCreditPackageExtension.MainConnactionIsCreatedLocal = true;
}
}
public void DeleteLastCreditPackageExtensionHistory(int nCreditPackageID, int last_nExtensionID, string CurrentMembershipID)
{
ACMSDAL.ConnectionProvider connProvider = new ConnectionProvider();
TblMemberCreditPackage myMemberCreditPackage = new TblMemberCreditPackage();
TblCreditPackageExtension myCreditPackageExtension = new TblCreditPackageExtension();
myMemberCreditPackage.MainConnectionProvider = connProvider;
myCreditPackageExtension.MainConnectionProvider = connProvider;
connProvider.OpenConnection();
connProvider.BeginTransaction("SaveCreditPackageExtension");
myCreditPackageExtension.NCreditPackageID = nCreditPackageID;
DataTable tblCreditPackageExtension = myCreditPackageExtension.SelectAllWnCreditPackageIDLogic();
if (tblCreditPackageExtension == null)
{
throw new Exception("This extension row has been deleted by others");
}
else if (tblCreditPackageExtension.Rows.Count == 0)
{
throw new Exception("This extension row has been deleted by others");
}
if (tblCreditPackageExtension.Rows.Count > 0)
{
DataRow[] rowList = tblCreditPackageExtension.Select(" nStatusID = 0 AND nExtensionID > " + last_nExtensionID.ToString());
if (rowList.Length > 0) // mean is not last package extension
{
throw new Exception("Only the most recent package extension can be deleted.");
}
}
DataRow[] deletedDataRowList = tblCreditPackageExtension.Select("nStatusID = 0 and nExtensionID = " + last_nExtensionID, "nExtensionID", DataViewRowState.CurrentRows);
if (deletedDataRowList.Length == 0)
{
throw new Exception("This extension row has been deleted by others");
}
DateTime dtOldExpiry = Convert.ToDateTime(deletedDataRowList[0]["dtOldExpiry"]);
int nCreditPackageStatusID = -1;
if (DateTime.Compare(dtOldExpiry, DateTime.Now) < 0)
{
nCreditPackageStatusID = 1;
}
try
{
//Update Credit Package Extension set nStatusID = 1 => Deleted
myCreditPackageExtension.MemberCreditPackage_ExtensionDelete(nCreditPackageID, last_nExtensionID);
//Update Member Credit Package Expiry Date; nStatusID = 1 If Expired
myMemberCreditPackage.MemberCreditPackage_ExtensionUpdate(nCreditPackageID, nCreditPackageStatusID, dtOldExpiry, CurrentMembershipID);
connProvider.CommitTransaction();
}
catch (Exception)
{
connProvider.RollbackTransaction("SaveCreditPackageExtension");
throw new Exception("Failed to Create New Extension");
}
finally
{
if (connProvider.CurrentTransaction != null)
{
connProvider.CurrentTransaction.Dispose();
}
if (connProvider.DBConnection != null)
{
if (connProvider.DBConnection.State == ConnectionState.Open)
{
connProvider.DBConnection.Close();
}
}
myMemberCreditPackage.MainConnactionIsCreatedLocal = true;
myCreditPackageExtension.MainConnactionIsCreatedLocal = true;
}
}
private void SaveExtensionHistory(int nCreditPackageID, string strMembershipID, DateTime dtOldExpiry, DateTime dtNewExpiry, DateTime dtStartDate, DateTime dtEndDate,
int nDaysExtended, int nStatusID, int nReasonID, string strRemarks, int nEmployeeID, DateTime dtCreateDate)
{
int nCreditPackageStatusID = -1;
if (DateTime.Compare(dtNewExpiry, DateTime.Now) > 0)
{
nCreditPackageStatusID = 0;
}
ACMSDAL.ConnectionProvider connProvider = new ConnectionProvider();
TblMemberCreditPackage myMemberCreditPackage = new TblMemberCreditPackage();
TblCreditPackageExtension myCreditPackageExtension = new TblCreditPackageExtension();
myMemberCreditPackage.MainConnectionProvider = connProvider;
myCreditPackageExtension.MainConnectionProvider = connProvider;
connProvider.OpenConnection();
connProvider.BeginTransaction("SaveCreditPackageExtension");
try
{
//Update MemberCreditPackage - New Expiry Date & Status ID by nCreditPackageID
myMemberCreditPackage.MemberCreditPackage_ExtensionUpdate(nCreditPackageID, nCreditPackageStatusID, dtNewExpiry, strMembershipID);
//Add Record to Credit Package Extension
myCreditPackageExtension.NCreditPackageID = nCreditPackageID;
myCreditPackageExtension.DtOldExpiry = dtOldExpiry;
myCreditPackageExtension.DtNewExpiry = dtNewExpiry;
myCreditPackageExtension.DtStartDate = dtStartDate;
myCreditPackageExtension.DtEndDate = dtEndDate;
myCreditPackageExtension.NDaysExtended = nDaysExtended;
myCreditPackageExtension.NStatusID = nStatusID;
myCreditPackageExtension.NReasonID = nReasonID;
myCreditPackageExtension.StrRemarks = strRemarks;
myCreditPackageExtension.NEmployeeID = nEmployeeID;
myCreditPackageExtension.Insert();
//Commit Transaction
connProvider.CommitTransaction();
//*** Remember to Disable the Update Expiry Button for Credit Packages
}
catch
{
//RollBack Transaction
connProvider.RollbackTransaction("SaveCreditPackageExtension");
}
finally
{
//connProvider.CurrentTransaction.Dispose();
//connProvider.DBConnection.Close();
if (connProvider.CurrentTransaction != null)
{
connProvider.CurrentTransaction.Dispose();
}
if (connProvider.DBConnection != null)
{
if (connProvider.DBConnection.State == ConnectionState.Open)
{
connProvider.DBConnection.Close();
}
}
myMemberCreditPackage.MainConnactionIsCreatedLocal = true;
myCreditPackageExtension.MainConnactionIsCreatedLocal = true;
}
}
public void DeleteLastCreditPackageExtensionHistory(int nCreditPackageID, int last_nExtensionID, string CurrentMembershipID)
{
ACMSDAL.ConnectionProvider connProvider = new ConnectionProvider();
TblMemberCreditPackage myMemberCreditPackage = new TblMemberCreditPackage();
TblCreditPackageExtension myCreditPackageExtension = new TblCreditPackageExtension();
myMemberCreditPackage.MainConnectionProvider = connProvider;
myCreditPackageExtension.MainConnectionProvider = connProvider;
connProvider.OpenConnection();
connProvider.BeginTransaction("SaveCreditPackageExtension");
myCreditPackageExtension.NCreditPackageID = nCreditPackageID;
DataTable tblCreditPackageExtension = myCreditPackageExtension.SelectAllWnCreditPackageIDLogic();
if (tblCreditPackageExtension == null)
{
throw new Exception("This extension row has been deleted by others");
}
else if (tblCreditPackageExtension.Rows.Count == 0)
{
throw new Exception("This extension row has been deleted by others");
}
if (tblCreditPackageExtension.Rows.Count > 0)
{
DataRow[] rowList = tblCreditPackageExtension.Select(" nStatusID = 0 AND nExtensionID > " + last_nExtensionID.ToString());
if (rowList.Length > 0) // mean is not last package extension
{
throw new Exception("Only the most recent package extension can be deleted.");
}
}
DataRow[] deletedDataRowList = tblCreditPackageExtension.Select("nStatusID = 0 and nExtensionID = " + last_nExtensionID, "nExtensionID", DataViewRowState.CurrentRows);
if (deletedDataRowList.Length == 0)
{
throw new Exception("This extension row has been deleted by others");
}
DateTime dtOldExpiry = Convert.ToDateTime(deletedDataRowList[0]["dtOldExpiry"]);
int nCreditPackageStatusID = -1;
if (DateTime.Compare(dtOldExpiry, DateTime.Now) < 0)
{
nCreditPackageStatusID = 1;
}
try
{
//Update Credit Package Extension set nStatusID = 1 => Deleted
myCreditPackageExtension.MemberCreditPackage_ExtensionDelete(nCreditPackageID, last_nExtensionID);
//Update Member Credit Package Expiry Date; nStatusID = 1 If Expired
myMemberCreditPackage.MemberCreditPackage_ExtensionUpdate(nCreditPackageID, nCreditPackageStatusID, dtOldExpiry, CurrentMembershipID);
connProvider.CommitTransaction();
}
catch (Exception)
{
connProvider.RollbackTransaction("SaveCreditPackageExtension");
throw new Exception("Failed to Create New Extension");
}
finally
{
if (connProvider.CurrentTransaction != null)
{
connProvider.CurrentTransaction.Dispose();
}
if (connProvider.DBConnection != null)
{
if (connProvider.DBConnection.State == ConnectionState.Open)
{
connProvider.DBConnection.Close();
}
}
myMemberCreditPackage.MainConnactionIsCreatedLocal = true;
myCreditPackageExtension.MainConnactionIsCreatedLocal = true;
}
}