public string ChangePassword(PreferenceModel pref) { uas_User user = pref.db.uas_User.Where(u => u.UserID == SessionHelper.LoginStatus.UserID).FirstOrDefault(); try { string encryptedNewPassword = UtilityFunction.EncryptPassword(pref.NewPasswordOne); user.Password = encryptedNewPassword; user.ModifiedBy = SessionHelper.LoginStatus.UserID; user.ModifiedDate = DateTime.Now; pref.db.Entry(user).State = System.Data.Entity.EntityState.Modified; pref.db.SaveChanges(); } catch (Exception ex) { Debug.Write("Change password: "******"Change password: Error changing if force change password."); } } return("success"); }
/// <summary> /// Takes a LoginStatus and creates corresponding LoginInfo. /// </summary> /// <param name="loginStatus"></param> /// <returns></returns> private LoginInfo FillLoginInfo(LoginStatus loginStatus) { LoginInfo loginInfo = new LoginInfo(); using (var context = DataContext.getUasDbContext()) { uas_User result = null; try { result = context.uas_User.Where(u => u.UserID == loginStatus.UserID).Select(u => u).FirstOrDefault(); } catch (Exception ex) { Debug.WriteLine("FillLoginInfo exception: " + ex.Message); } if (result != null) { loginInfo.LoginID = result.LoginID; } loginInfo.SessionData = Session.SessionID; } return(loginInfo); }
public string checkOldPass(PreferenceModel pref) { uas_User user = pref.db.uas_User.Where(u => u.UserID == SessionHelper.LoginStatus.UserID).FirstOrDefault(); if (UtilityFunction.EncryptPassword(pref.Password) == user.Password) { return("success"); } else if (String.IsNullOrEmpty(user.Password) && user.ChangePassword && UtilityFunction.EncryptPassword(pref.Password) == user.TempPassword) { return("success"); } return("fail"); }
public string GetInterviewerInfo(string userId) { int uid = Int32.Parse(userId); using (var context = DataContext.getUasDbContext()) { context.Configuration.LazyLoadingEnabled = false; uas_User user = (from i in context.uas_User where i.UserID == uid select i).FirstOrDefault(); context.Entry(user).Collection(u => u.uas_UserAddress).Load(); context.Entry(user).Collection(u => u.uas_UserPhone).Load(); context.Entry(user).Collection(u => u.uas_UserEmail).Load(); string jsonInfo = fastJSON.JSON.ToJSON(user); return(jsonInfo); } }
/* * Method to get the uas_User * *** Only needed fields are being populated. *** */ public static uas_User GetUserByLogin(DbConnection dbConn, string loginID) { uas_User usr = null; DbDataReader reader = null; try { using (DbCommand command = dbConn.CreateCommand()) { command.CommandText = "SELECT UserID,EnterpriseID,Password,FirstName,LastName,StatusFlag FROM [dbo].uas_User WHERE LoginID = '" + loginID + "'"; command.CommandType = CommandType.Text; reader = command.ExecuteReader(); reader.Read(); if (!reader.IsDBNull(0)) { Debug.WriteLine("* * * GetUserByLogin uas_User FieldCount: " + reader.FieldCount.ToString()); Debug.WriteLine("* * * GetUserByLogin uas_User : "******"FirstName"] + " " + reader["LastName"]); var fname = reader["FirstName"]; var lname = reader["LastName"]; usr = new uas_User(); usr.UserID = reader.GetInt32(0); usr.EnterpriseID = reader.GetInt32(1); usr.Password = reader.GetString(2); usr.FirstName = (fname == null)? String.Empty : fname.ToString(); usr.LastName = (lname == null) ? String.Empty : lname.ToString(); usr.StatusFlag = reader.GetString(5); } reader.Close(); } } catch (Exception ex) { Debug.WriteLine("* * * GetUserByLogin Exception: " + loginID + " - " + ex.Message); throw; // throw the same exception } return(usr); }
public string Save(PreferenceModel pref) { Debug.WriteLine("PreferencesController.Save from form - first last:" + pref.user.FirstName + " " + pref.user.LastName); Debug.WriteLine("PreferencesController.Save address: " + pref.address.Address1); if (!SessionHelper.IsUserLoggedIn) { return("User not logged in"); } uas_User user = pref.db.uas_User.Where(u => u.UserID == SessionHelper.LoginStatus.UserID).FirstOrDefault(); uas_UserPhone userPhone = pref.db.uas_UserPhone.Where(u => u.UserID == SessionHelper.LoginStatus.UserID).FirstOrDefault(); uas_UserAddress userAddress = pref.db.uas_UserAddress.Where(u => u.UserID == SessionHelper.LoginStatus.UserID).FirstOrDefault(); uas_UserEmail userEmail = pref.db.uas_UserEmail.Where(u => u.UserID == SessionHelper.LoginStatus.UserID).FirstOrDefault(); user.FirstName = pref.user.FirstName; user.LastName = pref.user.LastName; user.MiddleName = pref.user.MiddleName; user.Title = pref.user.Title; user.Area = pref.user.Area; userPhone.PhoneNumber = pref.phone.PhoneNumber; userPhone.Extension = pref.phone.Extension; userAddress.Address1 = pref.address.Address1; userAddress.City = pref.address.City; userAddress.StateProvince = pref.address.StateProvince; userAddress.PostalCode = pref.address.PostalCode; userEmail.EmailAddress = pref.email.EmailAddress; user.ModifiedBy = SessionHelper.LoginStatus.UserID; user.ModifiedDate = DateTime.Now; userPhone.ModifiedBy = SessionHelper.LoginStatus.UserID; userPhone.ModifiedDate = DateTime.Now; userAddress.ModifiedBy = SessionHelper.LoginStatus.UserID; userAddress.ModifiedDate = DateTime.Now; userEmail.ModifiedBy = SessionHelper.LoginStatus.UserID; userEmail.ModifiedDate = DateTime.Now; pref.db.Entry(user).State = System.Data.Entity.EntityState.Modified; pref.db.Entry(userAddress).State = System.Data.Entity.EntityState.Modified; pref.db.Entry(userPhone).State = System.Data.Entity.EntityState.Modified; pref.db.Entry(userEmail).State = System.Data.Entity.EntityState.Modified; pref.user = user; pref.address = userAddress; pref.phone = userPhone; pref.email = userEmail; try { pref.db.SaveChanges(); } catch (DbEntityValidationException dbEx) { Debug.WriteLine("Save DbEntityValidation Exception: "); string errors = ""; foreach (DbEntityValidationResult devr in dbEx.EntityValidationErrors) { foreach (DbValidationError dve in devr.ValidationErrors) { Debug.WriteLine(" DbEntityValidationResult: " + dve.ErrorMessage); errors += dve.ErrorMessage + "<br />"; } } return(errors); } catch (System.Data.DataException de) { Debug.WriteLine("Save DataException: " + de.Message); return(de.Message); } catch (Exception xcptn) { Debug.WriteLine("Save Exception: " + xcptn.Message); return(xcptn.Message); } return("success"); }
public MoveModel(int frID, IFormsRepository fr) { LoginIDs = new List <SelectListItem>(); formResultId = frID; formsRepo = fr; def_FormResults formResult = formsRepo.GetFormResultById(formResultId); def_ResponseVariables rvFirst = formsRepo.GetResponseVariablesByFormResultIdentifier(formResultId, "sis_cl_first_nm"); if (rvFirst != null) { firstName = rvFirst.rspValue; } def_ResponseVariables rvLast = formsRepo.GetResponseVariablesByFormResultIdentifier(formResultId, "sis_cl_last_nm"); if (rvLast != null) { lastName = rvLast.rspValue; } recipientID = formResult.subject; using (var context = DataContext.getUasDbContext()) { if (formResult.EnterpriseID != null) { enterprise = context.uas_Enterprise.Where(e => e.EnterpriseID == formResult.EnterpriseID).Select(e => e.EnterpriseName).FirstOrDefault(); selectedEnterprise = (int)formResult.EnterpriseID; } if (formResult.GroupID != null) { group = context.uas_Group.Where(g => g.GroupID == formResult.GroupID).Select(g => g.GroupName).FirstOrDefault(); selectedGroup = (int)formResult.GroupID; } if (formResult.assigned != null) { uas_User assignedUser = context.uas_User.Where(u => u.UserID == formResult.assigned).Select(u => u).FirstOrDefault(); selectedUser = (int)formResult.assigned; if (assignedUser != null) { assigned = assignedUser.UserName; //if (assignedUser.StatusFlag != "A") //{ // assigned += " (inactive)"; //} } } LoginIDs.Add(new SelectListItem { Value = "", Text = "" }); if (SessionHelper.LoginStatus.EnterpriseID == 0) // User has site wide (all enterprise) access { Enterprises = new List <SelectListItem>(); Groups = new List <SelectListItem>(); List <uas_Enterprise> enterprises = context.uas_Enterprise.Where(e => e.StatusFlag == "A").Select(e => e).ToList(); foreach (uas_Enterprise ent in enterprises) { Enterprises.Add(new SelectListItem { Value = ent.EnterpriseID.ToString(), Text = ent.EnterpriseName }); } List <uas_Group> groups = context.uas_Group.Where(g => g.StatusFlag == "A" && g.EnterpriseID == selectedEnterprise).Select(g => g).ToList(); Groups.Add(new SelectListItem { Value = "", Text = "" }); foreach (uas_Group grp in groups) { Groups.Add(new SelectListItem { Value = grp.GroupID.ToString(), Text = grp.GroupName }); } List <uas_User> users = null; if (selectedGroup > 0) { List <int> userIdsForUserGroup = context.uas_GroupUserAppPermissions.Where(g => selectedGroup == g.uas_Group.GroupID && g.StatusFlag == "A").Select(g => g.UserID).ToList(); users = context.uas_User.Where(u => u.EnterpriseID == selectedEnterprise && userIdsForUserGroup.Contains(u.UserID) && u.StatusFlag == "A").Select(u => u).ToList(); } else { users = context.uas_User.Where(u => u.EnterpriseID == SessionHelper.LoginStatus.EnterpriseID).Select(u => u).ToList(); } foreach (uas_User user in users) { LoginIDs.Add(new SelectListItem { Value = user.UserID.ToString(), Text = user.UserName }); } } else if (SessionHelper.LoginStatus.appGroupPermissions[0].authorizedGroups.Contains(0)) // User has enterprise wide access (all groups/users in enterprise) { Groups = new List <SelectListItem>(); List <uas_User> users = context.uas_User.Where(u => u.EnterpriseID == SessionHelper.LoginStatus.EnterpriseID && u.StatusFlag == "A").Select(u => u).ToList(); foreach (uas_User user in users) { LoginIDs.Add(new SelectListItem { Value = user.UserID.ToString(), Text = user.UserName }); } List <uas_Group> groups = context.uas_Group.Where(g => g.EnterpriseID == SessionHelper.LoginStatus.EnterpriseID && g.StatusFlag == "A").Select(g => g).ToList(); Groups.Add(new SelectListItem { Value = "", Text = "" }); foreach (uas_Group grp in groups) { Groups.Add(new SelectListItem { Value = grp.GroupID.ToString(), Text = grp.GroupName }); } } else // Regular user. No selection for enterprise or group. { var authorizedGroups = SessionHelper.LoginStatus.appGroupPermissions[0].authorizedGroups; List <int> userIdsForUserGroup = context.uas_GroupUserAppPermissions.Where(g => authorizedGroups.Contains(g.uas_Group.GroupID) && g.StatusFlag == "A").Select(g => g.UserID).ToList(); List <uas_User> users = context.uas_User.Where(u => u.EnterpriseID == SessionHelper.LoginStatus.EnterpriseID && userIdsForUserGroup.Contains(u.UserID) && u.StatusFlag == "A").Select(u => u).ToList(); foreach (uas_User user in users) { LoginIDs.Add(new SelectListItem { Value = user.UserID.ToString(), Text = user.UserName }); } } } }