public ActionResult Edetails(int ide, int idee) { empid = ide; loanid = idee; List <string> l = new List <string>(); string r = "Request Status"; string q = "select Value from Lookup where Category = '" + r + "'"; if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlCommand cmd = new SqlCommand(q, conn); SqlDataReader reader = cmd.ExecuteReader(); string value = "0"; // int i = 0; while (reader.Read()) { value = (reader[0].ToString()); // l[i] = value; l.Add(value); // i++; } DB7Entities4 db = new DB7Entities4(); Lookup db1 = new Lookup(); ViewBag.choice = new SelectList(l); //s choice.SelectedValue = l.Attributes("InitialValue"); var getRequestStatus = db.LoanRequestStatus.ToList(); SelectList list = new SelectList(getRequestStatus, "LoanId", "RequestStatus"); ViewBag.requeststatus = list; DataTable dt = new DataTable(); if (conn.State == ConnectionState.Closed) { conn.Open(); } string query1 = "select Employee.Id,LoanApply.LoanApplyId,FirstName +' '+ LastName as [Name], Email,Department.Name,Designation,Salary,HireDate,RequestDate,LoanMoney,NoOfInstallments,InstallmentStartDate,InstallmentEndDate,RequestDate from Employee Join LoanApply on Employee.Id = LoanApply.EmployeeId join LoanRequestStatus on LoanApply.LoanApplyId = LoanRequestStatus.LoanId join Department on Department.Id = Employee.DepartmentId where RequestStatus = 'Pending' and Employee.Id = '" + ide + "' and LoanApplyId = '" + idee + "'"; SqlDataAdapter da = new SqlDataAdapter(query1, conn); da.Fill(dt); return(View(dt)); }
public ActionResult prodocumentsverify(int ide, int idee) { DataTable dt = new DataTable(); if (conn.State == ConnectionState.Closed) { conn.Open(); } loanide = idee; List <string> l = new List <string>(); string r = "Request Status"; string q1 = "select Value from Lookup where Category = '" + r + "'"; if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlCommand cmd = new SqlCommand(q1, conn); SqlDataReader reader = cmd.ExecuteReader(); string value = "0"; // int i = 0; while (reader.Read()) { value = (reader[0].ToString()); // l[i] = value; l.Add(value); // i++; } DB7Entities4 db = new DB7Entities4(); Lookup db1 = new Lookup(); ViewBag.choice = new SelectList(l); string a = "Against Provident Fund"; string st = "Accepted"; string q; q = "select Employee.Id,LoanApply.LoanApplyId, FirstName +' '+ LastName as [Name], Email,LoanMoney,LoanApply.[RequestDate],NoOfInstallments,[Installment Money],InstallmentStartDate,InstallmentEndDate,PropertyDocument,AutomobileDocument,SubmissionDate,IsDefaulter from Employee Join LoanApply on Employee.Id = LoanApply.EmployeeId join LoanCategory on LoanApply.LoanCategory = LoanCategory.Id join LoanRequestStatus on LoanApply.LoanApplyId = LoanRequestStatus.LoanId join LoanDocumentVerify on LoanDocumentVerify.LoanId = LoanApply.LoanApplyId where LoanDocumentVerify.LoanId ='" + idee + "'"; SqlDataAdapter da = new SqlDataAdapter(q, conn); da.Fill(dt); // r data = db.LoanApplies.SqlQuery(query).ToList(); return(View(dt)); }
public ActionResult Login2(Models.Person emp) { using (var context = new DB7Entities4()) { bool isValid = context.Employees.Any(x => x.Email == emp.Email && x.Password == emp.Password); bool isValid1 = context.Admins.Any(x => x.Email == emp.Email && x.Password == emp.Password); if (isValid) { FormsAuthentication.SetAuthCookie(emp.Email, false); return(RedirectToAction("welcome", "loan\\welcome")); } else if (isValid1) { FormsAuthentication.SetAuthCookie(emp.Email, false); return(RedirectToAction("welcome", "HR\\welcome")); } ModelState.AddModelError("", "Invalid Email or Password"); return(View()); } }