public master_lodgement_reimbursment alter_master_lodgement_reimbursment() { try { master_lodgement_reimbursment prev_master_lodgement_reimbursment = db.master_lodgement_reimbursments.SingleOrDefault(a => a.id == master_lodgement_reimbursment.id); prev_master_lodgement_reimbursment.amount = master_lodgement_reimbursment.amount; prev_master_lodgement_reimbursment.bank = master_lodgement_reimbursment.bank; prev_master_lodgement_reimbursment.date = master_lodgement_reimbursment.date; prev_master_lodgement_reimbursment.from_date = master_lodgement_reimbursment.from_date; prev_master_lodgement_reimbursment.islocked = master_lodgement_reimbursment.islocked; prev_master_lodgement_reimbursment.isverified = master_lodgement_reimbursment.isverified; prev_master_lodgement_reimbursment.shop = master_lodgement_reimbursment.shop; prev_master_lodgement_reimbursment.teller_number = master_lodgement_reimbursment.teller_number; prev_master_lodgement_reimbursment.to_date = master_lodgement_reimbursment.to_date; prev_master_lodgement_reimbursment.transaction = master_lodgement_reimbursment.transaction; prev_master_lodgement_reimbursment.transaction_category = master_lodgement_reimbursment.transaction_category; prev_master_lodgement_reimbursment.transaction_type = master_lodgement_reimbursment.transaction_type; prev_master_lodgement_reimbursment.weekno = master_lodgement_reimbursment.weekno; db.SubmitChanges(); return(master_lodgement_reimbursment); } catch (Exception) { return(null); } }
public master_lodgement_reimbursment find_master_lodgement_reimbursment_By_AppId(string Appid) { try { master_lodgement_reimbursment = db.master_lodgement_reimbursments.SingleOrDefault(a => a.app_id == Appid); return(master_lodgement_reimbursment); } catch (Exception) { return(null); } }
public master_lodgement_reimbursment find_master_lodgement_reimbursment_By_ID(int id) { try { master_lodgement_reimbursment = db.master_lodgement_reimbursments.SingleOrDefault(a => a.id == id); return(master_lodgement_reimbursment); } catch (Exception) { return(null); } }
public master_lodgement_reimbursment delete_master_lodgement_reimbursment() { try { master_lodgement_reimbursment prev_master_lodgement_reimbursment = db.master_lodgement_reimbursments.SingleOrDefault(a => a.id == master_lodgement_reimbursment.id); db.master_lodgement_reimbursments.DeleteOnSubmit(prev_master_lodgement_reimbursment); return(master_lodgement_reimbursment); } catch (Exception) { return(null); } }
public bool initializeParameters(shop shop, string message, master_lodgement_reimbursment trans) { if (message.Contains("{lodgement_analysis}")) { string lodgementstring = ""; lodgementstring = "NGN" + trans.amount.ToString("#,0.00") + " to our " + trans.bank1.code + " A/C"; message = message.Replace("{lodgement_analysis}", lodgementstring); } if (message.Contains("{reimbursment_analysis}")) { string reimbursmentstring = ""; reimbursmentstring = "NGN" + trans.amount.ToString("#,0.00"); message = message.Replace("{reimbursment_analysis}", reimbursmentstring); } messages = message; return(initializeParameters(shop, message, new object())); }
public bool SaveMasterLodgementTransaction(master_lodgement_reimbursment newmlr, master_transaction newmastertransaction, master_balance_sheet masterbalance) { try { using (TransactionScope scope = new TransactionScope()) { newmastertransaction.app_id = Application().app_id; newmlr.app_id = Application().app_id; db.master_transactions.InsertOnSubmit(newmastertransaction); db.SubmitChanges(); newmlr.transaction = new CRUD.master_transaction_crud().find_master_transaction_By_AppId(newmastertransaction.app_id).id; newmlr.transaction_type = (newmastertransaction.transaction_category.type == true) ? 1 : 0; newmlr.transaction_category = newmastertransaction.trans_category; db.master_lodgement_reimbursments.InsertOnSubmit(newmlr); master_balance_sheet prev_master_balance_sheet = db.master_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 master_lodgement_reimbursment_crud(master_lodgement_reimbursment master_lodgement_reimbursment_) { this.master_lodgement_reimbursment_ = master_lodgement_reimbursment_; }
private void AddnewLodgementReimbursementTransaction(shop shop, transaction_category tran, PaymentNotificationRequest pnr, BettingSuiteDataContext db) { DateTime date = DateTime.Today; master_balance_sheet masterbalance = new CRUD.master_balance_sheet_crud().getMasterBalanceByShopId(shop.id); if (masterbalance == null) { masterbalance = new master_balance_sheet { shop = shop.id, credit_balance = 0, online_credit = 0, sales_balance = 0, netbalance = 0, }; masterbalance = new CRUD.master_balance_sheet_crud(masterbalance).insert_master_balance_sheet(); } master_transaction reversalmastertransaction = new master_transaction(); master_lodgement_reimbursment newmlr = new master_lodgement_reimbursment { amount = pnr.Amount, bank = 0,//interswitch id, date = date, shop = shop.id, teller_number = pnr.PaymentLogId.ToString(), islocked = true, isverified = true, payment_type = 5, transaction_category = tran.id, }; login lodin = db.logins.Single(a => a.username == "InterSwitch"); master_transaction newmastertransaction = new master_transaction { amount = Math.Abs(pnr.Amount), balance_before = (masterbalance != null) ? masterbalance.sales_balance : 0, balance_after = (masterbalance != null) ? getbal(masterbalance.sales_balance, pnr.Amount, tran) : pnr.Amount, shop = shop.id, trans_category = tran.id, trans_timestamp = DateTime.Now, trans_type = (tran.type == true) ? 1 : 0, posted_by = lodin.id,// interswitch id, description = pnr.PaymentReference + " Posted For " + date.ToShortDateString(), details = (tran.code == "L") ? "Lodgement For " + date.ToShortDateString() : "Lodgement Reversal For " + date.ToShortDateString() }; masterbalance.sales_balance = (masterbalance != null) ? getbal(masterbalance.sales_balance, newmastertransaction.amount, tran) : newmastertransaction.amount; masterbalance.netbalance = (masterbalance != null) ? getbal(masterbalance.netbalance, newmastertransaction.amount, tran) : newmastertransaction.amount; bool loadtran = new Utilities.TransactionHelper().SaveMasterLodgementTransaction(newmlr, newmastertransaction, masterbalance); if (loadtran) { try { bool mailvalidity = new Utilities.Mail_Validity_Helper().getMailSendingStatus(); SMS_Vendor_Validity_Helper valhelp = new SMS_Vendor_Validity_Helper(); sms_vendor vendor = valhelp.getVendorsByName("50kobo"); bool smsvalidity = (DateTime.Today <= vendor.expiry_date) ? true : false; if (newmlr.bank1.code != "CASH") { sms message; if (tran.code == "L") { if (smsvalidity) { sm mm = new CRUD.sms_crud().findByCode("CA"); message = new sms(); if (message.initializeParameters(shop, mm.subject.Trim() + "\r\n" + mm.content.Trim() + "\r\n" + mm.conclusion.Trim(), newmlr)) { message.CustomizeAndSendSMS(); } } if (mailvalidity) { mail mail = new CRUD.mail_crud().findByCode("LA"); MailClient client = new MailClient(); client.SendLodgementReimbursementMail(shop, mail, newmastertransaction); } } else if (tran.code == "R") { if (smsvalidity) { sm mm = new CRUD.sms_crud().findByCode("DA"); message = new sms(); if (message.initializeParameters(shop, mm.subject + "\r\n" + mm.content + "\r\n" + mm.conclusion, newmlr)) { message.CustomizeAndSendSMS(); } } if (mailvalidity) { mail mail = new CRUD.mail_crud().findByCode("RA"); MailClient client = new MailClient(); client.SendLodgementReimbursementMail(shop, mail, newmastertransaction); } } } } catch (Exception) { } } else { } }