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)); }