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");
}
}