public ActionResult DeleteConfirmed(int id)
{
Buy_tbl buy_tbl = db.buy_Tbls.Find(id);
db.buy_Tbls.Remove(buy_tbl);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,OrderDate,Sup_Id,Sup_Name")] Buy_tbl buy_tbl)
{
if (ModelState.IsValid)
{
db.Entry(buy_tbl).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(buy_tbl));
}
public ActionResult Create([Bind(Include = "Id,OrderDate,Sup_Id,Sup_Name")] Buy_tbl buy_tbl)
{
if (ModelState.IsValid)
{
db.buy_Tbls.Add(buy_tbl);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(buy_tbl));
}
// GET: Buy_tbl/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Buy_tbl buy_tbl = db.buy_Tbls.Find(id);
if (buy_tbl == null)
{
return(HttpNotFound());
}
return(View(buy_tbl));
}
public JsonResult AddOrderAndOrderDetials(OrderViewModel orderViewModel)
{
bool status = true;
var isValidModel = TryUpdateModel(orderViewModel);
if (isValidModel)
{
using (ApplicationDbContext db = new ApplicationDbContext())
{
var subname = db.suply_Tbls.Find(orderViewModel.Cust_TBLId);
Buy_tbl order = new Buy_tbl()
{
OrderDate = System.DateTime.Now,
Sup_Id = orderViewModel.Cust_TBLId,
Sup_Name = subname.Name
};
db.buy_Tbls.Add(order);
if (db.SaveChanges() > 0)
{
int orderID = db.buy_Tbls.Max(o => o.Id);
foreach (var item in orderViewModel.Items)
{
MainStore orderDetails = new MainStore()
{
Buy_tblId = orderID,
Product_TbleId = item.ProductID,
Price = Convert.ToInt32(item.Price),
QtyIn = item.Quantity,
QtyOut = 0,
Amount = item.TotalPrice,
Date = DateTime.Now
};
var stck = db.product_Tbles.Where(p => p.Id == item.ProductID).FirstOrDefault();
stck.SQty = stck.SQty + item.Quantity;
Sub_Acount sub = new Sub_Acount()
{
Suply_TblId = orderViewModel.Cust_TBLId,
ByNo = orderID,
Amount = item.TotalPrice,
Date = System.DateTime.Now
};
db.mainStores.Add(orderDetails);
db.sub_Acounts.Add(sub);
}
if (db.SaveChanges() > 0)
{
return(new JsonResult {
Data = new { status = status, message = "Order Added Successfully" }
});
}
}
}
}
status = false;
return(new JsonResult {
Data = new { status = status, message = "Error !" }
});
}
