public IActionResult AccountPay()
{
var supplier = context.Supplier.GetAll().ToList();
PurchaseProductVM purchaseProductVM = new PurchaseProductVM()
{
SupplierItem = POSHelper.Supplier(supplier),
};
return(View(purchaseProductVM));
}
public IActionResult Index(PurchaseProductVM purchaseProduct)
{
try
{
#region Pushing into Purchase Product
PurchaseProduct purchase = new PurchaseProduct()
{
InvoiceNumber = purchaseProduct.InvoiceNumber,
SupplierId = purchaseProduct.SupplierId,
SubTotal = purchaseProduct.SubTotal,
GrandTotal = purchaseProduct.GrandTotal,
Discount = purchaseProduct.Discount,
Dues = purchaseProduct.Dues,
PaidAmount = purchaseProduct.PaidAmount,
PaymentMode = purchaseProduct.PaymentMode,
};
context.PurchaseProduct.Add(purchase);
context.Save();
#endregion
#region Pushing into Purchase Product Detail
foreach (var item in purchaseProduct.PurchaseProductDetails)
{
PurchaseProductDetail purchaseProductDetail = new PurchaseProductDetail()
{
PurchaseProductId = purchase.Id,
InvoiceNumber = item.InvoiceNumber,
ProductId = item.ProductId,
Quantity = item.Quantity,
UnitPrice = item.UnitPrice,
VatAndTaxId = item.VatAndTaxId,
BasePrice = item.BasePrice,
SellPrice = item.SellPrice,
};
context.PurchaseProductDetail.Add(purchaseProductDetail);
context.Save();
UpdateInventory(item.ProductId, item.Quantity, item.SellPrice);
}
#endregion
return(Json(true));
}
catch (Exception ex)
{
return(Json(ex.Message));
throw ex;
}
}
public IActionResult Index()
{
var supplierList = context.Supplier.GetAll().ToList();
var productList = context.Product.GetAll().ToList();
var vatAndTax = context.VatAndTax.GetAll().ToList();
PurchaseProductVM purchaseProduct = new PurchaseProductVM()
{
SupplierItem = POSHelper.Supplier(supplierList),
ProductItem = POSHelper.Product(productList),
VatItem = POSHelper.VatAndTax(vatAndTax),
};
return(View(purchaseProduct));
}
private void dataGridBind()
{
try
{
_entities = new KBBQEntities();
int rowNo = 1;
dgItemDetails.AutoGenerateColumns = false;
List <PurchaseProductVM> modelList = new List <PurchaseProductVM>();
var data = _entities.purchaseProducts.OrderBy(x => x.pName);
foreach (var item in data)
{
PurchaseProductVM model = new PurchaseProductVM();
model.rowNo = rowNo;
model.id = Convert.ToInt32(item.id);
model.pName = item.pName;
model.date = Convert.ToDateTime(item.date).ToString("dd-MM-yyyy");
model.weight = item.weight + " " + item.unit;
model.qty = item.qty;
model.cdate = Convert.ToDateTime(item.cdate).ToString("dd-MM-yyyy hh:mm tt");
if (item.udate == null)
{
model.udate = "--";
}
else
{
model.udate = Convert.ToDateTime(item.udate).ToString("dd-MM-yyyy hh:mm tt");
}
modelList.Add(model);
rowNo++;
}
dgItemDetails.DataSource = modelList;
lblTotalRows.Text = modelList.Count.ToString();
}
catch (Exception x)
{
MessageBox.Show("Something went wrong. Contact your system administrator");
}
}
public IActionResult AccountPay(PurchaseProductVM purchaseProduct)
{
try
{
foreach (var item in purchaseProduct.PurchaseProducts)
{
var purchase = context.PurchaseProduct.Find(x => x.InvoiceNumber == item.InvoiceNumber).FirstOrDefault();
if (purchase != null)
{
purchase.PaidAmount = purchase.GrandTotal;
purchase.Dues = 0;
context.Save();
}
}
return(Json(true));
}
catch (Exception ex)
{
return(Json(false));
throw ex;
}
}
