public static void selectChiTietThayNguoi(string MaThayNguoi, out CHITIETTHAYNGUOI thaynguoi)
{
SqlConnection conn = DatabaseManager.Instance.getConnection();
string queryString = "SELECT MaCauThuVaoSan, MaCauThuRaSan, ThoiDiem FROM CHITIETTHAYNGUOI WHERE MaThayNguoi = @MaThayNguoi";
SqlCommand command = new SqlCommand(queryString);
thaynguoi = new CHITIETTHAYNGUOI()
{
MaThayNguoi = MaThayNguoi
};
try
{
command.Parameters.AddWithValue("@MaThayNguoi", MaThayNguoi);
command.Connection = conn;
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
thaynguoi.MaCauThuVaoSan = reader.GetString(0);
thaynguoi.MaCauThuRaSan = reader.GetString(1);
thaynguoi.ThoiDiem = reader.GetTimeSpan(2);
}
reader.Close();
}
catch (SqlException SQLex)
{
throw SQLex;
}
catch (Exception ex)
{
throw ex;
}
}
public static void updateChiTietThayNguoi(CHITIETTHAYNGUOI thaynguoi)
{
string ThoiDiem = thaynguoi.ThoiDiem.ToString("c");
SqlConnection conn = DatabaseManager.Instance.getConnection();
string queryString = "UPDATE CHITIETTHAYNGUOI SET MaCauThuVaoSan = @MaCauThuVaoSan, MaCauThuRaSan = @MaCauThuRaSan, ThoiDiem = @ThoiDiem, MaTranDau = @MaTranDau WHERE MaThayNguoi = @MaThayNguoi";
SqlCommand command = new SqlCommand(queryString);
try
{
command.Parameters.AddWithValue("@MaThayNguoi", thaynguoi.MaThayNguoi);
command.Parameters.AddWithValue("@MaCauThuVaoSan", thaynguoi.MaCauThuVaoSan);
command.Parameters.AddWithValue("@MaCauThuRaSan", thaynguoi.MaCauThuRaSan);
command.Parameters.AddWithValue("@ThoiDiem", ThoiDiem);
command.Parameters.AddWithValue("@MaTranDau", thaynguoi.MaTranDau);
command.Connection = conn;
int res = command.ExecuteNonQuery();
if (res == 0)
{
throw new Exception();
}
}
catch (SqlException SQLex)
{
throw SQLex;
}
catch (Exception ex)
{
throw ex;
}
}
private void themThayNguoi_Click(object sender, EventArgs e)
{
int minutes = Int16.Parse(phutThayNguoi.Value.ToString());
int second = Int16.Parse(giayThayNguoi.Value.ToString());
TimeSpan time = new TimeSpan(0, minutes, second);
string timeString = time.ToString();
bool checkComboBox = (doiThayNguoiComboBox.Text == "");
bool checkTimeEvent = checkTime(timeString, dataGridView6, 5);
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
{
//Console.WriteLine(cauThuVaoSanComboBox.SelectedValue.ToString());
//Console.WriteLine(cauThuRaSanComboBox.SelectedValue.ToString());
CHITIETTHAYNGUOI thaynguoi = new CHITIETTHAYNGUOI()
{
MaCauThuVaoSan = cauThuVaoSanComboBox.SelectedValue.ToString(),
MaCauThuRaSan = cauThuRaSanComboBox.SelectedValue.ToString(),
ThoiDiem = new TimeSpan(0, Int16.Parse(phutThayNguoi.Value.ToString()), Int16.Parse(giayThayNguoi.Value.ToString())),
MaTranDau = GlobalState.selectedMatchId
};
Database.ChiTietThayNguoi_DAO.createChiTietThayNguoi(thaynguoi);
this.thayNguoiExtTableAdapter.Fill(this.quanLyGiaiVoDichDataSet.ThayNguoiExt);
MessageBox.Show("Thêm thành công", "Thông báo");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Lỗi xảy ra");
}
}
}
private void suaThayNguoi_Click(object sender, EventArgs e)
{
if (suaThayNguoi.Text.Equals("Sửa"))
{
if (dataGridView6.SelectedCells.Count == 0 || dataGridView6.SelectedCells[0].RowIndex < 0)
{
MessageBox.Show("Xin hãy chọn thông tin 1 thay người trong bảng để chỉnh sửa", "Thông báo");
return;
}
else
{
//load change info into the fields
CHITIETTHAYNGUOI thaynguoi;
selectedChangeId = dataGridView6.SelectedCells[0].OwningRow.Cells[0].Value.ToString();
try
{
Database.ChiTietThayNguoi_DAO.selectChiTietThayNguoi(selectedChangeId, out thaynguoi);
cauThuVaoSanComboBox.SelectedValue = thaynguoi.MaCauThuVaoSan;
cauThuRaSanComboBox.SelectedValue = thaynguoi.MaCauThuRaSan;
phutThayNguoi.Value = thaynguoi.ThoiDiem.Hours * 60 + thaynguoi.ThoiDiem.Minutes;
giayThayNguoi.Value = thaynguoi.ThoiDiem.Seconds;
xoaThayNguoi.Text = "Hủy";
suaThayNguoi.Text = "Lưu";
themThayNguoi.Enabled = false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Lỗi xảy ra");
}
}
}
else if (suaThayNguoi.Text.Equals("Lưu"))
{
//check for database inconsitency (if server wont handle)
//update change info
try
{
CHITIETTHAYNGUOI thaynguoi = new CHITIETTHAYNGUOI()
{
MaThayNguoi = selectedChangeId,
MaCauThuVaoSan = cauThuVaoSanComboBox.SelectedValue.ToString(),
MaCauThuRaSan = cauThuRaSanComboBox.SelectedValue.ToString(),
ThoiDiem = new TimeSpan(0, Int16.Parse(phutThayNguoi.Value.ToString()), Int16.Parse(giayThayNguoi.Value.ToString())),
MaTranDau = GlobalState.selectedMatchId
};
Database.ChiTietThayNguoi_DAO.updateChiTietThayNguoi(thaynguoi);
MessageBox.Show("Cập nhật thành công", "Thông báo");
thayNguoiExtTableAdapter.Fill(quanLyGiaiVoDichDataSet.ThayNguoiExt);
selectedChangeId = "";
xoaThayNguoi.Text = "Xóa";
suaThayNguoi.Text = "Sửa";
themThayNguoi.Enabled = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Lỗi xảy ra");
}
}
}