public JsonResult InsertIntoPurchase(PurchaseInvoiceEntryViewModel vm)
{
Purchase _purchase = new Purchase()
{
ID = vm.PurchaseID + "(" + vm.SelectedSupplierValue + ")",
Date = vm.InvocingDate,
SupplierID = vm.SelectedSupplierValue,
Amount = vm.Amount,
Discount = vm.Discount,
Tax = vm.Tax,
GrandTotal = vm.GrandTotal,
IsPaid = vm.IsPaid,
Description = vm.Remarks
};
int response = repo.InsertIntoPurchase(_purchase);
if (response == 1)
{
string invoiceId = vm.PurchaseID + "(" + vm.SelectedSupplierValue + ")";
return(Json(invoiceId));
}
else
{
return(Json("Invoice Number Already exists!"));
}
}
public void InsertOrUpdateInventory(PurchaseInvoiceEntryViewModel vm)
{
using (MyContext db = new MyContext())
{
_stock = new Stock();
//Initialize new stock with vm inserted values
_stock.ItemID = vm.SelectedItemvalue;
_stock.BatchNo = vm.BatchNo;
_stock.Qty = vm.Qty;
_stock.CostPrice = vm.CostPrice;
_stock.SellingPrice = vm.SellingPrice;
_stock.ExpiryDate = vm.Expiry;
//Get list of all the inserted item in Stock table
List <Stock> _checkItem = (from s in db.Stocks
where s.ItemID == vm.SelectedItemvalue && s.BatchNo == vm.BatchNo
select s).ToList();
//count the number of exixting record on inserted item
int countStock = _checkItem.Count();
//Add new record if record is not found
if (countStock == 0)
{
//Add new item with new Initial qty
_stock.InitialQty = _stock.Qty;
db.Stocks.Add(_stock);
db.SaveChanges();
}
else
{
//to check how many times loop executes completely
int loopCount = 0;
//Check and Add or update
foreach (Stock stock in _checkItem)
{
if (stock.CostPrice == vm.CostPrice)
{
//Update qty and initial qty
stock.InitialQty += vm.Qty;
db.SaveChanges();
break;
}
loopCount++;
}
if (loopCount == _checkItem.Count())
{
//Add new record with Qty and intial Qty
_stock.InitialQty += vm.Qty;
db.Stocks.Add(_stock);
db.SaveChanges();
}
}
}
}
public ActionResult Index(PurchaseInvoiceEntryViewModel vm)
{
try
{
Purchase _purchase = new Purchase()
{
SupplierID = vm.SelectedSupplierValue,
ID = vm.PurchaseID + "(" + vm.SelectedSupplierValue + ")",
Date = vm.InvocingDate,
Amount = vm.Amount,
Discount = vm.Discount,
Tax = vm.Tax,
GrandTotal = vm.GrandTotal,
IsPaid = vm.IsPaid,
LastUpdated = DateTime.Now,
Description = vm.Remarks
};
PurchaseItem _purchaseItem = new PurchaseItem()
{
PurchaseID = _purchase.ID,
ItemID = vm.SelectedItemvalue,
Batch = vm.BatchNo,
Qty = vm.Qty,
CostPrice = vm.CostPrice,
SellingPrice = vm.SellingPrice,
Expiry = vm.Expiry
};
/*
* Add purchase
* Add PurchaseItem
* Add Stock
*/
db.Purchases.Add(_purchase);
db.PurchaseItems.Add(_purchaseItem);
db.SaveChanges();
repo.InsertOrUpdateInventory(vm);
}
catch (Exception ex)
{
ViewBag.SaveException = "Record couldn't be saved! Please check if record has already been entered! Thank you!!";
return(View(vm));
}
ViewBag.SuccessMsg = "Successfully Saved ! Cheers!";
return(RedirectToAction("Index", "PurchaseItem"));
}
// List<PurchaseInvoiceEntryViewModel> tempList = new List<PurchaseInvoiceEntryViewModel>();
// GET: PurchaseInvoiceEntry
public ActionResult Index()
{
var vm = new PurchaseInvoiceEntryViewModel();
return(View(vm));
}
public JsonResult AddToTempList(PurchaseInvoiceEntryViewModel vm)
{
tempList.Add(vm);
return(Json(tempList));
}
