public async Task <ActionResult <int> > Count([FromBody] AppUser_AppUserFilterDTO AppUser_AppUserFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } AppUserFilter AppUserFilter = ConvertFilterDTOToFilterEntity(AppUser_AppUserFilterDTO); int count = await AppUserService.Count(AppUserFilter); return(count); }
public async Task <ActionResult <List <AppUser_AppUserDTO> > > List([FromBody] AppUser_AppUserFilterDTO AppUser_AppUserFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } AppUserFilter AppUserFilter = ConvertFilterDTOToFilterEntity(AppUser_AppUserFilterDTO); List <AppUser> AppUsers = await AppUserService.List(AppUserFilter); List <AppUser_AppUserDTO> AppUser_AppUserDTOs = AppUsers .Select(c => new AppUser_AppUserDTO(c)).ToList(); return(AppUser_AppUserDTOs); }
private AppUserFilter ConvertFilterDTOToFilterEntity(AppUser_AppUserFilterDTO AppUser_AppUserFilterDTO) { AppUserFilter AppUserFilter = new AppUserFilter(); AppUserFilter.Selects = AppUserSelect.ALL; AppUserFilter.Skip = AppUser_AppUserFilterDTO.Skip; AppUserFilter.Take = AppUser_AppUserFilterDTO.Take; AppUserFilter.OrderBy = AppUser_AppUserFilterDTO.OrderBy; AppUserFilter.OrderType = AppUser_AppUserFilterDTO.OrderType; AppUserFilter.Id = AppUser_AppUserFilterDTO.Id; AppUserFilter.Username = AppUser_AppUserFilterDTO.Username; AppUserFilter.Password = AppUser_AppUserFilterDTO.Password; AppUserFilter.DisplayName = AppUser_AppUserFilterDTO.DisplayName; AppUserFilter.Email = AppUser_AppUserFilterDTO.Email; AppUserFilter.Phone = AppUser_AppUserFilterDTO.Phone; AppUserFilter.CreatedAt = AppUser_AppUserFilterDTO.CreatedAt; AppUserFilter.UpdatedAt = AppUser_AppUserFilterDTO.UpdatedAt; return(AppUserFilter); }
public async Task <ActionResult> ExportTemplate([FromBody] AppUser_AppUserFilterDTO AppUser_AppUserFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } string path = "Templates/AppUser_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", "AppUser.xlsx")); }
public async Task <ActionResult> Export([FromBody] AppUser_AppUserFilterDTO AppUser_AppUserFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } MemoryStream memoryStream = new MemoryStream(); using (ExcelPackage excel = new ExcelPackage(memoryStream)) { #region AppUser var AppUserFilter = ConvertFilterDTOToFilterEntity(AppUser_AppUserFilterDTO); 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", } }; 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 LocationLog var LocationLogFilter = new LocationLogFilter(); LocationLogFilter.Selects = LocationLogSelect.ALL; LocationLogFilter.OrderBy = LocationLogOrder.Id; LocationLogFilter.OrderType = OrderType.ASC; LocationLogFilter.Skip = 0; LocationLogFilter.Take = int.MaxValue; List <LocationLog> LocationLogs = await LocationLogService.List(LocationLogFilter); var LocationLogHeaders = new List <string[]>() { new string[] { "Id", "PreviousId", "AppUserId", "Latitude", "Longtitude", "UpdateInterval", } }; List <object[]> LocationLogData = new List <object[]>(); for (int i = 0; i < LocationLogs.Count; i++) { var LocationLog = LocationLogs[i]; LocationLogData.Add(new Object[] { LocationLog.Id, LocationLog.PreviousId, LocationLog.AppUserId, LocationLog.Latitude, LocationLog.Longtitude, LocationLog.UpdateInterval, }); } excel.GenerateWorksheet("LocationLog", LocationLogHeaders, LocationLogData); #endregion excel.Save(); } return(File(memoryStream.ToArray(), "application/octet-stream", "AppUser.xlsx")); }