public ActionResult UpdateVegetable(Item it, string UpdatedQuantity)
{
MehriamarqueeEntities meh = new MehriamarqueeEntities();
it.quantity = it.quantity + int.Parse(UpdatedQuantity);
meh.Entry(it).State = System.Data.Entity.EntityState.Modified;
meh.SaveChanges();
QuantityupdatedItemtable quant = new QuantityupdatedItemtable();
quant.itemID = it.itemId;
quant.Date = DateTime.Now;
quant.Quantity = int.Parse(UpdatedQuantity);
meh.QuantityupdatedItemtables.Add(quant);
meh.SaveChanges();
return(RedirectToAction("ViewVegetable"));
}
public ActionResult addNewStocksPost(NewItemsadding add, string Categorylist, string Unitlist)
{
MehriamarqueeEntities meh = new MehriamarqueeEntities();
try
{
if (Categorylist == "Vegetable")
{
Item it = new Item();
it.itemName = add.itemName;
it.quantity = add.itemQuantity;
it.salesPrice = add.itemSalePrice;
it.purchasePrice = add.itemPurchasePrice;
it.category = Categorylist;
it.unit = Unitlist;
meh.Items.Add(it);
meh.SaveChanges();
QuantityupdatedItemtable quant = new QuantityupdatedItemtable();
quant.itemID = it.itemId;
quant.Date = DateTime.Today;
quant.Quantity = it.quantity;
meh.QuantityupdatedItemtables.Add(quant);
meh.SaveChanges();
TempData["message"] = "Stock Added Successfully";
}
if (Categorylist == "Meats")
{
Item it = new Item();
it.itemName = add.itemName;
it.quantity = add.itemQuantity;
it.salesPrice = add.itemSalePrice;
it.purchasePrice = add.itemPurchasePrice;
it.category = Categorylist;
it.unit = Unitlist;
meh.Items.Add(it);
meh.SaveChanges();
QuantityupdatedItemtable quant = new QuantityupdatedItemtable();
quant.itemID = it.itemId;
quant.Date = DateTime.Today;
quant.Quantity = it.quantity;
meh.QuantityupdatedItemtables.Add(quant);
meh.SaveChanges();
TempData["message"] = "Stock Added Successfully";
}
if (Categorylist == "Grossory")
{
Item it = new Item();
it.itemName = add.itemName;
it.quantity = add.itemQuantity;
it.salesPrice = add.itemSalePrice;
it.purchasePrice = add.itemPurchasePrice;
it.category = Categorylist;
it.unit = Unitlist;
meh.Items.Add(it);
meh.SaveChanges();
QuantityupdatedItemtable quant = new QuantityupdatedItemtable();
quant.itemID = it.itemId;
quant.Date = DateTime.Today;
quant.Quantity = it.quantity;
meh.QuantityupdatedItemtables.Add(quant);
meh.SaveChanges();
TempData["message"] = "Stock Added Successfully";
}
if (Categorylist == "Beverages")
{
Beverage beverage = new Beverage();
beverage.beveragesName = add.itemName;
beverage.quantityOfBeverages = add.itemQuantity;
beverage.beveragesSalePrice = add.itemSalePrice;
beverage.beveragesPurchasePrice = add.itemPurchasePrice;
meh.Beverages.Add(beverage);
meh.SaveChanges();
QuantityupdateBeveragestable quant = new QuantityupdateBeveragestable();
quant.beverageID = beverage.beverageId;
quant.Date = DateTime.Today;
quant.Quantity = beverage.quantityOfBeverages;
meh.QuantityupdateBeveragestables.Add(quant);
meh.SaveChanges();
TempData["message"] = "Stock Added Successfully";
}
if (Categorylist == "Deserts")
{
Desert desert = new Desert();
desert.desertName = add.itemName;
desert.quantityOfdesert = add.itemQuantity;
desert.desertSalePrice = add.itemSalePrice;
desert.desertPurchasePrice = add.itemPurchasePrice;
meh.Deserts.Add(desert);
meh.SaveChanges();
QuantityupdatedDeserttable quant = new QuantityupdatedDeserttable();
quant.desertID = desert.desertId;
quant.Date = DateTime.Today;
quant.Quantity = desert.quantityOfdesert;
meh.QuantityupdatedDeserttables.Add(quant);
meh.SaveChanges();
TempData["message"] = "Stock Added Successfully";
}
}
catch (Exception)
{
TempData["message"] = "Server problem !Try Again";
}
return(RedirectToAction("addNewStocksGet"));
}
