public async Task <ActionResult <int> > Count([FromBody] TicketOfUser_TicketOfUserFilterDTO TicketOfUser_TicketOfUserFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } TicketOfUserFilter TicketOfUserFilter = ConvertFilterDTOToFilterEntity(TicketOfUser_TicketOfUserFilterDTO); TicketOfUserFilter = TicketOfUserService.ToFilter(TicketOfUserFilter); int count = await TicketOfUserService.Count(TicketOfUserFilter); return(count); }
private TicketOfUserFilter ConvertFilterDTOToFilterEntity(TicketOfUser_TicketOfUserFilterDTO TicketOfUser_TicketOfUserFilterDTO) { TicketOfUserFilter TicketOfUserFilter = new TicketOfUserFilter(); TicketOfUserFilter.Selects = TicketOfUserSelect.ALL; TicketOfUserFilter.Skip = TicketOfUser_TicketOfUserFilterDTO.Skip; TicketOfUserFilter.Take = TicketOfUser_TicketOfUserFilterDTO.Take; TicketOfUserFilter.OrderBy = TicketOfUser_TicketOfUserFilterDTO.OrderBy; TicketOfUserFilter.OrderType = TicketOfUser_TicketOfUserFilterDTO.OrderType; TicketOfUserFilter.Id = TicketOfUser_TicketOfUserFilterDTO.Id; TicketOfUserFilter.Notes = TicketOfUser_TicketOfUserFilterDTO.Notes; TicketOfUserFilter.UserId = TicketOfUser_TicketOfUserFilterDTO.UserId; TicketOfUserFilter.TicketId = TicketOfUser_TicketOfUserFilterDTO.TicketId; TicketOfUserFilter.TicketStatusId = TicketOfUser_TicketOfUserFilterDTO.TicketStatusId; TicketOfUserFilter.CreatedAt = TicketOfUser_TicketOfUserFilterDTO.CreatedAt; TicketOfUserFilter.UpdatedAt = TicketOfUser_TicketOfUserFilterDTO.UpdatedAt; return(TicketOfUserFilter); }
public async Task <ActionResult <List <TicketOfUser_TicketOfUserDTO> > > List([FromBody] TicketOfUser_TicketOfUserFilterDTO TicketOfUser_TicketOfUserFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } TicketOfUserFilter TicketOfUserFilter = ConvertFilterDTOToFilterEntity(TicketOfUser_TicketOfUserFilterDTO); TicketOfUserFilter = TicketOfUserService.ToFilter(TicketOfUserFilter); List <TicketOfUser> TicketOfUsers = await TicketOfUserService.List(TicketOfUserFilter); List <TicketOfUser_TicketOfUserDTO> TicketOfUser_TicketOfUserDTOs = TicketOfUsers .Select(c => new TicketOfUser_TicketOfUserDTO(c)).ToList(); return(TicketOfUser_TicketOfUserDTOs); }
public async Task <FileResult> ExportTemplate([FromBody] TicketOfUser_TicketOfUserFilterDTO TicketOfUser_TicketOfUserFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } MemoryStream memoryStream = new MemoryStream(); using (ExcelPackage excel = new ExcelPackage(memoryStream)) { #region TicketOfUser var TicketOfUserHeaders = new List <string[]>() { new string[] { "Id", "Notes", "UserId", "TicketId", "TicketStatusId", } }; List <object[]> TicketOfUserData = new List <object[]>(); excel.GenerateWorksheet("TicketOfUser", TicketOfUserHeaders, TicketOfUserData); #endregion #region Ticket var TicketFilter = new TicketFilter(); TicketFilter.Selects = TicketSelect.ALL; TicketFilter.OrderBy = TicketOrder.Id; TicketFilter.OrderType = OrderType.ASC; TicketFilter.Skip = 0; TicketFilter.Take = int.MaxValue; List <Ticket> Tickets = await TicketService.List(TicketFilter); var TicketHeaders = new List <string[]>() { new string[] { "Id", "Name", "Phone", "CustomerId", "UserId", "ProductId", "ReceiveDate", "ProcessDate", "FinishDate", "Subject", "Content", "TicketIssueLevelId", "TicketPriorityId", "TicketStatusId", "TicketSourceId", "TicketNumber", "DepartmentId", "RelatedTicketId", "SLA", "RelatedCallLogId", "ResponseMethodId", "StatusId", "Used", } }; List <object[]> TicketData = new List <object[]>(); for (int i = 0; i < Tickets.Count; i++) { var Ticket = Tickets[i]; TicketData.Add(new Object[] { Ticket.Id, Ticket.Name, Ticket.Phone, Ticket.CustomerId, Ticket.UserId, Ticket.ProductId, Ticket.ReceiveDate, Ticket.ProcessDate, Ticket.FinishDate, Ticket.Subject, Ticket.Content, Ticket.TicketIssueLevelId, Ticket.TicketPriorityId, Ticket.TicketStatusId, Ticket.TicketSourceId, Ticket.TicketNumber, Ticket.DepartmentId, Ticket.RelatedTicketId, Ticket.SLA, Ticket.RelatedCallLogId, Ticket.ResponseMethodId, Ticket.StatusId, Ticket.Used, }); } excel.GenerateWorksheet("Ticket", TicketHeaders, TicketData); #endregion #region TicketStatus var TicketStatusFilter = new TicketStatusFilter(); TicketStatusFilter.Selects = TicketStatusSelect.ALL; TicketStatusFilter.OrderBy = TicketStatusOrder.Id; TicketStatusFilter.OrderType = OrderType.ASC; TicketStatusFilter.Skip = 0; TicketStatusFilter.Take = int.MaxValue; List <TicketStatus> TicketStatuses = await TicketStatusService.List(TicketStatusFilter); var TicketStatusHeaders = new List <string[]>() { new string[] { "Id", "Name", "OrderNumber", "ColorCode", "StatusId", "Used", } }; List <object[]> TicketStatusData = new List <object[]>(); for (int i = 0; i < TicketStatuses.Count; i++) { var TicketStatus = TicketStatuses[i]; TicketStatusData.Add(new Object[] { TicketStatus.Id, TicketStatus.Name, TicketStatus.OrderNumber, TicketStatus.ColorCode, TicketStatus.StatusId, TicketStatus.Used, }); } excel.GenerateWorksheet("TicketStatus", TicketStatusHeaders, TicketStatusData); #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", "SexId", "Birthday", "Avatar", "PositionId", "Department", "OrganizationId", "ProvinceId", "Longitude", "Latitude", "StatusId", } }; 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.SexId, AppUser.Birthday, AppUser.Avatar, AppUser.PositionId, AppUser.Department, AppUser.OrganizationId, AppUser.ProvinceId, AppUser.Longitude, AppUser.Latitude, AppUser.StatusId, }); } excel.GenerateWorksheet("AppUser", AppUserHeaders, AppUserData); #endregion excel.Save(); } return(File(memoryStream.ToArray(), "application/octet-stream", "TicketOfUser.xlsx")); }