//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)); }