protected void btn_update_Click(object sender, EventArgs e)
{
try
{
using (var db = new THFinanceEntities())
{
int id = Convert.ToInt32(lbl_id.Text);
tbl_Guarantor tbl = (from s in db.tbl_Guarantor
where s.GuarantorId.Equals(id)
select s).SingleOrDefault();
tbl.GuarantorAddress = txt_guaranteeaddresseee.Text;
tbl.GuarantorborrowerId = Convert.ToInt32(ddl_borrwer.SelectedValue);
tbl.GuarantorDesignation = txt_guaranteedesignation.Text;
tbl.GuarantorFatherName = txt_guaranteefathername.Text;
tbl.GuarantorName = txt_guaranteename.Text;
tbl.GuarantorPhone = txt_guaranteephone.Text;
Stream fs = txt_guaranteeprooffile.PostedFile.InputStream;
Stream fs2 = txt_guaranteephoto.PostedFile.InputStream;
BinaryReader br = new BinaryReader(fs);
BinaryReader br2 = new BinaryReader(fs2);
Byte[] bytes = br.ReadBytes((Int32)fs.Length);
Byte[] bytes2 = br2.ReadBytes((Int32)fs.Length);
tbl.Guarantorphoto = bytes2;
tbl.GuarantorProof = bytes;
tbl.GuarantorProoftype = txt_guaranteeproof.Value;
db.SaveChanges();
clearfields();
}
}
catch (Exception)
{
throw;
}
}
protected void btn_Addpayment_Click(object sender, EventArgs e)
{
paymentpage.Visible = false;
payregistration.Visible = true;
using (var db = new THFinanceEntities())
{
var countryQuery = (from c in db.tbl_branches
select c).ToList();
ddl_branch.DataValueField = "branchid";
ddl_branch.DataTextField = "branchName";
ddl_branch.DataSource = countryQuery;
ddl_branch.DataBind();
ddl_branch.Items.Insert(0, new ListItem("select", "0"));
var cd = (from context3 in db.tbl_borrower
select context3).ToList();
ddl_Borroerpayeename.DataTextField = "borrowerName";
ddl_Borroerpayeename.DataValueField = "borrowerId";
ddl_Borroerpayeename.DataSource = cd;
ddl_Borroerpayeename.DataBind();
//ddl_Borroerpayeename.Items.Insert(0, new ListItem("select", "0"));
}
}
protected void btn_signup_Click(object sender, EventArgs e)
{
entity = new THFinanceEntities();
THF_User obj = new THF_User();
//string filePath = txt_uploadimage.PostedFile.FileName;
//string filename = Path.GetFileName(filePath);
//string strname = txt_uploadimage.Value.ToString();
Stream fs = txt_uploadimage.PostedFile.InputStream;
BinaryReader br = new BinaryReader(fs);
Byte[] bytes = br.ReadBytes((Int32)fs.Length);
//txt_uploadimage.PostedFile.SaveAs(Server.MapPath("~/Uploads/") + strname);
obj.UserName = txt_UserName.Value;
obj.UserEmail = txt_UserEmail.Value;
obj.UserPassword = txt_UserPassword.Value;
obj.UserProfessional = txt_UserProfessional.Value;
obj.imagesave = bytes;
entity.THF_User.Add(obj);
entity.SaveChanges();
Response.Write("<script type=\"text/javascript\">alert('Sucessfully Created');</script>");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["Useremail"] != null)
{
string str = Convert.ToString(Session["Useremail"]);
db = new THFinanceEntities();
var q = db.THF_User.Where(a => a.UserEmail == str).ToList();
string base64String = Convert.ToBase64String(q[0].imagesave, 0, q[0].imagesave.Length);
imgupload.ImageUrl = "data:image/png;base64," + base64String;
lbl_user.Text = q[0].UserName;
lbl_professional.Text = q[0].UserProfessional;
//var qry = from s in db.Employees
// select s;
//grdCustomer.DataSource = qry.ToList();
//grdCustomer.DataBind();
//grdCustomer.UseAccessibleHeader = true;
//grdCustomer.HeaderRow.TableSection = TableRowSection.TableHeader;
}
else
{
Response.Redirect("login.aspx");
}
}
}
public void loadgrid()
{
try
{
using (var context = new THFinanceEntities())
{
var q = (from s in context.tbl_PaymentType
join t1 in context.tbl_borrower on s.paymentBorrowerId equals t1.borrowerId
select new { s.PaymentDate, s.PaymentAmount, s.PaymentType, t1.borrowerName, s.givenamount, s.paymentId }).ToList();
if (q.Count == 0)
{
gridpayment.DataSource = q;
gridpayment.DataBind();
}
else
{
gridpayment.DataSource = q;
gridpayment.DataBind();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void btn_submit_Click(object sender, EventArgs e)
{
try
{
using (var db = new THFinanceEntities())
{
tble_Vehicle tbl = new tble_Vehicle();
tbl.VehicleBHP = txt_vehiclebhp.Text;
tbl.VehicleBorroerId = Convert.ToInt32(ddl_vehicelborrwer.SelectedValue);
tbl.VehicleChasisNo = txt_vehiclechasis.Text;
tbl.VehicleColor = txt_vehiclecolour.Text;
tbl.VehicleEngineNo = txt_enginenumber.Text;
tbl.VehicleInsurance = txt_vehicleinsurance.Value;
tbl.VehicleKeyNo = txt_vehiclekey.Value;
tbl.Vehiclemodel = txt_vehiclemodel.Text;
tbl.VehicleType = txt_VehicleType.Value;
if (tbl != null)
{
db.tble_Vehicle.Add(tbl);
db.SaveChanges();
clearfields();
}
}
}
catch (Exception)
{
throw;
}
}
protected void btn_Addpayment_Click(object sender, EventArgs e)
{
paymentmethod.Visible = false;
formguarantee.Visible = true;
btn_update.Visible = false;
btn_submit.Visible = true;
using (var db = new THFinanceEntities())
{
var cd = (from context3 in db.tbl_borrower
select context3).ToList();
ddl_paymentborrwer.DataTextField = "borrowerName";
ddl_paymentborrwer.DataValueField = "borrowerId";
ddl_paymentborrwer.DataSource = cd;
ddl_paymentborrwer.DataBind();
ddl_paymentborrwer.Items.Insert(0, new ListItem("select", "0"));
var countryQuery1 = (from a in db.tbl_chitti
select a).ToList();
ddl_chitti.DataValueField = "CHITTI_ID";
ddl_chitti.DataTextField = "CHITTI_NAME";
ddl_chitti.DataSource = countryQuery1;
ddl_chitti.DataBind();
ddl_chitti.Items.Insert(0, new ListItem("select", "0"));
}
}
protected void lnk_Edit_Command(object sender, CommandEventArgs e)
{
int id = Convert.ToInt32(e.CommandArgument);
using (var db = new THFinanceEntities())
{
var q = (from s in db.tble_Vehicle
where s.VehicleId.Equals(id)
select s).ToList();
var q1 = db.tbl_borrower.ToList();
ddl_vehicelborrwer.DataTextField = "borrowerName";
ddl_vehicelborrwer.DataValueField = "borrowerId";
ddl_vehicelborrwer.DataSource = q1;
ddl_vehicelborrwer.DataBind();
ddl_vehicelborrwer.Items.Insert(0, new ListItem("select", "0"));
lbl_id.Text = Convert.ToString(q[0].VehicleId);
txt_vehiclebhp.Text = q[0].VehicleBHP;
ddl_vehicelborrwer.SelectedValue = Convert.ToString(q[0].VehicleBorroerId);
txt_vehiclechasis.Text = q[0].VehicleChasisNo;
txt_vehiclecolour.Text = q[0].VehicleColor;
txt_enginenumber.Text = q[0].VehicleEngineNo;
txt_vehicleinsurance.Value = q[0].VehicleInsurance;
txt_vehiclekey.Value = q[0].VehicleKeyNo;
txt_vehiclemodel.Text = q[0].Vehiclemodel;
txt_VehicleType.Value = q[0].VehicleType;
}
}
protected void btn_update_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(lbl_id.Text);
try
{
using (var db = new THFinanceEntities())
{
var q = (from s in db.tble_Vehicle where s.VehicleBorroerId.Equals(id)
select s).Single();
tble_Vehicle tbl = new tble_Vehicle();
tbl.VehicleBHP = txt_vehiclebhp.Text;
tbl.VehicleBorroerId = Convert.ToInt32(ddl_vehicelborrwer.SelectedValue);
tbl.VehicleChasisNo = txt_vehiclechasis.Text;
tbl.VehicleColor = txt_vehiclecolour.Text;
tbl.VehicleEngineNo = txt_enginenumber.Text;
tbl.VehicleInsurance = txt_vehicleinsurance.Value;
tbl.VehicleKeyNo = txt_vehiclekey.Value;
tbl.Vehiclemodel = txt_vehiclemodel.Text;
tbl.VehicleType = txt_VehicleType.Value;
db.SaveChanges();
clearfields();
}
}
catch (Exception)
{
throw;
}
}
protected void txt_paidAmount_TextChanged(object sender, EventArgs e)
{
using (var db = new THFinanceEntities())
{
int id = Convert.ToInt32(ddl_Borroerpayeename.SelectedValue);
var q = (from s in db.tbl_PaymentType
where s.paymentBorrowerId.Equals(id)
select s).ToList();
var q1 = (from p in db.tbl_borrowerPaymentmethod
where p.borrowerName.Equals(id)
select p).ToList();
if (q1.Count == 0)
{
txt_remainingAmount.Text = Convert.ToString(Convert.ToInt32(q[0].PaymentAmount) - Convert.ToInt32((txt_paidAmount.Text)));
}
else
{
txt_remainingAmount.Text = Convert.ToString(Convert.ToInt32(q1[q1.Count - 1].borrowerReaminingamount) - Convert.ToInt32((txt_paidAmount.Text)));
//txt_paidAmount.Text = Convert.ToString(Convert.ToInt32(txt_amount.Value) / 100);
// txt_remainingAmount.Text = Convert.ToString(Convert.ToInt32(txt_amount.Value) - Convert.ToInt32(txt_paidAmount.Text));
}
}
}
protected void lnk_Edit_Command(object sender, CommandEventArgs e)
{
paymentpage.Visible = false;
payregistration.Visible = true;
btn_submit.Visible = false;
btn_update.Visible = true;
int id = Convert.ToInt32(e.CommandArgument);
using (var db = new THFinanceEntities())
{
var q = (from s in db.tbl_borrowerPaymentmethod
where s.borrowerPayid.Equals(id)
select s).ToList();
int manager = q[0].borrowerBranchid;
var countryQuery = (from c in db.tbl_branches
select c).ToList();
ddl_branch.DataValueField = "branchid";
ddl_branch.DataTextField = "branchName";
ddl_branch.DataSource = countryQuery;
ddl_branch.DataBind();
ddl_branch.Items.Insert(0, new ListItem("select", "0"));
var cd = (from context3 in db.tbl_borrower
select context3).ToList();
ddl_Borroerpayeename.DataTextField = "borrowerName";
ddl_Borroerpayeename.DataValueField = "borrowerId";
ddl_Borroerpayeename.DataSource = cd;
ddl_Borroerpayeename.DataBind();
ddl_Borroerpayeename.Items.Insert(0, new ListItem("select", "0"));
var countryQuery1 = (from a in db.tbl_managers
where a.manage_id.Equals(manager)
select a).ToList();
ddl_manager.DataValueField = "manage_id";
ddl_manager.DataTextField = "manager_name";
ddl_manager.DataSource = countryQuery1;
ddl_manager.DataBind();
ddl_manager.Items.Insert(0, new ListItem("select", "0"));
var countryQuery2 = (from a in db.tbl_chitti
select a).ToList();
ddl_chitti.DataValueField = "CHITTI_ID";
ddl_chitti.DataTextField = "CHITTI_NAME";
ddl_chitti.DataSource = countryQuery2;
ddl_chitti.DataBind();
ddl_chitti.Items.Insert(0, new ListItem("select", "0"));
lbl_id.Text = Convert.ToString(q[0].borrowerPayid);
ddl_Borroerpayeename.SelectedValue = Convert.ToString(q[0].borrowerName);
ddl_branch.SelectedValue = Convert.ToString(q[0].borrowerBranchid);
ddl_manager.SelectedValue = Convert.ToString(q[0].borrowermanager);
ddl_chitti.SelectedValue = Convert.ToString(q[0].borrowerLoanid);
txt_amount.Value = q[0].totalpayment;
txt_startdate.Text = Convert.ToString(q[0].borrowerStartdate);
txt_enddate.Value = Convert.ToString(q[0].borrowerPaymentdate);
txt_paidAmount.Text = q[0].borrowerPayamount;
txt_penalitydays.Value = Convert.ToString(q[0].borrowerPenalitydays);
txt_remainingAmount.Text = q[0].borrowerReaminingamount;
}
}
protected void ddl_payeename_SelectedIndexChanged(object sender, EventArgs e)
{
db = new THFinanceEntities();
int id = Convert.ToInt32(ddl_payeename.SelectedValue);
var countryQuery = (from c in db.tbl_branches
select c).ToList();
var payee = (from p in db.tbl_payment where p.name.Equals(id)
select p).ToList();
ddl_branch.DataValueField = "branchid";
ddl_branch.DataTextField = "branchName";
ddl_branch.DataSource = countryQuery;
ddl_branch.DataBind();
ddl_branch.Items.Insert(0, new ListItem("select", "0"));
var query = (from s in db.tbl_payee where s.ID.Equals(id)
select s).ToList();
var q = (from s in db.tbl_payment
where s.name.Equals(id)
select s).ToList();
if (q.Count > 0)
{
}
int id1 = Convert.ToInt32(query[0].branchId);
ddl_branch.SelectedValue = Convert.ToString(id1);
//int brnchid= Convert.ToInt32(query[0].branchId);
var query1 = (from c in db.tbl_managers where c.mgbrnch_id.Equals(id1)
select c).ToList();
ddl_manager.DataValueField = "manage_id";
ddl_manager.DataTextField = "manager_name";
ddl_manager.DataSource = query1;
ddl_manager.DataBind();
ddl_manager.Items.Insert(0, new ListItem("select", "0"));
ddl_manager.SelectedValue = Convert.ToString(query[0].managerId);
ddl_chitti.SelectedIndex = Convert.ToInt32(query[0].paymentmethod);
txt_amount.Value = Convert.ToString(query[0].amount);
txt_paidAmount.Text = Convert.ToString(Convert.ToInt32(query[0].amount) / 100);
if (payee.Count == 0)
{
txt_remainingAmount.Text = Convert.ToString(Convert.ToInt32(txt_amount.Value) - Convert.ToInt32(txt_paidAmount.Text));
txt_startdate.Text = Convert.ToString(query[0].startdate);
}
else
{
txt_remainingAmount.Text = Convert.ToString(Convert.ToInt32(payee[payee.Count - 1].remainingAmount) - Convert.ToInt32(txt_paidAmount.Text));
txt_startdate.Text = Convert.ToString(payee[payee.Count - 1].presentDate);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (var db = new THFinanceEntities())
{
DateTime str5 = DateTime.Now.AddDays(-5);
DateTime str = DateTime.Now;
DateTime str6 = DateTime.Now.AddDays(-6);
DateTime m2 = DateTime.Now.AddDays(-60);
DateTime m5 = DateTime.Now.AddDays(-90);
var q = (from s in db.tbl_borrowerPaymentmethod
where s.borrowerLoanid == 1 && s.borrowerStartdate == str.Date
group s by s.borrowerName
into groups
select groups.OrderByDescending(p => p.borrowerPayid).FirstOrDefault()).ToList();
var q6 = (from element in db.tbl_borrowerPaymentmethod
where element.borrowerLoanid == 1 && (element.borrowerStartdate < str6.Date)
group element by element.borrowerName
into groups
select groups.OrderByDescending(p => p.borrowerPayid).FirstOrDefault()).ToList();
var q5 = (from s in db.tbl_borrowerPaymentmethod
where s.borrowerLoanid == 1 && (s.borrowerStartdate < str.Date && s.borrowerStartdate >= str.Date)
group s by s.borrowerName
into groups
select groups.OrderByDescending(p => p.borrowerPayid).FirstOrDefault()).ToList();
var qm = (from s in db.tbl_borrowerPaymentmethod
where s.borrowerLoanid == 2 && s.borrowerStartdate == str.Date
group s by s.borrowerName
into groups
select groups.OrderByDescending(p => p.borrowerPayid).FirstOrDefault()).ToList();
var qm2 = (from s in db.tbl_borrowerPaymentmethod
where s.borrowerLoanid == 2 && (s.borrowerStartdate < str.Date && s.borrowerStartdate >= m2.Date)
group s by s.borrowerName
into groups
select groups.OrderByDescending(p => p.borrowerPayid).FirstOrDefault()).ToList();
var qm3 = (from s in db.tbl_borrowerPaymentmethod
where s.borrowerLoanid == 2 && (s.borrowerStartdate < m2.Date)
group s by s.borrowerName
into groups
select groups.OrderByDescending(p => p.borrowerPayid).FirstOrDefault()).ToList();
//var q6 = (from s in db.tbl_borrowerPaymentmethod
// where s.borrowerLoanid == 1 && ( s.borrowerStartdate > str.Date)
// group s by s.borrowerName).ToList();
lbl_daily.Text = Convert.ToString(q.Count);
lbl_daily5.Text = Convert.ToString(q5.Count);
lbl_dailylimit.Text = Convert.ToString(q6.Count);
lbl_monthly.Text = Convert.ToString(qm.Count);
lbl_monthly2.Text = Convert.ToString(qm2.Count);
lbl_monthly5.Text = Convert.ToString(qm3.Count);
}
}
}
public void loadgrid()
{
try
{
using (var context = new THFinanceEntities())
{
var q = (from s in context.tbl_borrowerPaymentmethod
join t1 in context.tbl_branches on s.borrowerBranchid equals t1.branchid
join t2 in context.tbl_managers on s.borrowermanager equals t2.manage_id
join t3 in context.tbl_chitti on s.borrowerLoanid equals t3.CHITTI_ID
join t4 in context.tbl_borrower on s.borrowerName equals t4.borrowerId
orderby s.borrowerPayid descending
select new { s.borrowerPayamount, s.borrowerPaymentdate, s.borrowerPayid, s.totalpayment, s.borrowerReaminingamount, s.borrowerStartdate, s.borrowerPenalitydays, t1.branchName, t2.manager_name, t3.CHITTI_NAME, t4.borrowerName });
///
var fd = (from t in context.tbl_borrowerPaymentmethod
group t by t.borrowerName into g select g.OrderByDescending(p => p.borrowerPayid).FirstOrDefault() as tbl_borrowerPaymentmethod
into td join bp in context.tbl_branches on td.borrowerBranchid equals bp.branchid
join bp1 in context.tbl_managers on td.borrowerBranchid equals bp1.manage_id
join bp2 in context.tbl_chitti on td.borrowerBranchid equals bp2.CHITTI_ID
join bp3 in context.tbl_borrower on td.borrowerName equals bp3.borrowerId
select new
{
td.borrowerPayamount,
td.borrowerPaymentdate,
td.borrowerPayid,
td.totalpayment,
td.borrowerReaminingamount,
td.borrowerStartdate,
td.borrowerPenalitydays,
bp.branchName,
bp1.manager_name,
bp2.CHITTI_NAME,
bp3.borrowerName
}
).ToList();
if (fd != null)
{
gridpaymentdetails.DataSource = fd;
gridpaymentdetails.DataBind();
}
else
{
gridpaymentdetails.DataSource = fd;
gridpaymentdetails.DataBind();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public void loadgrid()
{
db = new THFinanceEntities();
var qry = from s in db.tbl_branches
select s;
grdBranch.DataSource = qry.ToList();
grdBranch.DataBind();
}
public void loadgrid()
{
db = new THFinanceEntities();
var query = (from s in db.tbl_chitti
select s).ToList();
grdPayment.DataSource = query;
grdPayment.DataBind();
}
protected void ddl_Borroerpayeename_SelectedIndexChanged(object sender, EventArgs e)
{
int id = Convert.ToInt32(ddl_Borroerpayeename.SelectedValue);
using (var db = new THFinanceEntities())
{
var q = (from s in db.tbl_PaymentType
where s.paymentBorrowerId.Equals(id)
select s).ToList();
var q1 = (from p in db.tbl_borrowerPaymentmethod
where p.borrowerName.Equals(id)
select p).ToList();
if (q1.Count == 0)
{
int payment = Convert.ToInt32(q[0].paymentmethod);
if (payment == 1)
{
txt_amount.Value = Convert.ToString(q[0].PaymentAmount);
txt_startdate.Text = Convert.ToString(q[0].PaymentDate);
txt_paidAmount.Text = Convert.ToString(Convert.ToInt32(txt_amount.Value) / 100);
txt_remainingAmount.Text = Convert.ToString(Convert.ToInt32(txt_amount.Value) - Convert.ToInt32(txt_paidAmount.Text));
}
else
{
txt_amount.Value = Convert.ToString(q[0].PaymentAmount);
// txt_startdate.Text = Convert.ToString(q[0].PaymentDate);
DateTime installmentDate = Convert.ToDateTime(q[0].PaymentDate.ToString("dd/MM/yyyy")).AddMonths(1);
txt_startdate.Text = Convert.ToString(installmentDate);
txt_paidAmount.Text = Convert.ToString(Convert.ToInt32(txt_amount.Value) / 12 + Convert.ToInt32(txt_amount.Value) * 2 / 100);
txt_remainingAmount.Text = Convert.ToString(Convert.ToInt32(txt_amount.Value) - Convert.ToInt32(txt_paidAmount.Text));
}
}
else
{
txt_amount.Value = Convert.ToString(q1[q1.Count - 1].totalpayment);
txt_startdate.Text = Convert.ToString(q1[q1.Count - 1].borrowerStartdate);
txt_paidAmount.Text = Convert.ToString(q[0].monthlyInterest);
txt_remainingAmount.Text = Convert.ToString(Convert.ToInt32(q1[q1.Count - 1].borrowerReaminingamount) - Convert.ToInt32(txt_paidAmount.Text));
//txt_paidAmount.Text = Convert.ToString(Convert.ToInt32(txt_amount.Value) / 100);
// txt_remainingAmount.Text = Convert.ToString(Convert.ToInt32(txt_amount.Value) - Convert.ToInt32(txt_paidAmount.Text));
}
var countryQuery1 = (from a in db.tbl_chitti
select a).ToList();
ddl_chitti.DataValueField = "CHITTI_ID";
ddl_chitti.DataTextField = "CHITTI_NAME";
ddl_chitti.DataSource = countryQuery1;
ddl_chitti.DataBind();
ddl_chitti.Items.Insert(0, new ListItem("select", "0"));
ddl_chitti.SelectedValue = Convert.ToString(q[0].paymentmethod);
}
}
protected void btn_payment_Click(object sender, EventArgs e)
{
db = new THFinanceEntities();
tbl_chitti tbl = new tbl_chitti();
tbl.CHITTI_NAME = txt_payment.Text;
db.tbl_chitti.Add(tbl);
db.SaveChanges();
loadgrid();
}
protected void btn_managers_Click(object sender, EventArgs e)
{
db = new THFinanceEntities();
tbl_managers tbl = new tbl_managers();
tbl.mgbrnch_id = Convert.ToInt32(ddl_branch.SelectedValue);
tbl.manager_name = txt_manager.Text;
db.tbl_managers.Add(tbl);
db.SaveChanges();
}
public void loadgrid()
{
db = new THFinanceEntities();
var q = (from s in db.tbl_borrower
select s).ToList();
gridregistration.DataSource = q;
gridregistration.DataBind();
griddiv.Visible = true;
form1.Visible = false;
}
protected void ddl_payeeName_SelectedIndexChanged(object sender, EventArgs e)
{
db = new THFinanceEntities();
int id = Convert.ToInt32(ddl_payeeName.SelectedValue);
var q = (from s in db.tbl_payment
join t1 in db.tbl_chitti on s.paymentmethod equals t1.CHITTI_ID
where s.name.Equals(id)
select new { s.totalPayment, s.presentDate, s.paidAmount, s.remainingAmount, s.remainingdays, t1.CHITTI_NAME }).ToList();
grdpayeeDetails.DataSource = q;
grdpayeeDetails.DataBind();
}
protected void btn_submit_Click(object sender, EventArgs e)
{
try
{
using (var db = new THFinanceEntities())
{
tbl_PaymentType tbl = new tbl_PaymentType();
var q = (from s in db.tbl_PaymentType
select s).ToList();
tbl.paymentBorrowerId = Convert.ToInt32(ddl_paymentborrwer.SelectedValue);
tbl.PaymentDate = Convert.ToDateTime(txt_startdate.Value);
tbl.PaymentType = txt_PaymentType.Value;
tbl.PaymentAmount = Convert.ToInt32(txt_PaymentAmount.Text);
tbl.givenamount = txt_givenAmount.Text;
tbl.paymentmethod = Convert.ToInt32(ddl_chitti.SelectedValue);
tbl.monthlyInterest = txt_monthlypayment.Text;
if (q.Count == 0)
{
db.tbl_PaymentType.Add(tbl);
db.SaveChanges();
Response.Write("<script>alert('Sucessfully saved')</script>");
loadgrid();
clearfields();
return;
}
else
{
for (int i = 0; i < q.Count; i++)
{
var present = tbl.paymentBorrowerId;
var prev = q[i].paymentBorrowerId;
if (present == prev)
{
Response.Write("<script>alert('Borrower already exist')</script>");
return;
}
}
}
db.tbl_PaymentType.Add(tbl);
db.SaveChanges();
Response.Write("<script>alert('Sucessfully saved')</script>");
clearfields();
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
db = new THFinanceEntities();
var query = (from s in db.tbl_payee
select new { s.name, s.ID }).ToList();
ddl_payeeName.DataTextField = "name";
ddl_payeeName.DataValueField = "ID";
ddl_payeeName.DataSource = query;
ddl_payeeName.DataBind();
ddl_payeeName.Items.Insert(0, new ListItem("select", "0"));
}
}
protected void ddl_branch_SelectedIndexChanged(object sender, EventArgs e)
{
using (var db = new THFinanceEntities())
{
int id = Convert.ToInt32(ddl_branch.SelectedValue);
var countryQuery1 = (from a in db.tbl_managers
where a.manage_id.Equals(id)
select a).ToList();
ddl_manager.DataValueField = "manage_id";
ddl_manager.DataTextField = "manager_name";
ddl_manager.DataSource = countryQuery1;
ddl_manager.DataBind();
ddl_manager.Items.Insert(0, new ListItem("select", "0"));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
db = new THFinanceEntities();
var countryQuery = (from c in db.tbl_branches
select c).ToList();
ddl_branch.DataValueField = "branchid";
ddl_branch.DataTextField = "branchName";
ddl_branch.DataSource = countryQuery;
ddl_branch.DataBind();
ddl_branch.Items.Insert(0, new ListItem("select", "0"));
loadgrid();
}
}
protected void btn_Addguarantee_Click(object sender, EventArgs e)
{
griddiv.Visible = false;
formguarantee.Visible = true;
btn_submit.Visible = true;
btn_cancel.Visible = true;
btn_update.Visible = false;
using (var db = new THFinanceEntities())
{
var q = db.tbl_borrower.ToList();
ddl_vehicelborrwer.DataTextField = "borrowerName";
ddl_vehicelborrwer.DataValueField = "borrowerId";
ddl_vehicelborrwer.DataSource = q;
ddl_vehicelborrwer.DataBind();
ddl_vehicelborrwer.Items.Insert(0, new ListItem("select", "0"));
}
}
protected void btn_Addguarantee_Click(object sender, EventArgs e)
{
gridguaranteeregistration.Visible = false;
formguarantee.Visible = true;
btn_login.Visible = true;
btn_Addguarantee.Visible = false;
btn_cancel.Visible = true;
using (var context = new THFinanceEntities())
{
var q = context.tbl_borrower.ToList();
ddl_borrwer.DataTextField = "borrowerName";
ddl_borrwer.DataValueField = "borrowerId";
ddl_borrwer.DataSource = q;
ddl_borrwer.DataBind();
ddl_borrwer.Items.Insert(0, new ListItem("select", "0"));
}
}
public void loadgrid()
{
try
{
using (var db = new THFinanceEntities())
{
var q = (from s in db.tble_Vehicle
select s).ToList();
gridVehicle.DataSource = q;
gridVehicle.DataBind();
griddiv.Visible = true;
formguarantee.Visible = false;
}
}
catch (Exception)
{
throw;
}
}
protected void btn_submit_Click(object sender, EventArgs e)
{
THFinanceEntities db = new THFinanceEntities();
THF_User obj = new THF_User();
Session["Useremail"] = txt_userloginemail.Value;
obj.UserPassword = txt_userloginpassword.Value;
obj.UserEmail = txt_userloginemail.Value;
var q = db.THF_User.Where(a => a.UserEmail == obj.UserEmail && a.UserPassword == obj.UserPassword).ToList();
if (q.Count > 0)
{
Session["UserID"] = q[0].UserId;
Response.Redirect("default.aspx");
}
else
{
Response.Write("<script type=\"text/javascript\">alert('username and password are wrong');</script>");
}
}
public void Loadgrid()
{
try
{
using (var context = new THFinanceEntities())
{
var q = (from s in context.tbl_Guarantor
join t1 in context.tbl_borrower on s.GuarantorborrowerId equals t1.borrowerId
select new { s.GuarantorAddress, s.GuarantorFatherName, s.GuarantorName, s.GuarantorPhone, s.Guarantorphoto, s.GuarantorProof, s.GuarantorProoftype, t1.borrowerName, s.GuarantorId }).ToList();
if (q != null)
{
gridguaranteeregistration.DataSource = q;
gridguaranteeregistration.DataBind();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
