/// <summary> /// get_register /// This is called from the Process_Input procedure. /// </summary> public void get_register(int tlog_store_no, string currentdate0) { var register_found = "N"; STORE_TRANS_NO REG = db.STORE_TRANS_NOs.FirstOrDefault(i => i.STORE_NO == tlog_store_no && i.DA_TIMESTMP_MOD == null || i.DA_TIMESTMP_MOD != currentdate0); return; }
/// <summary> /// update_register1 /// The Procedure which Updates the STORE_TRANS_NO Record. /// </summary> public void update_register1(int tlog_store_no, int register_no) { //#ifdef debuga // #debugb Console.WriteLine("FLOW: update_register1" //#endif STORE_TRANS_NO udpate = db.STORE_TRANS_NOs.FirstOrDefault(i => i.STORE_NO == tlog_store_no && i.REGISTER_ID == register_no); udpate.DA_TIMESTMP_MOD = DateTime.Now; db.SubmitChanges(); return; }
/// <summary> /// update_register /// The Procedure which Updates the STORE_TRANS_NO Record. /// </summary> public void update_register() { //#ifdef debuga // #debugb Console.WriteLine("FLOW: update_register" //#endif STORE_TRANS_NO str_no = db.STORE_TRANS_NOs.FirstOrDefault(r => r.STORE_NO == tloghist_store_no && r.REGISTER_ID == tloghist_register_no); str_no.DA_TIMESTMP_MOD = DateTime.Now; return; }
/// <summary> /// update_trans_no /// The Procedure which Updates the STORE_TRANS_NO Record. /// </summary> public void update_trans_no(STORE_TRANS_NO data) { //#ifdef debuga // #debugb Console.WriteLine("FLOW: update_trans_no" //#endif STORE_TRANS_NO strno = db.STORE_TRANS_NOs.FirstOrDefault(i => i.STORE_NO == tlog_store_no && i.REGISTER_ID == register_no); strno.TRANSACTION_NO = tlog_trans_no; return; }
/// <summary> /// create_trans_no /// This is called from the get_trans_no procedure. /// </summary> public void create_trans_no(STORE_TRANS_NO data) { STORE_TRANS_NO store = new STORE_TRANS_NO(); store.STORE_NO = data.STORE_NO; store.REGISTER_ID = data.REGISTER_ID; store.TRANSACTION_NO = 0; db.STORE_TRANS_NOs.InsertOnSubmit(store); db.SubmitChanges(); get_trans_no(); return; }
/// <summary> /// get_trans_no /// This is called from the create_tlog procedure. /// </summary> public void get_trans_no(int tlog_store_no, int register_no) { var trans_nso_found = "N"; STORE_TRANS_NO STN = db.STORE_TRANS_NOs.FirstOrDefault(i => i.STORE_NO == tlog_store_no && i.REGISTER_ID == register_no); var stn_trans_no = STN.TRANSACTION_NO; if (stn_trans_no == 9999) { stn_trans_no = 0; } var trans_no_found = "Y"; if (trans_no_found == "N") { create_trans_no(); } return; }