// Check session in page initial stage protected override void OnActionExecuting(ActionExecutingContext filterContext) { try { if (Session["AuthenticatedUser"] != null) { userData = ((User)Session["AuthenticatedUser"]); } else { if (HttpContext.Request.IsAjaxRequest()) { filterContext.Result = new HttpStatusCodeResult(404, "Due to inactivity your session has timed out, please log in again."); } else { filterContext.Result = new RedirectResult("/Login/UserLogin?lbl=Due to inactivity your session has timed out, please log in again."); } } } catch { filterContext.Result = new RedirectResult("~/Exceptions/Index"); } }
// Check session in page initia stage protected override void OnActionExecuting(ActionExecutingContext filterContext) { try { if (Session["AuthenticatedUser"] != null) { userData = ((User)Session["AuthenticatedUser"]); } else { if (HttpContext.Request.IsAjaxRequest()) { //new HttpStatusCodeResult(404, "Failed to Setup company."); filterContext.Result = new HttpStatusCodeResult(404, "Due to inactivity your session has timed out, please log in again."); } else { filterContext.Result = new RedirectResult("/Login/UserLogin?lbl=Due to inactivity your session has timed out, please log in again."); } } } catch(Exception) { //filterContext.Result = new RedirectResult("~/Login/UserLogin"); //filterContext.Controller.TempData.Add("UserLogin", "Login"); filterContext.Result = new RedirectResult("~/Exceptions/Index"); } }
/// <summary> /// CreatedBy : Kanishka SHM /// CreatedDate: 2016/01/16 /// /// Insert User details /// /// argument : user (User) /// /// /// UpdatedBy : nadeeka /// UpdatedDate: 2016/03/03 /// removed existing connection open method and set parameter's to object list and pass stored procedure name to /// call DataHandler class to save user object /// </summary> /// <returns>1</returns> public int InsertUser(User user) { DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); paramertList.Add(new object[] { "@user_Id", user.UserId }); paramertList.Add(new object[] { "@user_name", user.UserName }); paramertList.Add(new object[] { "@password", user.Password }); paramertList.Add(new object[] { "@first_name", user.FirstName }); paramertList.Add(new object[] { "@last_name", user.LastName }); paramertList.Add(new object[] { "@email", user.Email }); paramertList.Add(new object[] { "@phone_no", user.PhoneNumber }); paramertList.Add(new object[] { "@status", user.Status }); paramertList.Add(new object[] { "@is_delete", user.IsDelete }); paramertList.Add(new object[] { "@created_by", user.CreatedBy }); paramertList.Add(new object[] { "@create_Date", DateTime.Now }); paramertList.Add(new object[] { "@branch_id", user.BranchId }); paramertList.Add(new object[] { "@role_id", user.RoleId }); paramertList.Add(new object[] { "@Company_id", user.Company_Id }); paramertList.Add(new object[] { "@step_status", user.step_status }); try { return dataHandler.ExecuteSQLReturn("spInsertUser", paramertList); } catch (Exception ex) { throw ex; } }
/// <summary> /// CreatedBy:Irfan MAM /// CreatedDate:2016/2/9 /// check the loan number is unique for a branch /// </summary> /// <returns>true or false</returns> public bool IsUniqueLoanNumberForBranch(string loanNumber, int RegisteredBranchId, User user,int loanId) { try { DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); paramertList.Add(new object[] { "@loan_number", loanNumber }); paramertList.Add(new object[] { "@branch_id", RegisteredBranchId }); paramertList.Add(new object[] { "@loan_id", loanId }); DataSet dataSet = dataHandler.GetDataSet("spIsUniqueLoanNumberForBranch", paramertList); if (dataSet != null && dataSet.Tables.Count != 0 && dataSet.Tables[0].Rows.Count != 0) { return false; } else { return true; } } catch (Exception ex) { throw ex; } }
// Check session in page initia stage protected override void OnActionExecuting(ActionExecutingContext filterContext) { try { if ((Session["AuthenticatedUser"] != null))// || (Session["loanStep"] != null) { userData = ((User)Session["AuthenticatedUser"]); if (Session["loanStep"] != null) { loanData = ((LoanSetupStep)Session["loanStep"]); Session["companyStep"] = 5; if(loanData.loanId > 0) { loanstep = loanData.stepId; CurtailmentAccess curtailmentAccess = new CurtailmentAccess(); _loan = curtailmentAccess.GetLoanDetailsByLoanId(loanData.loanId); Session["isInterest"] = _loan.isInterestCalculate; } else if (loanData.loanId == 0) { loanstep = 1; //CurtailmentAccess curtailmentAccess = new CurtailmentAccess(); // _loan = curtailmentAccess.GetLoanDetailsByLoanId(loanData.loanId); // Session["isInterest"] = _loan.isInterestCalculate; } } } else { if (HttpContext.Request.IsAjaxRequest()) { filterContext.Result = new HttpStatusCodeResult(404, "Due to inactivity your session has timed out, please log in again."); } else { filterContext.Result = new RedirectResult("/Login/UserLogin?lbl=Due to inactivity your session has timed out, please log in again."); } } } catch { filterContext.Result = new RedirectResult("~/Exceptions/Index"); } }
public DataSet SelectRequestAns(User user) { try { DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); paramertList.Add(new object[] { "@user_id", user.UserId }); return dataHandler.GetDataSet("spGetUserReque", paramertList); } catch (Exception ex) { throw ex; } }
/// <summary> /// CreatedBy : Kasun Samarawickrama /// CreatedDate: 2016/01/14 /// /// user login authentication /// /// UpdatedBy : Asanka /// UpdatedDate: 2016/03/04 /// removed existing connection open method and set parameter's to object list and pass stored procedure name to /// call DataHandler class to save user object /// </summary> /// <param name="username"></param> /// <param name="password"></param> /// /// <returns>userid</returns> public DataSet CheckUserLogin(User user) { DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); paramertList.Add(new object[] { "@userName", user.UserName }); try { return dataHandler.GetDataSet("spUserLogin", paramertList); } catch (Exception ex) { throw ex; } }
// Check session in page initia stage protected override void OnActionExecuting(ActionExecutingContext filterContext) { if (Session["AuthenticatedUser"] != null) { try { userData = ((User)Session["AuthenticatedUser"]); } catch { filterContext.Controller.TempData.Add("UserLogin", "Login"); } } else { filterContext.Controller.TempData.Add("UserLogin", "Login"); //filterContext.Result = new RedirectResult("~/Login/UserLogin"); //return RedirectToAction("UserLogin", "Login", new { lbl = "Your Session Expired" }); } }
/// <summary> // Frontend Page: Report page(Branch Summary report) /// Title: Display Branch Summary report /// Designed: Piyumi Perera /// User story: /// Developed: Piyumi Perera /// Date created: /// </summary> public void RenderReport(int branchId,string branchName, List<RptBranchSummary> branchSummary) { //check authentication session is null, if null return if (Session["AuthenticatedUser"] == null) return; User userData = (User)Session["AuthenticatedUser"]; //set reportviewr properties rptViewerBranchSummary.ProcessingMode = ProcessingMode.Local; rptViewerBranchSummary.Reset(); rptViewerBranchSummary.LocalReport.EnableExternalImages = true; rptViewerBranchSummary.LocalReport.ReportPath = Server.MapPath("~/Reports/RptBranchSummary.rdlc"); rptViewerBranchSummary.ZoomMode = ZoomMode.PageWidth; ReportAccess ra = new ReportAccess(); User usr = new User(); usr = (new UserAccess()).retreiveUserByUserId(userData.UserId); List<LoanDetailsRpt> details = new List<LoanDetailsRpt>(); LoanDetailsRpt detail = new LoanDetailsRpt(); detail.CompanyName = userData.CompanyName; if (userData.RoleId == 1) { detail.LenderBrnchName = branchName; } else { detail.LenderBrnchName = userData.BranchName; } detail.ReportDate = DateTime.Now.ToString("MM/dd/yyyy"); detail.CreaterName = usr.FirstName + " " + usr.LastName; details.Add(detail); rptViewerBranchSummary.LocalReport.DataSources.Add(new ReportDataSource("DataSet2", details)); foreach (var dates in details) { dates.ReportDate = DateTime.Now.ToString("MM/dd/yyyy"); } rptViewerBranchSummary.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", branchSummary)); }
/// <summary> /// CreatedBy : Kasun Smarawickrama /// CreatedDate: 2016/01/14 /// /// user dashboard view /// </summary> /// <param name="id">userid fromlogin page</param> /// <returns></returns> protected override void OnActionExecuting(ActionExecutingContext filterContext) { try { if (Session["AuthenticatedUser"] != null) { userData = ((User)Session["AuthenticatedUser"]); } else { //return RedirectToAction("UserLogin", "Login", new { lbl = "Your Session Expired" }); //filterContext.Controller.TempData.Add("UserLogin", "Login"); filterContext.Result = new RedirectResult("/Login/UserLogin?lbl=Due to inactivity your session has timed out, please log in again."); } } catch { //filterContext.Result = new RedirectResult("~/Login/UserLogin"); //filterContext.Controller.TempData.Add("UserLogin", "Login"); filterContext.Result = new RedirectResult("~/Exceptions/Index"); } }
/// <summary> /// CreatedBy : Kanishka SHM /// CreatedDate: 2016/01/18 /// /// Create company view /// </summary> /// <returns></returns> // GET: SetupCompany public ActionResult Setup() { if (Session["type"] == null) return RedirectToAction("UserLogin", "Login"); var type = (string)Session["type"]; //if (type == "CompanyEmployee") //{ //} CompanyAccess ca = new CompanyAccess(); //Get states to list List<State> stateList = ca.GetAllStates(); ViewBag.StateId = new SelectList(stateList, "StateId", "StateName"); _user = (User) TempData["User"]; List<CompanyType> ctList = ca.GetAllCompanyType(); ViewBag.TypeId = new SelectList(ctList, "TypeId", "TypeName"); return View(); }
public ActionResult SignUp(User user) { if (this.Session["CaptchaImageText"].ToString() == user.SecurityCode) { string newSalt = PasswordEncryption.RandomString(); user.Password = PasswordEncryption.encryptPassword(user.Password, newSalt); user.Email = user.NewEmail; user.RoleId = 1; user.Status = true; user.step_status = 0; UserAccess ua = new UserAccess(); if (ua.InsertUser(user) >= 1) { //ViewBag.SuccessMsg = "Your profile Successfully created."; TempData["status"] = "success"; //If succeed update step table to step2 StepAccess sa = new StepAccess(); //if (sa.updateStepNumberByUserId(ua.getUserId(user.Email), 1)) return RedirectToAction("UserLogin", "Login"); } TempData["status"] = "fail"; //ViewBag.ErrorMsg = "Failed to Sign up try again!"; } else { TempData["status"] = "captchaFail"; //ViewBag.ErrorMsg = "Entered Security Code is Not Correct!"; TempData["ErrorModel"] = user; } //return View(); return RedirectToAction("SignUp"); }
/// <summary> /// CreatedBy : MAM. IRFAN /// CreatedDate: 2016/01/13 /// /// retreive User Detail By UserId /// /// argument : user_id (int) /// /// /// UpdatedBy : nadeeka /// UpdatedDate: 2016/03/03 /// removed existing connection open method and set parameter to object list and pass stored procedure name /// call DataHandler class method and getting dataset object, /// create and return user object using that dataset /// /// </summary> /// <returns>User object</returns> public User retreiveUserByUserId(int id) { DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); paramertList.Add(new object[] { "@user_Id", id }); DataSet dataSet = dataHandler.GetDataSet("spRetrieveUserByUserId", paramertList); if (dataSet != null && dataSet.Tables.Count != 0 && dataSet.Tables[0].Rows.Count != 0) { User user = new User(); DataRow dataRow = dataSet.Tables[0].Rows[0]; user.UserId = int.Parse(dataRow["user_id"].ToString()); user.FirstName = dataRow["first_name"].ToString(); user.LastName = dataRow["last_name"].ToString(); user.Email = dataRow["email"].ToString(); user.PhoneNumber = dataRow["phone_no"].ToString(); user.Status = (bool)dataRow["status"]; user.CreatedDate = (DateTime)dataRow["created_date"]; user.IsDelete = (bool)dataRow["is_delete"]; user.CreatedBy = int.Parse(dataRow["created_by"].ToString()); if (dataRow["branch_id"].ToString() != "") { user.BranchId = int.Parse(dataRow["branch_id"].ToString()); } else { user.BranchId = 0; } user.RoleId = int.Parse(dataRow["role_id"].ToString()); user.UserName = dataRow["user_name"].ToString(); user.UneditUserName = dataRow["user_name"].ToString(); user.Password = dataRow["password"].ToString(); if (dataRow["company_id"].ToString() != "") { user.Company_Id = int.Parse(dataRow["company_id"].ToString()); } return user; } else { return null; } }
public ActionResult CreateFirstSuperUser(User user) { //user.Password = PasswordEncryption.encryptPassword(user.Password); string newSalt = PasswordEncryption.RandomString(); user.Password = PasswordEncryption.encryptPassword(user.Password, newSalt); user.Email = user.NewEmail; TempData["User"] = user; return RedirectToAction("Setup", "SetupCompany", new { id = 0, type = "CompanyEmployee" }); }
public ActionResult Create(User user) { int currentUser =0; try { currentUser = int.Parse(Session["userId"].ToString()); } catch (Exception) { return RedirectToAction("UserLogin", "Login"); } user.CreatedBy = _createById; user.IsDelete = false; user.Status = false; //Set admin branch to new user if (_curUserRoleId == 2) { user.BranchId = _curBranchId; } //Check role is selected if (user.RoleId == 0) user.RoleId = 2; //Check branch is selected if (_curUserRoleId == 1 && user.BranchId == 0) { user.BranchId = _curBranchId; } string passwordTemp = user.Password; UserAccess ua = new UserAccess(); string newSalt = PasswordEncryption.RandomString(); user.Password = PasswordEncryption.encryptPassword(user.Password, newSalt); user.Email = user.NewEmail; //Check this CompanyAccess ca = new CompanyAccess(); Company company = new Company();//ca.GetCompanyDetailsByFirstSpUserId(currentUser); //Insert user user.Company_Id = company.CompanyId; int res = ua.InsertUser(user); //Insert new user to user activation table string activationCode = Guid.NewGuid().ToString(); int userId = (new UserAccess()).getUserId(user.Email); res = ua.InsertUserActivation(userId, activationCode); if (res == 1) { ViewBag.SuccessMsg = "Data Successfully inserted!"; string body = "Hi " + user.FirstName + "! <br /><br /> Your account has been successfully created. Below in your account detail." + "<br /><br /> User name: " + user.UserName + "<br /> Password : <b>" + passwordTemp + "<br />Click <a href='http://localhost:57318/CreateUser/ConfirmAccount?userId=" + userId + "&activationCode=" + activationCode + "'>here</a> to activate your account." + "<br /><br/> Thanks,<br /> Admin."; Email email = new Email(user.Email); email.SendMail(body, "Account details"); // check the user as superadmin or admin.. if (user.RoleId == 1 || user.RoleId == 2) { ViewBag.SuccessMsg = "User Successfully Created"; return RedirectToAction("create",new { lbls = ViewBag.SuccessMsg }); } Session["editUserIds"] = userId; return RedirectToAction("SetRights", "EditRights", new {@lbl1 = ViewBag.SuccessMsg }); } else { ViewBag.ErrorMsg = "Failed to create user!"; //Restrict to create above user role RoleAccess ra = new RoleAccess(); List<UserRole> roleList = ra.GetAllUserRoles(); List<UserRole> tempRoleList = new List<UserRole>(); for (int i = roleList[_curUserRoleId - 1].RoleId; i <= roleList.Count && _curUserRoleId != 3; i++) { UserRole tempRole = new UserRole() { RoleId = roleList[i - 1].RoleId, RoleName = roleList[i - 1].RoleName }; tempRoleList.Add(tempRole); } ViewBag.RoleId = new SelectList(tempRoleList, "RoleId", "RoleName"); // get all branches List<Branch> branchesLists = (new BranchAccess()).getBranches(_companyId); ViewBag.BranchId = new SelectList(branchesLists, "BranchId", "BranchName"); return PartialView("Create"); } }
public ActionResult GetUserByUserId(int userId) { if (userId > 0) { User userObj = new User(); UserAccess uas = new UserAccess(); userObj = uas.retreiveUserByUserId(userId); if (userObj.UserId > 1) { userObj.PhoneNumber2 = userObj.PhoneNumber; } //SelectList UserList1 = new SelectList(eum.UserList, "UserId", "UserName"); return Json(userObj); } else { return RedirectToAction("UserLogin", "Login"); } }
public int CheckPasswd(int userId,string Cpwd) { if (userId > 0) { User userObj = new User(); UserAccess uas = new UserAccess(); userObj = uas.retreiveUserByUserId(userId); string passwordFromDB = userObj.Password; //user.Password = userObj.Password; char[] delimiter = { ':' }; string[] split = passwordFromDB.Split(delimiter); var checkCharHave = passwordFromDB.ToLowerInvariant().Contains(':'); if (passwordFromDB == null || (checkCharHave == false)) { // return RedirectToAction("UserLogin", "Login", new { lbl = "Incorrect Username or Password, please confirm and submit." }); } string passwordEncripted = PasswordEncryption.encryptPassword(Cpwd, split[1]); int reslt = 0; if (string.Compare(passwordEncripted, passwordFromDB) == 0) { reslt = 1; } else { reslt = 0; } return reslt; } else { return 0; } }
public ActionResult editUser(User user) { int currentUserId; int editUserId; string typevalue; try { currentUserId = int.Parse(Session["userId"].ToString()); editUserId = int.Parse(Session["editId"].ToString()); } catch (Exception) { return RedirectToAction("UserLogin", "Login", new { lbl = "Due to inactivity your session has timed out, please log in again." }); } bool isUpdate; if (currentUserId == editUserId) {// Update the data into database ViewBag.isSame = true; isUpdate = (new UserAccess()).updateProfileDetails(editUserId, user.UneditUserName, user.FirstName, user.LastName, user.Email, user.PhoneNumber, DateTime.Now); } else { // Update the data into database ViewBag.isSame = false; typevalue = (string)Session["searchtype"]; if (typevalue == "User") { ViewBag.Manage = "Manage Users"; } isUpdate = (new UserAccess()).updateUserDetails(editUserId, user.UneditUserName, user.FirstName, user.LastName, user.Email, user.PhoneNumber, user.Status, user.BranchId, DateTime.Now); } if (isUpdate) ViewBag.SuccessMsg = "Data Successfully Updated"; else { ViewBag.ErrorMsg = "Updating failed"; return View(user); } user = (new UserAccess()).retreiveUserByUserId(editUserId); // get all branches List<Branch> branchesLists = (new BranchAccess()).getBranches(user.Company_Id); // insert all branches into selectedlist List<SelectListItem> branchSelectLists = new List<SelectListItem>(); foreach (Branch branch in branchesLists) { branchSelectLists.Add(new SelectListItem() { Text = branch.BranchName, Value = branch.BranchId.ToString() }); } ViewBag.BranchId = new SelectList(branchSelectLists, "Value", "Text", user.BranchId); return PartialView(user); }
public ActionResult EditProfile() { User userObj = new User(); UserAccess uas = new UserAccess(); userObj = uas.retreiveUserByUserId(userData.UserId); string roleName = ""; if (userData.RoleId == 1) roleName = "Super Admin"; else if (userData.RoleId == 2) roleName = "Admin"; else if (userData.RoleId == 3) roleName = "User"; else if (userData.RoleId == 4) roleName = "Dealer User"; ViewBag.RoleName = roleName; if (TempData["UpdteReslt"] != null) { if (int.Parse(TempData["UpdteReslt"].ToString()) == 1) { ViewBag.SuccessMsg = "Profile is successfully updated"; } else if (int.Parse(TempData["UpdteReslt"].ToString()) == 0) { ViewBag.ErrorMsg = "Failed to update Profile"; } else if (int.Parse(TempData["UpdteReslt"].ToString()) == -1) { ViewBag.ErrorMsg = "Failed to update Profile"; } } userObj.PhoneNumber2 = userObj.PhoneNumber; return View(userObj); }
public ActionResult EditProfile(User model) { if (model != null) { if ((!string.IsNullOrEmpty(model.CurrentPassword)) && (!string.IsNullOrEmpty(model.Password)) && (!string.IsNullOrEmpty(model.ConfirmPassword))) { User userObj = new User(); userObj = (new UserAccess()).retreiveUserByUserId(userData.UserId); string passwordFromDB = userObj.Password; //user.Password = userObj.Password; char[] delimiter = { ':' }; string[] split = passwordFromDB.Split(delimiter); var checkCharHave = passwordFromDB.ToLowerInvariant().Contains(':'); if (passwordFromDB == null || (checkCharHave == false)) { return RedirectToAction("UserLogin", "Login", new { lbl = "Incorrect Username or Password, please confirm and submit." }); } string passwordEncripted = PasswordEncryption.encryptPassword(model.CurrentPassword, split[1]); if (string.Compare(passwordEncripted, passwordFromDB) == 0) { string passwordEncripted1 = PasswordEncryption.encryptPassword(model.Password, split[1]); model.Password = passwordEncripted1; model.CurrentPassword = passwordFromDB; } else { TempData["UpdteReslt"] = -1; return RedirectToAction("EditProfile"); //return View(); } //string newSalt = PasswordEncryption.RandomString(); //user.CurrentPassword = PasswordEncryption.encryptPassword(user.CurrentPassword, newSalt); //user.Password = PasswordEncryption.encryptPassword(user.Password, newSalt); } model.UserId = userData.UserId; model.Status = true; UserAccess usrAcc = new UserAccess(); int reslt = usrAcc.UpdateUser(model, userData.UserId); if ((reslt == 1) || (reslt == 2)) { Log log = new Log(userData.UserId, userData.Company_Id, model.BranchId, 0, "Edit User", "Edit User : "******"UpdteReslt"] = 1; } else { TempData["UpdteReslt"] = 0; } return RedirectToAction("EditProfile"); } return RedirectToAction("UserLogin", "Login"); }
/// <summary> /// Frontend Page: Add Unit /// Title:get details of dealer user /// Designed: Piyumi Perera /// User story: /// Developed: Piyumi Perera /// Date created: 25/05/2016 /// </summary> /// <returns></returns> public User GetDealerUserDetails(int userId, string Code) { User user2 = new User(); List<User> users = new List<User>(); DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); paramertList.Add(new object[] { "@user_id", userId }); paramertList.Add(new object[] { "@loan_code", Code }); DataSet dataSet = dataHandler.GetDataSet("spGetDealerUserByUserId", paramertList); if (dataSet != null && dataSet.Tables.Count != 0) { foreach (DataRow dataRow in dataSet.Tables[0].Rows) { User user = new User(); user.FirstName = dataRow["first_name"].ToString(); user.LastName = dataRow["last_name"].ToString(); user.Email = dataRow["email"].ToString(); user.PhoneNumber = dataRow["phone_no"].ToString(); user.LoanNumber = dataRow["loan_number"].ToString(); user.UserIdForSendReq = Convert.ToInt32(dataRow["request_user_id"].ToString()); user.UserEmailForSendReq = dataRow["request_email"].ToString(); users.Add(user); } user2.FirstName = users[0].FirstName; user2.LastName = users[0].LastName; user2.Email = users[0].Email; user2.PhoneNumber = users[0].PhoneNumber; user2.LoanNumber = users[0].LoanNumber; user2.UserIdForSendReq = Convert.ToInt32(users[0].UserIdForSendReq); user2.UserEmailForSendReq = users[0].UserEmailForSendReq; user2.NoOfUnitsAdded = users.Count; user2.AddedDate = DateTime.Now; return user2; } else { return null; } }
/// <summary> /// CreatedBy:Piyumi /// CreatedDate:4/22/2016 /// Get all types of users for company /// </summary> /// <param name="company_Id"></param> /// <returns></returns> public List<User> GetAllUsersByBranchId(int role_id, int branch_Id) { List<User> users = new List<User>(); DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); paramertList.Add(new object[] { "@role_id", role_id }); paramertList.Add(new object[] { "@branch_id", branch_Id }); DataSet dataSet = dataHandler.GetDataSet("spGetAllUsersByBranchId", paramertList); if (dataSet != null && dataSet.Tables.Count != 0) { foreach (DataRow dataRow in dataSet.Tables[0].Rows) { User user = new User(); user.UserId = Convert.ToInt32(dataRow["user_id"].ToString()); user.UserName = dataRow["user_name"].ToString(); user.Password = dataRow["password"].ToString(); user.FirstName = dataRow["first_name"].ToString(); user.LastName = dataRow["last_name"].ToString(); user.Email = dataRow["email"].ToString(); user.PhoneNumber = dataRow["phone_no"].ToString(); user.Status = bool.Parse(dataRow["status"].ToString()); user.BranchId = Convert.ToInt32(dataRow["branch_id"].ToString()); user.RoleId = Convert.ToInt32(dataRow["role_id"].ToString()); users.Add(user); } return users; } else { return null; } }
public ActionResult GetSuperAdminsDetails(int roleId) { if (roleId == 1) { User eum = new User(); UserAccess uas = new UserAccess(); eum.UserList = uas.GetSuperAdminsByCompanyId(userData.Company_Id); //SelectList UserList1 = new SelectList(eum.UserList, "UserId", "UserName"); //return Json(UserList1); if (eum.UserList != null) { //SelectList UserList1 = new SelectList(eum.UserList, "UserId", "UserName"); return Json(eum); } else { return RedirectToAction("UserLogin", "Login"); } } else { return RedirectToAction("UserLogin", "Login"); } }
public ActionResult EditUserAtDashboard(User user) { if(user!=null) { if ((!string.IsNullOrEmpty(user.CurrentPassword)) && (!string.IsNullOrEmpty(user.Password)) && (!string.IsNullOrEmpty(user.ConfirmPassword))) { User userObj = new User(); userObj = (new UserAccess()).retreiveUserByUserId(user.UserId); string passwordFromDB = userObj.Password; //user.Password = userObj.Password; char[] delimiter = { ':' }; string[] split = passwordFromDB.Split(delimiter); var checkCharHave = passwordFromDB.ToLowerInvariant().Contains(':'); if (passwordFromDB == null || (checkCharHave == false)) { return RedirectToAction("UserLogin", "Login"); } string passwordEncripted = PasswordEncryption.encryptPassword(user.CurrentPassword, split[1]); if (string.Compare(passwordEncripted, passwordFromDB) == 0) { string passwordEncripted1 = PasswordEncryption.encryptPassword(user.Password, split[1]); user.Password = passwordEncripted1; user.CurrentPassword = passwordFromDB; } else { TempData["UpdteReslt"] = -1; return RedirectToAction("EditUserAtDashboard"); //return View(); } //string newSalt = PasswordEncryption.RandomString(); //user.CurrentPassword = PasswordEncryption.encryptPassword(user.CurrentPassword, newSalt); //user.Password = PasswordEncryption.encryptPassword(user.Password, newSalt); } UserAccess usrAcc = new UserAccess(); int reslt = usrAcc.UpdateUser(user,userData.UserId); if((reslt==1)||(reslt == 2)) { Log log = new Log(userData.UserId, userData.Company_Id, user.BranchId, 0, "Edit User", "Edit User : "******"AuthenticatedUser"] = null; } else { TempData["UpdteReslt"] = 1; } } else { TempData["UpdteReslt"] = 0; } return RedirectToAction("EditUserAtDashboard"); } else { return RedirectToAction("UserLogin", "Login"); } }
/// <summary> /// CreatedBy : kasun /// CreatedDate: 2016/04/04 /// /// Update user right details in user permission table /// </summary> /// <param name="user"></param> /// <returns></returns> public int updateUserRightDetails(User user, int loggedUser) { DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); paramertList.Add(new object[] { "@user_Id", user.UserId }); paramertList.Add(new object[] { "@logged_user_Id", loggedUser }); paramertList.Add(new object[] { "@loan_id", user.LoanId }); paramertList.Add(new object[] { "@right_id", user.UserRights }); if (user.ReportRights != null && user.ReportRights != "") { paramertList.Add(new object[] { "@report_right_id", user.ReportRights }); } else { paramertList.Add(new object[] { "@report_right_id", "" }); } paramertList.Add(new object[] { "@modify_date", DateTime.Now }); try { return dataHandler.ExecuteSQLReturn("spUpdateUserRightDetails", paramertList); } catch (Exception ex) { throw ex; } }
/// <summary> /// CreatedBy : Kasun Smarawickrama /// CreatedDate: 2016/01/17 /// /// edit rights Set session variables /// </summary> /// <param name="user"></param> /// <returns></returns> public ActionResult editRights(User user) { int currentUserId = (int)Session["userId"]; int editUserId = (int)Session["editUserId"]; Session["editUserIds"] = editUserId; return RedirectToAction("EditRights", "EditRights"); }
/// <summary> /// CreatedBy:Piyumi /// CreatedDate:4/23/2016 /// edit user at dashboard /// </summary> /// <param name="user"></param> /// <returns></returns> public int UpdateUser(User user, int userId) { if (user != null) { DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); paramertList.Add(new object[] { "@user_id", user.UserId }); paramertList.Add(new object[] { "@current_password", user.CurrentPassword }); paramertList.Add(new object[] { "@password", user.Password }); paramertList.Add(new object[] { "@first_name", user.FirstName }); paramertList.Add(new object[] { "@last_name", user.LastName }); paramertList.Add(new object[] { "@email", user.Email }); if (user.RoleId == 1) { paramertList.Add(new object[] { "@phone_no", user.PhoneNumber }); } else { paramertList.Add(new object[] { "@phone_no", user.PhoneNumber2 }); } if (user.Status) { paramertList.Add(new object[] { "@status", 1 }); } else { paramertList.Add(new object[] { "@status", 0 }); } paramertList.Add(new object[] { "@modified_date", DateTime.Now }); paramertList.Add(new object[] { "@modified_by", userId }); try { return dataHandler.ExecuteSQLReturn("spUpdateUser", paramertList); } catch (Exception ex) { throw ex; } } else { return 0; } }
public int InsertUserInDashboard(User user) { DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); if (user != null) { paramertList.Add(new object[] { "@user_name", user.UserName }); paramertList.Add(new object[] { "@password", user.Password }); paramertList.Add(new object[] { "@first_name", user.FirstName }); paramertList.Add(new object[] { "@last_name", user.LastName }); paramertList.Add(new object[] { "@email", user.Email }); paramertList.Add(new object[] { "@phone_no", user.PhoneNumber2 }); paramertList.Add(new object[] { "@created_date", DateTime.Now }); paramertList.Add(new object[] { "@created_by", user.CreatedBy}); paramertList.Add(new object[] { "@company_id", user.Company_Id }); paramertList.Add(new object[] { "@branch_id", user.BranchId }); paramertList.Add(new object[] { "@role_id", user.RoleId}); if (user.RoleId == 3) { paramertList.Add(new object[] { "@rights", user.UserRights }); paramertList.Add(new object[] { "@report_rights", user.ReportRights }); paramertList.Add(new object[] { "@loan_id", user.LoanId }); } else { paramertList.Add(new object[] { "@rights",""}); paramertList.Add(new object[] { "@report_rights", "" }); paramertList.Add(new object[] { "@loan_id", 0 }); } paramertList.Add(new object[] { "@step_status", user.step_status }); paramertList.Add(new object[] { "@status", user.Status }); } try { return dataHandler.ExecuteSQLReturn("spInsertDashboardUserDetails", paramertList); } catch (Exception ex) { throw ex; } }
/// <summary> /// Frontend Page : Join Dealer /// Title: Get all users for given company id /// Designed: Piyumi Perera /// User story: /// Developed: Piyumi Perera /// Date Created: 05/26/2016 /// </summary> /// <param name="companyId"></param> /// <returns></returns> public List<User> GetUserListByCompany(int companyId) { List<User> users = new List<User>(); DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); paramertList.Add(new object[] { "@company_id", companyId }); DataSet dataSet = dataHandler.GetDataSet("spGetUsersbyCompany2", paramertList); if (dataSet != null && dataSet.Tables.Count != 0) { foreach (DataRow dataRow in dataSet.Tables[0].Rows) { User user = new User(); user.UserId = Convert.ToInt32(dataRow["user_id"].ToString()); user.UserName = dataRow["user_name"].ToString(); user.Password = dataRow["password"].ToString(); user.FirstName = dataRow["first_name"].ToString(); user.LastName = dataRow["last_name"].ToString(); user.NewEmail = dataRow["email"].ToString(); user.PhoneNumber = dataRow["phone_no"].ToString(); user.BranchId = Convert.ToInt32(dataRow["branch_id"].ToString()); user.RoleId = Convert.ToInt32(dataRow["role_id"].ToString()); users.Add(user); } return users; } else { return null; } }
public ActionResult UserLogin(UserLogin user) { try { //string ip = Request.UserHostAddress; DataSet dsUser = new DataSet(); var login = new LoginAccess(); var step = new StepAccess(); User userData = new User(); userData.UserName = user.userName; //pass user name to database and get user details dsUser = login.CheckUserLogin(userData); if (dsUser.Tables[0].Rows.Count > 0) { userData.UserId = int.Parse(dsUser.Tables[0].Rows[0]["user_id"].ToString()); userData.UserName = dsUser.Tables[0].Rows[0]["user_name"].ToString(); userData.Password = dsUser.Tables[0].Rows[0]["password"].ToString(); userData.RoleId = int.Parse(dsUser.Tables[0].Rows[0]["role_id"].ToString()); if (userData.RoleId == 4) { DataSet dsDelearCompany = new DataSet(); dsDelearCompany = login.GetDealerUserCompanyBranch(userData.UserId); if (dsDelearCompany.Tables[0].Rows[0]["company_id"].ToString() != "") { userData.Company_Id = int.Parse(dsDelearCompany.Tables[0].Rows[0]["company_id"].ToString()); userData.CompanyName = dsDelearCompany.Tables[0].Rows[0]["company_name"].ToString(); } if (dsDelearCompany.Tables[0].Rows[0]["branch_id"].ToString() != "") { userData.BranchId = int.Parse(dsDelearCompany.Tables[0].Rows[0]["branch_id"].ToString()); userData.BranchName = dsDelearCompany.Tables[0].Rows[0]["branch_name"].ToString(); } } else { userData.BranchId = int.Parse(dsUser.Tables[0].Rows[0]["branch_id"].ToString()); userData.BranchName = dsUser.Tables[0].Rows[0]["branch_name"].ToString(); if (dsUser.Tables[0].Rows[0]["company_id"].ToString() != "") { userData.Company_Id = int.Parse(dsUser.Tables[0].Rows[0]["company_id"].ToString()); userData.CompanyType = int.Parse(dsUser.Tables[0].Rows[0]["company_type"].ToString()); userData.CompanyCode = dsUser.Tables[0].Rows[0]["company_code"].ToString(); } else { userData.Company_Id = 0; } userData.CompanyName = dsUser.Tables[0].Rows[0]["company_name"].ToString(); } userData.step_status = int.Parse(dsUser.Tables[0].Rows[0]["step_status"].ToString()); //To compair Database password and user enter password string passwordFromDB = userData.Password; char[] delimiter = { ':' }; string[] split = passwordFromDB.Split(delimiter); var checkCharHave = passwordFromDB.ToLowerInvariant().Contains(':'); if (passwordFromDB == null || (checkCharHave == false)) { Log log = new Log(userData.UserId, userData.Company_Id, userData.BranchId, 0, "User Login", "User : "******" was unable to login, Entered password did not match", DateTime.Now); int islog = (new LogAccess()).InsertLog(log); return RedirectToAction("UserLogin", "Login", new { lbl = "Incorrect Username & Password combination. Please confirm entry and resubmit." }); } string passwordEncripted = PasswordEncryption.encryptPassword(user.password, split[1]); if (string.Compare(passwordEncripted, passwordFromDB) == 0) { //user object pass to session Session["AuthenticatedUser"] = userData; // Does not complete atleast one cycle if (userData.step_status == 0) { if (userData.RoleId == 3) { Log log = new Log(userData.UserId, userData.Company_Id, userData.BranchId, 0, "User Login", "User : "******" was unable to login", DateTime.Now); int islog = (new LogAccess()).InsertLog(log); return RedirectToAction("UserLogin", "Login", new { lbl = "Company setup process is on going please contact admin." }); } else { Log log = new Log(userData.UserId, userData.Company_Id, userData.BranchId, 0, "User Login", "User : "******" has logged successfully", DateTime.Now); int islog = (new LogAccess()).InsertLog(log); if (userData.Company_Id == 0) { Session["companyStep"] = 1; return RedirectToAction("Index", "SetupProcess"); } else if (userData.Company_Id > 0) { if (userData.RoleId == 1) { DataSet dsStepNo = new DataSet(); dsStepNo = step.checkSuperAdminLoginWhileCompanySetup(userData); if (dsStepNo.Tables[0].Rows.Count > 0) { Session["companyStep"] = int.Parse(dsStepNo.Tables[0].Rows[0]["step_number"].ToString()); return RedirectToAction("Index", "SetupProcess"); } else { LoanSetupStep loanStep = new LoanSetupStep(); DataSet dsLoanStepNo = new DataSet(); dsLoanStepNo = step.checkUserLoginWhileLoanSetup(userData); if (dsLoanStepNo.Tables[0].Rows.Count > 0) { loanStep.CompanyId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["company_id"].ToString()); loanStep.BranchId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["branch_id"].ToString()); loanStep.stepId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["step_number"].ToString()); loanStep.nonRegisteredBranchId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["non_registered_branch_id"].ToString()); if (dsLoanStepNo.Tables[0].Rows[0]["loan_id"].ToString() != "") { loanStep.loanId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["loan_id"].ToString()); } else { loanStep.loanId = 0; } Session["loanStep"] = loanStep; if (userData.RoleId == 1) { return RedirectToAction("Step" + (loanStep.stepId + 5), "SetupProcess"); } } } } else { //if step table has record pass(company id and branch id) DataSet dsStepNo = new DataSet(); dsStepNo = step.checkUserLoginWhileCompanySetup(userData); if (dsStepNo.Tables[0].Rows.Count > 0) { Session["companyStep"] = int.Parse(dsStepNo.Tables[0].Rows[0]["step_number"].ToString()); return RedirectToAction("Index", "SetupProcess"); } else { //No Step recor in relavent Company and branch LoanSetupStep loanStep = new LoanSetupStep(); DataSet dsLoanStepNo = new DataSet(); dsLoanStepNo = step.checkUserLoginWhileLoanSetup(userData); if (dsLoanStepNo.Tables[0].Rows.Count > 0) { loanStep.CompanyId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["company_id"].ToString()); loanStep.BranchId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["branch_id"].ToString()); loanStep.stepId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["step_number"].ToString()); loanStep.nonRegisteredBranchId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["non_registered_branch_id"].ToString()); if (dsLoanStepNo.Tables[0].Rows[0]["loan_id"].ToString() != "") { loanStep.loanId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["loan_id"].ToString()); } else { loanStep.loanId = 0; } Session["loanStep"] = loanStep; return RedirectToAction("Step" + (loanStep.stepId + 5), "SetupProcess"); } } } } } } // Complete cycle and no start new cycle else if (userData.step_status == 1 || userData.step_status == 2) { //delete just added unit if exists UnitAccess ua = new UnitAccess(); ua.DeleteJustAddedUnits(userData.UserId); //insert log Log log = new Log(userData.UserId, userData.Company_Id, userData.BranchId, 0, "User Login", "User : "******" has logged successfully", DateTime.Now); int islog = (new LogAccess()).InsertLog(log); return RedirectToAction("UserDetails", "UserManagement"); } // atleast one cycle complete and Start new cycle //else if (userData.step_status == 2) //{ // //delete just added unit if exists // UnitAccess ua = new UnitAccess(); // ua.DeleteJustAddedUnits(userData.UserId); // //insert log // Log log = new Log(userData.UserId, userData.Company_Id, userData.BranchId, 0, "User Login", "User : "******" has logged successfully", DateTime.Now); // int islog = (new LogAccess()).InsertLog(log); // if (userData.RoleId == 1) // { // DataSet dsStepNo = new DataSet(); // dsStepNo = step.checkSuperAdminLoginWhileCompanySetup(userData); // if (dsStepNo.Tables[0].Rows.Count > 0) // { // Session["companyStep"] = int.Parse(dsStepNo.Tables[0].Rows[0]["step_number"].ToString()); // Session["isNotCompleteStep"] = 1; // //return RedirectToAction("Index", "SetupProcess"); // return RedirectToAction("UserLogin", "Login"); // } // else // { // LoanSetupStep loanStep = new LoanSetupStep(); // DataSet dsLoanStepNo = new DataSet(); // dsLoanStepNo = step.checkUserLoginWhileLoanSetup(userData); // if (dsLoanStepNo.Tables[0].Rows.Count > 0) // { // loanStep.CompanyId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["company_id"].ToString()); // loanStep.BranchId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["branch_id"].ToString()); // loanStep.stepId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["step_number"].ToString()); // loanStep.nonRegisteredBranchId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["non_registered_branch_id"].ToString()); // if (dsLoanStepNo.Tables[0].Rows[0]["loan_id"].ToString() != "") // { // loanStep.loanId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["loan_id"].ToString()); // } // else // { // loanStep.loanId = 0; // } // Session["isNotCompleteStep"] = 1; // Session["loanStep"] = loanStep; // if (userData.RoleId == 1) // { // //return RedirectToAction("Step" + (loanStep.stepId + 5), "SetupProcess"); // return RedirectToAction("UserLogin", "Login"); // } // } // } // } // else // { // //if step table has record pass(company id and branch id) // DataSet dsStepNo = new DataSet(); // dsStepNo = step.checkUserLoginWhileCompanySetup(userData); // if (dsStepNo.Tables[0].Rows.Count > 0) // { // Session["isNotCompleteStep"] = 1; // Session["companyStep"] = int.Parse(dsStepNo.Tables[0].Rows[0]["step_number"].ToString()); // return RedirectToAction("UserLogin", "Login"); // } // else // { // //No Step recor in relavent Company and branch // LoanSetupStep loanStep = new LoanSetupStep(); // DataSet dsLoanStepNo = new DataSet(); // dsLoanStepNo = step.checkUserLoginWhileLoanSetup(userData); // if (dsLoanStepNo.Tables[0].Rows.Count > 0) // { // loanStep.CompanyId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["company_id"].ToString()); // loanStep.BranchId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["branch_id"].ToString()); // loanStep.stepId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["step_number"].ToString()); // loanStep.nonRegisteredBranchId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["non_registered_branch_id"].ToString()); // if (dsLoanStepNo.Tables[0].Rows[0]["loan_id"].ToString() != "") // { // loanStep.loanId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["loan_id"].ToString()); // } // else // { // loanStep.loanId = 0; // } // Session["isNotCompleteStep"] = 1; // Session["loanStep"] = loanStep; // //return RedirectToAction("Step" + (loanStep.stepId + 5), "SetupProcess"); // return RedirectToAction("UserLogin", "Login"); // } // //if SA stepstatus 2 and no records in loan setup and companysetup // else // { // return RedirectToAction("UserDetails", "Usermanagement"); // } // } // } //} else { //insert log Log log = new Log(userData.UserId, userData.Company_Id, userData.BranchId, 0, "User Login", "User : "******" was unable to login", DateTime.Now); int islog = (new LogAccess()).InsertLog(log); return RedirectToAction("UserLogin", "Login", new { lbl = "Company setup process is on going please contact admin." }); } // //check Company setup process // //Check SuperAdmin // //company ID null or 0 then redirect to step process 1 // if (userData.Company_Id == 0) // { // Session["companyStep"] = 1; // return RedirectToAction("Index", "SetupProcess"); // } // else if (userData.Company_Id > 0) // { // //check branch count more than one and // if (userData.RoleId == 1) // { // //check branch count in view and step table row count // //IF more than branch count and has step record ask question // DataSet dsStepNo = new DataSet(); // dsStepNo = step.checkSuperAdminLoginWhileCompanySetup(userData); // if (dsStepNo.Tables[0].Rows.Count > 0) // { // int bcount = 0; // if (dsStepNo.Tables[0].Rows[0]["branchCount"].ToString() != "") // { // bcount = int.Parse(dsStepNo.Tables[0].Rows[0]["branchCount"].ToString()); // } // int scount = 0; // if (dsStepNo.Tables[0].Rows[0]["stepCount"].ToString() != "") // { // scount = int.Parse(dsStepNo.Tables[0].Rows[0]["stepCount"].ToString()); // } // if (bcount <= scount) // { // Session["companyStep"] = int.Parse(dsStepNo.Tables[0].Rows[0]["step_number"].ToString()); // return RedirectToAction("Index", "SetupProcess"); // } // else // { // //message: Not complete Step, Do you want to complete it. // Session["isNotCompleteStep"] = 1; // Session["companyStep"] = int.Parse(dsStepNo.Tables[0].Rows[0]["step_number"].ToString()); // return RedirectToAction("UserLogin", "Login"); // } // } // else // { // LoanSetupStep loanStep = new LoanSetupStep(); // DataSet dsLoanStepNo = new DataSet(); // dsLoanStepNo = step.checkUserLoginWhileLoanSetup(userData); // if (dsLoanStepNo.Tables[0].Rows.Count > 0) // { // loanStep.CompanyId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["company_id"].ToString()); // loanStep.BranchId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["branch_id"].ToString()); // loanStep.stepId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["step_number"].ToString()); // loanStep.nonRegisteredBranchId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["non_registered_branch_id"].ToString()); // if (dsLoanStepNo.Tables[0].Rows[0]["loan_id"].ToString() != "") // { // loanStep.loanId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["loan_id"].ToString()); // } // else // { // loanStep.loanId = 0; // } // Session["loanStep"] = loanStep; // if (userData.RoleId == 1) // { // return RedirectToAction("Step" + (loanStep.stepId + 5), "SetupProcess"); // } // } // else // { // //Redirect to Super Admin dashboard // return RedirectToAction("UserDetails", "UserManagement"); // } // } // } // else // { // //if step table has record pass(company id and branch id) // DataSet dsStepNo = new DataSet(); // dsStepNo = step.checkUserLoginWhileCompanySetup(userData); // if (dsStepNo.Tables[0].Rows.Count > 0) // { // Session["companyStep"] = int.Parse(dsStepNo.Tables[0].Rows[0]["step_number"].ToString()); // if (userData.RoleId == 2) // { // return RedirectToAction("Index", "SetupProcess"); // } // else // { // return RedirectToAction("UserLogin", "Login", new { lbl = "Company setup process is on going please contact admin." }); // } // } // else // { // //No Step recor in relavent Company and branch // LoanSetupStep loanStep = new LoanSetupStep(); // DataSet dsLoanStepNo = new DataSet(); // dsLoanStepNo = step.checkUserLoginWhileLoanSetup(userData); // if (dsLoanStepNo.Tables[0].Rows.Count > 0) // { // loanStep.CompanyId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["company_id"].ToString()); // loanStep.BranchId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["branch_id"].ToString()); // loanStep.stepId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["step_number"].ToString()); // loanStep.nonRegisteredBranchId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["non_registered_branch_id"].ToString()); // if (dsLoanStepNo.Tables[0].Rows[0]["loan_id"].ToString() != "") // { // loanStep.loanId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["loan_id"].ToString()); // } // else // { // loanStep.loanId = 0; // } // Session["loanStep"] = loanStep; // if (userData.RoleId == 2) // { // //return RedirectToAction("Index", "SetupProcess"); // return RedirectToAction("Step" + (loanStep.stepId+5), "SetupProcess"); // } // } // else // { // if (userData.RoleId == 2) // { // //Redirect to Branch Admin dashboard // return RedirectToAction("UserDetails", "UserManagement"); // } // else // { // //Redirect to User dashboard // return RedirectToAction("UserDetails", "UserManagement"); // } // } // } // } // } //} //else //{ // //User Name Correct but user enter password does not match with database password value // return RedirectToAction("UserLogin", "Login", new { lbl = "Incorrect Username or Password, please confirm and submit." }); //} //insert log entry } else { //User Name Correct but user enter password does not match with database password value Log log = new Log(userData.UserId, userData.Company_Id, userData.BranchId, 0, "User Login", "User : "******" was unable to login, Entered password did not match ", DateTime.Now); int islog = (new LogAccess()).InsertLog(log); return RedirectToAction("UserLogin", "Login", new { lbl = "Incorrect Username & Password combination. Please confirm entry and resubmit." }); } } else { //Incorrect UserName Log log = new Log(userData.UserId, userData.Company_Id, userData.BranchId, 0, "User Login", "User : "******" was unable to login, Entered username did not exist ", DateTime.Now); int islog = (new LogAccess()).InsertLog(log); return RedirectToAction("UserLogin", "Login", new { lbl = "Incorrect Username & Password combination. Please confirm entry and resubmit." }); } } catch { return RedirectToAction("UserLogin", "Login", new { lbl = "An error has occurred.Please try again later" }); } return RedirectToAction("UserLogin", "Login"); }