// Hàm thêm trọng tài vào database
public static void ThemTrongTai(TRONGTAI a_NewTrongTai)
{
using (MyDatabaseQLDBDataContext db = new MyDatabaseQLDBDataContext())
{
db.TRONGTAIs.InsertOnSubmit(a_NewTrongTai);
db.SubmitChanges();
}
}
public ActionResult DeleteConfirmed(string id)
{
TRONGTAI tRONGTAI = db.TRONGTAIs.Find(id);
db.TRONGTAIs.Remove(tRONGTAI);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "MaTrongTai,TenTrongTai,QuocTich")] TRONGTAI tRONGTAI)
{
if (ModelState.IsValid)
{
db.Entry(tRONGTAI).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tRONGTAI));
}
public ActionResult Edit([Bind(Include = "IDTRONGTAI,TENTRONGTAI,EMAIL,SDT")] TRONGTAI tRONGTAI)
{
if (ModelState.IsValid)
{
db.Entry(tRONGTAI).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tRONGTAI));
}
public ActionResult Create([Bind(Include = "MaTrongTai,TenTrongTai,QuocTich")] TRONGTAI tRONGTAI)
{
if (ModelState.IsValid)
{
db.TRONGTAIs.Add(tRONGTAI);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tRONGTAI));
}
public ActionResult Create([Bind(Include = "IDTRONGTAI,TENTRONGTAI,EMAIL,SDT")] TRONGTAI tRONGTAI)
{
if (ModelState.IsValid)
{
db.TRONGTAIs.Add(tRONGTAI);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tRONGTAI));
}
public static void ChinhSuaTrongTai(V_TRONGTAI a_TrongTai)
{
TRONGTAI tt = new TRONGTAI();
tt.MATT = a_TrongTai.m_MaTrongTai;
tt.HOTEN = a_TrongTai.m_HoTen;
tt.NGAYSINH = a_TrongTai.m_NgaySinh;
tt.DIACHI = a_TrongTai.m_DiaChi;
tt.QUOCTICH = a_TrongTai.m_QuocTich;
tt.SONAMKINHNGHIEM = (byte)a_TrongTai.m_SoNamKinhNghiem;
tt.AVATAR = a_TrongTai.m_AVT;
tt.LOAITRONGTAI = a_TrongTai.m_LoaiTrongTai;
Database.DB_UPDATE.ChinhSuaTrongTai(tt);
}
// GET: TrongTai/Delete/5
public ActionResult Delete(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TRONGTAI tRONGTAI = db.TRONGTAIs.Find(id);
if (tRONGTAI == null)
{
return(HttpNotFound());
}
return(View(tRONGTAI));
}
public static void XoaTrongTai(string a_MaTrongTai)
{
using (MyDatabaseQLDBDataContext db = new MyDatabaseQLDBDataContext())
{
var tdtt = (from n in db.TRANDAU_TRONGTAIs
where n.MATT == a_MaTrongTai
select n);
TRONGTAI tt = (from n in db.TRONGTAIs
where n.MATT == a_MaTrongTai
select n).FirstOrDefault();
foreach (TRANDAU_TRONGTAI tdttt in tdtt)
{
db.TRANDAU_TRONGTAIs.DeleteOnSubmit(tdttt);
db.SubmitChanges();
}
if (tt != null)
{
db.TRONGTAIs.DeleteOnSubmit(tt);
db.SubmitChanges();
}
}
}
// Thêm trọng tài (hàm này sẽ được gói bên phía Views, truyền vào các tham số ở màn hình đó)
public static bool ThemTrongTai(V_TRONGTAI a_TrongTai)
{
// Sau khi kiểm tra ổn thỏa trọng tài hợp lệ thì nhét vào db.
TRONGTAI newTrongTai = new TRONGTAI
{
MATT = a_TrongTai.m_MaTrongTai,
HOTEN = a_TrongTai.m_HoTen,
NGAYSINH = a_TrongTai.m_NgaySinh,
DIACHI = a_TrongTai.m_DiaChi,
QUOCTICH = a_TrongTai.m_QuocTich,
SONAMKINHNGHIEM = (byte)a_TrongTai.m_SoNamKinhNghiem,
LOAITRONGTAI = a_TrongTai.m_LoaiTrongTai,
AVATAR = a_TrongTai.m_AVT,
};
// Kiểm tra và thêm vào db
if (DB_QUERY.TimTrongTai(a_TrongTai.m_MaTrongTai) == false)
{
Database.DB_INSERTING.ThemTrongTai(newTrongTai);
return(true);
}
return(false);
}
public static bool ChinhSuaTrongTai(TRONGTAI a_TrongTai)
{
using (MyDatabaseQLDBDataContext db = new MyDatabaseQLDBDataContext())
{
var Query = from n in db.TRONGTAIs
where n.MATT == a_TrongTai.MATT
select n;
foreach (var n in Query)
{
n.MATT = a_TrongTai.MATT;
n.HOTEN = a_TrongTai.HOTEN;
n.NGAYSINH = a_TrongTai.NGAYSINH;
n.DIACHI = a_TrongTai.DIACHI;
n.QUOCTICH = a_TrongTai.QUOCTICH;
n.SONAMKINHNGHIEM = a_TrongTai.SONAMKINHNGHIEM;
n.AVATAR = a_TrongTai.AVATAR;
n.LOAITRONGTAI = a_TrongTai.LOAITRONGTAI;
db.SubmitChanges();
return(true);
}
}
return(false);
}
// GET: Admin/TRONGTAIs/Delete/5
public ActionResult Delete(int?id)
{
TRONGTAI tRONGTAI = db.TRONGTAIs.Find(id);
return(View(tRONGTAI));
}
