protected void Application_Start(object sender, EventArgs e)
{
Application["AllUsersList"] = new List <UserInfo>();
List <UserInfo> allUsersList = Application["AllUsersList"] as List <UserInfo>;
SqlConnection con = null;
SqlConnection con2 = new SqlConnection("Data Source=dcm.uhcl.edu;Initial Catalog=c432018sp01madalas;User ID= madalas; Password=1604652");
try
{
con = new SqlConnection("Data Source=dcm.uhcl.edu;Initial Catalog=c432018sp01madalas;User ID= madalas; Password=1604652");
con.Open();
SqlCommand cmd = new SqlCommand("select * from MadalaS_WADsp18_UserInfo", con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
UserInfo user = new UserInfo();
user.EmailAddress1 = reader["EmailAddress1"].ToString();
user.EmailAddress2 = reader["EmailAddress2"].ToString();
user.FirstName = reader["FirstName"].ToString();
user.MiddleInitials = reader["MiddleInitials"].ToString();
user.LastName = reader["LastName"].ToString();
user.HomeStreetAddress = reader["HomeStreetAddress"].ToString();
user.HomeAptNo = reader["HomeAptNo"].ToString();
user.HomeCity = reader["HomeCity"].ToString();
user.HomeState = reader["HomeState"].ToString();
user.HomeZip = reader["HomeZip"].ToString();
user.HomePhone = reader["HomePhone"].ToString();
user.TimeAtCurrentAddressYears = Int32.Parse(reader["TimeAtCurrentAddressYears"].ToString());
user.TimeAtCurrentAddressMonths = Int32.Parse(reader["TimeAtCurrentAddressMonths"].ToString());
user.HousingStatus = Int32.Parse(reader["HousingStatus"].ToString());
user.SocialSecurity = reader["SocialSecurity"].ToString();
user.DateOfBirth = reader["DateOfBirth"].ToString();
user.DriversLicenseLastFourDigits = Int32.Parse(reader["DLLastFourDigits"].ToString());
user.PassWord = reader["Pwd"].ToString();
allUsersList.Add(user);
con2 = new SqlConnection("Data Source=dcm.uhcl.edu;Initial Catalog=c432018sp01madalas;User ID= madalas; Password=1604652");
con2.Open();
SqlCommand cmd2 = new SqlCommand("select * from MadalaS_WADsp18_LoanInfo", con2);
SqlDataReader reader2 = cmd2.ExecuteReader();
while (reader2.Read())
{
LoanInfor loan = new LoanInfor();
loan.ApplicationType = reader2["applicationType"].ToString();
loan.PrimaryLoanPurpose = reader2["primaryLoanPurpose"].ToString();
loan.LoanAmount = float.Parse(reader2["loanAmount"].ToString(), CultureInfo.InvariantCulture.NumberFormat);
loan.LoanTerm = Int32.Parse(reader2["loanTerm"].ToString());
loan.LoanPaymentMethod = Int32.Parse(reader2["loanPaymentMethod"].ToString());
for (var i = 0; i < allUsersList.Count; i++)
{
if (allUsersList[i].EmailAddress1 == reader2["emailAddress"].ToString())
{
allUsersList[i].loanInfor.Add(loan);
}
}
user.loanInfor.Add(loan);
}
}
}
catch (SqlException ex)
{
Response.Write("<script>alert('error" + ex.ToString() + "')</script>");
}
finally
{
con.Close();
con2.Close();
}
}
protected void OnBtnClick(object sender, EventArgs e)
{
if (submitButton.Text == "Go Back")
{
Server.Transfer("MyAccount.aspx");
}
else
{
if (confirm.Checked)
{
List <UserInfo> allUsersList = Application["AllUserList"] as List <UserInfo>;
//List<LoanInfor> tempLoan = new List<LoanInfor>();
LoanInfor loan = new LoanInfor();
UserInfo cUser = (UserInfo)Session["currentuser"];
loan.ApplicationType = DropDownList.SelectedItem.Text.ToString();
loan.PrimaryLoanPurpose = list.SelectedItem.Text.ToString();
loan.LoanAmount = Int32.Parse(loanAmtTextBox.Text.Split('.')[0]);
loan.LoanTerm = Int32.Parse(loanTermTextBox.Text);
loan.LoanPaymentMethod = Int32.Parse(payMethodRadio.SelectedItem.Value);
cUser.loanInfor.Add(loan);
SqlConnection con = null;
try
{
con = new SqlConnection("Data Source=dcm.uhcl.edu;Initial Catalog=c432018sp01madalas;User ID= madalas; Password=1604652");
con.Open();
SqlCommand cmd = new SqlCommand("INSERT into MadalaS_WADsp18_LoanInfo(emailAddress, applicationType, primaryLoanPurpose, loanAmount, loanTerm, loanPaymentMethod) values(@Email, @AppType, @Purpose, @Amount, @Term, @PayMethod)", con);
cmd.Prepare();
cmd.Parameters.AddWithValue("@Email", cUser.EmailAddress1);
cmd.Parameters.AddWithValue("@AppType", DropDownList.SelectedItem.Text.ToString());
cmd.Parameters.AddWithValue("@Purpose", list.SelectedItem.Text.ToString());
cmd.Parameters.AddWithValue("@Amount", Int32.Parse(loanAmtTextBox.Text.Split('.')[0]));
cmd.Parameters.AddWithValue("@Term", Int32.Parse(loanTermTextBox.Text));
cmd.Parameters.AddWithValue("@PayMethod", Int32.Parse(payMethodRadio.SelectedItem.Value));
cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
Response.Write("<script>alert('error" + ex.ToString() + "')</script>");
}
finally
{
con.Close();
}
String msgTo = cUser.EmailAddress1;
String msgSub = "Thank you for your interest in AmericalAutoLoans";
String msgBody = "Dear New User " + cUser.EmailAddress1 + "<br /> Thank you for creating AmericanAutoLoans account. Our staff will review your application within the next 24 hours. You will recieve an email notification with few more details. <br /> Our support staff is available 24 hours a day to answer questions regarding your loan application.<br /> Thank You. <br /> AmericanAutoLoans.com Team";
MailMessage obj = new MailMessage();
obj.Body = msgBody;
obj.From = new MailAddress("*****@*****.**", "American Auto Loans");
obj.To.Add(new MailAddress(msgTo));
obj.Subject = msgSub;
obj.IsBodyHtml = true;
SmtpClient clnt = new System.Net.Mail.SmtpClient();
clnt.Host = "smtp.gmail.com";
clnt.Port = 587;
clnt.EnableSsl = true;
clnt.UseDefaultCredentials = false;
clnt.DeliveryMethod = SmtpDeliveryMethod.Network;
clnt.Credentials = new NetworkCredential("*****@*****.**", "1234Asdf");
try
{
clnt.Send(obj);
}
catch (Exception ex)
{
//Label1.Text = ex.ToString();
}
finally
{
}
Session["appType"] = DropDownList.SelectedItem;
Session["loanPurpose"] = list.SelectedItem;
Session["loanAmt"] = loanAmtTextBox.Text;
Session["loanTerm"] = loanTermTextBox.Text;
Session["payMethod"] = payMethodRadio.SelectedItem;
Response.Write("<script>alert('Thank you " + cUser.FirstName + " " + cUser.LastName + " for creating Account with us. You can now Signin')</script>");
Server.Transfer("Home.aspx");
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('Please accept conformation checkbox');", true);
}
}
}
