String fname= request.getParameter("firstName");
			String mname= request.getParameter("middleName");
			String lname= request.getParameter("lastName");
			String dob= request.getParameter("dob");
			String ms= request.getParameter("martialStatus");
			String ssn= request.getParameter("ssnNumber");
			String lamount=request.getParameter("loanAmount");
			String lpurpose= request.getParameter("loanPurpose");
			String ldescription= request.getParameter("loanDescription");
			String addr1= request.getParameter("address_one");
			String addr2= request.getParameter("address_two");
			String city1= request.getParameter("city");
			String state1= request.getParameter("state");
			String pc= request.getParameter("postalCode");
			String hphone= request.getParameter("homePhone");
			String ophone= request.getParameter("officePhone");
			String mphone= request.getParameter("mobilePhone");
			String mailid= request.getParameter("email");
			String ename= request.getParameter("employerName");
			String esal= request.getParameter("annualSalary");
			String eaddr1= request.getParameter("employer_address_one");
			String eaddr2= request.getParameter("employer_address_two");
			String ecity= request.getParameter("employer_city");
			String estate= request.getParameter("employer_state");
			String epc= request.getParameter("employer_postalCode");
			String workex= request.getParameter("workExyear");
			String desg= request.getParameter("designation");
			String reason="NA";
			//fetching specific ssn data from beaureau

			int flag=0;
			String Query="insert into SubmitApplication (FirstName, MiddleName ,LastName, DateOfBirth,MaritalStatus,SSNNumber, LoanAmount, LoanPurpose, LoanDescription, Address1, Address2, City, CState, PostalCode, HomePhone, OfficePhone, MobileNumber, EmailAddress, EmployerName, AnnualSalary, Designation, EmployerAddressLine1, EmployerAddressLine2, EmployerCity, EmployerState, EmployerPostalCode, WorkExperience, Status,SubmittedDate) "
					+ "values('"+fname+"', '"+mname+"', '"+lname+"', '"+dob+"', '"+ms+"','"+ssn+"','"+lamount+"','"+lpurpose+"','"+ldescription+"','"+addr1+"','"+addr2+"', '"+city1+"', '"+state1+"','"+pc+"','"+hphone+"','"+ophone+"','"+mphone+"','"+mailid+"','"+ename+"','"+esal+"','"+desg+"','"+eaddr1+"','"+eaddr2+"','"+ecity+"','"+estate+"',"+"'"+epc+"','"+workex+"',"+" 'yet to add', (select SYSDATETIME()))";
			String conUrl = "jdbc:sqlserver://DJQPDSN2\\SUWETASQL; database=Training_Project; user=sa; password=Suweta@123";
			double score=0;
			int finalscore=0;
			LocalDate date1;
			long ageyrs=0,agemths=0,agedays=0;
			LocalDate date2 = LocalDate.now();
			String finalStatus="LOW FICO SCORE";
			 try {
		        	Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		        	Connection con=DriverManager.getConnection(conUrl);
					Statement st=con.createStatement();
					st.executeUpdate(Query);
					String qb="select * from BureauData where id='"+ssn+"'";


					ResultSet rs2= st.executeQuery(qb);
				//	rs2.first();
					//String display=rs2.getString("revol_bal");
					//System.out.println(display);

					//parsing fetched strings and calculting score

					double loan_amnt= Double.parseDouble(lamount);
					double ann_inc= Double.parseDouble(esal);
					double ratio = loan_amnt/ann_inc;
					double intercept = 1.036;
					int emp_length=Integer.parseInt(workex);
					while(rs2.next())
					{
						String delinq_2= rs2.getString("delinq_2yrs");
						double delinq_2yrs=Double.parseDouble(delinq_2);

						String days_str= rs2.getString("days");
						double days=Double.parseDouble(days_str);


						String inq_last_6months= rs2.getString("inq_last_6mths");
						double inq_6mnths=Double.parseDouble(inq_last_6months);


						String mnth_since_last_delq= rs2.getString("mths_since_last_delinq");
						double month_since_last_delnq=Double.parseDouble(mnth_since_last_delq);


						String mnths_since_lst_record= rs2.getString("mths_since_last_record");
						double months_since_lst_record=Double.parseDouble(mnths_since_lst_record);

						String open_acc= rs2.getString("open_acc");
						double open_account=Double.parseDouble(open_acc);

						String pub_rec= rs2.getString("pub_rec");
						double pub_record=Double.parseDouble(pub_rec);

						String revol_bal= rs2.getString("revol_bal");
						double revol_balance=Double.parseDouble(revol_bal);

						String revol_util= rs2.getString("revol_util");
						double revol_utili=Double.parseDouble(revol_util);

						String total_acc= rs2.getString("total_acc");
						double total_account=Double.parseDouble(total_acc);

						double work_exp=Double.parseDouble(workex);
						double work_exp_yrs=work_exp/12;
						double loan_amount=Double.parseDouble(lamount);

						double emp_sal=Double.parseDouble(esal);

						score=com.samplewebdemo.javaee.ProjectModel.projectfunction(lpurpose,ldescription,work_exp_yrs,loan_amount,emp_sal,delinq_2yrs,inq_6mnths,month_since_last_delnq,months_since_lst_record,open_account,pub_record,revol_balance,revol_utili,total_account,days);

						finalscore=(int)((score*550)+300);

						if (finalscore<300)
							finalscore=300;

						if (score<0.5)
						finalStatus="DECLINED";
						else
							finalStatus="SUCCESS";

						//Date date1=new SimpleDateFormat("dd/MM/yyyy").parse(dob);
						DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd");
						date1= LocalDate.parse(dob,formatter);
						//dob2=formatter.format(date2);
						 ageyrs=ChronoUnit.YEARS.between(date1, date2);
						 agemths=ChronoUnit.MONTHS.between(date1, date2);
						 agedays=ChronoUnit.DAYS.between(date1, date2);

						 if(ageyrs<18){
							 finalStatus="DECLINED";
							 reason="AGE LESS THAN 18";
						 }
						 if(ageyrs>65){
							 finalStatus="DECLINED";
							 reason="AGE GREATER THAN 65";
						 }
						 if(work_exp<6){
							 finalStatus="DECLINED";
							 reason="LESS WORK EXPERIENCE";
						 }
						 if(emp_sal<10000){
							 finalStatus="DECLINED";
							 reason="LESS ANNUAL SALARY";
						 }

					String insert_status="update SubmitApplication set Score="+finalscore+" , Reason='"+reason+"',Status='"+finalStatus+"'where SSNNumber='"+ssn+"'";
					st.executeUpdate(insert_status);
						flag=1;
					}

		        }catch(Exception e)
		        {
		        	e.printStackTrace();
		        	//w.println("in exception");

		        }