public async Task <string> AddUpdateInvoice(SaleOrderDomainModel saleOrder)
{
int condition = 0;
if (condition > 0)
{
List <tblInvoice> uList = new List <tblInvoice>();
uList = await invoiceRepository.GetAll();
}
string status = "";
int vrNo = 0;
int totalQty = 0;
string strVchNo = "";
List <SingleProductDomainModel> singleProductList = new List <SingleProductDomainModel>();
singleProductList = saleOrder.singleProductList;
foreach (SingleProductDomainModel singleDetail in singleProductList)
{
totalQty = Convert.ToInt32(singleDetail.quantity) + totalQty;
}
int lastSaleOrderId = 0;
using (abuhamzapetstoreEntities db = new abuhamzapetstoreEntities())
{
try
{
vrNo = (from c in db.tblvches
orderby c.vch_id descending
select c.vch_id).Take(1).SingleOrDefault();
strVchNo = "0000" + (vrNo + 1);
var result = db.stpSaleOrder(1, totalQty, saleOrder.subTotal,
saleOrder.grandTotal, saleOrder.discount, saleOrder.tenderAmount, saleOrder.remainingCash,
"Customer Name", 1, saleOrder.grandTotal, strVchNo, saleOrder.cus_No);
lastSaleOrderId = (from c in db.tblInvoices
orderby c.invoice_id descending
select c.invoice_id).Take(1).SingleOrDefault();
foreach (SingleProductDomainModel singleDetail in singleProductList)
{
result = db.stpSaleDetail(lastSaleOrderId, singleDetail.quantity, singleDetail.barcode,
singleDetail.sellPrice, strVchNo, singleDetail.purchasePrice);
}
if (saleOrder.isAdvanceVisible == true)
{
result = db.stpUseAdvance(saleOrder.voucherNo, strVchNo, saleOrder.totalAdvance, saleOrder.remainingAdvance);
}
}
catch (Exception ex)
{
status = ex.Message;
}
}
status = "added";
return(status);
}
public async Task <string> AddUpdateInvoice(SaleOrderDomainModel saleOrder)
{
return(await invoiceBusiness.AddUpdateInvoice(saleOrder));
}
