public void NewRedemption(string strMembershipID, string itemCode, int qtyOfItemCodeToRedempt, ref int strTransNo)
{
ACMSDAL.ConnectionProvider connProvider = new ConnectionProvider();
connProvider.OpenConnection();
TblRewardsCatalogue catalogue = new TblRewardsCatalogue();
catalogue.StrItemCode = itemCode;
catalogue.SelectOne();
TblRewardsTransaction rewardTrans = new TblRewardsTransaction();
rewardTrans.MainConnectionProvider = connProvider;
rewardTrans.StrMembershipID = strMembershipID;
rewardTrans.DtDate = DateTime.Now;
rewardTrans.NTypeID = 2;
rewardTrans.StrReferenceNo = itemCode;
rewardTrans.NEmployeeID = User.EmployeeID;
rewardTrans.StrBranchCode = User.BranchCode;
if (!catalogue.DRewardsPoints.IsNull)
{
rewardTrans.DRewardsPoints = -catalogue.DRewardsPoints.Value * qtyOfItemCodeToRedempt;
}
rewardTrans.Insert();
strTransNo = rewardTrans.NTransactionID.Value;
TblPromotionFreebie promoFreebie = new TblPromotionFreebie();
promoFreebie.StrPromotionCode = itemCode;
DataTable receiptFreebieTable = promoFreebie.SelectAllWstrPromotionCodeLogic();
//Code selected is Promotion Freebie Code
if (receiptFreebieTable.Rows.Count > 0)
{
//TblProductInventory proInven = new TblProductInventory();
//proInven.MainConnectionProvider = connProvider;
//// deduct stock
//foreach (DataRow r in receiptFreebieTable.Rows)
//{
// proInven.IncreaseQuantity(r["strItemCode"].ToString(), User.BranchCode, -qtyOfItemCodeToRedempt);
//}
}
else
{
//Code selected is Package Code
TblPackage pkg = new TblPackage();
pkg.StrPackageCode = itemCode;
DataTable pkgTable = pkg.SelectOne();
if (pkgTable.Rows.Count > 0)
{
TblMemberPackage mp = new TblMemberPackage();
mp.SelectAll();
MemberPackage memberPackage = new MemberPackage();
DataTable memberPackageTable = memberPackage.New(false, strMembershipID);
DataRow memberPackageRow = memberPackageTable.Rows[0];
memberPackageRow["strMembershipID"] = strMembershipID;
memberPackageRow["dtPurchaseDate"] = DateTime.Now;
memberPackageRow["strRemarks"] = "REWARDS";
memberPackageRow["nStatusID"] = 0;
memberPackageRow["strPackageCode"] = itemCode;
memberPackageRow["fFree"] = 1;
mp.SaveData(memberPackageTable);
}
else
{
//Code selected is Product Code
//TblProductInventory productInvent = new TblProductInventory();
//productInvent.MainConnectionProvider = connProvider;
//productInvent.StrProductCode = itemCode;
//productInvent.SelectOne();
//productInvent.NQuantity = ACMS.Convert.ToInt32(productInvent.NQuantity) - qtyOfItemCodeToRedempt;
//productInvent.Update();
}
}
if (connProvider.CurrentTransaction != null)
{
connProvider.CurrentTransaction.Dispose();
}
if (connProvider.DBConnection != null)
{
if (connProvider.DBConnection.State == ConnectionState.Open)
{
connProvider.DBConnection.Close();
}
}
}
public void NewRedemption(string strMembershipID, string itemCode, int qtyOfItemCodeToRedempt, ref int strTransNo)
{
ACMSDAL.ConnectionProvider connProvider = new ConnectionProvider();
connProvider.OpenConnection();
TblRewardsCatalogue catalogue = new TblRewardsCatalogue();
catalogue.StrItemCode = itemCode;
catalogue.SelectOne();
TblRewardsTransaction rewardTrans = new TblRewardsTransaction();
rewardTrans.MainConnectionProvider = connProvider;
rewardTrans.StrMembershipID = strMembershipID;
rewardTrans.DtDate = DateTime.Now;
rewardTrans.NTypeID = 2;
rewardTrans.StrReferenceNo = itemCode;
rewardTrans.NEmployeeID = User.EmployeeID;
rewardTrans.StrBranchCode = User.BranchCode;
if (!catalogue.DRewardsPoints.IsNull)
rewardTrans.DRewardsPoints = -catalogue.DRewardsPoints.Value * qtyOfItemCodeToRedempt;
rewardTrans.Insert();
strTransNo = rewardTrans.NTransactionID.Value;
TblPromotionFreebie promoFreebie = new TblPromotionFreebie();
promoFreebie.StrPromotionCode = itemCode;
DataTable receiptFreebieTable = promoFreebie.SelectAllWstrPromotionCodeLogic();
//Code selected is Promotion Freebie Code
if (receiptFreebieTable.Rows.Count > 0)
{
//TblProductInventory proInven = new TblProductInventory();
//proInven.MainConnectionProvider = connProvider;
//// deduct stock
//foreach (DataRow r in receiptFreebieTable.Rows)
//{
// proInven.IncreaseQuantity(r["strItemCode"].ToString(), User.BranchCode, -qtyOfItemCodeToRedempt);
//}
}
else
{
//Code selected is Package Code
TblPackage pkg = new TblPackage();
pkg.StrPackageCode = itemCode;
DataTable pkgTable = pkg.SelectOne();
if (pkgTable.Rows.Count > 0)
{
TblMemberPackage mp = new TblMemberPackage();
mp.SelectAll();
MemberPackage memberPackage = new MemberPackage();
DataTable memberPackageTable = memberPackage.New(false, strMembershipID);
DataRow memberPackageRow = memberPackageTable.Rows[0];
memberPackageRow["strMembershipID"] = strMembershipID;
memberPackageRow["dtPurchaseDate"] = DateTime.Now;
memberPackageRow["strRemarks"] = "REWARDS";
memberPackageRow["nStatusID"] = 0;
memberPackageRow["strPackageCode"] = itemCode;
memberPackageRow["fFree"] = 1;
mp.SaveData(memberPackageTable);
}
else
{
//Code selected is Product Code
//TblProductInventory productInvent = new TblProductInventory();
//productInvent.MainConnectionProvider = connProvider;
//productInvent.StrProductCode = itemCode;
//productInvent.SelectOne();
//productInvent.NQuantity = ACMS.Convert.ToInt32(productInvent.NQuantity) - qtyOfItemCodeToRedempt;
//productInvent.Update();
}
}
if (connProvider.CurrentTransaction != null)
connProvider.CurrentTransaction.Dispose();
if (connProvider.DBConnection != null)
{
if (connProvider.DBConnection.State == ConnectionState.Open)
connProvider.DBConnection.Close();
}
}
