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