public async Task <ActionResult <int> > Count([FromBody] PlaceChecking_PlaceCheckingFilterDTO PlaceChecking_PlaceCheckingFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } PlaceCheckingFilter PlaceCheckingFilter = ConvertFilterDTOToFilterEntity(PlaceChecking_PlaceCheckingFilterDTO); PlaceCheckingFilter = await PlaceCheckingService.ToFilter(PlaceCheckingFilter); int count = await PlaceCheckingService.Count(PlaceCheckingFilter); return(count); }
private PlaceCheckingFilter ConvertFilterDTOToFilterEntity(PlaceChecking_PlaceCheckingFilterDTO PlaceChecking_PlaceCheckingFilterDTO) { PlaceCheckingFilter PlaceCheckingFilter = new PlaceCheckingFilter(); PlaceCheckingFilter.Selects = PlaceCheckingSelect.ALL; PlaceCheckingFilter.Skip = PlaceChecking_PlaceCheckingFilterDTO.Skip; PlaceCheckingFilter.Take = PlaceChecking_PlaceCheckingFilterDTO.Take; PlaceCheckingFilter.OrderBy = PlaceChecking_PlaceCheckingFilterDTO.OrderBy; PlaceCheckingFilter.OrderType = PlaceChecking_PlaceCheckingFilterDTO.OrderType; PlaceCheckingFilter.Id = PlaceChecking_PlaceCheckingFilterDTO.Id; PlaceCheckingFilter.AppUserId = PlaceChecking_PlaceCheckingFilterDTO.AppUserId; PlaceCheckingFilter.PlaceId = PlaceChecking_PlaceCheckingFilterDTO.PlaceId; PlaceCheckingFilter.PlaceCheckingStatusId = PlaceChecking_PlaceCheckingFilterDTO.PlaceCheckingStatusId; PlaceCheckingFilter.CheckInAt = PlaceChecking_PlaceCheckingFilterDTO.CheckInAt; PlaceCheckingFilter.CheckOutAt = PlaceChecking_PlaceCheckingFilterDTO.CheckOutAt; return(PlaceCheckingFilter); }
public async Task <ActionResult> ExportTemplate([FromBody] PlaceChecking_PlaceCheckingFilterDTO PlaceChecking_PlaceCheckingFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } string path = "Templates/PlaceChecking_Template.xlsx"; byte[] arr = System.IO.File.ReadAllBytes(path); MemoryStream input = new MemoryStream(arr); MemoryStream output = new MemoryStream(); dynamic Data = new ExpandoObject(); using (var document = StaticParams.DocumentFactory.Open(input, output, "xlsx")) { document.Process(Data); }; return(File(output.ToArray(), "application/octet-stream", "PlaceChecking.xlsx")); }
public async Task <ActionResult <List <PlaceChecking_PlaceCheckingDTO> > > List([FromBody] PlaceChecking_PlaceCheckingFilterDTO PlaceChecking_PlaceCheckingFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } PlaceCheckingFilter PlaceCheckingFilter = ConvertFilterDTOToFilterEntity(PlaceChecking_PlaceCheckingFilterDTO); PlaceCheckingFilter = await PlaceCheckingService.ToFilter(PlaceCheckingFilter); List <PlaceChecking> PlaceCheckings = await PlaceCheckingService.List(PlaceCheckingFilter); List <PlaceChecking_PlaceCheckingDTO> PlaceChecking_PlaceCheckingDTOs = PlaceCheckings .Select(c => new PlaceChecking_PlaceCheckingDTO(c)).ToList(); return(PlaceChecking_PlaceCheckingDTOs); }
public async Task <ActionResult> Export([FromBody] PlaceChecking_PlaceCheckingFilterDTO PlaceChecking_PlaceCheckingFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } MemoryStream memoryStream = new MemoryStream(); using (ExcelPackage excel = new ExcelPackage(memoryStream)) { #region PlaceChecking var PlaceCheckingFilter = ConvertFilterDTOToFilterEntity(PlaceChecking_PlaceCheckingFilterDTO); PlaceCheckingFilter.Skip = 0; PlaceCheckingFilter.Take = int.MaxValue; PlaceCheckingFilter = await PlaceCheckingService.ToFilter(PlaceCheckingFilter); List <PlaceChecking> PlaceCheckings = await PlaceCheckingService.List(PlaceCheckingFilter); var PlaceCheckingHeaders = new List <string[]>() { new string[] { "Id", "AppUserId", "PlaceId", "PlaceCheckingStatusId", "CheckInAt", "CheckOutAt", } }; List <object[]> PlaceCheckingData = new List <object[]>(); for (int i = 0; i < PlaceCheckings.Count; i++) { var PlaceChecking = PlaceCheckings[i]; PlaceCheckingData.Add(new Object[] { PlaceChecking.Id, PlaceChecking.AppUserId, PlaceChecking.PlaceId, PlaceChecking.PlaceCheckingStatusId, PlaceChecking.CheckInAt, PlaceChecking.CheckOutAt, }); } excel.GenerateWorksheet("PlaceChecking", PlaceCheckingHeaders, PlaceCheckingData); #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", "Password", "DisplayName", "Email", "Phone", "Used", } }; 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.Password, AppUser.DisplayName, AppUser.Email, AppUser.Phone, }); } excel.GenerateWorksheet("AppUser", AppUserHeaders, AppUserData); #endregion #region Place var PlaceFilter = new PlaceFilter(); PlaceFilter.Selects = PlaceSelect.ALL; PlaceFilter.OrderBy = PlaceOrder.Id; PlaceFilter.OrderType = OrderType.ASC; PlaceFilter.Skip = 0; PlaceFilter.Take = int.MaxValue; List <Place> Places = await PlaceService.List(PlaceFilter); var PlaceHeaders = new List <string[]>() { new string[] { "Id", "Name", "PlaceGroupId", "Radius", "Latitude", "Longtitude", } }; List <object[]> PlaceData = new List <object[]>(); for (int i = 0; i < Places.Count; i++) { var Place = Places[i]; PlaceData.Add(new Object[] { Place.Id, Place.Name, Place.PlaceGroupId, Place.Radius, Place.Latitude, Place.Longtitude, }); } excel.GenerateWorksheet("Place", PlaceHeaders, PlaceData); #endregion #region CheckingStatus var CheckingStatusFilter = new CheckingStatusFilter(); CheckingStatusFilter.Selects = CheckingStatusSelect.ALL; CheckingStatusFilter.OrderBy = CheckingStatusOrder.Id; CheckingStatusFilter.OrderType = OrderType.ASC; CheckingStatusFilter.Skip = 0; CheckingStatusFilter.Take = int.MaxValue; List <CheckingStatus> CheckingStatuses = await CheckingStatusService.List(CheckingStatusFilter); var CheckingStatusHeaders = new List <string[]>() { new string[] { "Id", "Code", "Name", } }; List <object[]> CheckingStatusData = new List <object[]>(); for (int i = 0; i < CheckingStatuses.Count; i++) { var CheckingStatus = CheckingStatuses[i]; CheckingStatusData.Add(new Object[] { CheckingStatus.Id, CheckingStatus.Code, CheckingStatus.Name, }); } excel.GenerateWorksheet("CheckingStatus", CheckingStatusHeaders, CheckingStatusData); #endregion excel.Save(); } return(File(memoryStream.ToArray(), "application/octet-stream", "PlaceChecking.xlsx")); }