public ActionResult DeleteConfirmed(int id)
{
MndStkOut mndStkOut = db.mndStkOuts.Find(id);
db.mndStkOuts.Remove(mndStkOut);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,MndId,MndName,OrderDate")] MndStkOut mndStkOut)
{
if (ModelState.IsValid)
{
db.Entry(mndStkOut).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(mndStkOut));
}
public ActionResult Create([Bind(Include = "Id,MndId,MndName,OrderDate")] MndStkOut mndStkOut)
{
if (ModelState.IsValid)
{
db.mndStkOuts.Add(mndStkOut);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(mndStkOut));
}
// GET: MndStkOuts/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MndStkOut mndStkOut = db.mndStkOuts.Find(id);
if (mndStkOut == null)
{
return(HttpNotFound());
}
return(View(mndStkOut));
}
public JsonResult OutMndStockDetials(OrderViewModel orderViewModel)
{
bool status = true;
var isValidModel = TryUpdateModel(orderViewModel);
if (isValidModel)
{
using (ApplicationDbContext db = new ApplicationDbContext())
{
var mndname = db.MND_TBLs.Find(orderViewModel.Cust_TBLId);
MndStkOut order = new MndStkOut()
{
OrderDate = System.DateTime.Now,
MndId = orderViewModel.Cust_TBLId,
MndName = mndname.MND_NAME
};
db.mndStkOuts.Add(order);
if (db.SaveChanges() > 0)
{
int orderID = db.mndStkOuts.Max(o => o.Id);
foreach (var item in orderViewModel.Items)
{
MainStore orderDetails = new MainStore()
{
MndStkOutId = orderID,
Product_TbleId = item.ProductID,
Price = item.Price,
QtyIn = item.Quantity,
QtyOut = 0,
Date = DateTime.Now,
Amount = item.TotalPrice
};
Stock stock = new Stock()
{
Prod_Id = item.ProductID,
MndId = mndname.Id,
StQty = -item.Quantity,
Date = DateTime.Now,
Case = "مرتجع مندوب",
Cust_Id = 0
};
var stk = db.product_Tbles.Where(x => x.Id == item.ProductID).FirstOrDefault();
stk.SQty = stk.SQty + item.Quantity;
db.stocks.Add(stock);
db.mainStores.Add(orderDetails);
}
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 !" }
});
}
public JsonResult AddOrderAndOrderDetials(OrderViewModel orderViewModel)
{
bool status = true;
var isValidModel = TryUpdateModel(orderViewModel);
if (isValidModel)
{
using (ApplicationDbContext db = new ApplicationDbContext())
{
var cusname = db.CUST_TBLs.Find(orderViewModel.Cust_TBLId);
MndStkOut order = new MndStkOut()
{
OrderDate = System.DateTime.Now,
MndId = orderViewModel.Cust_TBLId,
MndName = cusname.CUST_NAME
};
db.mndStkOuts.Add(order);
if (db.SaveChanges() > 0)
{
int orderID = db.mndStkOuts.Max(o => o.Id);
foreach (var item in orderViewModel.Items)
{
MainStore orderDetails = new MainStore()
{
MndStkOutId = orderID,
Product_TbleId = item.ProductID,
Price = item.Quantity,
QtyIn = Convert.ToInt32(item.Price),
QtyOut = 0,
Amount = item.TotalPrice
};
Stock stock = new Stock()
{
Prod_Id = item.ProductID,
StQty = -Convert.ToInt32(item.Price),
Case = "مرتجع مندوب",
Date = System.DateTime.Now,
MndId = cusname.MND_TBLId,
Cust_Id = 0
};
db.mainStores.Add(orderDetails);
db.stocks.Add(stock);
}
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 !" }
});
}
