public JsonResult ProductBrandName_DataLoading(int pBrandID)
{
Database db = new Database();
ProductBrandDAO pbDAO = new ProductBrandDAO(db);
ProductBrandModel pbModel = pbDAO.FindById(pBrandID);
db.Close();
return(Json(new { brandID = pbModel.PRO_BRAND_ID, brandName = pbModel.PRO_BAND_NAME }));
}
public ActionResult ProductBrandManagement()
{
Database db = new Database();
ProductBrandDAO pbDAO = new ProductBrandDAO(db);
List <ProductBrandModel> pbModel = pbDAO.FindAll();
db.Close();
ViewBag.ProductBrand = pbModel;
return(View());
}
public ActionResult ProductBrandUpdating(string proBrand_name, int proBrand_id)
{
ProductBrandModel pbModel = new ProductBrandModel();
pbModel.PRO_BRAND_ID = proBrand_id;
pbModel.PRO_BAND_NAME = proBrand_name;
Database db = new Database();
ProductBrandDAO pbDAO = new ProductBrandDAO(db);
pbDAO.Update(pbModel);
db.Close();
return(Redirect("~/Product/ProductBrandManagement"));
}
public ActionResult ProductBrandDeleting(int brandID)
{
try
{
ProductBrandModel pbModel = new ProductBrandModel();
pbModel.PRO_BRAND_ID = brandID;
Database db = new Database();
ProductBrandDAO pbDAO = new ProductBrandDAO(db);
pbDAO.Delete(pbModel);
db.Close();
return(Redirect("~/Product/ProductBrandManagement"));
}
catch
{
return(RedirectToAction("Alert", "Product", new { link = "ProductBrandManagement", massage = "มีรายการที่อ้างถึงข้อมูลนี้อยู่ ไม่สามารถลบได้" }));
}
}
// เมื่อคลิกปุ่มเรดิโอ จะโหลดข้อมูลส่วนนี้ไปแสดง
public ActionResult ManageProduct_DataLoading()
{
int typeID = Int32.Parse(Request.Params["typeID"]);
Database db = new Database();
ProductBrandDAO pbDAO = new ProductBrandDAO(db);
List <ProductBrandModel> listPbModel = pbDAO.FindAll();
ViewData["BRAND"] = listPbModel;
db.Close();
db = new Database();
ProductDAO proDAO = new ProductDAO(db);
List <ProductModel> proModel = proDAO.FindByTypeID(typeID);
ViewData["PRODUCT"] = proModel;
db.Close();
return(View());
}
public ActionResult AddProductBrand()
{
string proBrandName = Request.Params["probrand_name"].Trim();
ProductBrandModel pbModel = new ProductBrandModel();
pbModel.PRO_BAND_NAME = proBrandName;
Database db = new Database();
ProductBrandDAO pbDAO = new ProductBrandDAO(db);
int id = pbDAO.Add(pbModel);
db.Close();
if (id > 0)
{
return(RedirectToAction("Alert", "Product", new { link = "~/Product/ManageProduct", massage = "เพิ่มข้อมูลเรียบร้อย" }));
}
else
{
return(RedirectToAction("ManageProduct", "Product"));
}
}
