public void DeleteGroup_Users(List <int> groupUserIDsToDelete) { //Validate Input foreach (int groupUserID in groupUserIDsToDelete) { if (groupUserID.IsInvalidKey()) { BusinessLayerHelper.ThrowErrorForInvalidDataKey("GroupUserID"); } } List <Group_Users> group_UserssToBeDeleted = new List <Group_Users>(); foreach (int groupUserID in groupUserIDsToDelete) { Group_Users group_Users = new Group_Users { GroupUserID = groupUserID }; _DatabaseContext.Group_Users.Attach(group_Users); _DatabaseContext.Group_Users.DeleteObject(group_Users); group_UserssToBeDeleted.Add(group_Users); OnGroup_UsersDeleting(group_Users); } int numberOfAffectedRows = _DatabaseContext.SaveChanges(); if (numberOfAffectedRows != groupUserIDsToDelete.Count) { throw new DataNotUpdatedException("One or more group_Users records have not been deleted."); } foreach (Group_Users group_UsersToBeDeleted in group_UserssToBeDeleted) { OnGroup_UsersDeleted(group_UsersToBeDeleted); } }
public void DeleteGroup_Users(Group_Users group_UsersToBeDeleted) { //Validate Input if (group_UsersToBeDeleted == null) { throw (new ArgumentNullException("group_UsersToBeDeleted")); } // Validate Primary key value if (group_UsersToBeDeleted.GroupUserID.IsInvalidKey()) { BusinessLayerHelper.ThrowErrorForInvalidDataKey("GroupUserID"); } OnGroup_UsersSaving(group_UsersToBeDeleted); OnGroup_UsersDeleting(group_UsersToBeDeleted); if (group_UsersToBeDeleted.EntityState == EntityState.Detached) { _DatabaseContext.Group_Users.Attach(group_UsersToBeDeleted); } _DatabaseContext.Group_Users.DeleteObject(group_UsersToBeDeleted); int numberOfAffectedRows = _DatabaseContext.SaveChanges(); if (numberOfAffectedRows == 0) { throw new DataNotUpdatedException("No Group_Users deleted!"); } OnGroup_UsersDeleted(group_UsersToBeDeleted); OnGroup_UsersSaved(group_UsersToBeDeleted); }
public void UpdateGroup_Users(Group_Users updatedGroup_Users) { // Validate Parameters if (updatedGroup_Users == null) { throw (new ArgumentNullException("updatedGroup_Users")); } // Validate Primary key value if (updatedGroup_Users.GroupUserID.IsInvalidKey()) { BusinessLayerHelper.ThrowErrorForInvalidDataKey("GroupUserID"); } // Apply business rules OnGroup_UsersSaving(updatedGroup_Users); OnGroup_UsersUpdating(updatedGroup_Users); //attaching and making ready for parsistance if (updatedGroup_Users.EntityState == EntityState.Detached) { _DatabaseContext.Group_Users.Attach(updatedGroup_Users); } _DatabaseContext.ObjectStateManager.ChangeObjectState(updatedGroup_Users, System.Data.EntityState.Modified); //this line makes the code un-testable! int numberOfAffectedRows = _DatabaseContext.SaveChanges(); if (numberOfAffectedRows == 0) { throw new DataNotUpdatedException("No group_Users updated!"); } //Apply business workflow OnGroup_UsersUpdated(updatedGroup_Users); OnGroup_UsersSaved(updatedGroup_Users); }
public virtual int CreateNewGroup_Users(Group_Users newGroup_Users) { // Validate Parameters if (newGroup_Users == null) { throw (new ArgumentNullException("newGroup_Users")); } // Apply business rules OnGroup_UsersSaving(newGroup_Users); OnGroup_UsersCreating(newGroup_Users); _DatabaseContext.Group_Users.AddObject(newGroup_Users); int numberOfAffectedRows = _DatabaseContext.SaveChanges(); if (numberOfAffectedRows == 0) { throw new DataNotUpdatedException("No group_Users created!"); } // Apply business workflow OnGroup_UsersCreated(newGroup_Users); OnGroup_UsersSaved(newGroup_Users); return(newGroup_Users.GroupUserID); }
protected void FormViewUser_ItemUpdating(object sender, FormViewUpdateEventArgs e) { TextBox txtUser = (TextBox)formViewUser.FindControl("txtUser"); UserActionStatus status = Validate(txtUser.Text, actionType.update); if (status == UserActionStatus.Success) { User user = new UserBLL().GetUserByUserID((Guid)e.Keys["UserId"]); using (DatabaseContext _DatabaseContext = new DatabaseContext()) { int roleID = Convert.ToInt32(((DropDownList)formViewUser.FindControl("ddlRoles")).SelectedValue); int groupID = Convert.ToInt32(((DropDownList)formViewUser.FindControl("ddlGroups")).SelectedValue); Role_Users role_Users = _DatabaseContext.Role_Users.First(instance => instance.UserID == user.UserID); Role role = _DatabaseContext.Roles.First(instance => instance.RoleID == roleID); role_Users.RoleID = role.RoleID; role_Users.RoleReference.EntityKey = role.EntityKey; Group_Users group_Users = _DatabaseContext.Group_Users.First(instance => instance.UserID == user.UserID); Group group = _DatabaseContext.Groups.First(instance => instance.GroupID == groupID); group_Users.GroupID = group.GroupID; group_Users.GroupReference.EntityKey = group.EntityKey; _DatabaseContext.SaveChanges(); } Type myType = (typeof(User)); PropertyInfo[] props = myType.GetProperties(); string[] arrNewValues = new string[e.NewValues.Keys.Count]; e.NewValues.Keys.CopyTo(arrNewValues, 0); foreach (var prop in props) { if (("System.String,System.Int,System.DateTime,System.Guid").IndexOf((prop.PropertyType).FullName) >= 0) // Si la propiedad es de tipo Guid, String, Int o DateTime { if (!arrNewValues.Contains(prop.Name)) { e.NewValues[prop.Name] = prop.GetValue(user, null); } } } User editor = new UserBLL().GetUserByUserName((HttpContext.Current.User.Identity).Name); e.NewValues["EditorUserId"] = editor.UserID.ToString(); e.NewValues["EditedDate"] = DateTime.Now; } else { ltlMessage.Text = MessageFormatter.GetFormattedErrorMessage(GetErrorMessage(status)); e.Cancel = true; } }
public bool updatePGroupUser(int ID, User[] UserList) { try { if (getGroupById(ID) != null) { List <Group_Users> select = base.db.Group_Users.Where(g => g.GroupID == ID).ToList(); if (select.Count <= 0) { foreach (User item in UserList) { Group_Users addItem = new Group_Users(); if (item.Checked == true) { addItem.GroupID = ID; addItem.UserID = item.ID; select.Add(addItem); } } base.db.Group_Users.AddRange(select); base.db.SaveChanges(); } else { foreach (User item in UserList) { Group_Users addItem = new Group_Users(); if (item.Checked == false && select.Where(g => g.UserID == item.ID).Count() == 1) { base.db.Group_Users.Remove(select.Where(g => g.UserID == item.ID).FirstOrDefault()); } if (item.Checked == true && select.Where(g => g.UserID == item.ID).Count() == 0) { addItem.GroupID = ID; addItem.UserID = item.ID; base.db.Group_Users.Add(addItem); } } base.db.SaveChanges(); } return(true); } else { return(false); } } catch (Exception) { return(false); } }
/// <summary> /// Deprecated Method for adding a new object to the Group_Users EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToGroup_Users(Group_Users group_Users) { base.AddObject("Group_Users", group_Users); }
partial void OnGroup_UsersDeleted(Group_Users group_Users);
partial void OnGroup_UsersDeleting(Group_Users group_Users);
partial void OnGroup_UsersSaved(Group_Users group_Users);
partial void OnGroup_UsersUpdated(Group_Users group_Users);
partial void OnGroup_UsersUpdating(Group_Users group_Users);
partial void OnGroup_UsersCreated(Group_Users group_Users);
partial void OnGroup_UsersCreating(Group_Users group_Users);
partial void OnGroup_UsersSaving(Group_Users group_Users);