public ActionResult Create([Bind(Include = "ID,MaLoaiVeSo,MaGiai,NgaySo,SoTrung,Flag")] KetQuaSoXo ketQuaSoXo)
{
if (ModelState.IsValid)
{
var tran = db.Database.BeginTransaction();
try
{
ketQuaSoXo.Flag = true;
TempData["notice"] = "Successfully create";
TempData["makqsx"] = ketQuaSoXo.ID.ToString();
db.KetQuaSoXoes.Add(ketQuaSoXo);
db.SaveChanges();
tran.Commit();
}
catch
{
tran.Rollback();
}
tran.Dispose();
return(RedirectToAction("Index"));
}
ViewBag.MaGiai = new SelectList(db.Giais, "MaGiai", "TenGiai", ketQuaSoXo.MaGiai);
ViewBag.MaLoaiVeSo = new SelectList(db.LoaiVesoes, "MaLoaiVeSo", "Tinh", ketQuaSoXo.MaLoaiVeSo);
return(View(ketQuaSoXo));
}
public ActionResult DeleteConfirmed(int id)
{
KetQuaSoXo ketQuaSoXo = db.KetQuaSoXoes.Find(id);
db.KetQuaSoXoes.Remove(ketQuaSoXo);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult ThemMoi(KetQuaSoXo _KetQuaSoXo)
{
ViewBag.MaGiai = new SelectList(db.Giais.ToList().OrderBy(n => n.TenGiai), "MaGiai", "TenGiai");
ViewBag.MaLoaiVeSo = new SelectList(db.LoaiVesoes.ToList().OrderBy(n => n.Tinh), "MaLoaiVeSo", "Tinh");
db.KetQuaSoXoes.Add(_KetQuaSoXo);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: Admin/KetQuaSoXoes/Create
public ActionResult Create()
{
ViewBag.MaGiai = new SelectList(db.Giais, "MaGiai", "TenGiai");
ViewBag.MaLoaiVeSo = new SelectList(db.LoaiVesoes, "MaLoaiVeSo", "Tinh");
KetQuaSoXo a = new KetQuaSoXo();
a.ID = getMaDL();
return(View(a));
}
public ActionResult DeleteConfirmed(string id)
{
KetQuaSoXo ketQuaSoXo = db.KetQuaSoXo.Find(id);
ketQuaSoXo.Flag = false;
db.Entry(ketQuaSoXo).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
public ActionResult Xoa(int _ID)
{
KetQuaSoXo kqxs = db.KetQuaSoXoes.SingleOrDefault(n => n.ID == _ID);
if (kqxs == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(kqxs));
}
public ActionResult ChinhSua(KetQuaSoXo _KetQuaSoXo)
{
ViewBag.MaGiai = new SelectList(db.Giais.ToList().OrderBy(n => n.TenGiai), "MaGiai", "TenGiai", _KetQuaSoXo.MaGiai);
ViewBag.MaLoaiVeSo = new SelectList(db.LoaiVesoes.ToList().OrderBy(n => n.Tinh), "MaLoaiVeSo", "Tinh", _KetQuaSoXo.MaLoaiVeSo);
if (!ModelState.IsValid)
{
return(View());
}
db.Entry(_KetQuaSoXo).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ID,MaLoaiVeSo,MaGiai,NgaySo,SoTrung,Flag")] KetQuaSoXo ketQuaSoXo)
{
if (ModelState.IsValid)
{
db.Entry(ketQuaSoXo).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaGiai = new SelectList(db.Giais, "MaGiai", "TenGiai", ketQuaSoXo.MaGiai);
ViewBag.MaLoaiVeSo = new SelectList(db.LoaiVesoes, "MaLoaiVeSo", "Tinh", ketQuaSoXo.MaLoaiVeSo);
return(View(ketQuaSoXo));
}
public ActionResult ChinhSua(int _ID)
{
KetQuaSoXo kqxs = db.KetQuaSoXoes.SingleOrDefault(n => n.ID == _ID);
if (kqxs == null)
{
Response.StatusCode = 404;
return(null);
}
ViewBag.MaGiai = new SelectList(db.Giais.ToList().OrderBy(n => n.TenGiai), "MaGiai", "TenGiai", kqxs.MaGiai);
ViewBag.MaLoaiVeSo = new SelectList(db.LoaiVesoes.ToList().OrderBy(n => n.Tinh), "MaLoaiVeSo", "Tinh", kqxs.MaLoaiVeSo);
return(View(kqxs));
}
// GET: KetQuaSoXoes/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
KetQuaSoXo ketQuaSoXo = db.KetQuaSoXo.Find(id);
if (ketQuaSoXo == null)
{
return HttpNotFound();
}
return View(ketQuaSoXo);
}
public ActionResult XacNhanXoa(int _ID)
{
KetQuaSoXo kqxs = db.KetQuaSoXoes.SingleOrDefault(n => n.ID == _ID);
if (kqxs == null)
{
Response.StatusCode = 404;
return(null);
}
db.KetQuaSoXoes.Remove(kqxs);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: Admin/KetQuaSoXoes/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
KetQuaSoXo ketQuaSoXo = db.KetQuaSoXoes.Find(id);
if (ketQuaSoXo == null)
{
return(HttpNotFound());
}
return(View(ketQuaSoXo));
}
public ActionResult Edit([Bind(Include = "ID,MaLoaiVeSo,MaGiai,NgaySo,SoTrung")] KetQuaSoXo ketQuaSoXo)
{
if (ModelState.IsValid)
{
TempData["notice"] = "Successfully edit";
TempData["tensanpham"] = ketQuaSoXo.ID;
ketQuaSoXo.Flag = true;
db.Entry(ketQuaSoXo).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ketQuaSoXo));
}
// GET: KetQuaSoXoes/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
KetQuaSoXo ketQuaSoXo = db.KetQuaSoXo.Find(id);
if (ketQuaSoXo == null)
{
return HttpNotFound();
}
ViewBag.MaGiai = new SelectList(db.Giai, "MaGiai", "TenGiai", ketQuaSoXo.MaGiai);
ViewBag.MaLoaiVeSo = new SelectList(db.LoaiVeso, "MaLoaiVeSo", "Tinh", ketQuaSoXo.MaLoaiVeSo);
return View(ketQuaSoXo);
}
public bool Update(KetQuaSoXo kq)
{
try
{
var tempt = db.KetQuaSoXoes.Find(kq.ID);
tempt.MaLoaiVeSo = kq.MaLoaiVeSo;
tempt.MaGiai = kq.MaGiai;
tempt.SoTrung = kq.SoTrung;
tempt.NgaySo = kq.NgaySo;
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public ActionResult Edit(KetQuaSoXo kq)
{
if (ModelState.IsValid)
{
var dao = new KetQuaDao();
kq.Flag = true;
var result = dao.Update(kq);
if (result)
{
return(RedirectToAction("Index", "KetQua"));
}
}
else
{
ModelState.AddModelError("", "Chỉnh sửa giải không thành công");
}
return(View("Index"));
}
public ActionResult Create([Bind(Include = "MaKetQua,MaLoaiVeSo,MaGiai,NgaySo,SoTrung,Flag")] KetQuaSoXo ketQuaSoXo)
{
if (ModelState.IsValid)
{
var dal = new KetQuaSoXo_DAL();
ketQuaSoXo.MaKetQua = dal.AutoID();
ketQuaSoXo.Flag = true;
db.KetQuaSoXo.Add(ketQuaSoXo);
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.MaGiai = new SelectList(db.Giai, "MaGiai", "TenGiai", ketQuaSoXo.MaGiai);
ViewBag.MaLoaiVeSo = new SelectList(db.LoaiVeso, "MaLoaiVeSo", "Tinh", ketQuaSoXo.MaLoaiVeSo);
return View(ketQuaSoXo);
}
public int Insert(KetQuaSoXo entity)
{
db.KetQuaSoXoes.Add(entity);
db.SaveChanges();
return(entity.ID);
}
