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