public List <OutLetBill> GetBills() { bills = new List <OutLetBill> (); var list11 = from p in allbills where p.IsUploaded == false group p by p.InvNo into g select new { key = g.Key, result = g.ToList(), count = g.Count() }; int counter = 0; List <OutLetBillTemp> list1 = new List <OutLetBillTemp> (); foreach (var grp in list11) { counter = counter + grp.count; list1.AddRange(grp.result); if (counter > 30) { break; } } // var list1 = allbills.Where (x => x.IsUploaded == false) // .GroupBy(x=>x.InvNo) // .Take (10) // .ToList (); foreach (OutLetBillTemp trx in list1) { OutLetBill bill = new OutLetBill(); bill.UserID = userid; bill.BranchCode = brn; bill.CompanyCode = comp; bill.Created = trx.Created; bill.CustCode = trx.CustCode; bill.ICode = trx.ICode; bill.InvDate = trx.InvDate; bill.InvNo = trx.InvNo; bill.IsInclusive = trx.IsUploaded; bill.Amount = trx.Amount; bill.NetAmount = trx.NetAmount; bill.TaxAmt = trx.TaxAmt; bill.TaxGrp = trx.TaxGrp; bill.UPrice = trx.UPrice; bill.Qty = trx.Qty; bill.TrxType = trx.TrxType; bills.Add(bill); } return(bills); }
public List <OutLetBill> GetBills() { string pathToDatabase = ((GlobalvarsApp)CallingActivity.Application).DATABASE_PATH; string comp = ((GlobalvarsApp)CallingActivity.Application).COMPANY_CODE; string brn = ((GlobalvarsApp)CallingActivity.Application).BRANCH_CODE; string userid = ((GlobalvarsApp)CallingActivity.Application).USERID_CODE; bills = new List <OutLetBill> (); using (var db = new SQLite.SQLiteConnection(pathToDatabase)) { var list1 = db.Table <SaleOrder> ().Where(x => x.isUploaded == false) .OrderBy(x => x.sono) .Take(10) .ToList <SaleOrder> (); var list2 = db.Table <SaleOrderDtls> ().ToList <SaleOrderDtls> (); foreach (SaleOrder so in list1) { var list3 = list2.Where(x => x.sono == so.sono).ToList <SaleOrderDtls> (); foreach (SaleOrderDtls invdtl in list3) { OutLetBill bill = new OutLetBill(); bill.UserID = userid; bill.BranchCode = brn; bill.CompanyCode = comp; bill.Created = so.created; bill.CustCode = so.custcode; bill.ICode = invdtl.icode; bill.InvDate = so.sodate; bill.InvNo = so.sono; bill.IsInclusive = invdtl.isincludesive; bill.Amount = invdtl.amount; bill.NetAmount = invdtl.netamount; bill.TaxAmt = invdtl.tax; bill.TaxGrp = invdtl.taxgrp; bill.UPrice = invdtl.price; bill.Qty = invdtl.qty; bill.TrxType = "SO"; bill.CNInvNo = so.custpono; bill.Remark = so.remark; bill.OtheDesc = so.billTo; bills.Add(bill); } } } return(bills); }
public List<OutLetBill> GetBills() { string pathToDatabase = ((GlobalvarsApp)CallingActivity.Application).DATABASE_PATH; string comp =((GlobalvarsApp)CallingActivity.Application).COMPANY_CODE; string brn =((GlobalvarsApp)CallingActivity.Application).BRANCH_CODE; string userid =((GlobalvarsApp)CallingActivity.Application).USERID_CODE; bills = new List<OutLetBill> (); using (var db = new SQLite.SQLiteConnection (pathToDatabase)) { var list1 = db.Table<DelOrder> ().Where(x=>x.isUploaded==false) .OrderBy(x=>x.dono) .Take(10) .ToList<DelOrder> (); var list2 = db.Table<DelOrderDtls> ().ToList<DelOrderDtls> (); foreach (DelOrder delOrder in list1) { var list3 = list2.Where (x => x.dono == delOrder.dono).ToList<DelOrderDtls> (); foreach (DelOrderDtls invdtl in list3) { OutLetBill bill = new OutLetBill (); bill.UserID = userid; bill.BranchCode = brn; bill.CompanyCode = comp; bill.Created = delOrder.created; bill.CustCode = delOrder.custcode; bill.ICode = invdtl.icode; bill.InvDate = delOrder.dodate; bill.InvNo = delOrder.dono; bill.IsInclusive = invdtl.isincludesive; bill.Amount = invdtl.amount; bill.NetAmount = invdtl.netamount; bill.TaxAmt = invdtl.tax; bill.TaxGrp = invdtl.taxgrp; bill.UPrice = invdtl.price; bill.Qty = invdtl.qty; bill.TrxType = "DO"; bill.Remark = delOrder.remark; bill.OtheDesc = delOrder.term; //bill.CNInvNo = so.custpono; bills.Add (bill); } } } return bills; }
public List<OutLetBill> GetBills() { bills = new List<OutLetBill> (); var list11 = from p in allbills where p.IsUploaded == false group p by p.InvNo into g select new {key = g.Key,result = g.ToList (),count=g.Count()}; int counter = 0; List<OutLetBillTemp> list1 = new List<OutLetBillTemp> (); foreach (var grp in list11) { counter = counter + grp.count; list1.AddRange(grp.result); if (counter > 30) { break; } } // var list1 = allbills.Where (x => x.IsUploaded == false) // .GroupBy(x=>x.InvNo) // .Take (10) // .ToList (); foreach (OutLetBillTemp trx in list1) { OutLetBill bill = new OutLetBill (); bill.UserID = userid; bill.BranchCode = brn; bill.CompanyCode = comp; bill.Created = trx.Created; bill.CustCode = trx.CustCode; bill.ICode = trx.ICode; bill.InvDate = trx.InvDate; bill.InvNo = trx.InvNo; bill.IsInclusive = trx.IsUploaded; bill.Amount = trx.Amount; bill.NetAmount = trx.NetAmount; bill.TaxAmt = trx.TaxAmt; bill.TaxGrp = trx.TaxGrp; bill.UPrice = trx.UPrice; bill.Qty = trx.Qty; bill.TrxType = trx.TrxType; bills.Add (bill); } return bills; }