public int DeleteByProfileIdAndPersonnelId(int profileId, int personnelId) { int result = 0; using (AppDBContext dbContext = new AppDBContext(_config)) { ProfilePersonnel record = dbContext.ProfilePersonnel.Where(pd => pd.ProfileId == profileId && pd.PersonnelId == personnelId).AsNoTracking().SingleOrDefault(); dbContext.Entry(record).State = EntityState.Deleted; result = dbContext.SaveChanges(); } return(result); }
public int Add(ProfilePersonnel record) { int result = 0; using (AppDBContext dbContext = new AppDBContext(_config)) { ProfilePersonnel existrecord = dbContext.ProfilePersonnel.Where(pd => pd.ProfileId == record.ProfileId && pd.PersonnelId == record.PersonnelId).FirstOrDefault(); if (existrecord == null) { dbContext.Entry(record).State = EntityState.Added; result = dbContext.SaveChanges(); } } return(result); }
public ActionResult BatchEdit(BatchEditViewModel model) { if (!ModelState.IsValid) { model.ProfileSelectList = GetProfileSelectList(); if (model.ProfileId.HasValue) { if (model.PersonnelList.Filter == null) { model.PersonnelList.Filter = new DefinedPersonnelListFilterViewModel(); } if (model.PersonnelWhichIsNotIncludeList.Filter == null) { model.PersonnelWhichIsNotIncludeList.Filter = new UndefinedPersonnelListFilterViewModel(); } if (!model.PersonnelList.CurrentPage.HasValue) { model.PersonnelList.CurrentPage = 1; } if (!model.PersonnelList.PageSize.HasValue) { model.PersonnelList.PageSize = 10; } if (!model.PersonnelWhichIsNotIncludeList.CurrentPage.HasValue) { model.PersonnelWhichIsNotIncludeList.CurrentPage = 1; } if (!model.PersonnelWhichIsNotIncludeList.PageSize.HasValue) { model.PersonnelWhichIsNotIncludeList.PageSize = 10; } ProfilePersonnelSearchFilter profilePersonnelSearchFilter = new ProfilePersonnelSearchFilter(); profilePersonnelSearchFilter.Filter_ProfileId = model.ProfileId.Value; profilePersonnelSearchFilter.CurrentPage = model.PersonnelList.CurrentPage.HasValue ? model.PersonnelList.CurrentPage.Value : 1; profilePersonnelSearchFilter.PageSize = model.PersonnelList.PageSize.HasValue ? model.PersonnelList.PageSize.Value : 10; profilePersonnelSearchFilter.SortOn = model.PersonnelList.SortOn; profilePersonnelSearchFilter.SortDirection = model.PersonnelList.SortDirection; profilePersonnelSearchFilter.Filter_Personnel_Name = model.PersonnelList.Filter.Filter_Personnel_Name; profilePersonnelSearchFilter.Filter_Personnel_LastName = model.PersonnelList.Filter.Filter_Personnel_LastName; ProfilePersonnelSearchFilter profilePersonnelWhichIsNotIncludeListSearchFilter = new ProfilePersonnelSearchFilter(); profilePersonnelWhichIsNotIncludeListSearchFilter.Filter_ProfileId = model.ProfileId.Value; profilePersonnelWhichIsNotIncludeListSearchFilter.CurrentPage = model.PersonnelWhichIsNotIncludeList.CurrentPage.HasValue ? model.PersonnelWhichIsNotIncludeList.CurrentPage.Value : 1; profilePersonnelWhichIsNotIncludeListSearchFilter.PageSize = model.PersonnelWhichIsNotIncludeList.PageSize.HasValue ? model.PersonnelWhichIsNotIncludeList.PageSize.Value : 10; profilePersonnelWhichIsNotIncludeListSearchFilter.SortOn = model.PersonnelWhichIsNotIncludeList.SortOn; profilePersonnelWhichIsNotIncludeListSearchFilter.SortDirection = model.PersonnelWhichIsNotIncludeList.SortDirection; profilePersonnelWhichIsNotIncludeListSearchFilter.Filter_Personnel_Name = model.PersonnelWhichIsNotIncludeList.Filter.Filter_Personnel_Name; profilePersonnelWhichIsNotIncludeListSearchFilter.Filter_Personnel_LastName = model.PersonnelWhichIsNotIncludeList.Filter.Filter_Personnel_LastName; model.PersonnelList.DataList = GetAllEmployeeByProfileId(profilePersonnelSearchFilter); model.PersonnelWhichIsNotIncludeList.DataList = GetAllEmployeeByProfileIdWhichIsNotIncluded(profilePersonnelWhichIsNotIncludeListSearchFilter); } else { model.PersonnelList = new DefinedPersonnelListViewModel(); model.PersonnelList.Filter = new DefinedPersonnelListFilterViewModel(); model.PersonnelList.DataList = new Business.Models.PaginatedList <PersonnelCheckViewModel>(new List <PersonnelCheckViewModel>(), 0, 1, 10, "", ""); model.PersonnelList.CurrentPage = 1; model.PersonnelList.PageSize = 10; model.PersonnelWhichIsNotIncludeList = new UndefinedPersonnelListViewModel(); model.PersonnelWhichIsNotIncludeList.Filter = new UndefinedPersonnelListFilterViewModel(); model.PersonnelWhichIsNotIncludeList.DataList = new Business.Models.PaginatedList <PersonnelCheckViewModel>(new List <PersonnelCheckViewModel>(), 0, 1, 10, "", ""); model.PersonnelWhichIsNotIncludeList.CurrentPage = 1; model.PersonnelWhichIsNotIncludeList.PageSize = 10; } return(View(model)); } if (model.SubmitType == "Add") { if (model.PersonnelWhichIsNotIncludeList.DataList != null && model.ProfileId.HasValue) { ModelState.Clear(); List <PersonnelCheckViewModel> records = model.PersonnelWhichIsNotIncludeList.DataList.Items.Where(x => x.Checked == true).ToList(); if (records != null) { foreach (var item in records) { ProfilePersonnel profilePersonnel = new ProfilePersonnel(); profilePersonnel.PersonnelId = item.Id; profilePersonnel.ProfileId = model.ProfileId.Value; _profilePersonnelService.Add(profilePersonnel); } } } } if (model.SubmitType == "Delete") { if (model.PersonnelList.DataList != null && model.ProfileId.HasValue) { ModelState.Clear(); List <PersonnelCheckViewModel> record = model.PersonnelList.DataList.Items.Where(x => x.Checked == true).ToList(); if (record != null) { foreach (var item in record) { var apiResponseModel = _profilePersonnelService.DeleteByProfileIdAndEmployeeId(model.ProfileId.Value, item.Id); } } } } model.ProfileSelectList = GetProfileSelectList(); if (model.ProfileId.HasValue) { if (model.PersonnelList.Filter == null) { model.PersonnelList.Filter = new DefinedPersonnelListFilterViewModel(); } if (model.PersonnelWhichIsNotIncludeList.Filter == null) { model.PersonnelWhichIsNotIncludeList.Filter = new UndefinedPersonnelListFilterViewModel(); } if (!model.PersonnelList.CurrentPage.HasValue) { model.PersonnelList.CurrentPage = 1; } if (!model.PersonnelList.PageSize.HasValue) { model.PersonnelList.PageSize = 10; } if (!model.PersonnelWhichIsNotIncludeList.CurrentPage.HasValue) { model.PersonnelWhichIsNotIncludeList.CurrentPage = 1; } if (!model.PersonnelWhichIsNotIncludeList.PageSize.HasValue) { model.PersonnelWhichIsNotIncludeList.PageSize = 10; } ProfilePersonnelSearchFilter profilePersonnelSearchFilter = new ProfilePersonnelSearchFilter(); profilePersonnelSearchFilter.Filter_ProfileId = model.ProfileId.Value; profilePersonnelSearchFilter.CurrentPage = model.PersonnelList.CurrentPage.HasValue ? model.PersonnelList.CurrentPage.Value : 1; profilePersonnelSearchFilter.PageSize = model.PersonnelList.PageSize.HasValue ? model.PersonnelList.PageSize.Value : 10; profilePersonnelSearchFilter.SortOn = model.PersonnelList.SortOn; profilePersonnelSearchFilter.SortDirection = model.PersonnelList.SortDirection; profilePersonnelSearchFilter.Filter_Personnel_Name = model.PersonnelList.Filter.Filter_Personnel_Name; profilePersonnelSearchFilter.Filter_Personnel_LastName = model.PersonnelList.Filter.Filter_Personnel_LastName; ProfilePersonnelSearchFilter profilePersonnelWhichIsNotIncludeListSearchFilter = new ProfilePersonnelSearchFilter(); profilePersonnelWhichIsNotIncludeListSearchFilter.Filter_ProfileId = model.ProfileId.Value; profilePersonnelWhichIsNotIncludeListSearchFilter.CurrentPage = model.PersonnelWhichIsNotIncludeList.CurrentPage.HasValue ? model.PersonnelWhichIsNotIncludeList.CurrentPage.Value : 1; profilePersonnelWhichIsNotIncludeListSearchFilter.PageSize = model.PersonnelWhichIsNotIncludeList.PageSize.HasValue ? model.PersonnelWhichIsNotIncludeList.PageSize.Value : 10; profilePersonnelWhichIsNotIncludeListSearchFilter.SortOn = model.PersonnelWhichIsNotIncludeList.SortOn; profilePersonnelWhichIsNotIncludeListSearchFilter.SortDirection = model.PersonnelWhichIsNotIncludeList.SortDirection; profilePersonnelWhichIsNotIncludeListSearchFilter.Filter_Personnel_Name = model.PersonnelWhichIsNotIncludeList.Filter.Filter_Personnel_Name; profilePersonnelWhichIsNotIncludeListSearchFilter.Filter_Personnel_LastName = model.PersonnelWhichIsNotIncludeList.Filter.Filter_Personnel_LastName; model.PersonnelList.DataList = GetAllEmployeeByProfileId(profilePersonnelSearchFilter); model.PersonnelWhichIsNotIncludeList.DataList = GetAllEmployeeByProfileIdWhichIsNotIncluded(profilePersonnelWhichIsNotIncludeListSearchFilter); if (model.PersonnelList.DataList == null || model.PersonnelList.DataList.Items == null) { model.PersonnelList.DataList = new Business.Models.PaginatedList <PersonnelCheckViewModel>(new List <PersonnelCheckViewModel>(), 0, 1, 10, "", ""); } if (model.PersonnelWhichIsNotIncludeList.DataList == null || model.PersonnelWhichIsNotIncludeList.DataList.Items == null) { model.PersonnelWhichIsNotIncludeList.DataList = new Business.Models.PaginatedList <PersonnelCheckViewModel>(new List <PersonnelCheckViewModel>(), 0, 1, 10, "", ""); } } else { model.PersonnelList = new DefinedPersonnelListViewModel(); model.PersonnelList.Filter = new DefinedPersonnelListFilterViewModel(); model.PersonnelList.DataList = new Business.Models.PaginatedList <PersonnelCheckViewModel>(new List <PersonnelCheckViewModel>(), 0, 1, 10, "", ""); model.PersonnelList.CurrentPage = 1; model.PersonnelList.PageSize = 10; model.PersonnelWhichIsNotIncludeList = new UndefinedPersonnelListViewModel(); model.PersonnelWhichIsNotIncludeList.Filter = new UndefinedPersonnelListFilterViewModel(); model.PersonnelWhichIsNotIncludeList.DataList = new Business.Models.PaginatedList <PersonnelCheckViewModel>(new List <PersonnelCheckViewModel>(), 0, 1, 10, "", ""); model.PersonnelWhichIsNotIncludeList.CurrentPage = 1; model.PersonnelWhichIsNotIncludeList.PageSize = 10; } return(View(model)); }