public static List <TransactionReportModel> GetAllReport() { tokobediaModelContainer dbs = new tokobediaModelContainer(); List <TransactionReportModel> allData = new List <TransactionReportModel>(); var result = (from x in dbs.HeaderTransactions join y in dbs.DetailTransactions on x.ID equals y.TransactionID join z in dbs.PaymentTypes on x.PaymentTypeID equals z.ID join w in dbs.Products on y.ProductID equals w.ID join v in dbs.Users on x.UserID equals v.Id select new { TransID = x.ID, UserName = v.Name, Date = x.Date, ProductName = w.Name, Quantity = y.Quantity, ProductPrice = w.Price }).ToList(); foreach (var xdata in result) { allData.Add(TransactionReportFactory.createTransRepObject(xdata)); } return(allData); }
static void Main(string[] args) { var avaleraProcessor = new AvaleraProcessor(@"C:/TaxReconcile/ReconcileDocumentLineDetail.csv"); var avaleraLines = avaleraProcessor.GetAvaleraLines(); var gillProcessor = new GillProcessor(@"C:/TaxReconcile/GIL.csv"); var gillLines = gillProcessor.GetGillLines(); var gillIds = gillLines.Select(x => x.Id).ToList(); var avIds = avaleraLines.Select(x => x.LineValue).ToList(); var matchingResults = avIds.Intersect(gillIds); Console.WriteLine("There should be " + matchingResults.Count().ToString() + " transactions."); var transactions = new List <TransactionsToVoid>(); foreach (var avaleraLine in avaleraLines) { if (matchingResults.Contains(avaleraLine.LineValue)) { transactions.Add(new TransactionsToVoid(avaleraLine)); } } TransactionReportFactory.Run(",", transactions.ToArray()); Console.WriteLine("There are " + transactions.Count.ToString() + " transactions. Your file can be found at C:/TaxReconcile/Results.csv."); Console.WriteLine("Enter q to quit or any key to open the result file now."); var response = Console.ReadLine(); if (string.IsNullOrEmpty(response) || !response.ToLower()[0].Equals('q')) { Process.Start(@"C:/TaxReconcileTestFolderCreation/Results.csv"); } }