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); } } }