public ActionResult Edit([Bind(Include = "ProductID,ProductCode,ProductName,SupplierID,Price,Notes")] Product product)
{
if (ModelState.IsValid)
{
product.KursID = db.KursSG.Where(o => o.Currency == "SGD").Select(o => o.KursID).FirstOrDefault();
db.Entry(product).State = EntityState.Modified;
db.SaveChanges();
Logger.AddLog(
User.Identity.Name,
product.ProductID,
Logger.Product,
Logger.Edit,
Logger.DescriptionProduct(product.ProductCode, product.ProductName, product.KursID, product.Price)
);
return(RedirectToAction("Index"));
}
var selectrate = (from b in db.KursSG
select new { b.Rate, text = b.Currency + "-" + b.Rate });
ViewBag.Kurs = new SelectList(selectrate.ToList(), "Rate", "text", product.KursID);
ViewBag.SupplierID = new SelectList(db.Suppliers, "SupplierID", "SupplierName", product.SupplierID);
return(View(product));
}
public ActionResult Edit([Bind(Include = "KursID,Currency,Rate")] Kurs kurs)
{
if (ModelState.IsValid)
{
db.Entry(kurs).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(kurs));
}
public ActionResult Edit([Bind(Include = "SupplierID,SupplierName,Notes")] Supplier supplier)
{
if (ModelState.IsValid)
{
db.Entry(supplier).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(supplier));
}
public ActionResult Edit([Bind(Include = "ProductOutID,ProductCode,Qty,Notes")] ProductOut productOut)
{
if (ModelState.IsValid)
{
ProductOut obj = db.ProductsOut.Find(productOut.ProductOutID);
int qtyBefore = obj.Qty;
obj.Qty = productOut.Qty;
obj.ProductCode = productOut.ProductCode;
obj.Notes = productOut.Notes;
DateTime date = Date.getDate();
DateTime fromDate = new DateTime(2014, 01, 01);
string query = string.Format("EXEC [dbo].[sp_GetReportStock] @dateFrom = '{0}', @dateTo = '{1}'", fromDate.ToString("yyyy-MM-dd"), date.ToString("yyyy-MM-dd"));
IEnumerable <ReportStock> list = db.Database.SqlQuery <ReportStock>(query);
int stock = list.Where(o => o.ProductCode == productOut.ProductCode).FirstOrDefault().Stock + qtyBefore;
var oldobj = db.ProductsOut.Find(productOut.ProductOutID);
var productName = db.Products.Where(o => o.ProductCode == productOut.ProductCode).FirstOrDefault().ProductName;
if (productOut.Qty <= stock)
{
db.Entry(obj).State = EntityState.Modified;
db.SaveChanges();
Logger.AddLog(
User.Identity.Name,
productOut.ProductOutID,
Logger.ProductOut,
Logger.Edit,
Logger.DescriptionQty(productOut.ProductCode, productName, productOut.Qty, qtyBefore)
);
return(RedirectToAction("Index"));
}
else
{
ViewBag.msg = "Quantity can't be greater than stock (" + stock.ToString() + ")";
}
}
IEnumerable <Product> listProduct = db.Products;
foreach (var item in listProduct)
{
item.ProductName = item.ProductCode + " - " + item.ProductName;
}
ViewBag.ProductCode = new SelectList(listProduct, "ProductCode", "ProductName", productOut.ProductCode);
return(View(productOut));
}
public ActionResult Edit([Bind(Include = "ProductInID,ProductCode,Qty,Price,Notes")] ProductIn productIn)
{
if (ModelState.IsValid)
{
db.Entry(productIn).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ProductID = new SelectList(db.Products, "ProductCode", "ProductCode", productIn.ProductCode);
return(View(productIn));
}
public ActionResult Edit([Bind(Include = "SaleID,ProductCode,Qty,Notes")] Sale sale)
{
if (ModelState.IsValid)
{
db.Entry(sale).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ProductCode = new SelectList(db.Products, "ProductCode", "ProductCode", sale.ProductCode);
return(View(sale));
}
public ActionResult Edit([Bind(Include = "KursID,Currency,Rate")] Kurs kurs)
{
if (ModelState.IsValid)
{
db.Entry(kurs).State = EntityState.Modified;
db.SaveChanges();
Logger.AddLog(
User.Identity.Name,
kurs.KursID,
Logger.Rate,
Logger.Edit,
Logger.DescriptionRate(kurs.Currency, kurs.Rate)
);
return RedirectToAction("Index");
}
return View(kurs);
}
public ActionResult Edit([Bind(Include = "ProductInID,ProductCode,Qty,Notes")] ProductIn productIn)
{
if (ModelState.IsValid)
{
ProductIn obj = db.ProducsIn.Find(productIn.ProductInID);
int qtyBefore = obj.Qty;
int priceBefore = obj.Price;
obj.Qty = productIn.Qty;
var price = db.Products.Where(o => o.ProductCode == productIn.ProductCode).Select(o => o.Price).FirstOrDefault();
obj.Price = productIn.Qty * price;
obj.ProductCode = productIn.ProductCode;
obj.Notes = productIn.Notes;
var oldobj = db.ProducsIn.Find(productIn.ProductInID);
var productName = db.Products.Where(o => o.ProductCode == productIn.ProductCode).FirstOrDefault().ProductName;
db.Entry(obj).State = EntityState.Modified;
db.SaveChanges();
Logger.AddLog(
User.Identity.Name,
productIn.ProductInID,
Logger.ProductIn,
Logger.Edit,
Logger.DescriptionQtyPrice(productIn.ProductCode, productName, productIn.Qty, qtyBefore, productIn.Price, priceBefore)
);
return(RedirectToAction("Index"));
}
ViewBag.ProductID = new SelectList(db.Products, "ProductCode", "ProductCode", productIn.ProductCode);
return(View(productIn));
}