public static void selectMuaGiai(string MaMuaGiai, out MUAGIAI muagiai)
{
SqlConnection conn = DatabaseManager.Instance.getConnection();
string queryString = "SELECT TenMuaGiai, TrangThai FROM MUAGIAI WHERE MaMuaGiai = @MaMuaGiai";
SqlCommand command = new SqlCommand(queryString);
muagiai = new MUAGIAI()
{
MaMuaGiai = MaMuaGiai,
TenMuaGiai = "",
TrangThai = 0,
};
try
{
command.Parameters.AddWithValue("@MaMuaGiai", MaMuaGiai);
command.Connection = conn;
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
muagiai.TenMuaGiai = reader.GetString(0);
muagiai.TrangThai = reader.GetInt32(1);
}
reader.Close();
}
catch (SqlException SQLex)
{
throw SQLex;
}
catch (Exception ex)
{
throw ex;
}
}
public static void updateMuaGiai(MUAGIAI muagiai)
{
SqlConnection conn = DatabaseManager.Instance.getConnection();
string queryString = "UPDATE MUAGIAI SET TenMuaGiai = @TenMuaGiai, TrangThai = @TrangThai WHERE MaMuaGiai = @MaMuaGiai";
SqlCommand command = new SqlCommand(queryString);
try
{
command.Parameters.AddWithValue("@TenMuaGiai", muagiai.TenMuaGiai);
command.Parameters.AddWithValue("@TrangThai", muagiai.TrangThai);
command.Parameters.AddWithValue("@MaMuaGiai", muagiai.MaMuaGiai);
command.Connection = conn;
int res = command.ExecuteNonQuery();
if (res == 0)
{
throw new Exception();
}
}
catch (SqlException SQLex)
{
throw SQLex;
}
catch (Exception ex)
{
throw ex;
}
}
public static string queryMaMuaGiai(MUAGIAI muagiai)
{
SqlConnection conn = DatabaseManager.Instance.getConnection();
string queryString = "SELECT MaMuaGiai FROM MUAGIAI WHERE TenMuaGiai = @TenMuaGiai AND TrangThai = @TrangThai";
SqlCommand command = new SqlCommand(queryString);
string result = "";
try
{
command.Parameters.AddWithValue("@TenMuaGiai", muagiai.TenMuaGiai);
command.Parameters.AddWithValue("@TrangThai", muagiai.TrangThai);
command.Connection = conn;
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
result = reader.GetString(0);
}
reader.Close();
}
catch (SqlException SQLex)
{
throw SQLex;
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public static void createMuaGiai(MUAGIAI muagiai)
{
SqlConnection conn = DatabaseManager.Instance.getConnection();
string queryString = "INSERT INTO MUAGIAI Values (NEWID(), @TenMuaGiai, @TrangThai)";
SqlCommand command = new SqlCommand(queryString);
try
{
command.Parameters.AddWithValue("@TenMuaGiai", muagiai.TenMuaGiai);
command.Parameters.AddWithValue("@TrangThai", 0);
command.Connection = conn;
int res = command.ExecuteNonQuery();
if (res == 0)
{
throw new Exception();
}
}
catch (SqlException SQLex)
{
throw SQLex;
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult DeleteConfirmed(string id)
{
MUAGIAI mUAGIAI = db.MUAGIAIs.Find(id);
db.MUAGIAIs.Remove(mUAGIAI);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "MaMua,TenMua,NgayBatDau,NgayKetThuc,MaTS,MaTTUT")] MUAGIAI mUAGIAI)
{
if (ModelState.IsValid)
{
db.Entry(mUAGIAI).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaTS = new SelectList(db.THAMSOes, "MaTS", "MaTS", mUAGIAI.MaTS);
return(View(mUAGIAI));
}
// GET: MuaGiai/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MUAGIAI mUAGIAI = db.MUAGIAIs.Find(id);
if (mUAGIAI == null)
{
return(HttpNotFound());
}
return(View(mUAGIAI));
}
// GET: MuaGiai/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MUAGIAI mUAGIAI = db.MUAGIAIs.Find(id);
if (mUAGIAI == null)
{
return(HttpNotFound());
}
ViewBag.MaTS = new SelectList(db.THAMSOes, "MaTS", "MaTS", mUAGIAI.MaTS);
return(View(mUAGIAI));
}
private void KhoiTaoMuaGiaiButton_Click(object sender, EventArgs e)
{
//call data access
try
{
MUAGIAI muagiai = new MUAGIAI()
{
TenMuaGiai = tenMuaGiaTextBox.Text,
TrangThai = 0,
};
Database.MuaGiai_DAO.createMuaGiai(muagiai);
string new_MaMuaGiai = Database.MuaGiai_DAO.queryMaMuaGiai(muagiai);
DIEUKIEN dk = new DIEUKIEN()
{
MaMuaGiai = new_MaMuaGiai,
SoCauThuToiThieu = 11,
SoCauThuToiDa = 40,
TuoiToiDa = 40,
TuoiToiThieu = 18,
SoLanThayNguoiToiDa = 3,
SoCauThuNuocNgoaiToiDa = 3,
DiemSoHoa = 1,
DiemSoThang = 3,
DiemSoThua = 0
};
Database.DieuKien_DAO.createDIEUKIEN(dk);
THUTUUUTIEN thutu = new THUTUUUTIEN()
{
ChiSoUuTien = 1,
MaMuaGiai = new_MaMuaGiai,
TenLoaiUuTien = "Điểm",
};
Database.ThuTuUuTien_DAO.createThuTuUuTien(thutu);
THUTUUUTIEN thutu2 = new THUTUUUTIEN()
{
ChiSoUuTien = 2,
MaMuaGiai = new_MaMuaGiai,
TenLoaiUuTien = "Hiệu Số",
};
Database.ThuTuUuTien_DAO.createThuTuUuTien(thutu2);
THUTUUUTIEN thutu3 = new THUTUUUTIEN()
{
ChiSoUuTien = 3,
MaMuaGiai = new_MaMuaGiai,
TenLoaiUuTien = "Số Bàn Sân Khách",
};
Database.ThuTuUuTien_DAO.createThuTuUuTien(thutu3);
THUTUUUTIEN thutu4 = new THUTUUUTIEN()
{
ChiSoUuTien = 4,
MaMuaGiai = new_MaMuaGiai,
TenLoaiUuTien = "Kết Quả Đối Đầu",
};
Database.ThuTuUuTien_DAO.createThuTuUuTien(thutu4);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Lỗi xảy ra");
}
// Kiểm tra điền đầy đủ thông tin chưa? Nếu đầy đủ thì sẽ tiến thẳng tới màn hình
if (ValidateChildren(ValidationConstraints.Enabled))
{
FirstScreen form = new FirstScreen();
this.Hide();
form.ShowDialog();
}
}
