public void AddSalesDetailsForRetailBill(RetailBill billedProducts) { using (Billing_Customized_Entities billedProductDetails = new Billing_Customized_Entities()) { billedProductDetails.RetailBills.Add(billedProducts); billedProductDetails.SaveChanges(); } }
public void UpdateBillDetailsForRetailBill(string currentBillNumber, decimal totalGST, decimal billAmount, decimal totalAmount, DataGridView purchasedProductsFromGridView) { List <RetailBillSalesDetail> purchased = new List <RetailBillSalesDetail>(); RetailBill salesDetail = new RetailBill(); List <Products> productDetails = new List <Products>(); if (purchasedProductsFromGridView.Rows.Count > 0) { for (int i = 0; i < purchasedProductsFromGridView.Rows.Count; i++) { RetailBillSalesDetail billedProducts = new RetailBillSalesDetail { ProductId = Convert.ToInt64(purchasedProductsFromGridView.Rows[i].Cells[1].Value), ProductName = purchasedProductsFromGridView.Rows[i].Cells[2].Value.ToString(), Quantity = Convert.ToDecimal(purchasedProductsFromGridView.Rows[i].Cells[3].Value), BillAmount = Convert.ToDecimal(purchasedProductsFromGridView.Rows[i].Cells[5].Value), TotalAmount = Convert.ToDecimal(purchasedProductsFromGridView.Rows[i].Cells[8].Value), GSTAmount = Convert.ToDecimal(purchasedProductsFromGridView.Rows[i].Cells[7].Value), SoldDate = DateTime.Today, BillNumber = Convert.ToInt64(currentBillNumber) }; purchased.Add(billedProducts); Products product = new Products { ProductId = Convert.ToInt64(purchasedProductsFromGridView.Rows[i].Cells[1].Value), Quantity = Convert.ToDecimal(purchasedProductsFromGridView.Rows[i].Cells[3].Value), }; productDetails.Add(product); } salesDetail.BillNos = Convert.ToInt64(currentBillNumber); salesDetail.GSTAmount = totalGST; salesDetail.BillAmount = billAmount; salesDetail.TotalAmount = Math.Round(totalAmount, MidpointRounding.ToEven); salesDetail.SoldDate = DateTime.Today; salesDetail.PaidAmount = Math.Round(totalAmount, MidpointRounding.ToEven); } Task.Run(() => cashierDataAccess.AddSalesDetailsForRetailBill(salesDetail)); Task.Run(() => cashierDataAccess.UpdateRetailBillSalesDetails(purchased)); cashierDataAccess.UpdateQuantity(productDetails); }
public void DeleteSalesDetailsForReturnBill(ProductSales billDetails, List <ProductSales> productSalesList, int billType) { dynamic salesDetails; dynamic bill; if (billType.Equals(1)) { bill = new RetailBill { TotalAmount = billDetails.TotalAmount, GSTAmount = billDetails.GstAmount, BillAmount = billDetails.BillAmount, SoldDate = billDetails.Date, BillNos = billDetails.BillNumber, Id = billDetails.Id }; salesDetails = new List <RetailBillSalesDetail>(); foreach (ProductSales sale in productSalesList) { RetailBillSalesDetail retail = new RetailBillSalesDetail { TotalAmount = sale.TotalAmount, BillAmount = sale.BillAmount, BillNumber = sale.BillNumber, GSTAmount = sale.GstAmount, ProductId = sale.ProductId, ProductName = sale.ProductName, Quantity = sale.Quantity, SoldDate = sale.Date, Id = sale.Id }; salesDetails.Add(retail); } } else if (billType.Equals(2)) { bill = new WholeSaleBill { TotalAmount = billDetails.TotalAmount, GSTAmount = billDetails.GstAmount, BillAmount = billDetails.BillAmount, SoldDate = billDetails.Date, BillNos = billDetails.BillNumber, Id = billDetails.Id }; salesDetails = new List <WholeSaleBillSalesDetail>(); foreach (ProductSales sale in productSalesList) { WholeSaleBillSalesDetail retail = new WholeSaleBillSalesDetail { TotalAmount = sale.TotalAmount, BillAmount = sale.BillAmount, BillNumber = sale.BillNumber, GSTAmount = sale.GstAmount, ProductId = sale.ProductId, ProductName = sale.ProductName, Quantity = sale.Quantity, SoldDate = sale.Date, Id = sale.Id }; salesDetails.Add(retail); } } else { bill = new CreditBill { TotalAmount = billDetails.TotalAmount, GSTAmount = billDetails.GstAmount, BillAmount = billDetails.BillAmount, SoldDate = billDetails.Date, BillNos = billDetails.BillNumber, Id = billDetails.Id }; salesDetails = new List <CreditBillSalesDetail>(); foreach (ProductSales sale in productSalesList) { CreditBillSalesDetail retail = new CreditBillSalesDetail { TotalAmount = sale.TotalAmount, BillAmount = sale.BillAmount, BillNumber = sale.BillNumber, GSTAmount = sale.GstAmount, ProductId = sale.ProductId, ProductName = sale.ProductName, Quantity = sale.Quantity, SoldDate = sale.Date, Id = sale.Id }; salesDetails.Add(retail); } } cashierDataAccess.DeleteSalesDetailsForReturnBill(salesDetails, bill, billType); }
public void Update(RetailBill retailinvoicemaster) { _RetailInvoiceMasterRepository.Update(retailinvoicemaster); _UnitOfWork.Commit(); }