public void InitService(
CompanyFile companyFile,
SDK.CompanyFileCredentials credentials,
SDK.ApiConfiguration myConfiguration,
OAuthKeyService myOAuthKeyService)
{
myCompanyFile = companyFile;
myCredentials = credentials;
myService = new ItemInvoiceService(myConfiguration, null, myOAuthKeyService);
}
public string PostSaleInvoice(PelicanSale sale,
PelicanContext context = null,
Guid?companyFileId = null)
{
var authorizationService = new AuthorizationService();
context = context ?? PelicanContext.CreateFromApplicationSettings();
companyFileId = companyFileId ?? context.CompanyFileId;
var apiContext = authorizationService.GetAuthorizedContext(context,
companyFileId.Value);
try
{
if (_taxCode == null)
{
var taxCodeService = new TaxCodeService(apiContext.ApiConfiguration);
var taxCodes = taxCodeService.GetRange(apiContext.CompanyFile,
null,
apiContext.CompanyFileCredentials);
_taxCode = taxCodes.Items.First(_ => _.Code == "GST");
}
var service = new ItemInvoiceService(apiContext.ApiConfiguration);
var entity = new ItemInvoice();
entity.UID = Guid.NewGuid();
entity.InvoiceType = InvoiceLayoutType.Item;
entity.Customer = new CustomerLink
{
UID = Guid.Parse(sale.Customer.Id)
};
entity.Number = string.Format("SJ{0:D5}",
_referenceNbr++);
entity.Date = DateTime.Today;
var invoiceLines = new List <ItemInvoiceLine>();
for (var index = 0;
index < sale.SaleableItems.Count();
index++)
{
var saleableItem = sale.SaleableItems[index];
var item = new ItemInvoiceLine();
item.Item = new ItemLink
{
UID = Guid.Parse(saleableItem.Id)
};
item.RowID = index;
item.ShipQuantity = 1;
item.Total = Convert.ToDecimal(saleableItem.Price);
item.TaxCode = new TaxCodeLink
{
UID = _taxCode.UID
};
invoiceLines.Add(item);
}
entity.Lines = invoiceLines;
entity.TotalAmount = Convert.ToDecimal(sale.SaleableItems.Sum(_ => _.Price));
entity.Comment = "Entered via Pelican";
return(service.Insert(apiContext.CompanyFile,
entity,
apiContext.CompanyFileCredentials));
}
catch (Exception ex)
{
switch (ex.GetType()
.Name)
{
case "WebException":
Debug.WriteLine(FormatMessage((WebException)ex));
break;
case "ApiCommunicationException":
Debug.WriteLine(FormatMessage((WebException)ex.InnerException));
break;
case "ApiOperationException":
Debug.WriteLine(ex.Message);
break;
default:
Debug.WriteLine(ex.Message);
break;
}
}
return(null);
}
protected void btnSearch_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;
listPL.Clear();
var service = new ItemOrderService(SessionManager.MyConfiguration, null, SessionManager.MyOAuthKeyService);
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 items = inv.Lines;
foreach (var item in inv.Lines)
{
listPL.Add(new SalesData
{
CustomerName = inv.Customer != null ? inv.Customer.Name : "",
TransactionNumber = inv.Number,
TransactionDate = inv.Date != null ? inv.Date.ToString("yyyy-MM-dd") : "",
TransactionType = "Sales Order",
TransactionStatus = inv.Status.ToString(),
Itemumber = item.Item != null ? item.Item.Number : "",
Product = item.Item != null ? item.Item.Name : "",
// AccountNumber=inv.ac,
LineMemo = inv.JournalMemo,
EmployeeName = inv.Salesperson != null ? inv.Salesperson.Name : "",
Qty = item.ShipQuantity,
// TaxExAmount = item.Total,
Total = item.Total,
TaxCode = item.TaxCode != null ? item.TaxCode.Code.ToString() : "",
PromisedDate = inv.PromisedDate,
ItemName = item.Description
});
}
}
}
var serviceItemInvoicService = new ItemInvoiceService(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)
{
listPL.Add(new SalesData
{
CustomerName = inv.Customer != null?inv.Customer.Name:"",
TransactionNumber = inv.Number,
TransactionDate = inv.Date != null?inv.Date.ToString("yyyy-MM-dd"):"",
TransactionType = "Sales Order",
TransactionStatus = inv.Status.ToString(),
Itemumber = item.Item != null ? item.Item.Number : "",
Product = item.Item != null ? item.Item.Name : "",
// AccountNumber=inv.ac,
LineMemo = inv.JournalMemo,
EmployeeName = inv.Salesperson != null ? inv.Salesperson.Name : "",
Qty = item.ShipQuantity,
// TaxExAmount = item.Total,
Total = item.Total,
TaxCode = item.TaxCode != null ? item.TaxCode.Code.ToString() : "",
PromisedDate = inv.PromisedDate,
ItemName = item.Description
});
}
}
}
ViewState["ListSalePurchase"] = listPL;
GridView1.DataSource = listPL.ToList();
GridView1.DataBind();
GridView1.Caption = "Sales";
}
