/// <summary> /// Insert_Gift_Card_Rec /// This is called from the Process_Gift_Card_Tbl procedure. /// </summary> public void Insert_Gift_Card_Rec(GIFT_CARD_INV_PR10_TEMP data) { var Sql_Msg = "Insert_Gift_Card_Rec PROBLEM"; var RJP_WORK = "Insert_Gift_Card_Rec "; //#debugb Console.WriteLine(" " //#debugb Console.WriteLine(RJP_WORK //#debugb Console.WriteLine(" " GIFT_CARD_INV_PR10_TEMP gft = new GIFT_CARD_INV_PR10_TEMP(); gft.VL_PROMOTION_CODE = data.VL_PROMOTION_CODE; gft.STORE_NO = data.STORE_NO; gft.TRANSACTION_DATE = data.TRANSACTION_DATE; gft.TRANS_POST_DATE = data.TRANS_POST_DATE; gft.CARDS_USED_QTY = data.CARDS_USED_QTY; db.GIFT_CARD_INV_PR10_TEMPs.InsertOnSubmit(gft); db.SubmitChanges(); var RJP_WORK = "Insert_Gift_Card_Rec OK "; //#debugb Console.WriteLine(" " //#debugb Console.WriteLine(RJP_WORK //#debugb Console.WriteLine(" " return; }
/// <summary> /// Insert_GC_Inv_Temp /// This is called from the Process_OLTP_Record procedure. /// </summary> public void Insert_GC_Inv_Temp(GIFT_CARD_INV_PR10_TEMP data) { var Sql_Msg = "Insert_GC_Inv_Temp PROBLEM"; var RJP_WORK = "Insert_GC_Inv_Temp "; //#debuga Console.WriteLine(" " //#debuga Console.WriteLine(RJP_WORK //#debuga Console.WriteLine(" " var inv_trans_date = transaction_datetime.Substring(1, 2) + transaction_datetime.Substring(4, 2) + transaction_datetime.Substring(9, 2); //#debuga Console.WriteLine("i1_promotion_code is " i1_promotion_code //#debugb Console.WriteLine("store_no is " store_no //#debuga Console.WriteLine("transaction_datetime is " transaction_datetime //#debuga Console.WriteLine("ws_timestmp_cre is " ws_timestmp_cre GIFT_CARD_INV_PR10_TEMP gft = new GIFT_CARD_INV_PR10_TEMP(); gft.VL_PROMOTION_CODE = data.VL_PROMOTION_CODE; gft.STORE_NO = data.STORE_NO; gft.TRANSACTION_DATE = data.TRANSACTION_DATE; gft.TRANS_POST_DATE = data.TRANS_POST_DATE; gft.CARDS_USED_QTY = 1; db.GIFT_CARD_INV_PR10_TEMPs.InsertOnSubmit(gft); db.SubmitChanges(); var RJP_WORK = "Insert_GC_Inv_Temp OK "; //#debuga Console.WriteLine(" " //#debuga Console.WriteLine(RJP_WORK //#debuga Console.WriteLine(" " return; }
/// <summary> /// This procedure will update GIFT_CARD_INV /// </summary> public void update_gcinv() { GIFT_CARD_INV_PR10_TEMP giftcard = db.GIFT_CARD_INV_PR10_TEMPs.FirstOrDefault(i => i.SENT_DATE == null); giftcard.SENT_DATE = DateTime.Now; db.SubmitChanges(); return; }
/// <summary> /// Process_Gift_Card_Tbl /// This is called from the Begin_Report procedure. /// </summary> public void Process_Gift_Card_Tbl() { Insert_Gift_Card_Rec(); GIFT_CARD_INV_PR10_TEMP PR10GCI = db.GIFT_CARD_INV_PR10_TEMPs, FirstOrDefault(); //GROUP BY //VL_PROMOTION_CODE, //STORE_NO, //TRANSACTION_DATE, //TRANS_POST_DATE return; }