public ActionResult Create([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.Products.Add(product);
db.SaveChanges();
Logger.AddLog(
User.Identity.Name,
product.ProductID,
Logger.Product,
Logger.Add,
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 Create([Bind(Include = "ProductInID,ProductCode,Date,Qty,Notes")] ProductIn productIn)
{
productIn.Date = Date.getDate();
var price = db.Products.Where(o => o.ProductCode == productIn.ProductCode).Select(o => o.Price).FirstOrDefault();
productIn.Price = productIn.Qty * price;
if (ModelState.IsValid)
{
//var oldobj = db.ProducsIn.Find(productIn.ProductInID);
var productName = db.Products.Where(o => o.ProductCode == productIn.ProductCode).FirstOrDefault().ProductName;
db.ProducsIn.Add(productIn);
db.SaveChanges();
Logger.AddLog(
User.Identity.Name,
productIn.ProductInID,
Logger.ProductIn,
Logger.Add,
Logger.DescriptionQtyPrice(productIn.ProductCode, productName, productIn.Qty, productIn.Qty, productIn.Price, productIn.Price)
);
return(RedirectToAction("Index"));
}
ViewBag.ProductID = new SelectList(db.Products, "ProductCode", "ProductCode", productIn.ProductCode);
return(View(productIn));
}
public ActionResult Create([Bind(Include = "KursID,Currency,Rate")] Kurs kurs)
{
if (ModelState.IsValid)
{
db.KursSG.Add(kurs);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(kurs));
}
public ActionResult Create([Bind(Include = "SupplierID,SupplierName,Notes")] Supplier supplier)
{
if (ModelState.IsValid)
{
db.Suppliers.Add(supplier);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View());
}
public ActionResult Create([Bind(Include = "ProductOutID,Date,ProductCode,Qty,Notes")] ProductOut productOut)
{
productOut.Date = System.DateTime.Today;
if (ModelState.IsValid)
{
db.ProductsOut.Add(productOut);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ProductCode = new SelectList(db.Products, "ProductCode", "ProductCode", productOut.ProductCode);
return(View(productOut));
}
public ActionResult Create([Bind(Include = "SaleID,Date,ProductCode,Qty,Notes")] Sale sale)
{
sale.Date = System.DateTime.Today;
if (ModelState.IsValid)
{
//var obj = db.Products.Where(o => o.ProductCode == sale.ProductCode).FirstOrDefault();
//sale. = obj.ProductID;
db.Sales.Add(sale);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ProductCode = new SelectList(db.Products, "ProductCode", "ProductCode", sale.ProductCode);
return(View(sale));
}
public ActionResult Create([Bind(Include = "ProductInID,ProductCode,Date,Qty,Notes")] ProductIn productIn)
{
productIn.Date = System.DateTime.Today;
var price = db.Products.Where(o => o.ProductCode == productIn.ProductCode).Select(o => o.Price).FirstOrDefault();
productIn.Price = productIn.Qty * price;
if (ModelState.IsValid)
{
db.ProducsIn.Add(productIn);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ProductID = new SelectList(db.Products, "ProductCode", "ProductCode", productIn.ProductCode);
return(View(productIn));
}
public ActionResult Create([Bind(Include = "ProductOutID,Date,ProductCode,Qty,Notes")] ProductOut productOut)
{
DateTime date = Date.getDate();
productOut.Date = date;
if (ModelState.IsValid)
{
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;
//var obj = db.Products.Where(o => o.ProductCode == sale.ProductCode).FirstOrDefault();
//sale. = obj.ProductID;
//var oldobj = db.ProductsOut.Find(productOut.ProductOutID);
var productName = db.Products.Where(o => o.ProductCode == productOut.ProductCode).FirstOrDefault().ProductName;
if (productOut.Qty <= stock)
{
db.ProductsOut.Add(productOut);
db.SaveChanges();
Logger.AddLog(
User.Identity.Name,
productOut.ProductOutID,
Logger.ProductOut,
Logger.Add,
Logger.DescriptionQty(productOut.ProductCode, productName, productOut.Qty, productOut.Qty)
);
return(RedirectToAction("Index"));
}
else
{
ViewBag.msg = "Quantity can't be greater than stock (" + stock.ToString() + ")";
}
}
ViewBag.ProductCode = new SelectList(db.Products, "ProductCode", "ProductCode", productOut.ProductCode);
return(View(productOut));
}
public ActionResult Create([Bind(Include = "KursID,Currency,Rate")] Kurs kurs)
{
if (ModelState.IsValid)
{
db.KursSG.Add(kurs);
db.SaveChanges();
Logger.AddLog(
User.Identity.Name,
kurs.KursID,
Logger.Rate,
Logger.Add,
Logger.DescriptionRate(kurs.Currency, kurs.Rate)
);
return RedirectToAction("Index");
}
return View(kurs);
}
private static void _insertLog()
{
using (var context = new ATokoDb())
{
try
{
context.AuditLogs.Add(_log);
context.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
}
public IHttpActionResult PostTest(ViewModel model)
{
var kurs = new Kurs
{
Currency = model.Currency,
Rate = model.Rate
};
var supplier = new Supplier
{
SupplierName = model.SupplierName
};
using (var context = new ATokoDb())
{
context.KursSG.Add(kurs);
context.Suppliers.Add(supplier);
context.SaveChanges();
}
return(CreatedAtRoute("DefaultApi", new { id = kurs.KursID }, kurs));
}
