public async Task <MasterPageViewModel> TotalGetAllPaging(GetWorkPagingRequest request) { var sessions = Core.Token; _client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", sessions); var response = await _client.GetAsync($"/api/works/TotalGetAllPaging?pageIndex=" + $"{request.PageIndex}&pageSize={request.PageSize}&WK_INT_NO={request.WK_INT_NO}" + $"&TTL_ENG={request.TTL_ENG}&ISWC_NO={request.ISWC_NO}" + $"&ISRC={request.ISRC}&WRITER={request.WRITER}" + $"&ARTIST={request.ARTIST}&SOC_NAME={request.SOC_NAME}&SearchType={request.SearchType}&IsGetMonopolyInfo={request.IsGetMonopolyInfo}&SOCIETY={request.SOCIETY}" ); var body = await response.Content.ReadAsStringAsync(); var dataReturn = JsonConvert.DeserializeObject <MasterPageViewModel>(body); if (dataReturn != null) { return(dataReturn); } else { MasterPageViewModel data = new MasterPageViewModel { TotalRecordes = 0 }; return(data); } }
public async Task <ApiResult <PagedResult <WorkViewModel> > > GetAllPaging(GetWorkPagingRequest request) { var sessions = Core.Token; _client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", sessions); var response = await _client.GetAsync($"/api/works/GetAllPaging?pageIndex=" + $"{request.PageIndex}&pageSize={request.PageSize}&WK_INT_NO={request.WK_INT_NO}" + $"&TTL_ENG={request.TTL_ENG}&ISWC_NO={request.ISWC_NO}" + $"&ISRC={request.ISRC}&WRITER={request.WRITER}" + $"&ARTIST={request.ARTIST}&SOC_NAME={request.SOC_NAME}&SearchType={request.SearchType}&IsGetMonopolyInfo={request.IsGetMonopolyInfo}&SOCIETY={request.SOCIETY}" ); var body = await response.Content.ReadAsStringAsync(); var dataReturn = JsonConvert.DeserializeObject <PagedResult <WorkViewModel> >(body); if (dataReturn != null) { ApiSuccessResult <PagedResult <WorkViewModel> > data = new ApiSuccessResult <PagedResult <WorkViewModel> > { IsSuccessed = true, Message = "search work is successful", ResultObj = dataReturn }; return(data); } else { ApiSuccessResult <PagedResult <WorkViewModel> > data = new ApiSuccessResult <PagedResult <WorkViewModel> > { IsSuccessed = false, Message = "search work is failure", ResultObj = null }; return(data); } }
public async Task <MasterPageViewModel> TotalGetAllPaging(GetWorkPagingRequest request) { var data = await _apiClient.TotalGetAllPaging(request); return(data); }
private async void ExportToExcel(string filePath) { try { #region Load data List <WorkViewModel> md = new List <WorkViewModel>(); //totalPage = 1; //int PageIndex = 0; GetWorkPagingRequest re = new GetWorkPagingRequest(); re.SOCIETY = "VCPMC"; re.PageSize = Core.LimitRequestWork; re.PageIndex = 1; var ms = await controller.TotalGetAllPaging(re); if (ms.TotalRecordes == 0) { statusMain.Invoke(new MethodInvoker(delegate { lbOperation.Text = "data empty, not data VCPMC for export"; })); return; } else { //if (ms.TotalRecordes % request.PageSize == 0) //{ // totalPage = ms.TotalRecordes / re.PageSize; //} //else //{ // totalPage = ms.TotalRecordes / re.PageSize + 1; //} } statusMain.Invoke(new MethodInvoker(delegate { progressBarImport.Value = 0; lbPercent.Text = "0%"; })); statusMain.Invoke(new MethodInvoker(delegate { lbOperation.Text = "Wating load data from server..."; })); int serial = 0; //for (int i = 0; i < totalPage; i++) //{ // serial++; // re.PageIndex = serial; // var data = await controller.GetAllPaging(re); // if (data == null || data.ResultObj == null || data.ResultObj.Items == null || data.ResultObj.Items.Count == 0 || filepath == string.Empty) // { // statusMain.Invoke(new MethodInvoker(delegate // { // lbOperation.Text = "Load data from server is error"; // })); // return; // } // else // { // foreach (var item in data.ResultObj.Items) // { // md.Add(item); // } // } // statusMain.Invoke(new MethodInvoker(delegate // { // if (serial > totalPage) serial = totalPage; // float values = (float)(i + 1) / (float)totalPage * 100; // progressBarImport.Value = (int)values; // lbPercent.Text = $"{((int)values).ToString()}%"; // })); //} if (md.Count == 0) { statusMain.Invoke(new MethodInvoker(delegate { lbOperation.Text = "data empty, not data VCPMC for export"; })); return; } #endregion #region export //var dataExport = data.ResultObj.Items.Where() statusMain.Invoke(new MethodInvoker(delegate { progressBarImport.Value = 0; lbPercent.Text = "0%"; })); statusMain.Invoke(new MethodInvoker(delegate { lbOperation.Text = "Export to excel..."; })); int pos = filePath.LastIndexOf('.'); string x1 = filePath.Substring(0, pos); string x2 = filePath.Substring(pos + 1, filePath.Length - pos - 1); string[] file = new string[] { x1, x2 }; string path = string.Empty; string name = string.Empty; string extension = string.Empty; if (file != null && file.Length > 1) { extension = file[1]; int a = file[0].LastIndexOf("\\"); if (a > 2) { path = file[0].Substring(0, a); name = file[0].Substring(a + 1, file[0].Length - a - 1); } } if (path.Length > 0 && name.Length > 0 && extension.Length > 0) { int totalFile = 0; if (md.Count % Core.LimitDisplayExportExcel == 0) { totalFile = md.Count / Core.LimitDisplayExportExcel; } else { totalFile = md.Count / Core.LimitDisplayExportExcel + 1; } serial = 0; int index = 0; while (index < md.Count) { serial++; var datax = md.Skip(index).Take(Core.LimitDisplayExportExcel).ToList(); index += Core.LimitDisplayExportExcel; bool check = WriteReportHelper.ExportWork(datax, $"{path}\\{name}-{serial.ToString().PadLeft(3, '0')}.{extension}"); datax = null; GC.Collect(); statusMain.Invoke(new MethodInvoker(delegate { if (serial > totalFile) { serial = totalFile; } float values = (float)serial / (float)totalFile * 100; progressBarImport.Value = (int)values; lbPercent.Text = $"{((int)values).ToString()}%"; })); } } statusMain.Invoke(new MethodInvoker(delegate { lbOperation.Text = "Export to excel be finish"; })); toolMain.Invoke(new MethodInvoker(delegate { btnExport.Enabled = true; })); statusMain.Invoke(new MethodInvoker(delegate { progressBarImport.Value = 100; })); #endregion } catch (Exception) { statusMain.Invoke(new MethodInvoker(delegate { lbOperation.Text = "Export data from server is error"; })); } }
public async Task <ApiResult <PagedResult <WorkViewModel> > > GetAllPaging(GetWorkPagingRequest request) { var data = await _apiClient.GetAllPaging(request); return(data); }