public async Task <ActionResult> DeleteConfirmed(string id)
{
LOAI_THIETBI loai_thietbi = await db.LOAI_THIETBI.FindAsync(id);
db.LOAI_THIETBI.Remove(loai_thietbi);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public LOAI_THIETBI THEM_LOAITB(FormCollection form)
{
LOAI_THIETBI lOAI_THIETBI = new LOAI_THIETBI();
lOAI_THIETBI.MA_LOAITB = form["MA_LOAITB"];
lOAI_THIETBI.TEN_LOAI = form["TEN_LOAI"];
lOAI_THIETBI.MA_NHOMTB = form["MA_NHOMTB"];
lOAI_THIETBI.GHI_CHU = form["GHI_CHU"];
return(lOAI_THIETBI);
}
public LOAI_THIETBI SUA_LOAITB(FormCollection form)
{
var mA_LOAITB = form["MA_LOAITB"];
LOAI_THIETBI lOAI_THIETBI = db.LOAI_THIETBI.Where(a => a.MA_LOAITB == mA_LOAITB).FirstOrDefault();
lOAI_THIETBI.TEN_LOAI = form["TEN_LOAI"];
lOAI_THIETBI.MA_NHOMTB = form["MA_NHOMTB"];
lOAI_THIETBI.GHI_CHU = form["GHI_CHU"];
return(lOAI_THIETBI);
}
public async Task <ActionResult> Edit([Bind(Include = "MA_LOAITB,TEN_LOAI,MA_NHOMTB,GHI_CHU")] LOAI_THIETBI loai_thietbi)
{
if (ModelState.IsValid)
{
db.Entry(loai_thietbi).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.MA_NHOMTB = new SelectList(db.NHOM_THIETBI, "MA_NHOMTB", "TEN_NHOM", loai_thietbi.MA_NHOMTB);
return(View(loai_thietbi));
}
// GET: /LoaiThietBi/Details/5
public async Task <ActionResult> Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
LOAI_THIETBI loai_thietbi = await db.LOAI_THIETBI.FindAsync(id);
if (loai_thietbi == null)
{
return(HttpNotFound());
}
return(View(loai_thietbi));
}
// GET: /LoaiThietBi/Edit/5
public async Task <ActionResult> Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
LOAI_THIETBI loai_thietbi = await db.LOAI_THIETBI.FindAsync(id);
if (loai_thietbi == null)
{
return(HttpNotFound());
}
ViewBag.MA_NHOMTB = new SelectList(db.NHOM_THIETBI, "MA_NHOMTB", "TEN_NHOM", loai_thietbi.MA_NHOMTB);
return(View(loai_thietbi));
}
public async Task <ActionResult> Index(FormCollection form, string SAVE, string EDIT)
{
var pHAN_QUYEN = db.NHOM_ND_CHUCNANG.Where(a => a.MA_NHOM == Session["NHOM_ND"].ToString() &&
a.MA_CHUC_NANG == 6);
ViewBag.Them = pHAN_QUYEN.Where(a => a.MA_QUYEN == 1);
ViewBag.Sua = pHAN_QUYEN.Where(a => a.MA_QUYEN == 3);
var dsNhomTB = db.NHOM_THIETBI.Select(a => a.TEN_NHOM)
.ToList()
.Distinct();
ViewBag.MA_NHOMTB = new SelectList(dsNhomTB);
if (!String.IsNullOrEmpty(SAVE))
{
var temp = form["MA_LOAITB"];
if (db.LOAI_THIETBI.FirstOrDefault(a => a.MA_LOAITB == temp) != null)
{
ViewBag.ErrorMessage = "Trùng mã loại thiết bị";
}
else if (ModelState.IsValid)
{
LOAI_THIETBI lOAI_THIETBI = THEM_LOAITB(form);
db.LOAI_THIETBI.Add(lOAI_THIETBI);
await db.SaveChangesAsync();
ViewBag.ErrorMessage = "Thêm thành công";
}
}
else if (!String.IsNullOrEmpty(EDIT))
{
LOAI_THIETBI edit_LOAITB = SUA_LOAITB(form);
if (ModelState.IsValid)
{
db.Entry(edit_LOAITB).State = EntityState.Modified;
await db.SaveChangesAsync();
ViewBag.ErrorMessage = "Sửa thành công";
}
}
return(View(await db.LOAI_THIETBI.Include(l => l.NHOM_THIETBI).ToListAsync()));
}
public async Task <ActionResult> Create([Bind(Include = "MA_LOAITB,TEN_LOAI,MA_NHOMTB,GHI_CHU")] LOAI_THIETBI loai_thietbi, FormCollection form)
{
if (db.LOAI_THIETBI.Count(a => a.MA_LOAITB == loai_thietbi.MA_LOAITB) > 0)
{
return(new HttpStatusCodeResult(404, "Trùng mã loại thiết bị"));
}
else if (ModelState.IsValid)
{
loai_thietbi.MA_NHOMTB = (from m in db.NHOM_THIETBI
where m.TEN_NHOM == loai_thietbi.MA_NHOMTB
select m.MA_NHOMTB).First();
db.LOAI_THIETBI.Add(loai_thietbi);
await db.SaveChangesAsync();
}
return(RedirectToAction("Index"));
//ViewBag.MA_NHOMTB = new SelectList(db.NHOM_THIETBI, "MA_NHOMTB", "TEN_NHOM", loai_thietbi.MA_NHOMTB);
//return View(loai_thietbi);
}
