public void AddCategoryMapping(int userID) { var category = _Category.GetWithInclude(x => x.IsDelete == false).ToList(); foreach (var item in category) { UserCategoryMapping catergorymap = new UserCategoryMapping(); catergorymap.UserID = userID; catergorymap.CategoryID = item.Id; catergorymap.IsSelected = true; _userCategoryMapping.Insert(catergorymap); } }
public int Save(UserCategoryMappingModel model) { UserCategoryMapping _tbl_usercategory = new UserCategoryMapping(model); if (model.Id != null && model.Id != 0) { _userCategory.Update(_tbl_usercategory); } else { _userCategory.Insert(_tbl_usercategory); } return(_tbl_usercategory.ID); }
public dynamic CreateGroup(GroupViewModel GVM) { string baseURL = HttpContext.Current.Request.Url.Authority; baseURL += (WebConfigurationManager.AppSettings["groupimagepath"]).Replace("~", ""); GroupViewModel data = new GroupViewModel(); Group G = new Group(); using (LystenEntities db = new LystenEntities()) { int CreatorId = Convert.ToInt32(GVM.CreatorId); int CategoryId = Convert.ToInt32(GVM.CategoryId); G = new Group() { Name = GVM.Name, IsActive = true, CreatedDate = System.DateTime.Now, CreatorId = CreatorId, GroupTypeId = Convert.ToInt32(GVM.GroupTypeId), CategoryId = CategoryId }; db.Groups.Add(G); db.SaveChanges(); data = AutoMapper.Mapper.Map <Group, GroupViewModel>(G); if (G.Image == null || G.Image == "") { data.Image = ""; } else { data.Image = baseURL + GVM.Image; } if (!db.UserCategoryMappings.Any(x => x.UserId == CreatorId && x.CategoryId == CategoryId)) { UserCategoryMapping uc = new UserCategoryMapping() { CategoryId = CategoryId, UserId = CreatorId }; db.UserCategoryMappings.Add(uc); db.SaveChanges(); } } return(data); }
public void UpdateCategory(List <CategoryModel> lstmodel, int userid) { lstmodel.ForEach(x => { var userCategory = _userCategoryMapping.GetWithInclude(z => z.UserID == userid && z.CategoryID == x.Id).FirstOrDefault(); if (userCategory != null) { userCategory.IsSelected = x.IsChecked; _userCategoryMapping.Update(userCategory); } else { UserCategoryMapping catergorymap = new UserCategoryMapping(); catergorymap.UserID = userid; catergorymap.CategoryID = x.Id; catergorymap.IsSelected = x.IsChecked; _userCategoryMapping.Insert(catergorymap); } }); return; }