private ScheduleMasterFilter ConvertFilterDTOToFilterEntity(ScheduleMaster_ScheduleMasterFilterDTO ScheduleMaster_ScheduleMasterFilterDTO) { ScheduleMasterFilter ScheduleMasterFilter = new ScheduleMasterFilter(); ScheduleMasterFilter.Selects = ScheduleMasterSelect.ALL; ScheduleMasterFilter.Skip = ScheduleMaster_ScheduleMasterFilterDTO.Skip; ScheduleMasterFilter.Take = ScheduleMaster_ScheduleMasterFilterDTO.Take; ScheduleMasterFilter.OrderBy = ScheduleMaster_ScheduleMasterFilterDTO.OrderBy; ScheduleMasterFilter.OrderType = ScheduleMaster_ScheduleMasterFilterDTO.OrderType; ScheduleMasterFilter.Id = ScheduleMaster_ScheduleMasterFilterDTO.Id; ScheduleMasterFilter.ManagerId = ScheduleMaster_ScheduleMasterFilterDTO.ManagerId; ScheduleMasterFilter.SalerId = ScheduleMaster_ScheduleMasterFilterDTO.SalerId; ScheduleMasterFilter.Name = ScheduleMaster_ScheduleMasterFilterDTO.Name; ScheduleMasterFilter.Code = ScheduleMaster_ScheduleMasterFilterDTO.Code; ScheduleMasterFilter.StatusId = ScheduleMaster_ScheduleMasterFilterDTO.StatusId; ScheduleMasterFilter.RecurDays = ScheduleMaster_ScheduleMasterFilterDTO.RecurDays; ScheduleMasterFilter.StartDate = ScheduleMaster_ScheduleMasterFilterDTO.StartDate; ScheduleMasterFilter.EndDate = ScheduleMaster_ScheduleMasterFilterDTO.EndDate; ScheduleMasterFilter.StartDayOfWeek = ScheduleMaster_ScheduleMasterFilterDTO.StartDayOfWeek; ScheduleMasterFilter.DisplayOrder = ScheduleMaster_ScheduleMasterFilterDTO.DisplayOrder; ScheduleMasterFilter.Description = ScheduleMaster_ScheduleMasterFilterDTO.Description; ScheduleMasterFilter.CreatedAt = ScheduleMaster_ScheduleMasterFilterDTO.CreatedAt; ScheduleMasterFilter.UpdatedAt = ScheduleMaster_ScheduleMasterFilterDTO.UpdatedAt; return(ScheduleMasterFilter); }
public async Task <ActionResult <int> > Count([FromBody] ScheduleMaster_ScheduleMasterFilterDTO ScheduleMaster_ScheduleMasterFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } ScheduleMasterFilter ScheduleMasterFilter = ConvertFilterDTOToFilterEntity(ScheduleMaster_ScheduleMasterFilterDTO); ScheduleMasterFilter = ScheduleMasterService.ToFilter(ScheduleMasterFilter); int count = await ScheduleMasterService.Count(ScheduleMasterFilter); return(count); }
public async Task <ActionResult <List <ScheduleMaster_ScheduleMasterDTO> > > List([FromBody] ScheduleMaster_ScheduleMasterFilterDTO ScheduleMaster_ScheduleMasterFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } ScheduleMasterFilter ScheduleMasterFilter = ConvertFilterDTOToFilterEntity(ScheduleMaster_ScheduleMasterFilterDTO); ScheduleMasterFilter = ScheduleMasterService.ToFilter(ScheduleMasterFilter); List <ScheduleMaster> ScheduleMasters = await ScheduleMasterService.List(ScheduleMasterFilter); List <ScheduleMaster_ScheduleMasterDTO> ScheduleMaster_ScheduleMasterDTOs = ScheduleMasters .Select(c => new ScheduleMaster_ScheduleMasterDTO(c)).ToList(); return(ScheduleMaster_ScheduleMasterDTOs); }
public async Task <FileResult> ExportTemplate([FromBody] ScheduleMaster_ScheduleMasterFilterDTO ScheduleMaster_ScheduleMasterFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } MemoryStream memoryStream = new MemoryStream(); using (ExcelPackage excel = new ExcelPackage(memoryStream)) { #region ScheduleMaster var ScheduleMasterHeaders = new List <string[]>() { new string[] { "Id", "ManagerId", "SalerId", "Name", "Code", "StatusId", "RecurDays", "StartDate", "EndDate", "NoEndDate", "StartDayOfWeek", "DisplayOrder", "Description", } }; List <object[]> ScheduleMasterData = new List <object[]>(); excel.GenerateWorksheet("ScheduleMaster", ScheduleMasterHeaders, ScheduleMasterData); #endregion #region AppUser var AppUserFilter = new AppUserFilter(); AppUserFilter.Selects = AppUserSelect.ALL; AppUserFilter.OrderBy = AppUserOrder.Id; AppUserFilter.OrderType = OrderType.ASC; AppUserFilter.Skip = 0; AppUserFilter.Take = int.MaxValue; List <AppUser> AppUsers = await AppUserService.List(AppUserFilter); var AppUserHeaders = new List <string[]>() { new string[] { "Id", "Username", "DisplayName", "Address", "Email", "Phone", "PositionId", "Department", "OrganizationId", "StatusId", "Avatar", "ProvinceId", "SexId", "Birthday", } }; List <object[]> AppUserData = new List <object[]>(); for (int i = 0; i < AppUsers.Count; i++) { var AppUser = AppUsers[i]; AppUserData.Add(new Object[] { AppUser.Id, AppUser.Username, AppUser.DisplayName, AppUser.Address, AppUser.Email, AppUser.Phone, AppUser.PositionId, AppUser.Department, AppUser.OrganizationId, AppUser.StatusId, AppUser.Avatar, AppUser.ProvinceId, AppUser.SexId, AppUser.Birthday, }); } excel.GenerateWorksheet("AppUser", AppUserHeaders, AppUserData); #endregion #region Status var StatusFilter = new StatusFilter(); StatusFilter.Selects = StatusSelect.ALL; StatusFilter.OrderBy = StatusOrder.Id; StatusFilter.OrderType = OrderType.ASC; StatusFilter.Skip = 0; StatusFilter.Take = int.MaxValue; List <Status> Statuses = await StatusService.List(StatusFilter); var StatusHeaders = new List <string[]>() { new string[] { "Id", "Code", "Name", } }; List <object[]> StatusData = new List <object[]>(); for (int i = 0; i < Statuses.Count; i++) { var Status = Statuses[i]; StatusData.Add(new Object[] { Status.Id, Status.Code, Status.Name, }); } excel.GenerateWorksheet("Status", StatusHeaders, StatusData); #endregion excel.Save(); } return(File(memoryStream.ToArray(), "application/octet-stream", "ScheduleMaster.xlsx")); }