/
LoanEntry.aspx.cs
90 lines (72 loc) · 2.5 KB
/
LoanEntry.aspx.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Globalization;
using CLS_BL;
using CLS_DL;
public partial class LoanEntry : System.Web.UI.Page
{
int K = 0;
DataTable Dt = new DataTable();
SQLDB SqlObj = new SQLDB();
CHEBL objBL = new CHEBL();
PLTaxi PLobj = new PLTaxi();
DateTime Today;
int _INS = 0;
string Username = string.Empty;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LoadBankMaster();
}
}
public void LoadBankMaster()
{
CmbBankName.DataTextField = "BANKNAME";
CmbBankName.DataValueField = "BID";
CmbBankName.DataSource = objBL.GetBankMaster();
CmbBankName.DataBind();
CmbBankName.Items.Insert(0, "BankName");
}
protected void CmbBankName_TextChanged(object sender, EventArgs e)
{
string Price;
Price = SqlObj.ExecuteScalar("SELECT BRANCH FROM BANKMASTER WHERE BANKNAME='" + CmbBankName.SelectedItem.Text + "'");
txtBranchName.Text = Convert.ToString(Price);
}
protected void btnSave_Click(object sender, EventArgs e)
{
InsertLoanMaster();
}
public void InsertLoanMaster()
{
System.Globalization.DateTimeFormatInfo dateInfo = new System.Globalization.DateTimeFormatInfo();
dateInfo.ShortDatePattern = "dd/MM/yyyy";
PLobj.BID = Convert.ToInt32(CmbBankName.SelectedValue);
PLobj.LoanDt = Convert.ToDateTime(txtLoanDt.Text, dateInfo);
PLobj.AccountNo = Convert.ToInt64(txtAccountNo.Text);
PLobj.DueDt = Convert.ToDateTime(txtEMTDt.Text, dateInfo);
PLobj.LoanAmt = Convert.ToDecimal(txtLoanTotAmt.Text);
PLobj.EmiAmt = Convert.ToDecimal(txtEMIAmt.Text);
PLobj.Status = "UnPaid";
K = objBL.InsertLoanMaster(PLobj);
if (K > 0)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "err_msg", "alert(' Loan Record Saved Successful !');location.href='LoanEntry.aspx'", true);
}
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "err_msg", "alert(' Loan Record Inserted Failed !');location.href='LoanEntry.aspx'", true);
}
}
}