public JsonResult PartsBrandName_DataLoading(int pBrandID) { Database db = new Database(); PartsBrandDAO pbDAO = new PartsBrandDAO(db); PartsBrandModel pbModel = pbDAO.FindById(pBrandID); db.Close(); return(Json(new { brandName = pbModel.PART_BRAND_NAME, brandID = pbModel.PART_BRAND_ID })); }
public ActionResult PartsBrandManagement() { Database db = new Database(); PartsBrandDAO pbDAO = new PartsBrandDAO(db); List <PartsBrandModel> pbModel = pbDAO.FindAll(); ViewBag.Brand = pbModel; db.Close(); return(View()); }
public ActionResult PartsBrandUpdating(int partsBrand_id, string partsBrand_name) { PartsBrandModel pbModel = new PartsBrandModel(); pbModel.PART_BRAND_ID = partsBrand_id; pbModel.PART_BRAND_NAME = partsBrand_name; Database db = new Database(); PartsBrandDAO pbDAO = new PartsBrandDAO(db); pbDAO.Update(pbModel); db.Close(); return(Redirect("~/Stock/PartsBrandManagement")); }
public ActionResult StockManagement_DataLoading(int typeID) { Database db = new Database(); PartsBrandDAO pbDAO = new PartsBrandDAO(db); List <PartsBrandModel> pbModel = pbDAO.FindAll(); ViewBag.PartsBrand = pbModel; db.Close(); db = new Database(); PartsDAO pDAO = new PartsDAO(db); List <PartsModel> tModel = pDAO.FindByPartsTypeID(typeID); ViewBag.Parts = tModel; db.Close(); return(View()); }
public ActionResult PartsBrandDeleting(int brandID) { try { PartsBrandModel pbModel = new PartsBrandModel(); pbModel.PART_BRAND_ID = brandID; Database db = new Database(); PartsBrandDAO pbDAO = new PartsBrandDAO(db); pbDAO.Delete(pbModel); db.Close(); return(Redirect("~/Stock/PartsBrandManagement")); } catch (Exception ex) { return(RedirectToAction("alert", "Stock", new { link = "PartsBrandManagement", massage = "มีรายการที่อ้างถึงข้อมูลนี้อยู่ ไม่สามารถลบได้" })); } }
/// เพิ่มยี่ห้อ /// <returns>ไปหน้าเดิม</returns> public ActionResult PartsBrandInserting(string partsbrand_name) { Database db = new Database(); PartsBrandDAO pbDAO = new PartsBrandDAO(db); List <PartsBrandModel> pbModel = pbDAO.FindByBrandName(partsbrand_name); db.Close(); if (pbModel.Count > 0) { return(RedirectToAction("alert", "Stock", new { link = "StockManagement", massage = "ไม่สามารถเพิ่มข้อมูลได้มีข้อมูลนี้แล้ว กรุณาตรวจสอบอีกครั้ง !" })); } else { PartsBrandModel pbMD = new PartsBrandModel(); pbMD.PART_BRAND_NAME = partsbrand_name; db = new Database(); pbDAO = new PartsBrandDAO(db); pbDAO.Add(pbMD); db.Close(); return(RedirectToAction("alert", "Stock", new { link = "StockManagement", massage = "เพิ่มข้อมูลสำเร็จแล้ว." })); } }