// // GET: /Group/Create public ActionResult Create() { Group objGroup = new Group(); objGroup.Users = this.repository.Users(_userStatistics.OrganizationId); objGroup.OrganizationList = LoadSelectLists(); objGroup.OrganizationId = ViewBag.OrganizationId == null ? 0 : Convert.ToInt32(ViewBag.OrganizationId); return View(objGroup); }
public string Create(Group objGroup) { try { if (ModelState.IsValid) { objGroup.InsertedOn = DateTime.Now; objGroup.InsertedBy = _userStatistics.UserId; //objGroup.UserCount = objGroup.Members.Split(',').Length; UserGroup objUserGroup = null; if (repository.CreateGroup(objGroup)) { if (objGroup.Members != null) { var userIds = objGroup.Members.Split(','); foreach (var id in userIds) { objUserGroup = new UserGroup(); objUserGroup.UserId = Convert.ToInt32(id); objUserGroup.GroupId = objGroup.GroupId; objUserGroup.InsertedBy = _userStatistics.UserId; this.repository.AssignGroupToUser(objUserGroup); } return Convert.ToString(true); } return Convert.ToString(true); } return Convert.ToString(false); } return Convert.ToString(false); } catch (Exception ex) { return ex.Message.ToString(); } }
public bool CreateGroup(Group objGroup) { var parameters = new { GroupName = objGroup.GroupName, Description = objGroup.Description, InsertedOn = objGroup.InsertedOn, InsertedBy = objGroup.InsertedBy, OrganizationId = objGroup.OrganizationId }; using (IDbConnection connection = OpenConnection()) { const string storedProcedure = "usp_AddGroups"; int rowsAffected = connection.Execute(storedProcedure, parameters, commandType: CommandType.StoredProcedure); SetIdentity<int>(connection, id => objGroup.GroupId = id); if (rowsAffected > 0) { return true; } return false; } }
public string Edit(Group objGroup) { try { if (ModelState.IsValid) { objGroup.ModifieBy = _userStatistics.UserId; objGroup.ModifiedOn = DateTime.Now; DBConnectionString.Group group = new DBConnectionString.Group { Description = objGroup.Description, GroupId = objGroup.GroupId, GroupName = objGroup.GroupName, ModifieBy = _userStatistics.UserId, ModifiedOn = DateTime.Now, OrganizationId = objGroup.OrganizationId, InsertedBy=objGroup.InsertedBy, InsertedOn=objGroup.InsertedOn }; UserGroup objUserGroup = null; int recAffected = group.Update(); if (recAffected > 0) { objGroup.UserGroups = this.repository.UserGroupsByGroup(objGroup.GroupId); if (objGroup.Members != null) { var userIds = objGroup.Members.Split(','); foreach (var id in userIds) { if (!objGroup.UserGroups.Select(s => s.UserId).Contains(Convert.ToInt64(id))) { objUserGroup = new UserGroup(); objUserGroup.UserId = Convert.ToInt32(id); objUserGroup.GroupId = objGroup.GroupId; objUserGroup.InsertedBy = _userStatistics.UserId; this.repository.AssignGroupToUser(objUserGroup); } } foreach (var ug in objGroup.UserGroups) { if (!userIds.Contains(ug.UserId.ToString())) { repository.DeleteUserGroup(ug.UserId, ug.GroupId); } } return Convert.ToString(true); } return Convert.ToString(true); } return Convert.ToString(false); } return Convert.ToString(false); } catch (Exception ex) { return ex.Message.ToString(); } }