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 = "เพิ่มข้อมูลสำเร็จแล้ว." }));
}
}
