public bool Update(ViewModels.UserDataViewModel userDataViewModel) { bool ret = false; try { if (userDataViewModel.UserID == userDataViewModel.OldUserID) { UserData user = db.UserData.Find(userDataViewModel.OldUserID); user.Email = userDataViewModel.Email; user.EndDate = userDataViewModel.EndDate.Value; user.LoginID = userDataViewModel.LoginID; user.Phone1 = userDataViewModel.Phone1; user.Phone2 = userDataViewModel.Phone2; user.Phone3 = userDataViewModel.Phone3; //user.ResponsibleID = userDataViewModel.ResponsibleID; user.RoleID = userDataViewModel.RoleID; user.StartDate = userDataViewModel.StartDate.Value; //user.UserID = userDataViewModel.UserID; user.UserName = userDataViewModel.UserName; user.Email = userDataViewModel.Email; db.SaveChanges(); ret = true; } else { UserData userData = new UserData(); userData.Email = userDataViewModel.Email; userData.EndDate = userDataViewModel.EndDate.Value; userData.LoginID = userDataViewModel.LoginID; userData.Phone1 = userDataViewModel.Phone1; userData.Phone2 = userDataViewModel.Phone2; userData.Phone3 = userDataViewModel.Phone3; userData.PwdError = 0; userData.Pwd = "0000"; userData.ResponsibleID = ""; userData.RoleID = userDataViewModel.RoleID; userData.StartDate = userDataViewModel.StartDate.Value; userData.UserID = userDataViewModel.UserID; userData.UserName = userDataViewModel.UserName; db.UserData.Add(userData); db.SaveChanges(); var qry = db.WBSEventC.Where(x => x.CreateUserID == userDataViewModel.OldUserID); foreach (WBSEventC o in qry) { o.CreateUserID = userDataViewModel.UserID; } var qry2 = db.WBSEventC.Where(x => x.DeleteMarkUserID == userDataViewModel.OldUserID); foreach (WBSEventC o in qry2) { o.DeleteMarkUserID = userDataViewModel.UserID; } var qry3 = db.WBSEventC.Where(x => x.ModifyUserID == userDataViewModel.OldUserID); foreach (WBSEventC o in qry3) { o.ModifyUserID = userDataViewModel.UserID; } var qry4 = db.WBSEventC.Where(x => x.QuestionCreateUserID == userDataViewModel.OldUserID); foreach (WBSEventC o in qry4) { o.QuestionCreateUserID = userDataViewModel.UserID; } var qry5 = db.WBSEventC.Where(x => x.AssignUserID == userDataViewModel.OldUserID); foreach (WBSEventC o in qry) { o.AssignUserID = userDataViewModel.UserID; } var qry6 = db.WBSEventC.Where(x => x.AssignCreateUserID == userDataViewModel.OldUserID); foreach (WBSEventC o in qry6) { o.AssignCreateUserID = userDataViewModel.UserID; } var qry7 = db.WBSEventC.Where(x => x.AssignModifyUserID == userDataViewModel.OldUserID); foreach (WBSEventC o in qry7) { o.AssignModifyUserID = userDataViewModel.UserID; } var qry8 = db.WBSEventC.Where(x => x.ServiceModifyUserID == userDataViewModel.OldUserID); foreach (WBSEventC o in qry) { o.ServiceModifyUserID = userDataViewModel.UserID; } var qry9 = db.WBSEventC.Where(x => x.ServiceCreateUserID == userDataViewModel.OldUserID); foreach (WBSEventC o in qry9) { o.ServiceCreateUserID = userDataViewModel.UserID; } var qry10 = db.ResponsibleClass.Where(x => x.UserID == userDataViewModel.OldUserID); foreach (ResponsibleClass o in qry10) { o.UserID = userDataViewModel.UserID; } var qry11 = db.ResponsibleClass.Where(x => x.UserID2 == userDataViewModel.OldUserID); foreach (ResponsibleClass o in qry11) { o.UserID2 = userDataViewModel.UserID; } var qry12 = db.UserDevice.Where(x => x.UserID == userDataViewModel.OldUserID); foreach (UserDevice o in qry12) { o.UserID = userDataViewModel.UserID; } var qry13 = db.NewsData.Where(x => x.CreateUserID == userDataViewModel.OldUserID); foreach (NewsData o in qry13) { o.CreateUserID = userDataViewModel.UserID; } var qry14 = db.PageRemark.Where(x => x.ModifyUserID == userDataViewModel.OldUserID); foreach (PageRemark o in qry14) { o.ModifyUserID = userDataViewModel.UserID; } db.SaveChanges(); UserData user2 = db.UserData.Find(userDataViewModel.OldUserID); db.UserData.Remove(user2); db.SaveChanges(); ret = true; } } catch (DbUpdateConcurrencyException ex) { // Update the values of the entity that failed to save from the store ex.Entries.Single().Reload(); } catch (DbEntityValidationException ex) { var errorMessages = ex.EntityValidationErrors .SelectMany(x => x.ValidationErrors) .Select(x => x.ErrorMessage); // Join the list to a single string. var fullErrorMessage = string.Join("; ", errorMessages); // Combine the original exception message with the new one. var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage); // Throw a new DbEntityValidationException with the improved exception message. throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors); } return ret; }
public bool Create(ViewModels.UserDataViewModel userDataViewModel) { bool ret = false; try { UserData userData = new UserData(); userData.Email = userDataViewModel.Email; userData.EndDate = userDataViewModel.EndDate.Value; userData.LoginID = userDataViewModel.LoginID; userData.Phone1 = userDataViewModel.Phone1; userData.Phone2 = userDataViewModel.Phone2; userData.Phone3 = userDataViewModel.Phone3; userData.PwdError = 0; userData.Pwd = "0000"; userData.ResponsibleID = ""; userData.RoleID = userDataViewModel.RoleID; userData.StartDate = userDataViewModel.StartDate.Value; userData.UserID = userDataViewModel.UserID; userData.UserName = userDataViewModel.UserName; db.UserData.Add(userData); db.SaveChanges(); ret = true; } catch { } return ret; }