public winningsHelper(master_balance_sheet master_balance_sheet_) { try { this.master_balance_sheet = master_balance_sheet_; shop_code = master_balance_sheet.shop1.shop_code; admin_user user = new admin_user(); if (master_balance_sheet.shop1.agent != null) { user = new CRUD.admin_users_crud().find_admin_user_By_ID(master_balance_sheet.shop1.agent.Value); } else if (master_balance_sheet.shop1.shopmanager_id != null) { int shopmanager = master_balance_sheet.shop1.shopmanager_id.Value; login login = new CRUD.logins_crud().find_login_By_ID(shopmanager); user = new CRUD.admin_users_crud().find_admin_user_By_ID(login.admin_users[0].id); } AccountNumber = (user.accountNo != null)? user.accountNo: ""; AccountName = (user.account_name != null) ? user.account_name : ""; Bank = (user.bank_list != null) ? user.bank_list.name : ""; Balance = master_balance_sheet.sales_balance.Value; } catch (Exception) { this.master_balance_sheet = master_balance_sheet_; shop_code = master_balance_sheet.shop1.shop_code; AccountNumber = ""; AccountName = ""; Bank = ""; Balance = master_balance_sheet.sales_balance.Value; } }
public bool SaveLapsePaymentTransaction(master_transaction newmastertransaction, master_balance_sheet masterbalance) { try { using (TransactionScope scope = new TransactionScope()) { newmastertransaction.app_id = Application().app_id; db.master_transactions.InsertOnSubmit(newmastertransaction); 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); } }
private void SaveTransactions() { try { using (TransactionScope scope = new TransactionScope()) { db.master_transactions.InsertAllOnSubmit(transactionsToSave); db.debt_transactions.InsertAllOnSubmit(debtTransactionToSave); foreach (master_balance_sheet bal in ShopBalancesToUpdate) { master_balance_sheet prevbal = db.master_balance_sheets.SingleOrDefault(a => a.id == bal.id); prevbal.credit_balance = bal.credit_balance; prevbal.sales_balance = bal.sales_balance; prevbal.netbalance = bal.netbalance; } foreach (debt debt in shopDebtsToUpdate) { debt prevdebt = db.debts.SingleOrDefault(a => a.id == debt.id); prevdebt.current_amount = debt.current_amount; prevdebt.status = debt.status; } db.SubmitChanges(); scope.Complete(); } } catch (Exception) { } }
private void SendSms(bonushelper bhelp, master_balance_sheet balancesheet, transaction_category btran) { 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 (bhelp.shop.agent != null) { sms message = new sms(); if (btran.code == "B") { if (smsvalidity) { sm mm = new CRUD.sms_crud().findByCode("BA"); message = new sms(); if (message.initialisebonusparams(bhelp.shop, mm.subject + "\r\n" + mm.content + "\r\n" + mm.conclusion, bhelp.Bonus, balancesheet.sales_balance.Value)) { ; } message.CustomizeAndSendSMS(); } } } } catch (Exception) { } }
public master_balance_sheet find_master_balance_sheet_By_ID(int id) { try { master_balance_sheet = db.master_balance_sheets.SingleOrDefault(a => a.id == id); return(master_balance_sheet); } catch (Exception) { return(null); } }
public master_balance_sheet find_master_balance_sheet_By_AppId(string Appid) { try { master_balance_sheet = db.master_balance_sheets.SingleOrDefault(a => a.App_id == Appid); return(master_balance_sheet); } catch (Exception) { return(null); } }
public master_balance_sheet find_master_balance_sheet_By_ShopId(int ShopId) { try { master_balance_sheet = db.master_balance_sheets.SingleOrDefault(a => a.shop == ShopId); return(master_balance_sheet); } catch (Exception) { return(null); } }
public master_balance_sheet delete_master_balance_sheet() { try { master_balance_sheet prev_master_balance_sheet = db.master_balance_sheets.SingleOrDefault(a => a.id == master_balance_sheet.id); db.master_balance_sheets.DeleteOnSubmit(prev_master_balance_sheet); return(master_balance_sheet); } catch (Exception) { return(null); } }
public List <master_balance_sheet> fillDataToList() { if (dtExcelRecords == null) { return(null); } else { List <master_balance_sheet> balance = new List <master_balance_sheet>(); //sho shophelper = new shop_crud(); //shop shoped; foreach (DataRow row in dtExcelRecords.Rows) { int rowindex = dtExcelRecords.Rows.IndexOf(row); //if (dtExcelRecords.Rows.IndexOf(row) == 0) // continue; //if (dtExcelRecords.Rows.IndexOf(row) == dtExcelRecords.Rows.Count - 1) // break; // var values = row.ItemArray; master_balance_sheet bal; // shop = new shop { id = -1, shop_code = (string)values[1] };// new shop_crud().find_shop_By_Code((string)values[1]) != null ? shophelper.find_shop_By_Code((string)values[1]) : new shop {id=-1, shop_code=(string) values[1]}; try { shop shop = new CRUD.shop_crud().find_shop_By_Code(values[1].ToString()); bal = new master_balance_sheet { App_id = (shop != null)?shop.shop_code :"NO RECORD", sales_balance = (values[2] != null)?decimal.Parse(values[2].ToString()):0, credit_balance = 0, netbalance = (values[2] != null) ? decimal.Parse(values[2].ToString()) : 0, online_credit = 0, shop = (shop != null)?shop.id: -1 }; balance.Add(bal); } catch (Exception) { } } return(balance); } }
public void SaveTransaction(bonushelper bhelp, transaction_category bonustransaction, admin_user user) { master_balance_sheet sendbal; transaction_category sendtran; try { using (TransactionScope scope = new TransactionScope()) { master_balance_sheet bal = db.master_balance_sheets.SingleOrDefault(a => a.shop == bhelp.shop.id); master_transaction transaction = new master_transaction { amount = bhelp.Bonus, app_id = Application().app_id, balance_after = getbal(bal.sales_balance, bhelp.Bonus, bonustransaction), balance_before = bal.sales_balance, description = bonustransaction.description + " " + "for " + fromdate.ToShortDateString() + " - " + todate.ToShortDateString(), details = bonustransaction.description + " " + "for " + fromdate.ToShortDateString() + " - " + todate.ToShortDateString(), posted_by = user.id, shop = bhelp.shop.id, trans_category = bonustransaction.id, trans_timestamp = DateTime.Now, trans_type = (bonustransaction.type == true) ? 0 : 1, }; db.master_transactions.InsertOnSubmit(transaction); master_balance_sheet prevbal = db.master_balance_sheets.SingleOrDefault(a => a.shop == bhelp.shop.id); prevbal.sales_balance = getbal(bal.sales_balance, bhelp.Bonus, bonustransaction); prevbal.netbalance = getbal(bal.netbalance, bhelp.Bonus, bonustransaction); sendbal = prevbal; sendtran = bonustransaction; db.SubmitChanges(); scope.Complete(); } SendSms(bhelp, sendbal, sendtran); } catch (Exception) { } }
public master_balance_sheet alter_master_balance_sheet() { try { master_balance_sheet prev_master_balance_sheet = db.master_balance_sheets.SingleOrDefault(a => a.id == master_balance_sheet.id); prev_master_balance_sheet.credit_balance = master_balance_sheet.credit_balance; prev_master_balance_sheet.netbalance = master_balance_sheet.netbalance; prev_master_balance_sheet.online_credit = master_balance_sheet.online_credit; prev_master_balance_sheet.sales_balance = master_balance_sheet.sales_balance; db.SubmitChanges(); return(master_balance_sheet); } catch (Exception) { return(null); } }
public bool SaveCutOffTransaction(debt_transaction newdebttransaction, debt debt, master_transaction newmastertransaction, master_balance_sheet masterbalance) { try { using (TransactionScope scope = new TransactionScope()) { newmastertransaction.app_id = Application().app_id; debt.app_id = Application().app_id; newdebttransaction.app_id = Application().app_id; db.master_transactions.InsertOnSubmit(newmastertransaction); 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.debts.InsertOnSubmit(debt); db.SubmitChanges(); newdebttransaction.debt = new CRUD.debt_crud().find_debt_By_AppId(debt.app_id).id; db.debt_transactions.InsertOnSubmit(newdebttransaction); db.SubmitChanges(); scope.Complete(); } return(true); } catch (Exception) { return(false); } }
private void ComputeBonuses() { //AutoSendSMS("234" + user.phone.Substring(1, user.phone.Length-1)); foreach (bonushelper bhelp in bonuses) { if (bhelp.Bonus > 0) { try { //workerSms = new Thread(() => SaveTransaction(bhelp, bonustransaction, user)); //workerSms.Start(); //completed++; shop shop = bhelp.shop; List <debt> shopdebt = shopDebtsToUpdate.Where(a => a.shop == shop.id).ToList <debt>(); if (shopdebt.Count > 0) { master_balance_sheet shopbal = ShopBalancesToUpdate.SingleOrDefault(a => a.shop == shop.id); bhelp.Bonus = lodgeDebt(shopdebt, bhelp.Bonus, shopbal); } if (bhelp.Bonus > 0) { master_balance_sheet shopbal = ShopBalancesToUpdate.SingleOrDefault(a => a.shop == shop.id); bhelp.Bonus = LodgeSales(shop, bhelp.Bonus, shopbal); } } catch (Exception) { } } } }
private decimal LodgeSales(shop shop, decimal bonus, master_balance_sheet shopbal) { master_transaction tran = new master_transaction() { amount = bonus, app_id = Application().app_id, balance_after = getbal(shopbal.sales_balance, bonus, bonustransaction), balance_before = shopbal.sales_balance, description = bonustransaction.description + " " + "for " + fromdate.ToShortDateString() + " - " + todate.ToShortDateString(), details = bonustransaction.description + " " + "for " + fromdate.ToShortDateString() + " - " + todate.ToShortDateString(), posted_by = user.id, shop = shop.id, trans_category = bonustransaction.id, trans_timestamp = DateTime.Now, trans_type = (bonustransaction.type == true) ? 0 : 1, }; shopbal.sales_balance = getbal(shopbal.sales_balance, bonus, bonustransaction); shopbal.netbalance = getbal(shopbal.netbalance, bonus, bonustransaction); transactionsToSave.Add(tran); return(bonus); }
public balancesheethelper(master_balance_sheet existsheet, master_daily_sale sale, List <transaction_category> trancategory) { //dbmc = dbmc_; master_daily_sale = sale; this.trancategory = trancategory; sheet = existsheet; if (sheet == null) { application app = new application { app_id = Guid.NewGuid().ToString() }; sheet = new master_balance_sheet { App_id = app.app_id, shop = master_daily_sale.shop, netbalance = Decimal.Zero, sales_balance = Decimal.Zero, credit_balance = Decimal.Zero, online_credit = Decimal.Zero }; } }
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); } }
private decimal lodgeDebt(List <debt> shopdebt, decimal amount, master_balance_sheet shopbal) { foreach (debt debt in shopdebt) { transaction_category debttran = db.transaction_categories.SingleOrDefault(a => a.code == "DL"); bank bank = new CRUD.bank_crud().find_bank_By_Code("INT"); payment_type ptype = new CRUD.payment_type_crud().find_payment_type_By_ID(1); login lodin = db.logins.Single(a => a.username == "InterSwitch"); if (amount > 0) { //debt less than or equal to bonus if (debt.current_amount <= amount && debt.status == true && debt.current_amount > 0) { decimal temp = debt.current_amount.Value; debt.current_amount = 0; debt.status = false; debt.installment_count += 1; debt_transaction dtran = new debt_transaction { amount = temp, app_id = Application().app_id, balance_after = getbal(temp, temp, debttran), balance_before = temp, description = debttran.description + " " + "for " + DateTime.Today, details = debttran.description + " " + "for " + DateTime.Today, posted_by = lodin.id, shop = debt.shop, trans_category = debttran.id, trans_timestamp = DateTime.Now, trans_type = (debttran.type == true) ? 0 : 1, debt = debt.id, }; db.debt_transactions.InsertOnSubmit(dtran); db.SubmitChanges(); debt_transaction debtIdtran = new CRUD.debt_transaction_crud().find_debt_transaction_By_AppId(dtran.app_id); debt_lodgement_reimbursment newmlr = new debt_lodgement_reimbursment { app_id = Application().app_id, amount = temp, bank = bank.id, date = DateTime.Today, shop = debt.shop, teller_number = "", islocked = true, isverified = true, payment_type = ptype.id, transaction = (debtIdtran != null) ? debtIdtran.id : 142, transaction_category = debttran.id, }; db.debt_lodgement_reimbursments.InsertOnSubmit(newmlr); amount -= temp; //debtTransactionToSave.Add(dtran); shopbal.credit_balance = getbal(shopbal.credit_balance, temp, debttran); shopbal.netbalance = getbal(shopbal.netbalance, temp, debttran); //SAVE DEBT .... BALANCES debt DebtToUpdate = db.debts.SingleOrDefault(a => a.id == debt.id); DebtToUpdate.current_amount = debt.current_amount; DebtToUpdate.status = debt.status; DebtToUpdate.installment_count = debt.installment_count; master_balance_sheet salesbalancesToUpdate = db.master_balance_sheets.SingleOrDefault(a => a.shop == shopbal.shop); salesbalancesToUpdate.credit_balance = shopbal.credit_balance; salesbalancesToUpdate.netbalance = shopbal.netbalance; db.SubmitChanges(); shop shop = new CRUD.shop_crud().find_shop_By_ID(debt.shop); SendSmsAndMail(shop, debttran, debt, dtran, newmlr); } else if (debt.current_amount > amount && debt.status == true && debt.current_amount > 0) { decimal temp = debt.current_amount.Value; debt.current_amount = getbal(debt.current_amount, amount, debttran); debt.installment_count += 1; debt_transaction dtran = new debt_transaction { amount = amount, app_id = Application().app_id, balance_after = getbal(temp, amount, debttran), balance_before = temp, description = debttran.description + " " + "for " + DateTime.Today, details = debttran.description + " " + "for " + DateTime.Today, posted_by = lodin.id, shop = debt.shop, trans_category = debttran.id, trans_timestamp = DateTime.Now, trans_type = (debttran.type == true) ? 0 : 1, debt = debt.id, }; db.debt_transactions.InsertOnSubmit(dtran); db.SubmitChanges(); //debtTransactionToSave.Add(dtran); debt_transaction debtIdtran = new CRUD.debt_transaction_crud().find_debt_transaction_By_AppId(dtran.app_id); debt_lodgement_reimbursment newmlr = new debt_lodgement_reimbursment { app_id = Application().app_id, amount = temp, bank = bank.id, date = DateTime.Today, shop = debt.shop, teller_number = "", islocked = true, isverified = true, payment_type = ptype.id, transaction = (debtIdtran != null) ? debtIdtran.id : 142, transaction_category = debttran.id, }; db.debt_lodgement_reimbursments.InsertOnSubmit(newmlr); shopbal.credit_balance = getbal(shopbal.credit_balance, amount, debttran); shopbal.netbalance = getbal(shopbal.netbalance, amount, debttran); //SAVE DEBT .... BALANCES debt DebtToUpdate = db.debts.SingleOrDefault(a => a.id == debt.id); DebtToUpdate.current_amount = debt.current_amount; DebtToUpdate.status = debt.status; DebtToUpdate.installment_count = debt.installment_count; master_balance_sheet salesbalancesToUpdate = db.master_balance_sheets.SingleOrDefault(a => a.shop == shopbal.shop); salesbalancesToUpdate.credit_balance = shopbal.credit_balance; salesbalancesToUpdate.netbalance = shopbal.netbalance; amount -= amount; db.SubmitChanges(); shop shop = new CRUD.shop_crud().find_shop_By_ID(debt.shop); SendSmsAndMail(shop, debttran, debt, dtran, newmlr); break; } } } return(amount); }
public int SaveBalanceList(List <master_balance_sheet> balance, int login, DateTime date) { int ret = 0; try { foreach (master_balance_sheet bals in balance) { master_balance_sheet bal = bals; if (bal.shop != -1) { master_balance_sheet existingbal = new CRUD.master_balance_sheet_crud().find_master_balance_sheet_By_ShopId(bal.shop.Value); if (existingbal == null) { using (TransactionScope scope = new TransactionScope()) { master_transaction transaction = new master_transaction { app_id = Application().app_id, amount = bal.netbalance, balance_before = existingbal.netbalance, balance_after = Decimal.Add(bal.netbalance.Value, existingbal.netbalance.Value), description = "Balance B/D AS AT" + date.ToShortDateString(), details = "Balance B/D AS AT " + date.ToShortDateString(), posted_by = login, shop = bal.shop, trans_category = (bal.netbalance >= 0) ? creditbalance.id : debitbalance.id, trans_timestamp = DateTime.Now, trans_type = (bal.netbalance >= 0) ? 0 : 1 }; db.master_transactions.InsertOnSubmit(transaction); db.master_balance_sheets.InsertOnSubmit(bal); scope.Complete(); } } else // (existingbal.netbalance != 0 || existingbal.sales_balance != 0) { using (TransactionScope scope = new TransactionScope()) { master_transaction transaction = new master_transaction { app_id = Application().app_id, amount = bal.netbalance, balance_before = existingbal.netbalance, balance_after = Decimal.Add(bal.netbalance.Value, existingbal.netbalance.Value), description = "Balance B/D AS AT" + date.ToShortDateString(), details = "Balance B/D AS AT " + date.ToShortDateString(), posted_by = login, shop = bal.shop, trans_category = (bal.netbalance >= 0) ? creditbalance.id : debitbalance.id, trans_timestamp = DateTime.Now, trans_type = (bal.netbalance >= 0) ? 0 : 1 }; db.master_transactions.InsertOnSubmit(transaction); bal.id = existingbal.id; bal.sales_balance = Decimal.Add(bal.sales_balance.Value, existingbal.sales_balance.Value); bal.netbalance = Decimal.Add(bal.netbalance.Value, existingbal.netbalance.Value); master_balance_sheet prev_master_balance_sheet = db.master_balance_sheets.SingleOrDefault(a => a.id == bal.id); prev_master_balance_sheet.netbalance = bal.netbalance; prev_master_balance_sheet.sales_balance = bal.sales_balance; db.SubmitChanges(); scope.Complete(); } }//else if (existingbal.netbalance == 0 && existingbal.sales_balance == 0) //{ // bal = new CRUD.master_balance_sheet_crud(bal).alter_master_balance_sheet(); //} } else { ret++; } } } catch (Exception) { ret++; } return(ret); }
public master_balance_sheet_crud(master_balance_sheet master_balance_sheet_) { this.master_balance_sheet_ = master_balance_sheet_; }
private decimal lodgeDebt(List <debt> shopdebt, decimal bonus, master_balance_sheet shopbal) { foreach (debt debt in shopdebt) { if (bonus > 0) { //debt less than or equal to bonus if (debt.current_amount <= bonus && debt.status == true && debt.current_amount > 0) { decimal temp = debt.current_amount.Value; debt.current_amount = 0; debt.status = false; debt_transaction dtran = new debt_transaction { amount = temp, app_id = Application().app_id, balance_after = getbal(temp, temp, bonustransaction), balance_before = temp, description = bonustransaction.description + " " + "for " + fromdate.ToShortDateString() + " - " + todate.ToShortDateString(), details = bonustransaction.description + " " + "for " + fromdate.ToShortDateString() + " - " + todate.ToShortDateString(), posted_by = user.id, shop = debt.shop, trans_category = bonustransaction.id, trans_timestamp = DateTime.Now, trans_type = (bonustransaction.type == true) ? 0 : 1, debt = debt.id, }; bonus -= temp; debtTransactionToSave.Add(dtran); shopbal.credit_balance = getbal(shopbal.credit_balance, temp, bonustransaction); shopbal.netbalance = getbal(shopbal.netbalance, temp, bonustransaction); } else if (debt.current_amount > bonus && debt.status == true && debt.current_amount > 0) { decimal temp = debt.current_amount.Value; debt.current_amount -= bonus; debt_transaction dtran = new debt_transaction { amount = bonus, app_id = Application().app_id, balance_after = getbal(temp, bonus, bonustransaction), balance_before = temp, description = bonustransaction.description + " " + "for " + fromdate.ToShortDateString() + " - " + todate.ToShortDateString(), details = bonustransaction.description + " " + "for " + fromdate.ToShortDateString() + " - " + todate.ToShortDateString(), posted_by = user.id, shop = debt.shop, trans_category = bonustransaction.id, trans_timestamp = DateTime.Now, trans_type = (bonustransaction.type == true) ? 0 : 1, debt = debt.id, }; debtTransactionToSave.Add(dtran); shopbal.credit_balance = getbal(shopbal.credit_balance, bonus, bonustransaction); shopbal.netbalance = getbal(shopbal.netbalance, bonus, bonustransaction); bonus -= bonus; } } } return(bonus); }
public master_daily_sale insert_master_daily_sale() { bool isupdate = false; shop shop = find_shop_By_Code(master_daily_sale.shop1.shop_code); if (shop != null) { try { WgbSalesUpload.master_daily_sale prev_master_daily_sale = db.master_daily_sales.SingleOrDefault(u => u.shop1.id == shop.id && u.date == master_daily_sale.date); master_balance_sheet existsheet; try { existsheet = sheets.SingleOrDefault(a => a.shop == shop.id); } catch (Exception) { existsheet = null; } using (TransactionScope scope = new TransactionScope()) { if (prev_master_daily_sale != null) { isupdate = true; master_daily_sale negatesale = new master_daily_sale(); negatesale.balance = Math.Abs((decimal)prev_master_daily_sale.balance); negatesale.cancelled = Math.Abs((decimal)prev_master_daily_sale.cancelled); negatesale.commision = Math.Abs((decimal)prev_master_daily_sale.commision); negatesale.date_posted = DateTime.Now; negatesale.islocked = prev_master_daily_sale.islocked; negatesale.isverified = prev_master_daily_sale.isverified; negatesale.net_balance = Math.Abs((decimal)prev_master_daily_sale.net_balance); negatesale.posted_by = prev_master_daily_sale.posted_by; negatesale.sales = Math.Abs((decimal)prev_master_daily_sale.sales); negatesale.stake = Math.Abs((decimal)prev_master_daily_sale.stake); negatesale.winnings = Math.Abs((decimal)prev_master_daily_sale.winnings); negatesale.shop = prev_master_daily_sale.shop; negatesale.date = prev_master_daily_sale.date; negatesale.single_stake_commision = Math.Abs((decimal)prev_master_daily_sale.single_stake_commision); negatesale.single_stake_sales = Math.Abs((decimal)prev_master_daily_sale.single_stake_sales); negatesale.single_stake_percent = Math.Abs((decimal)prev_master_daily_sale.single_stake_percent); negatesale.other_stake_commision = Math.Abs((decimal)prev_master_daily_sale.other_stake_commision); application app2 = new application { app_id = Guid.NewGuid().ToString() }; negatesale.app_id = app2.app_id; //db.master_daily_sales.InsertOnSubmit(negatesale); bsh = new balancesheethelper(existsheet, negatesale, trancategory); List <master_transaction> translist = bsh.getDailySalestransactionsReversal(); //lodge commission for aunty bola if (shop.shop_ownership == "WGB") { transaction_category trancatcomm = trancategory.SingleOrDefault(a => a.code == "CR"); LodgeCommission(translist.SingleOrDefault(a => a.trans_category == trancatcomm.id), trancatcomm); } db.master_transactions.InsertAllOnSubmit(translist); master_balance_sheet sheet = bsh.balancesheet; // master_balance_sheet existsheet = db.master_balance_sheets.SingleOrDefault(a => a.shop == prev_master_daily_sale.shop); if (existsheet == null) { db.master_balance_sheets.InsertOnSubmit(sheet); } else { existsheet.netbalance = sheet.netbalance; existsheet.sales_balance = sheet.sales_balance; existsheet.online_credit = sheet.online_credit; existsheet.credit_balance = sheet.credit_balance; new CRUD.master_balance_sheet_crud(existsheet).alter_master_balance_sheet(); } prev_master_daily_sale.balance = master_daily_sale.balance; prev_master_daily_sale.cancelled = master_daily_sale.cancelled; prev_master_daily_sale.commision = master_daily_sale.commision; prev_master_daily_sale.date = master_daily_sale.date; prev_master_daily_sale.date_posted = master_daily_sale.date_posted; prev_master_daily_sale.islocked = master_daily_sale.islocked; prev_master_daily_sale.isverified = master_daily_sale.isverified; prev_master_daily_sale.net_balance = master_daily_sale.net_balance; prev_master_daily_sale.posted_by = master_daily_sale.posted_by; prev_master_daily_sale.sales = master_daily_sale.sales; // prev_master_daily_sale.shop = master_daily_sale.shop; prev_master_daily_sale.stake = master_daily_sale.stake; prev_master_daily_sale.winnings = master_daily_sale.winnings; prev_master_daily_sale.single_stake_sales = master_daily_sale.single_stake_sales; prev_master_daily_sale.single_stake_commision = master_daily_sale.single_stake_commision; prev_master_daily_sale.single_stake_percent = master_daily_sale.single_stake_percent; prev_master_daily_sale.other_stake_commision = master_daily_sale.other_stake_commision; // master_balance_sheet sheet = bsh.balancesheet; // master_balance_sheet existsheet = db.master_balance_sheets.SingleOrDefault(a => a.shop == master_daily_sale.shop); bsh = new balancesheethelper(existsheet, prev_master_daily_sale, trancategory); List <master_transaction> translist2 = bsh.getDailySalestransactions(); //lodge commission for aunty bola if (shop.shop_ownership == "WGB") { transaction_category trancatcomm = trancategory.SingleOrDefault(a => a.code == "C"); LodgeCommission(translist2.SingleOrDefault(a => a.trans_category == trancatcomm.id), trancatcomm); } db.master_transactions.InsertAllOnSubmit(translist2); master_balance_sheet sheet2 = bsh.balancesheet; if (existsheet == null) { db.master_balance_sheets.InsertOnSubmit(sheet2); } else { existsheet.netbalance = sheet.netbalance; existsheet.sales_balance = sheet.sales_balance; existsheet.online_credit = sheet.online_credit; existsheet.credit_balance = sheet.credit_balance; new CRUD.master_balance_sheet_crud(existsheet).alter_master_balance_sheet(); } db.SubmitChanges(); } if (!isupdate) { application app = new application { app_id = Guid.NewGuid().ToString() }; // app = new application_crud(app).insert_application(); db.SubmitChanges(); master_daily_sale.app_id = app.app_id; master_daily_sale.shop1 = shop; master_daily_sale.date_posted = DateTime.Today; if (master_daily_sale.shop1 != null) { db.master_daily_sales.InsertOnSubmit(master_daily_sale); bsh = new balancesheethelper(existsheet, master_daily_sale, trancategory); List <master_transaction> translist = bsh.getDailySalestransactions(); //lodge commission for aunty bola if (shop.shop_ownership == "WGB") { transaction_category trancatcomm = trancategory.SingleOrDefault(a => a.code == "C"); LodgeCommission(translist.SingleOrDefault(a => a.trans_category == trancatcomm.id), trancatcomm); } db.master_transactions.InsertAllOnSubmit(translist); master_balance_sheet sheet = bsh.balancesheet; //master_balance_sheet existsheet = db.master_balance_sheets.SingleOrDefault(a => a.shop == master_daily_sale.shop); if (existsheet == null) { db.master_balance_sheets.InsertOnSubmit(sheet); } else { existsheet.netbalance = sheet.netbalance; existsheet.sales_balance = sheet.sales_balance; existsheet.online_credit = sheet.online_credit; existsheet.credit_balance = sheet.credit_balance; new CRUD.master_balance_sheet_crud(existsheet).alter_master_balance_sheet(); } } // db.master_balance_sheets.InsertOnSubmit(sheet); db.SubmitChanges(); } scope.Complete(); } return(master_daily_sale); } catch (Exception) { return(null); } } else { return(null); } }
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 { } }