public int DeleteByProfileIdAndEmployeeId(int profileId, int employeeId)
{
int result = 0;
using (AppDBContext dbContext = new AppDBContext(_config))
{
ProfileEmployee record = dbContext.ProfileEmployee.Where(pd => pd.ProfileId == profileId && pd.EmployeeId == employeeId).AsNoTracking().SingleOrDefault();
dbContext.Entry(record).State = EntityState.Deleted;
result = dbContext.SaveChanges();
}
return(result);
}
public int Add(ProfileEmployee record)
{
int result = 0;
using (AppDBContext dbContext = new AppDBContext(_config))
{
ProfileEmployee existrecord = dbContext.ProfileEmployee.Where(pd => pd.ProfileId == record.ProfileId && pd.EmployeeId == record.EmployeeId).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(SessionHelper.CurrentUser.UserToken, SessionHelper.CurrentLanguageTwoChar);
if (model.ProfileId.HasValue)
{
if (model.EmployeeList.Filter == null)
{
model.EmployeeList.Filter = new DefinedEmployeeListFilterViewModel();
}
if (model.EmployeeWhichIsNotIncludeList.Filter == null)
{
model.EmployeeWhichIsNotIncludeList.Filter = new UndefinedEmployeeListFilterViewModel();
}
if (!model.EmployeeList.CurrentPage.HasValue)
{
model.EmployeeList.CurrentPage = 1;
}
if (!model.EmployeeList.PageSize.HasValue)
{
model.EmployeeList.PageSize = 10;
}
if (!model.EmployeeWhichIsNotIncludeList.CurrentPage.HasValue)
{
model.EmployeeWhichIsNotIncludeList.CurrentPage = 1;
}
if (!model.EmployeeWhichIsNotIncludeList.PageSize.HasValue)
{
model.EmployeeWhichIsNotIncludeList.PageSize = 10;
}
ProfileEmployeeSearchFilter profileEmployeeSearchFilter = new ProfileEmployeeSearchFilter();
profileEmployeeSearchFilter.Filter_ProfileId = model.ProfileId.Value;
profileEmployeeSearchFilter.CurrentPage = model.EmployeeList.CurrentPage.HasValue ? model.EmployeeList.CurrentPage.Value : 1;
profileEmployeeSearchFilter.PageSize = model.EmployeeList.PageSize.HasValue ? model.EmployeeList.PageSize.Value : 10;
profileEmployeeSearchFilter.SortOn = model.EmployeeList.SortOn;
profileEmployeeSearchFilter.SortDirection = model.EmployeeList.SortDirection;
profileEmployeeSearchFilter.Filter_Employee_Name = model.EmployeeList.Filter.Filter_Employee_Name;
profileEmployeeSearchFilter.Filter_Employee_LastName = model.EmployeeList.Filter.Filter_Employee_LastName;
ProfileEmployeeSearchFilter profileEmployeeWhichIsNotIncludeListSearchFilter = new ProfileEmployeeSearchFilter();
profileEmployeeWhichIsNotIncludeListSearchFilter.Filter_ProfileId = model.ProfileId.Value;
profileEmployeeWhichIsNotIncludeListSearchFilter.CurrentPage = model.EmployeeWhichIsNotIncludeList.CurrentPage.HasValue ? model.EmployeeWhichIsNotIncludeList.CurrentPage.Value : 1;
profileEmployeeWhichIsNotIncludeListSearchFilter.PageSize = model.EmployeeWhichIsNotIncludeList.PageSize.HasValue ? model.EmployeeWhichIsNotIncludeList.PageSize.Value : 10;
profileEmployeeWhichIsNotIncludeListSearchFilter.SortOn = model.EmployeeWhichIsNotIncludeList.SortOn;
profileEmployeeWhichIsNotIncludeListSearchFilter.SortDirection = model.EmployeeWhichIsNotIncludeList.SortDirection;
profileEmployeeWhichIsNotIncludeListSearchFilter.Filter_Employee_Name = model.EmployeeWhichIsNotIncludeList.Filter.Filter_Employee_Name;
profileEmployeeWhichIsNotIncludeListSearchFilter.Filter_Employee_LastName = model.EmployeeWhichIsNotIncludeList.Filter.Filter_Employee_LastName;
model.EmployeeList.DataList = GetAllEmployeeByProfileId(SessionHelper.CurrentUser.UserToken, SessionHelper.CurrentLanguageTwoChar, profileEmployeeSearchFilter);
model.EmployeeWhichIsNotIncludeList.DataList = GetAllEmployeeByProfileIdWhichIsNotIncluded(SessionHelper.CurrentUser.UserToken, SessionHelper.CurrentLanguageTwoChar, profileEmployeeWhichIsNotIncludeListSearchFilter);
}
else
{
model.EmployeeList = new DefinedEmployeeListViewModel();
model.EmployeeList.Filter = new DefinedEmployeeListFilterViewModel();
model.EmployeeList.DataList = new Business.Models.PaginatedList <EmployeeCheckViewModel>(new List <EmployeeCheckViewModel>(), 0, 1, 10, "", "");
model.EmployeeList.CurrentPage = 1;
model.EmployeeList.PageSize = 10;
model.EmployeeWhichIsNotIncludeList = new UndefinedEmployeeListViewModel();
model.EmployeeWhichIsNotIncludeList.Filter = new UndefinedEmployeeListFilterViewModel();
model.EmployeeWhichIsNotIncludeList.DataList = new Business.Models.PaginatedList <EmployeeCheckViewModel>(new List <EmployeeCheckViewModel>(), 0, 1, 10, "", "");
model.EmployeeWhichIsNotIncludeList.CurrentPage = 1;
model.EmployeeWhichIsNotIncludeList.PageSize = 10;
}
return(View(model));
}
if (model.SubmitType == "Add")
{
if (model.EmployeeWhichIsNotIncludeList.DataList != null && model.ProfileId.HasValue)
{
ModelState.Clear();
List <EmployeeCheckViewModel> records = model.EmployeeWhichIsNotIncludeList.DataList.Items.Where(x => x.Checked == true).ToList();
if (records != null)
{
foreach (var item in records)
{
ProfileEmployee profileEmployee = new ProfileEmployee();
profileEmployee.EmployeeId = item.ID;
profileEmployee.ProfileId = model.ProfileId.Value;
_profileEmployeeService.Add(SessionHelper.CurrentUser.UserToken, SessionHelper.CurrentLanguageTwoChar, profileEmployee);
}
}
}
}
if (model.SubmitType == "Delete")
{
if (model.EmployeeList.DataList != null && model.ProfileId.HasValue)
{
ModelState.Clear();
List <EmployeeCheckViewModel> record = model.EmployeeList.DataList.Items.Where(x => x.Checked == true).ToList();
if (record != null)
{
foreach (var item in record)
{
var apiResponseModel = _profileEmployeeService.DeleteByProfileIdAndEmployeeId(SessionHelper.CurrentUser.UserToken, SessionHelper.CurrentLanguageTwoChar, model.ProfileId.Value, item.ID);
}
}
}
}
model.ProfileSelectList = GetProfileSelectList(SessionHelper.CurrentUser.UserToken, SessionHelper.CurrentLanguageTwoChar);
if (model.ProfileId.HasValue)
{
if (model.EmployeeList.Filter == null)
{
model.EmployeeList.Filter = new DefinedEmployeeListFilterViewModel();
}
if (model.EmployeeWhichIsNotIncludeList.Filter == null)
{
model.EmployeeWhichIsNotIncludeList.Filter = new UndefinedEmployeeListFilterViewModel();
}
if (!model.EmployeeList.CurrentPage.HasValue)
{
model.EmployeeList.CurrentPage = 1;
}
if (!model.EmployeeList.PageSize.HasValue)
{
model.EmployeeList.PageSize = 10;
}
if (!model.EmployeeWhichIsNotIncludeList.CurrentPage.HasValue)
{
model.EmployeeWhichIsNotIncludeList.CurrentPage = 1;
}
if (!model.EmployeeWhichIsNotIncludeList.PageSize.HasValue)
{
model.EmployeeWhichIsNotIncludeList.PageSize = 10;
}
ProfileEmployeeSearchFilter profileEmployeeSearchFilter = new ProfileEmployeeSearchFilter();
profileEmployeeSearchFilter.Filter_ProfileId = model.ProfileId.Value;
profileEmployeeSearchFilter.CurrentPage = model.EmployeeList.CurrentPage.HasValue ? model.EmployeeList.CurrentPage.Value : 1;
profileEmployeeSearchFilter.PageSize = model.EmployeeList.PageSize.HasValue ? model.EmployeeList.PageSize.Value : 10;
profileEmployeeSearchFilter.SortOn = model.EmployeeList.SortOn;
profileEmployeeSearchFilter.SortDirection = model.EmployeeList.SortDirection;
profileEmployeeSearchFilter.Filter_Employee_Name = model.EmployeeList.Filter.Filter_Employee_Name;
profileEmployeeSearchFilter.Filter_Employee_LastName = model.EmployeeList.Filter.Filter_Employee_LastName;
ProfileEmployeeSearchFilter profileEmployeeWhichIsNotIncludeListSearchFilter = new ProfileEmployeeSearchFilter();
profileEmployeeWhichIsNotIncludeListSearchFilter.Filter_ProfileId = model.ProfileId.Value;
profileEmployeeWhichIsNotIncludeListSearchFilter.CurrentPage = model.EmployeeWhichIsNotIncludeList.CurrentPage.HasValue ? model.EmployeeWhichIsNotIncludeList.CurrentPage.Value : 1;
profileEmployeeWhichIsNotIncludeListSearchFilter.PageSize = model.EmployeeWhichIsNotIncludeList.PageSize.HasValue ? model.EmployeeWhichIsNotIncludeList.PageSize.Value : 10;
profileEmployeeWhichIsNotIncludeListSearchFilter.SortOn = model.EmployeeWhichIsNotIncludeList.SortOn;
profileEmployeeWhichIsNotIncludeListSearchFilter.SortDirection = model.EmployeeWhichIsNotIncludeList.SortDirection;
profileEmployeeWhichIsNotIncludeListSearchFilter.Filter_Employee_Name = model.EmployeeWhichIsNotIncludeList.Filter.Filter_Employee_Name;
profileEmployeeWhichIsNotIncludeListSearchFilter.Filter_Employee_LastName = model.EmployeeWhichIsNotIncludeList.Filter.Filter_Employee_LastName;
model.EmployeeList.DataList = GetAllEmployeeByProfileId(SessionHelper.CurrentUser.UserToken, SessionHelper.CurrentLanguageTwoChar, profileEmployeeSearchFilter);
model.EmployeeWhichIsNotIncludeList.DataList = GetAllEmployeeByProfileIdWhichIsNotIncluded(SessionHelper.CurrentUser.UserToken, SessionHelper.CurrentLanguageTwoChar, profileEmployeeWhichIsNotIncludeListSearchFilter);
}
else
{
model.EmployeeList = new DefinedEmployeeListViewModel();
model.EmployeeList.Filter = new DefinedEmployeeListFilterViewModel();
model.EmployeeList.DataList = new Business.Models.PaginatedList <EmployeeCheckViewModel>(new List <EmployeeCheckViewModel>(), 0, 1, 10, "", "");
model.EmployeeList.CurrentPage = 1;
model.EmployeeList.PageSize = 10;
model.EmployeeWhichIsNotIncludeList = new UndefinedEmployeeListViewModel();
model.EmployeeWhichIsNotIncludeList.Filter = new UndefinedEmployeeListFilterViewModel();
model.EmployeeWhichIsNotIncludeList.DataList = new Business.Models.PaginatedList <EmployeeCheckViewModel>(new List <EmployeeCheckViewModel>(), 0, 1, 10, "", "");
model.EmployeeWhichIsNotIncludeList.CurrentPage = 1;
model.EmployeeWhichIsNotIncludeList.PageSize = 10;
}
return(View(model));
}
public ApiResponseModel <ProfileEmployee> Add(string userToken, string displayLanguage, ProfileEmployee profileEmployee)
{
ApiResponseModel <ProfileEmployee> result = new ApiResponseModel <ProfileEmployee>();
// api'yi çağırma yapılır, gelen sonuç elde edilir
using (HttpClient httpClient = new HttpClient())
{
httpClient.BaseAddress = new Uri(ConfigHelper.ApiUrl);
httpClient.DefaultRequestHeaders.Accept.Clear();
httpClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
httpClient.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", userToken);
httpClient.DefaultRequestHeaders.Add("DisplayLanguage", displayLanguage);
var portalApiRequestModel = new AddRequestModel();
portalApiRequestModel.EmployeeId = profileEmployee.EmployeeId;
portalApiRequestModel.ProfileId = profileEmployee.ProfileId;
HttpResponseMessage response = httpClient.PostAsJsonAsync(string.Format("v1/ProfileEmployee"), portalApiRequestModel).Result;
result = response.Content.ReadAsJsonAsync <ApiResponseModel <ProfileEmployee> >().Result;
}
return(result);
}
