public bool SaveMasterLodgementTransaction(shop_lodgement_reimbursment newmlr, shop_transaction newmastertransaction, shop_balance_sheet masterbalance) { try { using (TransactionScope scope = new TransactionScope()) { newmastertransaction.app_id = Application().app_id; db.shop_transactions.InsertOnSubmit(newmastertransaction); db.SubmitChanges(); newmlr.transaction = new CRUD.shop_transaction_crud().find_shop_transaction_By_AppId(newmastertransaction.app_id).id; db.shop_lodgement_reimbursments.InsertOnSubmit(newmlr); shop_balance_sheet prev_master_balance_sheet = db.shop_balance_sheets.SingleOrDefault(a => a.id == masterbalance.id); prev_master_balance_sheet.credit_balance = masterbalance.credit_balance; prev_master_balance_sheet.netbalance = masterbalance.netbalance; prev_master_balance_sheet.online_credit = masterbalance.online_credit; prev_master_balance_sheet.sales_balance = masterbalance.sales_balance; db.SubmitChanges(); scope.Complete(); } return(true); } catch (Exception) { return(false); } }
public shop_lodgement_reimbursment alter_shop_lodgement_reimbursment() { try { shop_lodgement_reimbursment prev_shop_lodgement_reimbursment = db.shop_lodgement_reimbursments.SingleOrDefault(a => a.id == shop_lodgement_reimbursment.id); prev_shop_lodgement_reimbursment.amount = shop_lodgement_reimbursment.amount; prev_shop_lodgement_reimbursment.bank = shop_lodgement_reimbursment.bank; prev_shop_lodgement_reimbursment.date = shop_lodgement_reimbursment.date; prev_shop_lodgement_reimbursment.from_date = shop_lodgement_reimbursment.from_date; prev_shop_lodgement_reimbursment.islocked = shop_lodgement_reimbursment.islocked; prev_shop_lodgement_reimbursment.isverified = shop_lodgement_reimbursment.isverified; prev_shop_lodgement_reimbursment.shop = shop_lodgement_reimbursment.shop; prev_shop_lodgement_reimbursment.teller_number = shop_lodgement_reimbursment.teller_number; prev_shop_lodgement_reimbursment.to_date = shop_lodgement_reimbursment.to_date; prev_shop_lodgement_reimbursment.transaction = shop_lodgement_reimbursment.transaction; prev_shop_lodgement_reimbursment.weekno = shop_lodgement_reimbursment.weekno; db.SubmitChanges(); return(shop_lodgement_reimbursment); } catch (Exception) { return(null); } }
public shop_lodgement_reimbursment find_shop_lodgement_reimbursment_By_AppId(string Appid) { try { shop_lodgement_reimbursment = db.shop_lodgement_reimbursments.SingleOrDefault(a => a.app_id == Appid); return(shop_lodgement_reimbursment); } catch (Exception) { return(null); } }
public shop_lodgement_reimbursment find_shop_lodgement_reimbursment_By_ID(int id) { try { shop_lodgement_reimbursment = db.shop_lodgement_reimbursments.SingleOrDefault(a => a.id == id); return(shop_lodgement_reimbursment); } catch (Exception) { return(null); } }
public shop_lodgement_reimbursment delete_shop_lodgement_reimbursment() { try { shop_lodgement_reimbursment prev_shop_lodgement_reimbursment = db.shop_lodgement_reimbursments.SingleOrDefault(a => a.id == shop_lodgement_reimbursment.id); db.shop_lodgement_reimbursments.DeleteOnSubmit(prev_shop_lodgement_reimbursment); return(shop_lodgement_reimbursment); } catch (Exception) { return(null); } }
public shop_lodgement_reimbursment_crud(shop_lodgement_reimbursment shop_lodgement_reimbursment_) { this.shop_lodgement_reimbursment_ = shop_lodgement_reimbursment_; }