protected void btn_update_Click(object sender, EventArgs e)
{
try
{
using (var db = new THFinanceEntities())
{
int id = Convert.ToInt32(lbl_id.Text);
var q = (from s in db.tbl_borrowerPaymentmethod
where s.borrowerPayid.Equals(id)
select s).SingleOrDefault();
tbl_borrowerPaymentmethod tbl = new tbl_borrowerPaymentmethod();
tbl.borrowerBranchid = Convert.ToInt32(ddl_branch.SelectedValue);
tbl.borrowerLoanid = Convert.ToInt32(ddl_chitti.SelectedValue);
tbl.borrowermanager = Convert.ToInt32(ddl_manager.SelectedValue);
tbl.borrowerName = Convert.ToInt32(ddl_Borroerpayeename.SelectedValue);
tbl.borrowerPayamount = txt_paidAmount.Text;
tbl.borrowerPaymentdate = Convert.ToDateTime(txt_startdate.Text);
tbl.totalpayment = txt_amount.Value;
tbl.borrowerReaminingamount = txt_remainingAmount.Text;
tbl.borrowerPenalitydays = Convert.ToInt32(txt_penalitydays.Value);
tbl.modified = Convert.ToInt32(Session["UserID"]);
tbl.modifieddate = DateTime.Now;
if (tbl != null)
{
// db.tbl_borrower.Add(q);
db.SaveChanges();
clearfields();
loadgrid();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void btn_submit_Click(object sender, EventArgs e)
{
try
{
using (var db = new THFinanceEntities())
{
tbl_borrowerPaymentmethod tbl = new tbl_borrowerPaymentmethod();
int id = Convert.ToInt32(ddl_Borroerpayeename.SelectedValue);
int days = Convert.ToInt32(txt_penalitydays.Value);
var q = (from s in db.tbl_PaymentType
where s.paymentBorrowerId.Equals(id)
select s).ToList();
// txt_penalitydays.Value = "0";
if (ddl_chitti.SelectedValue == "1")
{
//txt_penalitydays.Value = Convert.ToString(dayscount);
}
else
{
}
DateTime fromdate = DateTime.Parse(Convert.ToDateTime(txt_startdate.Text).ToShortDateString());
DateTime todate = DateTime.Parse(Convert.ToDateTime(txt_enddate.Value).ToShortDateString());
if (fromdate > todate)
{
Response.Write("<script>alert('please select today date')</script>");
return;
}
else
{
tbl.borrowerBranchid = Convert.ToInt32(ddl_branch.SelectedValue);
tbl.borrowerLoanid = Convert.ToInt32(ddl_chitti.SelectedValue);
tbl.borrowerName = Convert.ToInt32(ddl_Borroerpayeename.SelectedValue);
tbl.borrowermanager = Convert.ToInt32(ddl_manager.SelectedValue);
tbl.borrowerPayamount = txt_paidAmount.Text;
tbl.borrowerReaminingamount = txt_remainingAmount.Text;
tbl.borrowerPaymentdate = todate;
tbl.borrowerPenalitydays = Convert.ToInt32(txt_penalitydays.Value);
tbl.borrowerStartdate = Convert.ToDateTime(txt_startdate.Text);
tbl.totalpayment = txt_amount.Value;
tbl.createdby = Convert.ToInt32(Session["UserID"]);
tbl.createddate = DateTime.Now;
if (ddl_chitti.SelectedValue == "1")
{
if (Convert.ToDateTime(q[0].PaymentDate) >= tbl.borrowerStartdate.AddDays(100))
{
if (tbl.borrowerReaminingamount == "0")
{
tbl.status = 1;
db.tbl_borrowerPaymentmethod.Add(tbl);
db.SaveChanges();
Response.Write("<script>alert('Payment sucessfully completed ')</script>");
clearfields();
return;
}
else
{
tbl.status = 2;
db.tbl_borrowerPaymentmethod.Add(tbl);
db.SaveChanges();
Response.Write("<script>alert('Payment pending')</script>");
clearfields();
return;
}
}
else
{
if (ddl_chitti.SelectedValue == "1")
{
tbl.borrowerReaminingamount = Convert.ToString(Convert.ToInt32(txt_remainingAmount.Text) + days * 100);
tbl.borrowerStartdate = todate.AddDays(1);
}
else
{
txt_remainingAmount.Text = Convert.ToString(Convert.ToInt32(txt_remainingAmount.Text) + days * 10);
tbl.borrowerStartdate = todate.AddMonths(1);
}
tbl.status = 0;
db.tbl_borrowerPaymentmethod.Add(tbl);
db.SaveChanges();
Response.Write("<script>alert('Sucessfully Saved')</script>");
clearfields();
return;
}
}
else
{
if (tbl.borrowerPaymentdate >= tbl.borrowerStartdate.AddMonths(12))
{
if (tbl.borrowerReaminingamount == "0")
{
tbl.status = 1;
db.tbl_borrowerPaymentmethod.Add(tbl);
db.SaveChanges();
Response.Write("<script>alert('Payment sucessfully completed ')</script>");
clearfields();
return;
}
else
{
tbl.status = 2;
db.tbl_borrowerPaymentmethod.Add(tbl);
db.SaveChanges();
Response.Write("<script>alert('Payment pending')</script>");
clearfields();
return;
}
}
else
{
if (ddl_chitti.SelectedValue == "1")
{
txt_remainingAmount.Text = Convert.ToString(Convert.ToInt32(txt_remainingAmount.Text) + days * 100);
tbl.borrowerStartdate = todate.AddDays(1);
}
else
{
txt_remainingAmount.Text = Convert.ToString(Convert.ToInt32(txt_remainingAmount.Text) + days * 10);
tbl.borrowerStartdate = todate.AddMonths(1);
}
tbl.status = 0;
db.tbl_borrowerPaymentmethod.Add(tbl);
db.SaveChanges();
Response.Write("<script>alert('Sucessfully Saved')</script>");
clearfields();
return;
}
}
//if(tbl.borrowerStartdate == tbl.borrowerStartdate.AddMonths(12))
//{
// if (tbl.borrowerReaminingamount == "0")
// {
// status = 1;
// Response.Write("<script>alert('Payment sucessfully completed ')</script>");
// return;
// }
// else
// {
// status = 2;
// }
//}
// if (tbl.borrowerReaminingamount=="0")
//{
// status = 1;
// Response.Write("<script>alert('Payment sucessfully completed ')</script>");
// return;
//}
}
}
}
catch (Exception ex)
{
throw ex;
}
}