private void GetTextBoxValuesSelectedUser() { string userName = userListComboBox.SelectedValue.ToString(); Debug.WriteLine("FORM: Looking up User in DB: " + userName); using (FWFCUsersdbEntities context = new FWFCUsersdbEntities()) { var selectedUser = context.Users.Where(c => (c.UserID + ": " + c.First_Name + " " + c.Last_Name) == userName).SingleOrDefault(); if (selectedUser != null) { Debug.WriteLine("FORM: User Found!"); AssociateSelectedUserMain(selectedUser); UserFocus.thisUser = selectedUser; var selectedUserRoles = context.Roles.Where(c => c.FK_UserID == selectedUser.UserID).SingleOrDefault(); if (selectedUserRoles != null) { Debug.WriteLine("FORM: User Roles Found!"); AssociateSelectedUserRole(selectedUserRoles); UserFocus.thisUserRole = selectedUserRoles; } else { Debug.WriteLine("FORM: User Roles Not Found!"); } } else { Debug.WriteLine("FORM: User Not Found!"); } } }
public void NewUserSession() { Debug.WriteLine("USERACCESS: NewUserSession called."); using (FWFCUsersdbEntities context = new FWFCUsersdbEntities()) { if (context.Users.Any(c => c.UserName == thisUser.UserName)) { Debug.WriteLine("USER: User found in DB!"); var currentUser = context.Users.Where(c => c.UserName == thisUser.UserName).SingleOrDefault(); if (currentUser.Password == thisUser.Password) { Debug.WriteLine("USER: Password Match!"); currentUser.UserStatus = "LOGGEDIN"; currentUser.LastAccessDateTime = DateTime.Now; context.AttemptSaveChanges(); RetrieveAllUserInfoFromDB(); } else { ClearAllDBRelation(); } } else { ClearAllDBRelation(); } } }
public void UpdateUserInfo() { using (FWFCUsersdbEntities context = new FWFCUsersdbEntities()) { User updatingUser = context.Users.Where(c => c.UserID == thisUser.UserID).SingleOrDefault(); if (updatingUser != null) { Debug.WriteLine("USER: User Found: Updating DB with Basic Info"); updatingUser.ModifiedDateTime = DateTime.Now; updatingUser.UserName = thisUser.UserName; updatingUser.First_Name = thisUser.First_Name; updatingUser.Last_Name = thisUser.Last_Name; updatingUser.Password = thisUser.Password; updatingUser.isAdmin = thisUser.isAdmin; Role updatingUserRole = context.Roles.Where(c => c.FK_UserID == updatingUser.UserID).SingleOrDefault(); if (updatingUserRole != null) { AssociateRoleInfo(updatingUserRole); } else { Debug.WriteLine("ROLE: No Existing Roles Found! Creating New Role record in DB."); thisUserRole.FK_UserID = updatingUser.UserID; context.Roles.Add(thisUserRole); } context.AttemptSaveChanges(); } } }
public List <string> GetUserNames() // Future Consideration: Maybe Add this to separate static class { Debug.WriteLine("DB: Acquiring User List from DB"); List <string> thisList = new List <string>(); using (FWFCUsersdbEntities context = new FWFCUsersdbEntities()) { var userList = context.Users.ToList(); foreach (var user in userList) { thisList.Add(user.UserID + ": " + user.First_Name + " " + user.Last_Name); } } return(thisList); }
public void LogOut() { Debug.WriteLine("USERACCESS: LogOut called."); using (FWFCUsersdbEntities context = new FWFCUsersdbEntities()) { var logoutUser = context.Users.Where(c => c.UserName == this.thisUser.UserName).FirstOrDefault(); if (!(logoutUser == null)) { Debug.WriteLine("USERACCESS: Attempting to Log Out " + logoutUser.UserName); logoutUser.UserStatus = "LOGOUT"; } context.AttemptSaveChanges(); ClearAllDBRelation(); } }
/// <summary> /// Attempts to Save the requested FWFCUsersDBEntites data to the DB utilizing Entity Framework SaveChanges() method. /// On Fail: Will output error to Debugger. /// </summary> /// <param name="context"></param> public static void AttemptSaveChanges(this FWFCUsersdbEntities context) { try { context.SaveChanges(); } catch (DbEntityValidationException ex) { foreach (var entityValidationErrors in ex.EntityValidationErrors) { foreach (var validationError in entityValidationErrors.ValidationErrors) { Debug.WriteLine("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage); } } } }
public void UpdatePassword() { using (FWFCUsersdbEntities context = new FWFCUsersdbEntities()) { var updatePasswordFocusUser = context.Users.Where(c => c.UserID == thisUser.UserID).SingleOrDefault(); if (updatePasswordFocusUser != null) { Debug.WriteLine("USER: User Found! Updating Password."); updatePasswordFocusUser.Password = thisUser.Password; } else { Debug.WriteLine("USER: User Not Found in DB! Unable to update Password."); } context.AttemptSaveChanges(); } }
private void SaveNewUserToDB() { using (FWFCUsersdbEntities context = new FWFCUsersdbEntities()) { thisUser.CreatedDateTime = DateTime.Now; thisUser.ModifiedDateTime = DateTime.Now; thisUser.UserStatus = "NEW"; context.Users.Add(thisUser); context.AttemptSaveChanges(); thisUser = context.Users.Where(c => c.UserName == thisUser.UserName).SingleOrDefault(); if (thisUser != null) { Debug.WriteLine("USER: New User's DB UserID = " + thisUser.UserID); } else { Debug.WriteLine("USER: There has been an error associating a new UserID!"); } } }
private bool VerifyUniqueUserName() { bool validated = false; Debug.WriteLine("USER: Verifying whether UserName is Unique"); using (FWFCUsersdbEntities context = new FWFCUsersdbEntities()) { User uniqueUser = context.Users.Where(c => c.UserName == thisUser.UserName).SingleOrDefault(); if (uniqueUser == null) { Debug.WriteLine("USER: User Name is Unique!"); validated = true; } else { Debug.WriteLine("USER: User Name is NOT Unique! Cannot Save new User over Existing!"); } } return(validated); }
private void RetrieveAllUserInfoFromDB() { Debug.WriteLine("USERACCESS: RetrieveAllUserInfoFromDB called."); using (FWFCUsersdbEntities context = new FWFCUsersdbEntities()) { // Associate Main User Detail var currentUser = context.Users.Where(c => c.UserName == this.thisUser.UserName).FirstOrDefault(); if (currentUser != null) { Debug.WriteLine("USER: Associating User Main Info"); this.thisUser.UserID = currentUser.UserID; this.thisUser.First_Name = currentUser.First_Name; this.thisUser.Last_Name = currentUser.Last_Name; this.thisUser.Roles = currentUser.Roles; this.thisUser.CreatedDateTime = currentUser.CreatedDateTime; this.thisUser.LastAccessDateTime = currentUser.LastAccessDateTime; this.thisUser.ModifiedDateTime = currentUser.ModifiedDateTime; this.thisUser.isAdmin = currentUser.isAdmin; this.thisUser.UserStatus = currentUser.UserStatus; } else { Debug.WriteLine("USER: User Not Found!"); } // Associate User Roles var currentUserRole = context.Roles.Where(c => c.FK_UserID == currentUser.UserID).FirstOrDefault(); if (currentUserRole != null) { Debug.WriteLine("ROLE: Associating User Role Info"); this.thisUserRole.CreateNewBatch = currentUserRole.CreateNewBatch; this.thisUserRole.CreateNewTemplate = currentUserRole.CreateNewTemplate; this.thisUserRole.CreateNewWire = currentUserRole.CreateNewWire; this.thisUserRole.DeleteBatch = currentUserRole.DeleteBatch; this.thisUserRole.DeleteTemplate = currentUserRole.DeleteTemplate; this.thisUserRole.DeleteWire = currentUserRole.DeleteWire; this.thisUserRole.ExportBatch = currentUserRole.ExportBatch; this.thisUserRole.ModifyBatch = currentUserRole.ModifyBatch; this.thisUserRole.ModifyTemplate = currentUserRole.ModifyTemplate; this.thisUserRole.ModifyWire = currentUserRole.ModifyWire; this.thisUserRole.VerifyBatch = currentUserRole.VerifyBatch; this.thisUserRole.VerifyTemplate = currentUserRole.VerifyTemplate; this.thisUserRole.VerifyWire = currentUserRole.VerifyWire; } else { Debug.WriteLine("ROLE: No User Roles Found!"); } // Associate User Security var currentUserSecurity = context.Securities.Where(c => c.FK_UserID == currentUser.UserID).FirstOrDefault(); if (currentUserSecurity != null) { Debug.WriteLine("SECURITY: Associating User Security Info"); this.thisUserSecurity.Question1 = currentUserSecurity.Question1; this.thisUserSecurity.Question2 = currentUserSecurity.Question2; this.thisUserSecurity.Question3 = currentUserSecurity.Question3; this.thisUserSecurity.Question4 = currentUserSecurity.Question4; this.thisUserSecurity.Question5 = currentUserSecurity.Question5; this.thisUserSecurity.Answer1 = currentUserSecurity.Answer1; this.thisUserSecurity.Answer2 = currentUserSecurity.Answer2; this.thisUserSecurity.Answer3 = currentUserSecurity.Answer3; this.thisUserSecurity.Answer4 = currentUserSecurity.Answer4; this.thisUserSecurity.Answer5 = currentUserSecurity.Answer5; this.thisUserSecurity.SecurityPIN = currentUserSecurity.SecurityPIN; } else { Debug.WriteLine("SECURITY: No Security Info Found!"); } } }