public GroupDetailModel AddGroups(GroupDetailModel groups, out Header header) { GroupDetailModel groupDetailModel = new GroupDetailModel(); try { header = GlobalHelper.ConstructHeader(Messages.GroupAddSucces); groupDetailModel = this.unitOfWork.GroupDetailRepository.AddGroups(groups); if (groupDetailModel == null) { header = GlobalHelper.ConstructHeader(Messages.GroupAlready); } return(groupDetailModel); } catch (Exception ex) { logger.Error(ex.StackTrace.ToString()); if (ex.Message.Contains("Adding Group Failed")) { header = GlobalHelper.ConstructHeader(ex, Messages.GroupAddFailed); } else { header = GlobalHelper.ConstructHeader(ex, Messages.Exception); } return(groupDetailModel); } }
private GroupDetail ConvertGroupDetailModel(GroupDetail item, GroupDetailModel model) { item.GroupId = item.GroupId; item.GroupName = model.GroupName; item.ModifiedOn = DateTime.UtcNow; item.UserId = model.UserId; item.ModifiedBy = model.UserId; return(item); }
// GET: Group public ActionResult GroupDetail(string groupCode) { currentGroupCode = groupCode; GroupDetailModel gdm = null; GroupGetResponse ggr = _groupCom.GetGroup(groupCode); if (ggr != null) { gdm = new GroupDetailModel() { CourseCode = ggr.CourseCode, GroupCode = ggr.GroupCode, GroupName = ggr.GroupName, GroupTypeCode = ggr.GroupTypeCode, Objective = ggr.Objective, TimeZone = ggr.TimeZone, UserList = new List <GroupUserModel>(), GroupPosts = new List <PostModel>() }; foreach (var user in ggr.UserList) { gdm.UserList.Add(new GroupUserModel() { emailId = user.emailId, name = user.name }); } foreach (var posts in ggr.GroupPosts) { PostModel pm = new PostModel() { PostText = posts.PostText, TimePosted = posts.TimePosted, UserName = posts.UserName, }; if (posts.ChildPosts != null && posts.ChildPosts.Count > 0) { pm.ChildPosts = new List <PostModel>(); foreach (var cp in posts.ChildPosts) { pm.ChildPosts.Add(new PostModel() { PostText = cp.PostText, TimePosted = cp.TimePosted, UserName = cp.UserName }); } } gdm.GroupPosts.Add(pm); } } return(View(gdm)); }
private GroupDetail ConvertGroupDetailModel(GroupDetailModel item) { return(new GroupDetail { GroupName = item.GroupName, CreatedOn = DateTime.UtcNow, ModifiedOn = DateTime.UtcNow, UserId = item.UserId, CreatedBy = item.UserId, ModifiedBy = item.UserId, }); }
private GroupDetailModel GetGroupDetailModel(Parameters parameters) { var _user = HttpContext.Session.GetSession <User>("User"); var _group = _groupManager.GetGroupInfo(parameters.ID, _user?.ID); if (_group != null) { GroupDetailModel model = new GroupDetailModel(); model.Group = _group; return(model); } return(null); }
public GroupDetailModel DeactiveGroup(GroupDetailModel groups, out Header header) { GroupDetailModel groupDetailModel = new GroupDetailModel(); try { header = GlobalHelper.ConstructHeader(); groupDetailModel = this.unitOfWork.GroupDetailRepository.DeactiveGroup(groups); return(groupDetailModel); } catch (Exception ex) { header = GlobalHelper.ConstructHeader(ex, Messages.DeleteData); logger.Error(ex.StackTrace.ToString()); return(groupDetailModel); } }
public GroupDetailModel DeactiveGroup(GroupDetailModel groups) { try { logger.Info("Deactive Group"); GroupDetail item = this.dbContext.GroupDetails.SingleOrDefault(d => d.GroupId == groups.GroupId); item.isActive = false; this.dbContext.SaveChanges(); } catch (Exception ex) { logger.Error(ex.Message); this.LogError(ex); throw ex; } return(groups); }
public GroupDetailModel ImportGroupAttendance(GroupDetailModel lstgroups, out Header header) { try { header = GlobalHelper.ConstructHeader(Messages.GroupAddSucces); lstgroups = this.unitOfWork.GroupDetailRepository.ImportGroupAttendance(lstgroups); if (lstgroups == null) { header = GlobalHelper.ConstructHeader(Messages.Failed); } return(lstgroups); } catch (Exception ex) { logger.Error(ex.StackTrace.ToString()); header = GlobalHelper.ConstructHeader(ex, Messages.Exception); return(lstgroups); } }
public GroupDetailModel EditGroups(GroupDetailModel groups, out Header header) { GroupDetailModel groupDetailModel = new GroupDetailModel(); try { header = GlobalHelper.ConstructHeader(Messages.AddUserUpdatedMessage); groupDetailModel = this.unitOfWork.GroupDetailRepository.EditGroups(groups); if (groupDetailModel == null) { header = GlobalHelper.ConstructHeader(Messages.GroupAlready); } return(groupDetailModel); } catch (Exception ex) { header = GlobalHelper.ConstructHeader(ex, Messages.Exception); logger.Error(ex.StackTrace.ToString()); return(groupDetailModel); } }
// POST: Group/Create public JsonResult CreateGroup(GroupDetailModel Group) { DataSet ds = new DataSet(); object[] message = new object[1]; try { if (Group != null & ModelState.IsValid) { ds = data.CreateGroup(Group); message[0] = ds.Tables[0].Rows[0]["sMess"].ToString(); } } catch (Exception ex) { message[0] = "Error: Không thêm được nhóm quyền!"; CLog.LogError(CBase.GetDeepCaller(), CBase.GetDetailError(ex)); } return(Json(new { mess = message }, JsonRequestBehavior.AllowGet)); }
public ActionResult Report() { List <GroupDetail> data = new List <GroupDetail>(); XmlDocument doc = new XmlDocument(); doc.Load(Server.MapPath("~/GroupDetail.xml")); XmlNode node = doc.SelectSingleNode("ADGroupDetail"); // 得到根节点的所有子节点 XmlNodeList xnl = node.ChildNodes; int i = 0; foreach (XmlNode xn1 in xnl) { GroupDetail group = new GroupDetail(); // 将节点转换为元素,便于得到节点的属性值 XmlElement xe = (XmlElement)xn1; // 得到Type和ISBN两个属性的属性值 group.id = i++; group.name = xe.GetAttribute("Name").ToString(); XmlNodeList xnl0 = xe.ChildNodes; group.Createby = xnl0.Item(0).InnerText; group.CreateTime = xnl0.Item(1).InnerText; data.Add(group); } GroupDetailModel GM = new GroupDetailModel() { groupdetail = data, }; return(View(GM)); }
public async Task <ActionResult> GroupDetail(GroupDetailModel model) { return(View(model)); }
public List <GroupDetailModel> GetGroupsById(int userId, int groupId) { List <GroupDetailModel> groupDetailListModels = new List <GroupDetailModel>(); try { var getValues = this.FindAll(x => x.UserId == userId && x.GroupId == groupId && x.isActive == true).ToList(); if (getValues != null) { foreach (var item in getValues) { GroupDetailModel groupDetailModel = new GroupDetailModel(); groupDetailModel.GroupId = item.GroupId; groupDetailModel.GroupName = item.GroupName; groupDetailModel.UserId = userId; groupDetailModel.UserInfoList = (from us in dbContext.UserInfoes join gsa in dbContext.GroupUserAssocs.Where(x => x.GroupId == item.GroupId) on us.UserId equals gsa.UserId select new UserModel() { UserId = us.UserId, PhoneNumber = us.PhoneNumber, FullName = us.FullName, EmailId = us.EmailId, }).ToList(); groupDetailModel.GroupUserAssocsList = (from gua in dbContext.GroupUserAssocs.Where(x => x.GroupId == item.GroupId) join gd in dbContext.GroupDetails.Where(x => x.GroupId == item.GroupId) on gua.GroupId equals gd.GroupId select new GroupUserAssocModel { GroupId = gua.GroupId, GroupUserId = gua.GroupUserId }).ToList(); groupDetailListModels.Add(groupDetailModel); } } else { return(null); } } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}:{2}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage, validationError.PropertyName); // raise a new exception nesting // the current instance as InnerException raise = new InvalidOperationException(message, raise); this.LogInfo(message); } } throw raise; } catch (Exception ex) { logger.Error(ex.Message); this.LogError(ex); throw ex; } return(groupDetailListModels); }
public GroupDetailModel AddGroups(GroupDetailModel groups) { try { logger.Info("Add Group Respository"); var group = dbContext.GroupDetails.Where(x => x.GroupName == groups.GroupName).FirstOrDefault(); if (group != null) { return(null); } else { GroupDetail groupDetail = this.ConvertGroupDetailModel(groups); groupDetail.isActive = true; this.Add(groupDetail); groups.GroupId = groupDetail.GroupId; if (groupDetail.GroupId != 0) { foreach (var item in groups.UserInfoList) { var userValidate = this.unitOfWork.UserRepository.CheckingValidationsAndRetrunUser(item); item.UserId = userValidate.UserId; item.UserErrorMessage = userValidate.UserErrorMessage; } if (groups.UserInfoList.Count > 0) { var bulkUpload = this.unitOfWork.UserRepository.BulkUserAddOrUopdate(groups.UserInfoList); foreach (var item in bulkUpload.Where(x => x.isAssocationDeleted == false)) { if (item.UserId != 0) { dbContext.GroupUserAssocs.Add( new GroupUserAssoc() { GroupId = groupDetail.GroupId, UserId = item.UserId, CreatedDate = DateTime.UtcNow, ModifiedDate = DateTime.UtcNow, IsActive = true, ModifiedBy = groupDetail.UserId, }); dbContext.SaveChanges(); } } } } else { throw new Exception("Adding Group Failed"); } } return(groups); } catch (Exception ex) { logger.Error("Add Group Respository" + ex.Message); this.LogError(ex); groups = null; throw ex; } }
public GroupDetailModel ImportGroupAttendance(GroupDetailModel groups) { try { logger.Info("Import Group Respository"); var group = new GroupDetail(); if (groups.GroupId != 0) { group = dbContext.GroupDetails.Where(x => x.GroupId == groups.GroupId).FirstOrDefault(); } else { group = dbContext.GroupDetails.Where(x => x.GroupName == groups.GroupName).FirstOrDefault(); } if (group == null) { GroupDetail groupdDetailsEntitiy = this.Find(d => d.GroupId == groups.GroupId); GroupDetail groupDetail = this.ConvertGroupDetailModel(groupdDetailsEntitiy, groups); this.Add(groupDetail); groups.GroupId = groupDetail.GroupId; if (groupDetail.GroupId != 0) { foreach (var item in groups.UserInfoList) { var userValidate = this.unitOfWork.UserRepository.CheckingValidationsAndRetrunUser(item); item.UserId = userValidate.UserId; item.UserErrorMessage = userValidate.UserErrorMessage; } if (groups.UserInfoList.Count > 0) { var bulkUploadUserList = this.unitOfWork.UserRepository.BulkUserAddOrUopdate(groups.UserInfoList.Where(x => x.isAssocationDeleted == false).ToList()); foreach (var item in bulkUploadUserList) { if (item.UserId != 0) { dbContext.GroupUserAssocs.Add( new GroupUserAssoc() { GroupId = groupDetail.GroupId, UserId = item.UserId, CreatedDate = DateTime.UtcNow, ModifiedDate = DateTime.UtcNow, IsActive = true, ModifiedBy = groupDetail.UserId, }); } } } } else { throw new Exception("Group id not exits"); } } else { GroupDetail groupDetail = this.ConvertGroupDetailModel(groups); groupDetail.isActive = true; this.Add(groupDetail); groups.GroupId = groupDetail.GroupId; if (groupDetail.GroupId != 0) { foreach (var item in groups.UserInfoList) { var userValidate = this.unitOfWork.UserRepository.CheckingValidationsAndRetrunUser(item); item.UserId = userValidate.UserId; item.UserErrorMessage = userValidate.UserErrorMessage; } if (groups.UserInfoList.Count > 0) { var bulkUpload = this.unitOfWork.UserRepository.BulkUserAddOrUopdate(groups.UserInfoList.Where(x => x.isAssocationDeleted == false).ToList()); foreach (var item in bulkUpload) { if (item.UserId != 0) { var assocation = dbContext.GroupUserAssocs.Where(x => x.UserId == item.UserId && x.GroupId == groupDetail.GroupId).FirstOrDefault(); if (assocation == null) { dbContext.GroupUserAssocs.Add( new GroupUserAssoc() { GroupId = groupDetail.GroupId, UserId = item.UserId, CreatedDate = DateTime.UtcNow, ModifiedDate = DateTime.UtcNow, IsActive = true, ModifiedBy = item.UserId, }); } if (item.isAssocationDeleted) { dbContext.GroupUserAssocs.AddOrUpdate( new GroupUserAssoc() { GroupId = groupDetail.GroupId, UserId = item.UserId, CreatedDate = DateTime.UtcNow, ModifiedDate = DateTime.UtcNow, IsActive = false, ModifiedBy = item.UserId, }); } } } } } } return(groups); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}:{2}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage, validationError.PropertyName); // raise a new exception nesting // the current instance as InnerException raise = new InvalidOperationException(message, raise); this.LogInfo(message); } } throw raise; } catch (Exception ex) { logger.Error("import Group Respository" + ex.Message); this.LogError(ex); groups = null; throw ex; } }
public GroupDetailModel EditGroups(GroupDetailModel groups) { try { logger.Info("Edit Group Respository"); var value = dbContext.GroupDetails.Where(x => x.GroupName == groups.GroupName && x.GroupId != groups.GroupId).Count(); if (value == 0) { GroupDetail groupdDetailsEntitiy = this.Find(d => d.GroupId == groups.GroupId); GroupDetail groupDetail = this.ConvertGroupDetailModel(groupdDetailsEntitiy, groups); groupDetail.isActive = true; this.Update(groupDetail); groups.GroupId = groupDetail.GroupId; if (groupDetail.GroupId != 0) { foreach (var item in groups.UserInfoList) { var userValidate = this.unitOfWork.UserRepository.CheckingValidationsAndRetrunUser(item); item.UserId = userValidate.UserId; item.UserErrorMessage = userValidate.UserErrorMessage; } if (groups.UserInfoList.Count > 0) { var bulkUpload = this.unitOfWork.UserRepository.BulkUserAddOrUopdate(groups.UserInfoList); foreach (var item in bulkUpload.Where(x => x.isAssocationDeleted == false)) { if (item.UserId != 0) { var assocation = dbContext.GroupUserAssocs.Where(x => x.UserId == item.UserId && x.GroupId == groupDetail.GroupId).FirstOrDefault(); if (assocation == null) { dbContext.GroupUserAssocs.Add( new GroupUserAssoc() { GroupId = groupDetail.GroupId, UserId = item.UserId, CreatedDate = DateTime.UtcNow, ModifiedDate = DateTime.UtcNow, IsActive = true, ModifiedBy = item.UserId, }); dbContext.SaveChanges(); } if (item.isAssocationDeleted) { dbContext.GroupUserAssocs.AddOrUpdate( new GroupUserAssoc() { GroupId = groupDetail.GroupId, UserId = item.UserId, CreatedDate = DateTime.UtcNow, ModifiedDate = DateTime.UtcNow, IsActive = false, ModifiedBy = item.UserId, }); dbContext.SaveChanges(); } } } } } } else { return(null); } } catch (Exception ex) { logger.Error(ex.Message); this.LogError(ex); throw ex; } return(groups); }