/// <summary> /// select_register /// The Procedure which selects the Register from TLOG_HIST to Update with the Current Date /// </summary> public void select_register() { //#ifdef debuga // #debugb Console.WriteLine("FLOW: select_register" //#endif TLOG_HIST TLOGHIST = db.TLOG_HISTs.FirstOrDefault(i => i.DA_TIMESTMP_CRE == currentdate0).OrderBy(i => i.STORE_NO, i.REGISTER_NO).OrderByDescending(); int tloghist_store_no = Convert.ToInt32(TLOGHIST.STORE_NO.Trim()); var tloghist_register_no = TLOGHIST.REGISTER_NO.Trim(); update_register(); return; }
/// <summary> /// create_tlog_history /// This procedure inserts a row in the TLOG_HIST Record. /// </summary> public void create_tlog_history(TLOG_HIST data) { //#debugc Console.WriteLine("#tlog_obj_cd is " #tlog_obj_cd TLOG_HIST tlog = new TLOG_HIST(); tlog.STORE_NO = data.STORE_NO; tlog.TRANSACTION_DATE = data.TRANSACTION_DATE; tlog.TRANSACTION_NO = data.TRANSACTION_NO; tlog.GIFT_CARD_NUMBER = data.GIFT_CARD_NUMBER; tlog.AUTHORIZATION_CODE = data.AUTHORIZATION_CODE; tlog.REGISTER_NO = data.REGISTER_NO; tlog.POS_CARD_AUTH_TYPE = data.POS_CARD_AUTH_TYPE; tlog.POS_GIFT_CARD_FLAG = 6; tlog.GROSS_LINE_AMOUNT = data.GROSS_LINE_AMOUNT; tlog.REMAING_CARD_BAL = data.REMAING_CARD_BAL; tlog.LINE_OBJECT_TYPE = data.LINE_OBJECT_TYPE; tlog.PROMO_CODE = data.PROMO_CODE; tlog.PROMO_CODE_SUB = data.PROMO_CODE_SUB; tlog.DA_TIMESTMP_CRE = data.DA_TIMESTMP_CRE; db.TLOG_HIST.InsertOnSubmit(tlog); db.SubmitChanges(); return; }