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