public override void Refresh() { string cmdtext = ""; ACMSDAL.TblPromotion promotion1 = new ACMSDAL.TblPromotion(); myDataTable1 = promotion1.LoadData("select dtdate from tblreceipt where strreceiptNo = @strReceipt", new string[] { "@strReceipt" }, new object[] { myReceipt }); dtDate = DateTime.Now; if (myDataTable1.Rows.Count > 0) dtDate = System.Convert.ToDateTime(myDataTable1.Rows[0][0]); //if (myIsMember) //{ cmdtext = " Select distinct A.* from tblPromotion A, tblMember B, tblLoyaltyStatus C, tblPromotionBranch D, tblPromotionReceiptSalesCategory E " + " where A.FItemDiscount = 0 AND " + " A.mMinimumAmount <= @ReceiptAmount And A.nApprovedStatusID = 1 AND " + " ( A.nPromotionTypeID = 1 or A.nPromotionTypeID = 2) AND " + " A.dtValidStart <= @Date AND CONVERT(VARCHAR(10),A.dtValidEnd,102)+' 23:59:59' >= @Date AND " + " ((A.nDiscountCategoryID = C.nDiscountCategoryID AND B.nLoyaltyStatusID = C.nLoyaltyStatusID) or A.nDiscountCategoryID =0) AND" + " D.strPromotionCode = A.strPromotionCode and D.strBranchCode = @strBranchCode AND E.strPromotionCode = A.strPromotionCode AND " + " B.StrMembershipID = @ID AND E.nSalesCategoryID = @nSalesCategoryID"; //} ACMSDAL.TblPromotion promotion = new ACMSDAL.TblPromotion(); myDataTable = promotion.LoadData(cmdtext, new string[] {"@ReceiptAmount", "@Date", "@strBranchCode", "@ID" , "@nSalesCategoryID"}, new object[] { myReceiptAmt, dtDate, myBranchCode, myID, mySalesCategoryID }); Init(); }
public override void Refresh() { string cmdtext = ""; //if (myIsMember) //{ cmdtext = " Select distinct A.* from tblPromotion A, tblMember B, tblLoyaltyStatus C, tblPromotionBranch D, tblPromotionReceiptSalesCategory E " + " where A.FItemDiscount = 0 AND " + " A.mMinimumAmount <= @ReceiptAmount And A.nApprovedStatusID = 1 AND " + " (A.nPromotionTypeID = 0) AND " + " A.dtValidStart <= @Date AND A.dtValidEnd >= @Date AND " + " ((A.nDiscountCategoryID = C.nDiscountCategoryID AND B.nLoyaltyStatusID = C.nLoyaltyStatusID) or A.nDiscountCategoryID =0) AND" + " D.strPromotionCode = A.strPromotionCode and D.strBranchCode = @strBranchCode AND E.strPromotionCode = A.strPromotionCode AND " + " B.StrMembershipID = @ID AND E.nSalesCategoryID = @nSalesCategoryID"; //} ACMSDAL.TblPromotion promotion = new ACMSDAL.TblPromotion(); myDataTable = promotion.LoadData(cmdtext, new string[] {"@ReceiptAmount", "@Date", "@strBranchCode", "@ID", "@nSalesCategoryID"}, new object[]{myReceiptAmt, DateTime.Now.Date, myBranchCode, myID, mySalesCategoryID}); Init(); }
public override void Refresh() { string cmdtext = ""; ACMSDAL.TblPromotion promotion1 = new ACMSDAL.TblPromotion(); myDataTable1 = promotion1.LoadData("select dtdate from tblreceipt where strreceiptNo = @strReceipt", new string[] { "@strReceipt"}, new object[] { myReceipt }); dtDate = DateTime.Now; if (myDataTable1.Rows.Count > 0) dtDate = System.Convert.ToDateTime(myDataTable1.Rows[0][0]); if (!myIsStaffPurchase)//1105 { cmdtext = " Select distinct A.* from tblPromotion A, tblEmployee B, tblJobPosition C, tblPromotionBranch D, tblMember E where A.FItemDiscount = 1 AND " + " A.mMinimumAmount <= @ReceiptAmount And A.nApprovedStatusID = 1 AND " + " (A.nPromotionTypeID = 1 or A.nPromotionTypeID = 2) AND " + " A.dtValidStart <= cast(@Date as varchar(11)) AND A.dtValidEnd >= cast(@Date as varchar(11)) AND " + " ((A.nDiscountCategoryID = C.nDiscountCategoryID AND B.strJobPositionCode = C.strJobPositionCode) or A.nDiscountCategoryID =0) AND " + " D.strPromotionCode = A.strPromotionCode and D.strBranchCode = @strBranchCode AND " + " E.StrMembershipID = @ID AND A.strPromotionCode in " + " ( Select strPromotionCode from tblItemPromotion where " + " (nCategoryTypeID = @nCategoryTypeID and nGroupID = 0 and strCode = @strCodeInTblItemPromotionToMatch) " + " or (nCategoryTypeID = @nCategoryTypeID and nGroupID = 1 and strCode = @strCodeInTblItemPromotionToMatch))"; } else { cmdtext = " Select distinct A.* from tblPromotion A, tblEmployee B, tblJobPosition C, tblPromotionBranch D, tblMember E where A.FItemDiscount = 1 AND " + " A.mMinimumAmount <= @ReceiptAmount And A.nApprovedStatusID = 1 AND " + " (A.nPromotionTypeID = 1 or A.nPromotionTypeID = 2) AND " + " A.dtValidStart <= cast(@Date as varchar(11)) AND A.dtValidEnd >= cast(@Date as varchar(11)) AND " + " ((A.nDiscountCategoryID = C.nDiscountCategoryID AND B.strJobPositionCode = C.strJobPositionCode) or A.nDiscountCategoryID =0) AND " + " D.strPromotionCode = A.strPromotionCode and D.strBranchCode = @strBranchCode AND B.nEmployeeID = E.nMembershipNo AND " + " E.StrMembershipID = @ID AND A.strPromotionCode in " + " ( Select strPromotionCode from tblItemPromotion where " + " (nCategoryTypeID = @nCategoryTypeID and nGroupID = 0 and strCode = @strCodeInTblItemPromotionToMatch) " + " or (nCategoryTypeID = @nCategoryTypeID and nGroupID = 1 and strCode = @strCodeInTblItemPromotionToMatch))"; } ACMSDAL.TblPromotion promotion = new ACMSDAL.TblPromotion(); myDataTable = promotion.LoadData(cmdtext, new string[] {"@ReceiptAmount", "@Date", "@strBranchCode", "@ID", "@nCategoryTypeID", "@strCodeInTblItemPromotionToMatch", "@nCategoryID"}, new object[] { myReceiptAmt, dtDate, myBranchCode, myID, myCategoryTypeID, myStrCodeInTblItemPromotionToMatch, myCategoryID }); Init(); }
public override void Refresh() { ACMSDAL.TblPromotion sqlPromotion = new ACMSDAL.TblPromotion(); myDataTable = sqlPromotion.GetPromotionForMemberPackage(myStrBranchCode); Init(); }
public override void Refresh() { string cmdtext = ""; if (!myIsStaffPurchase) { cmdtext = " Select distinct A.* from tblPromotion A, tblMember B, tblLoyaltyStatus C, tblPromotionBranch D where A.FItemDiscount = 1 AND " + " A.strPromotionCode <>'090018SPD' AND A.mMinimumAmount <= @ReceiptAmount And A.nApprovedStatusID = 1 AND " + " (A.nPromotionTypeID = 0) AND " + " A.dtValidStart <= @Date AND A.dtValidEnd >= @Date AND " + " ((A.nDiscountCategoryID = C.nDiscountCategoryID AND B.nLoyaltyStatusID = C.nLoyaltyStatusID) or A.nDiscountCategoryID = 0) AND" + " D.strPromotionCode = A.strPromotionCode and D.strBranchCode = @strBranchCode AND " + " B.StrMembershipID = @ID AND A.strPromotionCode in " + " ( Select strPromotionCode from tblItemPromotion where " + " (nCategoryTypeID = @nCategoryTypeID and nGroupID = 0 and strCode = @strCodeInTblItemPromotionToMatch) " + " or (nCategoryTypeID = @nCategoryTypeID and nGroupID = 1 and strCode = '@nCategoryID'))" + " union Select distinct A.* from tblPromotion A, tblMember B, tblLoyaltyStatus C where A.FItemDiscount = 1 AND " + //1105 newly add jackie " A.mMinimumAmount <= @ReceiptAmount And A.nApprovedStatusID = 1 AND " + " (A.nPromotionTypeID = 0) AND ((A.nDiscountCategoryID = C.nDiscountCategoryID AND B.nLoyaltyStatusID = C.nLoyaltyStatusID) or A.nDiscountCategoryID = 0) AND " + " strPromotionCode='090018SPD' and @nCategoryID =12 AND B.StrMembershipID = @ID and month(B.dtDOB) =month(GETDATE()) "; } else { cmdtext = " Select distinct A.* from tblPromotion A, tblEmployee B, tblJobPosition C, tblPromotionBranch D, tblMember E where A.FItemDiscount = 1 AND " + " A.mMinimumAmount <= @ReceiptAmount And A.nApprovedStatusID = 1 AND " + " (A.nPromotionTypeID = 0) AND " + " A.dtValidStart <= @Date AND A.dtValidEnd >= @Date AND " + " ((A.nDiscountCategoryID = C.nDiscountCategoryID AND B.strJobPositionCode = C.strJobPositionCode) or A.nDiscountCategoryID =0) AND " + " D.strPromotionCode = A.strPromotionCode and D.strBranchCode = @strBranchCode AND B.nEmployeeID = E.nMembershipNo AND " + " E.StrMembershipID = @ID AND A.strPromotionCode in " + " ( Select strPromotionCode from tblItemPromotion where " + " (nCategoryTypeID = @nCategoryTypeID and nGroupID = 0 and strCode = @strCodeInTblItemPromotionToMatch) " + " or (nCategoryTypeID = @nCategoryTypeID and nGroupID = 1 and strCode = '@nCategoryID'))"; } ACMSDAL.TblPromotion promotion = new ACMSDAL.TblPromotion(); myDataTable = promotion.LoadData(cmdtext, new string[] {"@ReceiptAmount", "@Date", "@strBranchCode", "@ID", "@nCategoryTypeID", "@strCodeInTblItemPromotionToMatch", "@nCategoryID"}, new object[]{myReceiptAmt, DateTime.Now.Date, myBranchCode, myID, myCategoryTypeID, myStrCodeInTblItemPromotionToMatch, myCategoryID}); Init(); }