public debt alter_debt() { try { debt prev_debt = db.debts.SingleOrDefault(a => a.id == debt.id); prev_debt.debt_type = debt.debt_type; prev_debt.amount = debt.amount; prev_debt.current_amount = debt.current_amount; prev_debt.startdate = debt.startdate; prev_debt.expirydate = debt.expirydate; prev_debt.proposed_installment = debt.proposed_installment; prev_debt.installment_count = debt.installment_count; prev_debt.proposed_installment_amount = debt.proposed_installment_amount; prev_debt.installment_duration = debt.installment_duration; prev_debt.status = debt.status; prev_debt.other_information = debt.other_information; db.SubmitChanges(); return(debt); } catch (Exception) { return(null); } }
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) { } }
public debt find_debt_By_AppId(string Appid) { try { debt = db.debts.SingleOrDefault(a => a.app_id == Appid); return(debt); } catch (Exception) { return(null); } }
public debt find_debt_By_ID(int id) { try { debt = db.debts.SingleOrDefault(a => a.id == id); return(debt); } catch (Exception) { return(null); } }
public debt delete_debt() { try { debt prev_debt = db.debts.SingleOrDefault(a => a.id == debt.id); db.debts.DeleteOnSubmit(prev_debt); return(debt); } catch (Exception) { return(null); } }
public debt Insert_debt_select(int ID) { debt = debt.Select(ID); Insert_amt_paid_txt.Text = Convert.ToString(debt.amt_paid); Insert_case_id_txt.Text = Convert.ToString(debt.case_id); Insert_client_id_txt.Text = Convert.ToString(debt.client_id); Insert_creditor_name_txt.Text = Convert.ToString(debt.creditor_name); Insert_debt_amt_txt.Text = Convert.ToString(debt.debt_amt); Insert_item_purchased_txt.Text = Convert.ToString(debt.item_purchased); Insert_last_payment_date_txt.Text = Convert.ToString(debt.last_payment_date); Insert_purchase_date_txt.Text = Convert.ToString(debt.purchase_date); Insert_value_amt_txt.Text = Convert.ToString(debt.value_amt); return(debt); }
public debt debt_insert() { debt.amt_paid = Convert.ToDecimal(Insert_amt_paid_txt.Text); debt.case_id = Convert.ToInt32(Insert_case_id_txt.Text); debt.client_id = Convert.ToInt32(Insert_client_id_txt.Text); debt.creditor_name = Insert_creditor_name_txt.Text; debt.debt_amt = Convert.ToDecimal(Insert_debt_amt_txt.Text); debt.item_purchased = Insert_item_purchased_txt.Text; debt.last_payment_date = Convert.ToDateTime(Insert_last_payment_date_txt.Text); debt.purchase_date = Convert.ToDateTime(Insert_purchase_date_txt.Text); debt.value_amt = Convert.ToDecimal(Insert_value_amt_txt.Text); debt = debt.Insert(debt); Insert_debt_GridView.DataBind(); Update_debt_GridView.DataBind(); Delete_debt_GridView.DataBind(); return(debt); }
public debt debt_insert() { debt.amt_paid = Convert.ToDecimal(Insert_amt_paid_txt.Text); debt.case_id = Convert.ToInt32(Insert_case_id_txt.Text); debt.client_id = Convert.ToInt32(Insert_client_id_txt.Text); debt.creditor_name = Insert_creditor_name_txt.Text; debt.debt_amt = Convert.ToDecimal(Insert_debt_amt_txt.Text); debt.item_purchased = Insert_item_purchased_txt.Text; debt.last_payment_date = Convert.ToDateTime(Insert_last_payment_date_txt.Text); debt.purchase_date = Convert.ToDateTime(Insert_purchase_date_txt.Text); debt.value_amt = Convert.ToDecimal(Insert_value_amt_txt.Text); debt = debt.Insert(debt); Insert_debt_GridView.DataBind(); Update_debt_GridView.DataBind(); Delete_debt_GridView.DataBind(); return debt; }
public debt debt_update(int ID) { debt = debt.Select(ID); debt.debt_id = Convert.ToInt32(Update_debt_id_txt.Text); debt.amt_paid = Convert.ToDecimal(Update_amt_paid_txt.Text); debt.case_id = Convert.ToInt32(Update_case_id_txt.Text); debt.client_id = Convert.ToInt32(Update_client_id_txt.Text); debt.creditor_name = Update_creditor_name_txt.Text; debt.debt_amt = Convert.ToDecimal(Update_debt_amt_txt.Text); debt.item_purchased = Update_item_purchased_txt.Text; debt.last_payment_date = Convert.ToDateTime(Update_last_payment_date_txt.Text); debt.purchase_date = Convert.ToDateTime(Update_purchase_date_txt.Text); debt.value_amt = Convert.ToDecimal(Update_value_amt_txt.Text); debt.Update(debt); Insert_debt_GridView.DataBind(); Update_debt_GridView.DataBind(); Delete_debt_GridView.DataBind(); return debt; }
public debt debt_update(int ID) { debt = debt.Select(ID); debt.debt_id = Convert.ToInt32(Update_debt_id_txt.Text); debt.amt_paid = Convert.ToDecimal(Update_amt_paid_txt.Text); debt.case_id = Convert.ToInt32(Update_case_id_txt.Text); debt.client_id = Convert.ToInt32(Update_client_id_txt.Text); debt.creditor_name = Update_creditor_name_txt.Text; debt.debt_amt = Convert.ToDecimal(Update_debt_amt_txt.Text); debt.item_purchased = Update_item_purchased_txt.Text; debt.last_payment_date = Convert.ToDateTime(Update_last_payment_date_txt.Text); debt.purchase_date = Convert.ToDateTime(Update_purchase_date_txt.Text); debt.value_amt = Convert.ToDecimal(Update_value_amt_txt.Text); debt.Update(debt); Insert_debt_GridView.DataBind(); Update_debt_GridView.DataBind(); Delete_debt_GridView.DataBind(); return(debt); }
public void MinGroup(int group_id) { try { group group = db.groups.Where((x) => x.idgroups == group_id).First(); decimal[,] matrix = new decimal[group.users.Count, group.users.Count]; var list = group.users.ToList(); for (var i = 0; i < list.Count; i++) { var debt_list = list[i].debts.Where((x) => x.column == list[i].id).ToList(); foreach (var debt in debt_list) { int user_id = list.IndexOf(db.users.Where((x) => x.id == debt.row).First()); if (user_id != -1) { matrix[user_id, i] = debt.value.Value; db.debts.Remove(debt); } } } //db.SaveChanges(); Res(matrix); for (int i = 0; i < list.Count; i++) { for (int j = 0; j < list.Count; j++) { if (matrix[i, j] != 0) { debt d = new debt(); d.row = list[i].id; d.column = list[j].id; d.value = matrix[i, j]; list[i].debts1.Add(d); } } } db.SaveChanges(); } catch (Exception) { } }
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 SendSmsAndMail(shop shop, transaction_category tran, debt debt, debt_transaction dtran, debt_lodgement_reimbursment newmlr) { 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 (shop.agent != null) { sms message; if (tran.code == "DL") { if (smsvalidity) { sm mm = new CRUD.sms_crud().findByCode("DL"); message = new sms(); if (message.initializeDebtParameters(shop, debt, dtran, newmlr, mm.subject.Trim() + "\r\n" + mm.content.Trim() + "\r\n" + mm.conclusion.Trim())) { message.CustomizeAndSendSMS(); } } if (mailvalidity) { mail mail = new CRUD.mail_crud().findByCode("DL"); MailClient client = new MailClient(); client.SendDebtLodgement(shop, mail, debt, dtran); } } } } catch (Exception) { } }
public debt_crud(debt debt_) { this.debt_ = debt_; }
protected void Update_Select_Record(object sender, EventArgs e) { debt = Update_debt_select(Convert.ToInt32(Update_debt_GridView.SelectedValue)); }
public ActionResult AddDebt(string summ, int group_id, string count, string comment) { var t = JsonConvert.DeserializeObject <result>(count); var div = t.array.Count(); Decimal Sum = 0; try { Sum = System.Convert.ToDecimal(Eval.JScriptEvaluate(summ, VsaEngine.CreateEngine())); } catch (Exception) { return(RedirectToAction("Index", "Error", new { error = "Введено неверное выражение" })); } if (Sum > 0) { Decimal debt = Sum / div; foreach (var id in t.array) { var user = db.users.Where((x) => x.id == id.id).First(); VDolgah.debt first = null; if ((first = user.debts1.Where((x) => x.column == (Session["user"] as VDolgah.user).id).FirstOrDefault()) != null) { first.value += debt; addLog(debt, group_id, comment, user.id); } else if ((first = user.debts.Where((x) => x.row == (Session["user"] as VDolgah.user).id).FirstOrDefault()) != null) { first.value -= debt; if (first.value == 0) { db.debts.Remove(first); } if (first.value < 0) { debt tmp = new VDolgah.debt(); tmp.row = first.column; tmp.column = first.row; tmp.value = -first.value; db.debts.Add(tmp); addLog(debt, group_id, comment, tmp.row); db.debts.Remove(first); } else { addLog(debt, group_id, comment, user.id); } } else if (id.id != (Session["user"] as VDolgah.user).id) { var d = new debt(); d.row = id.id; d.column = (Session["user"] as VDolgah.user).id; d.value = debt; db.debts.Add(d); addLog(debt, group_id, comment, user.id); } } db.SaveChanges(); return(RedirectToAction("Index", new { group_id = group_id })); } else { return(RedirectToAction("Index", "Error", new { error = "Введен долг, который равен 0 или отрицательный" })); } }
protected void INSERT(object sender, EventArgs e) { debt = debt_insert(); }
protected void Delete_Select_Record(object sender, EventArgs e) { debt = Delete_debt_select(Convert.ToInt32(Delete_debt_GridView.SelectedValue)); }
protected void Insert_Select_Record(object sender, EventArgs e) { debt = Insert_debt_select(Convert.ToInt32(Insert_debt_GridView.SelectedValue)); }
protected void UPDATE(object sender, EventArgs e) { debt = debt_update(Convert.ToInt32(Update_debt_GridView.SelectedValue)); }
protected void Save_Debt_info() { clientdebt.client_id = clientperson.person_id; clientdebt.case_id = clientCase_intake.case_id; foreach (GridViewRow rows in GVDebt.Rows) { if (rows.Cells[1].Text != null && rows.Cells[1].Text != " ") { clientdebt.creditor_name = rows.Cells[1].Text; } else { clientdebt.creditor_name = null; } if (rows.Cells[2].Text != null && rows.Cells[2].Text != " ") { clientdebt.amt_paid = Convert.ToDecimal(rows.Cells[2].Text); } else { clientdebt.amt_paid = 0; } if (rows.Cells[3].Text != null && rows.Cells[3].Text != " ") { clientdebt.item_purchased = rows.Cells[3].Text; } else { clientdebt.item_purchased = null; } if (rows.Cells[4].Text != null && rows.Cells[4].Text != " ") { clientdebt.last_payment_date = Convert.ToDateTime(rows.Cells[4].Text); } else { clientdebt.last_payment_date = DateTime.Now; } if (rows.Cells[5].Text != null && rows.Cells[5].Text != " ") { clientdebt.purchase_date = Convert.ToDateTime(rows.Cells[5].Text); } else { clientdebt.purchase_date = DateTime.Now; } if (rows.Cells[6].Text != null && rows.Cells[6].Text != " ") { clientdebt.value_amt = Decimal.Round(Convert.ToDecimal(rows.Cells[6].Text), 0); } else { clientdebt.value_amt = 0; } if (rows.Cells[7].Text == null || rows.Cells[7].Text == " ") { clientdebt = clientdebt.Insert(clientdebt); } else { clientdebt.debt_id = Convert.ToInt32(rows.Cells[7].Text); clientdebt.Update(clientdebt); } } }
public DebtRenderer(debt debt) { this.id = debt.id; this.name = (debt.debt_type1 != null) ? debt.debt_type1.name : "UNKNOWN"; this.debt_ = debt; }
public List <debt_transaction> GetShopDebtTransactionWithinDate(shop shop, debt debt) { return(db.debt_transactions.Where(a => a.shop == shop.id && a.debt == debt.id).ToList <debt_transaction>()); }
public debt Delete_debt_select(int ID) { debt = debt.Select(ID); Delete_debt_id_txt_lbl.Text = Convert.ToString(debt.debt_id); Delete_amt_paid_txt_lbl.Text = Convert.ToString(debt.amt_paid); Delete_case_id_txt_lbl.Text = Convert.ToString(debt.case_id); Delete_client_id_txt_lbl.Text = Convert.ToString(debt.client_id); Delete_creditor_name_txt_lbl.Text = Convert.ToString(debt.creditor_name); Delete_debt_amt_txt_lbl.Text = Convert.ToString(debt.debt_amt); Delete_item_purchased_txt_lbl.Text = Convert.ToString(debt.item_purchased); Delete_last_payment_date_txt_lbl.Text = Convert.ToString(debt.last_payment_date); Delete_purchase_date_txt_lbl.Text = Convert.ToString(debt.purchase_date); Delete_value_amt_txt_lbl.Text = Convert.ToString(debt.value_amt); return debt; }
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); }