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;
}
protected void INSERT(object sender, EventArgs e)
{
debt = debt_insert();
}
protected void Insert_Select_Record(object sender, EventArgs e)
{
debt = Insert_debt_select(Convert.ToInt32(Insert_debt_GridView.SelectedValue));
}
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);
}
protected void UPDATE(object sender, EventArgs e)
{
debt = debt_update(Convert.ToInt32(Update_debt_GridView.SelectedValue));
}
