public void InitService(
CompanyFile companyFile,
SDK.CompanyFileCredentials credentials,
SDK.ApiConfiguration myConfiguration,
OAuthKeyService myOAuthKeyService)
{
myCompanyFile = companyFile;
myCredentials = credentials;
myService = new ItemBillService(myConfiguration, null, myOAuthKeyService);
}
protected void btnPurchaseSearch_Click(object sender, EventArgs e)
{
var salesDataService = new Sale();
string filter = string.Format("$filter=Date ge datetime'{0}' and Date le datetime'{1}'", txtFromDate.Text, txtToDate.Text);
string pageFilter = string.Empty;
var service = new ItemBillService(SessionManager.MyConfiguration, null, SessionManager.MyOAuthKeyService);
// var service = new ItemOrderService(SessionManager.MyConfiguration, null, SessionManager.MyOAuthKeyService);
listPL.Clear();
int count = 1000;
for (int currentPage = 1; count >= 1000; currentPage++)
{
pageFilter = string.Format("&$top={0}&$skip={1}&$orderby=Date desc", PageSize,
PageSize * (currentPage - 1));
var list = service.GetRange(SessionManager.SelectedCompanyFile, filter + pageFilter, SessionManager.MyCredentials, null);
count = list.Items.Count();
//var invoisvc = new ItemInvoiceService(SessionManager.MyConfiguration, null, SessionManager.MyOAuthKeyService);
//var list = invoisvc.GetRange(SessionManager.SelectedCompanyFile, null, SessionManager.MyCredentials);
//
var invoices = list.Items;
foreach (var inv in invoices)
{
var salesData = new SalesData();
// var items = inv.Lines;
salesData.Total = inv.TotalAmount;
salesData.TaxCode = inv.FreightTaxCode.Code.ToString();
salesData.PromisedDate = inv.PromisedDate;
salesData.CustomerName = inv.Supplier.Name;
salesData.TransactionNumber = inv.Number;
salesData.TransactionDate = inv.Date.ToString("yyyy-MM-dd");
// TransactionType=inv.InvoiceType,
salesData.TransactionStatus = inv.Status.ToString();
if (inv.Lines != null)
{
foreach (var item in inv.Lines)
{
salesData.Itemumber = item.Item != null ? item.Item.Number : "";
salesData.ItemName = item.Item != null ? item.Item.Name : "";
// item.// AccountNumber=inv.ac,
salesData.LineMemo = inv.JournalMemo;
// item./ EmployeeName = inv.Salesperson != null ? inv.Salesperson.Name : "",
salesData.Qty = item.BillQuantity;
}
}
listPL.Add(salesData);
}
}
var serviceItemInvoicService = new ItemPurchaseOrderService(SessionManager.MyConfiguration, null, SessionManager.MyOAuthKeyService);
count = 1000;
for (int currentPage = 1; count >= 1000; currentPage++)
{
pageFilter = string.Format("&$top={0}&$skip={1}&$orderby=Date desc", PageSize,
PageSize * (currentPage - 1));
var list = serviceItemInvoicService.GetRange(SessionManager.SelectedCompanyFile, filter + pageFilter, SessionManager.MyCredentials, null);
count = list.Items.Count();
//var invoisvc = new ItemInvoiceService(SessionManager.MyConfiguration, null, SessionManager.MyOAuthKeyService);
//var list = invoisvc.GetRange(SessionManager.SelectedCompanyFile, null, SessionManager.MyCredentials);
//
var invoices = list.Items;
foreach (var inv in invoices)
{
// var items = inv.Lines;
foreach (var item in inv.Lines)
{
var saleDataInvItem = new SalesData();
// var items = inv.Lines;
saleDataInvItem.Total = inv.TotalAmount;
saleDataInvItem.TaxCode = inv.FreightTaxCode.Code.ToString();
saleDataInvItem.PromisedDate = inv.PromisedDate;
saleDataInvItem.CustomerName = inv.Supplier.Name;
saleDataInvItem.TransactionNumber = inv.Number;
saleDataInvItem.TransactionDate = inv.Date.ToString("yyyy-MM-dd");
// TransactionType=inv.InvoiceType,
saleDataInvItem.TransactionStatus = inv.Status.ToString();
foreach (var itemInvoic in inv.Lines)
{
saleDataInvItem.Itemumber = itemInvoic.Item != null ? itemInvoic.Item.Number : "";
saleDataInvItem.ItemName = itemInvoic.Item != null ? itemInvoic.Item.Name : "";
// item.// AccountNumber=inv.ac,
saleDataInvItem.LineMemo = inv.JournalMemo;
// item./ EmployeeName = inv.Salesperson != null ? inv.Salesperson.Name : "",
saleDataInvItem.Qty = itemInvoic.BillQuantity;
}
listPL.Add(saleDataInvItem);
}
}
}
ViewState["ListSalePurchase"] = listPL;
GridView1.Caption = "Purchases";
GridView1.DataSource = listPL.ToList();
GridView1.DataBind();
}
