//sua
public bool upTHONGKECT(DTO_THONGKECT d)
{
try
{
connect.Open();
string sql = string.Format("UPDATE THONGKECT SET BanThang={0}, TheVang={1}, TheDo={2} WHERE MaGiai='{3}' AND MaDoi='{4}' AND HoTenCT=N'{5}' AND SoAo={6}", d.BanThang, d.TheVang, d.TheDo, d.MaGiai, d.MaDoi, d.HoTenCT, d.SoAo);
SqlCommand cmd = new SqlCommand(sql, connect);
//kiem tra
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
}
catch (Exception e) { }
finally
{
connect.Close();
}
return(false);
}
//xoa
public bool delTHONGKECT(DTO_THONGKECT d)
{
try
{
connect.Open();
string sql = string.Format("DELETE FROM THONGKECT WHERE MaGiai='{0}'", d.MaGiai);
SqlCommand cmd = new SqlCommand(sql, connect);
//kiem tra
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
}
catch (Exception e) { }
finally
{
connect.Close();
}
return(false);
}
//them
public bool addTHONGKECT(DTO_THONGKECT d)
{
try
{
connect.Open();
string sql = string.Format("INSERT INTO THONGKECT(MaGiai,MaDoi,HoTenCT,SoAo,BanThang,TheVang,TheDo) VALUES ('{0}','{1}',N'{2}','{3}','{4}','{5}','{6}')", d.MaGiai, d.MaDoi, d.HoTenCT, d.SoAo, d.BanThang, d.TheVang, d.TheDo);
SqlCommand cmd = new SqlCommand(sql, connect);
//kiem tra
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
}
catch (Exception e) { }
finally
{
//close connect
connect.Close();
}
return(false);
}
private void btnChon_Click(object sender, EventArgs e)
{
dtaTime.Enabled = true;
dtaTime.ColumnHeadersDefaultCellStyle.ForeColor = Color.Orange;
dtaTime.RowsDefaultCellStyle.ForeColor = Color.Purple;
cboGiai.ValueMember = "MaGiai";
cboChon.ValueMember = "SoAo";
switch (lblChon.Text)
{
case "Ghi bàn đội 1":
string mag = (string)cboGiai.SelectedValue;
DTO_THONGKECT dtotk = new DTO_THONGKECT(mag, madoi, cboChon.Text, (int)cboChon.SelectedValue, (int)numChon.Value, null, null);
DataTable t = tk.getEmpty(mag, madoi);
if (t.Rows.Count > 0)
{
tk.upTHONGKECT(dtotk);
}
else
{
tk.addTHONGKECT(dtotk);
}
break;
case "Ghi bàn đội 2":
mag = (string)cboGiai.SelectedValue;
dtotk = new DTO_THONGKECT(mag, madoi, cboChon.Text, (int)cboChon.SelectedValue, (int)numChon.Value, null, null);
t = tk.getEmpty(mag, madoi);
if (t.Rows.Count > 0)
{
tk.upTHONGKECT(dtotk);
}
else
{
tk.addTHONGKECT(dtotk);
}
break;
case "Thẻ vàng đội 1":
mag = (string)cboGiai.SelectedValue;
dtotk = new DTO_THONGKECT(mag, madoi, cboChon.Text, (int)cboChon.SelectedValue, (int)numChon.Value, null, null);
t = tk.getEmpty(mag, madoi);
if (t.Rows.Count > 0)
{
tk.upTHONGKECT(dtotk);
}
else
{
tk.addTHONGKECT(dtotk);
}
break;
case "Thẻ vàng đội 2":
mag = (string)cboGiai.SelectedValue;
dtotk = new DTO_THONGKECT(mag, madoi, cboChon.Text, (int)cboChon.SelectedValue, (int)numChon.Value, null, null);
t = tk.getEmpty(mag, madoi);
if (t.Rows.Count > 0)
{
tk.upTHONGKECT(dtotk);
}
else
{
tk.addTHONGKECT(dtotk);
}
break;
case "Thẻ đỏ đội 1":
mag = (string)cboGiai.SelectedValue;
dtotk = new DTO_THONGKECT(mag, madoi, cboChon.Text, (int)cboChon.SelectedValue, (int)numChon.Value, null, null);
t = tk.getEmpty(mag, madoi);
if (t.Rows.Count > 0)
{
tk.upTHONGKECT(dtotk);
}
else
{
tk.addTHONGKECT(dtotk);
}
break;
case "Thẻ đỏ đội 2":
mag = (string)cboGiai.SelectedValue;
dtotk = new DTO_THONGKECT(mag, madoi, cboChon.Text, (int)cboChon.SelectedValue, (int)numChon.Value, null, null);
t = tk.getEmpty(mag, madoi);
if (t.Rows.Count > 0)
{
tk.upTHONGKECT(dtotk);
}
else
{
tk.addTHONGKECT(dtotk);
}
break;
}
hide();
}
public bool delTHONGKECT(DTO_THONGKECT g)
{
return(dalTHONGKECT.delTHONGKECT(g));
}
public bool upTHONGKECT(DTO_THONGKECT g)
{
return(dalTHONGKECT.upTHONGKECT(g));
}
public bool addTHONGKECT(DTO_THONGKECT g)
{
return(dalTHONGKECT.addTHONGKECT(g));
}
