internal async void OnCurrentAsycudaSalesAllocationsExIDChanged(object sender, NotificationEventArgs <string> e) { using (AsycudaSalesAllocationsExRepository ctx = new AsycudaSalesAllocationsExRepository()) { CurrentAsycudaSalesAllocationsEx = await ctx.GetAsycudaSalesAllocationsEx(e.Data).ConfigureAwait(continueOnCapturedContext: false); } NotifyPropertyChanged(m => CurrentAsycudaSalesAllocationsEx); }
public static async Task <IEnumerable <SaleReportLine> > GetDocumentSalesReport(int ASYCUDA_Id) { try { using (var ctx = new AsycudaSalesAllocationsExRepository()) { var alst = (await ctx.GetAsycudaSalesAllocationsExsByExpression(string.Format("xASYCUDA_Id == {0} " + "&& EntryDataDetailsId != null " + "&& PreviousItem_Id != null" + "&& pRegistrationDate != null", ASYCUDA_Id)) .ConfigureAwait(false)).ToList(); if (alst.Count <= 0) { return(null); } var d = alst.Where(x => x.xLineNumber != null) .OrderBy(s => s.xLineNumber) .ThenBy(s => s.InvoiceNo) .Select(s => new SaleReportLine { Line = Convert.ToInt32(s.xLineNumber), Date = Convert.ToDateTime(s.InvoiceDate), InvoiceNo = s.InvoiceNo, CustomerName = s.CustomerName, ItemNumber = s.ItemNumber, ItemDescription = s.ItemDescription, TariffCode = s.TariffCode, SalesFactor = Convert.ToDouble(s.SalesFactor), SalesQuantity = Convert.ToDouble(s.QtyAllocated), xQuantity = Convert.ToDouble(s.xQuantity),// Convert.ToDouble(s.QtyAllocated), Price = Convert.ToDouble(s.Cost), SalesType = s.DutyFreePaid, GrossSales = Convert.ToDouble(s.TotalValue), PreviousCNumber = s.pCNumber, PreviousLineNumber = s.pLineNumber.ToString(), PreviousRegDate = Convert.ToDateTime(s.pRegistrationDate).ToShortDateString(), CIFValue = (Convert.ToDouble(s.Total_CIF_itm) / Convert.ToDouble(s.pQuantity)) * Convert.ToDouble(s.QtyAllocated), DutyLiablity = (Convert.ToDouble(s.DutyLiability) / Convert.ToDouble(s.pQuantity)) * Convert.ToDouble(s.QtyAllocated) }).Distinct(); return(new ObservableCollection <SaleReportLine>(d)); } } catch (Exception Ex) { } return(null); }
private async void OnAsycudaSalesAllocationsExsFilterExpressionChangetals(object sender, SimpleMvvmToolkit.NotificationEventArgs <string> e) { using (var ctx = new AsycudaSalesAllocationsExRepository()) { TotalTotalValue = await ctx.SumNav(e.Data, vloader.NavigationExpression, "TotalValue").ConfigureAwait(false); TotalAllocatedValue = await ctx.SumNav(e.Data, vloader.NavigationExpression, "AllocatedValue").ConfigureAwait(false); } }
public async Task SelectAll() { IEnumerable <AsycudaSalesAllocationsEx> lst = null; using (var ctx = new AsycudaSalesAllocationsExRepository()) { lst = await ctx.GetAsycudaSalesAllocationsExsByExpressionNav(vloader.FilterExpression, vloader.NavigationExpression).ConfigureAwait(continueOnCapturedContext: false); } SelectedAsycudaSalesAllocationsExs = new ObservableCollection <AsycudaSalesAllocationsEx>(lst); }
public IList <AsycudaSalesAllocationsEx> LoadRange(int startIndex, int count, SortDescriptionCollection sortDescriptions, out int overallCount) { try { if (FilterExpression == null) { FilterExpression = "All"; } using (var ctx = new AsycudaSalesAllocationsExRepository()) { var r = ctx.LoadRange(startIndex, count, FilterExpression, navExp, IncludesLst); overallCount = r.Result.Item2; return(r.Result.Item1.ToList()); } } catch (Exception ex) { StatusModel.Message(ex.Message); overallCount = 0; return(new List <AsycudaSalesAllocationsEx>()); } }
// Send to Excel Implementation public async Task Send2Excel() { IEnumerable <AsycudaSalesAllocationsEx> lst = null; using (var ctx = new AsycudaSalesAllocationsExRepository()) { lst = await ctx.GetAsycudaSalesAllocationsExsByExpressionNav(vloader.FilterExpression, vloader.NavigationExpression).ConfigureAwait(continueOnCapturedContext: false); } if (lst == null || !lst.Any()) { MessageBox.Show("No Data to Send to Excel"); return; } var s = new ExportToExcel <AsycudaSalesAllocationsExExcelLine, List <AsycudaSalesAllocationsExExcelLine> > { dataToPrint = lst.Select(x => new AsycudaSalesAllocationsExExcelLine { InvoiceDate = x.InvoiceDate, InvoiceNo = x.InvoiceNo, SANumber = Convert.ToInt32(x.SANumber), ItemNumber = x.ItemNumber, ItemDescription = x.ItemDescription, DutyFreePaid = x.DutyFreePaid, TaxAmount = x.TaxAmount, Status = x.Status, SalesQuantity = x.SalesQuantity, SalesCost = x.Cost, SalesQtyAllocated = x.SalesQtyAllocated, TotalSalesValue = x.TotalValue, QtyAllocated = x.QtyAllocated, AllocatedValue = x.AllocatedValue, pReferenceNumber = x.pReferenceNumber, pCNumber = x.pCNumber, pLineNumber = x.pLineNumber, pRegistrationDate = x.pRegistrationDate, pExpiryDate = x.pExpiryDate, pIsAssessed = x.pIsAssessed, pQuantity = x.pQuantity, pQtyAllocated = x.pQtyAllocated, PiQuantity = x.PiQuantity, Total_CIF_itm = x.Total_CIF_itm, DutyLiability = x.DutyLiability, xReferenceNumber = x.xReferenceNumber, xCNumber = x.xCNumber, xLineNumber = x.xLineNumber, xRegistrationDate = x.xRegistrationDate, DoNotAllocateSales = x.DoNotAllocateSales, DoNotAllocatePreviousEntry = x.DoNotAllocatePreviousEntry, TariffCode = x.TariffCode, Invalid = x.Invalid, }).ToList() }; using (var sta = new StaTaskScheduler(numberOfThreads: 1)) { await Task.Factory.StartNew(s.GenerateReport, CancellationToken.None, TaskCreationOptions.None, sta).ConfigureAwait(false); } }