public static void updateBanThang(BANTHANG banThang)
{
string ThoiDiem = banThang.ThoiDiem.ToString("c");
SqlConnection conn = DatabaseManager.Instance.getConnection();
string queryString = "UPDATE BANTHANG SET MaCauThu = @MaCauThu, MaLoaiBanThang = @MaLoaiBanThang, ThoiDiem = @ThoiDiem, MaTranDau = @MaTranDau WHERE MaBanThang = @MaBanThang";
SqlCommand command = new SqlCommand(queryString);
try
{
command.Parameters.AddWithValue("@MaCauThu", banThang.MaCauThu);
command.Parameters.AddWithValue("@MaLoaiBanThang", banThang.MaLoaiBanThang);
command.Parameters.AddWithValue("@ThoiDiem", ThoiDiem);
command.Parameters.AddWithValue("@MaTranDau", banThang.MaTranDau);
command.Parameters.AddWithValue("@MaBanThang", banThang.MaBanThang);
command.Connection = conn;
int res = command.ExecuteNonQuery();
if (res == 0)
{
throw new Exception("Cannot update Goal!");
}
}
catch (SqlException SQLex)
{
throw SQLex;
}
catch (Exception ex)
{
throw ex;
}
}
public static void createBanThang(BANTHANG banThang)
{
string ThoiDiem = banThang.ThoiDiem.ToString("c");
SqlConnection conn = DatabaseManager.Instance.getConnection();
string queryString = "INSERT INTO BANTHANG Values (NEWID(),@MaCauThu,@MaLoaiBanThang,@ThoiDiem,@MaTranDau)";
SqlCommand command = new SqlCommand(queryString);
try
{
command.Parameters.AddWithValue("@MaCauThu", banThang.MaCauThu);
command.Parameters.AddWithValue("@MaLoaiBanThang", banThang.MaLoaiBanThang);
command.Parameters.AddWithValue("@ThoiDiem", ThoiDiem);
command.Parameters.AddWithValue("@MaTranDau", banThang.MaTranDau);
command.Connection = conn;
int res = command.ExecuteNonQuery();
if (res == 0)
{
throw new Exception("Cannot insert New Goal!");
}
}
catch (SqlException SQLex)
{
throw SQLex;
}
catch (Exception ex)
{
throw ex;
}
}
private void suaBanThang_Click(object sender, EventArgs e)
{
if (suaBanThang.Text.Equals("Sửa"))
{
if (danhSachGhiBanData.SelectedCells.Count == 0 || danhSachGhiBanData.SelectedCells[0].RowIndex < 0)
{
MessageBox.Show("Xin hãy chọn thông tin 1 bàn thắng trong bảng để chỉnh sửa", "Thông báo");
return;
}
else
{
BANTHANG banThang;
selectedGoalId = danhSachGhiBanData.SelectedCells[0].OwningRow.Cells[0].Value.ToString();
try
{
Database.BanThang_DAO.selectBanThang(selectedGoalId, out banThang);
cauThuGhiBanComboBox.SelectedValue = banThang.MaCauThu;
loaiBanThangComboBox.SelectedValue = banThang.MaLoaiBanThang;
phutGhiBan.Value = banThang.ThoiDiem.Hours * 60 + banThang.ThoiDiem.Minutes;
giayGhiBan.Value = banThang.ThoiDiem.Seconds;
xoaBanThang.Text = "Hủy";
suaBanThang.Text = "Lưu";
themBanThang.Enabled = false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Lỗi xảy ra");
}
}
}
else if (suaBanThang.Text.Equals("Lưu"))
{
//check for database inconsitency (if server wont handle)
//update goal infotry
try
{
BANTHANG banThang = new BANTHANG()
{
MaBanThang = selectedGoalId,
MaCauThu = cauThuGhiBanComboBox.SelectedValue.ToString(),
MaLoaiBanThang = loaiBanThangComboBox.SelectedValue.ToString(),
ThoiDiem = new TimeSpan(0, Int16.Parse(phutGhiBan.Value.ToString()), Int16.Parse(giayGhiBan.Value.ToString())),
MaTranDau = GlobalState.selectedMatchId
};
Database.BanThang_DAO.updateBanThang(banThang);
MessageBox.Show("Cập nhật thành công", "Thông báo");
banThangExtTableAdapter.Fill(quanLyGiaiVoDichDataSet.BanThangExt);
selectedGoalId = "";
xoaBanThang.Text = "Xóa";
suaBanThang.Text = "Sửa";
themBanThang.Enabled = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Lỗi xảy ra");
}
}
}
// Hàm thêm bàn thấng vào database
public static void ThemBanThang(BANTHANG a_BanThang)
{
using (MyDatabaseQLDBDataContext db = new MyDatabaseQLDBDataContext())
{
db.BANTHANGs.InsertOnSubmit(a_BanThang);
db.SubmitChanges();
}
}
public ActionResult DeleteConfirmed(string id)
{
BANTHANG bANTHANG = db.BANTHANGs.Find(id);
db.BANTHANGs.Remove(bANTHANG);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "MaLoaiBanThang,BanThang1")] BANTHANG bANTHANG)
{
if (ModelState.IsValid)
{
db.Entry(bANTHANG).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bANTHANG));
}
public ActionResult Create([Bind(Include = "MaLoaiBanThang,BanThang1")] BANTHANG bANTHANG)
{
if (ModelState.IsValid)
{
db.BANTHANGs.Add(bANTHANG);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bANTHANG));
}
// Thêm dữ liệu bàn thắng vào db
public static void ThemBanThang(V_BANTHANG a_BanThang)
{
BANTHANG bt = new BANTHANG
{
MACT = a_BanThang.m_MACT,
MADB = a_BanThang.m_MADB,
MATD = a_BanThang.m_MATD,
PHUTGHIBAN = (byte)a_BanThang.m_PHUTGHIBAN,
LOAIBT = a_BanThang.m_LOAIBANTHANG,
};
Database.DB_INSERTING.ThemBanThang(bt);
}
// GET: BanThang/Delete/5
public ActionResult Delete(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BANTHANG bANTHANG = db.BANTHANGs.Find(id);
if (bANTHANG == null)
{
return(HttpNotFound());
}
return(View(bANTHANG));
}
private void themBanThang_Click(object sender, EventArgs e)
{
int minutes = Int16.Parse(phutGhiBan.Value.ToString());
int second = Int16.Parse(giayGhiBan.Value.ToString());
TimeSpan time = new TimeSpan(0, minutes, second);
string timeString = time.ToString();
bool checkComboBox = (doiGhiBanComboBox.Text == "");
bool checkTimeEvent = checkTime(timeString, danhSachGhiBanData, 4);
if (checkComboBox && checkTimeEvent)
{
MessageBox.Show("Hãy chọn đội bóng!");
}
else
if ((!checkTimeEvent && checkComboBox) || (!checkComboBox && !checkTimeEvent))
{
MessageBox.Show("Thời điểm đã trùng");
}
else
{
try
{
BANTHANG banThang = new BANTHANG()
{
MaCauThu = cauThuGhiBanComboBox.SelectedValue.ToString(),
MaLoaiBanThang = loaiBanThangComboBox.SelectedValue.ToString(),
ThoiDiem = new TimeSpan(0, Int16.Parse(phutGhiBan.Value.ToString()), Int16.Parse(giayGhiBan.Value.ToString())),
MaTranDau = GlobalState.selectedMatchId
};
Database.BanThang_DAO.createBanThang(banThang);
this.banThangExtTableAdapter.Fill(this.quanLyGiaiVoDichDataSet.BanThangExt);
MessageBox.Show("Thêm thành công", "Thông báo");
//TODO: update game score
int tiSoNha; int tiSoKhach;
Database.TranDau_DAO.loadTiSoTranDau(GlobalState.selectedMatchId, out tiSoNha, out tiSoKhach);
tiSoDoiNha.Text = tiSoNha.ToString();
tiSoDoiKhach.Text = tiSoKhach.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Lỗi xảy ra");
}
}
}
public static void selectBanThang(string MaBanThang, out BANTHANG banThang)
{
SqlConnection conn = DatabaseManager.Instance.getConnection();
string queryString = "SELECT MaCauThu, MaLoaiBanThang, ThoiDiem FROM BANTHANG WHERE MaBanThang = @MaBanThang";
SqlCommand command = new SqlCommand(queryString);
banThang = new BANTHANG()
{
MaBanThang = MaBanThang,
MaCauThu = "",
MaLoaiBanThang = "",
ThoiDiem = new TimeSpan(0)
};
try
{
command.Parameters.AddWithValue("@MaBanThang", MaBanThang);
command.Connection = conn;
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
banThang.MaCauThu = reader.GetString(0);
banThang.MaLoaiBanThang = reader.GetString(1);
banThang.ThoiDiem = reader.GetTimeSpan(2);
}
reader.Close();
}
catch (SqlException SQLex)
{
throw SQLex;
}
catch (Exception ex)
{
throw ex;
}
}
