private void Form1_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'vUGDataSet13.Transfer' table. You can move, or remove it, as needed.
this.transferTableAdapter1.Fill(this.vUGDataSet13.Transfer);
// TODO: This line of code loads data into the 'vUGDataSet12.Transfer' table. You can move, or remove it, as needed.
// this.transferTableAdapter.Fill(this.vUGDataSet12.Transfer);
// TODO: This line of code loads data into the 'vUGDataSet11.Coach' table. You can move, or remove it, as needed.
this.coachTableAdapter.Fill(this.vUGDataSet11.Coach);
// TODO: This line of code loads data into the 'vUGDataSet10.Team' table. You can move, or remove it, as needed.
this.teamTableAdapter.Fill(this.vUGDataSet10.Team);
// TODO: This line of code loads data into the 'vUGDataSet9.Penance' table. You can move, or remove it, as needed.
// this.penanceTableAdapter.Fill(this.vUGDataSet9.Penance);
// TODO: This line of code loads data into the 'vUGDataSet8.LichThiDauVong4' table. You can move, or remove it, as needed.
this.lichThiDauVong4TableAdapter.Fill(this.vUGDataSet8.LichThiDauVong4);
// TODO: This line of code loads data into the 'vUGDataSet7.LichThiDauVong3' table. You can move, or remove it, as needed.
this.lichThiDauVong3TableAdapter.Fill(this.vUGDataSet7.LichThiDauVong3);
// TODO: This line of code loads data into the 'vUGDataSet6.LichThiDauVong2' table. You can move, or remove it, as needed.
this.lichThiDauVong2TableAdapter.Fill(this.vUGDataSet6.LichThiDauVong2);
// TODO: This line of code loads data into the 'vUGDataSet5.LichThiDauVong1' table. You can move, or remove it, as needed.
this.lichThiDauVong1TableAdapter.Fill(this.vUGDataSet5.LichThiDauVong1);
// TODO: This line of code loads data into the 'vUGDataSet.Fotball_Player' table. You can move, or remove it, as needed.
this.fotball_PlayerTableAdapter.Fill(this.vUGDataSet.Fotball_Player);
// TODO: This line of code loads data into the 'vUGDataSet2.Coach' table. You can move, or remove it, as needed.
// this.coachTableAdapter.Fill(this.vUGDataSet2.Coach);
// TODO: This line of code loads data into the 'vUGDataSet1.Team' table. You can move, or remove it, as needed.
// this.teamTableAdapter.Fill(this.vUGDataSet1.Team);
dataGridView2.DataSource = Fotball_Player_BUS.LoadDanhSachTatCaCauThu();
}
private void btnDEL_Click(object sender, EventArgs e)
{
string id_fp = tbMaCauThu.Text.ToString();
Fotball_Player_BUS.XoaCauThu(id_fp);
dataGridView1.DataSource = Fotball_Player_BUS.LoadDanhSachTatCaCauThu();
}
private void btnUPDATE_Click(object sender, EventArgs e)
{
string ID_FP = tbMaCauThu.Text.ToString();
string Team_ID = tbTeam.Text;
string FP_FirstName = tbFirst_Name.Text;
string FP_LastName = tbFP_LastName.Text;
string Date_of_Birth_FP = "";
string Country = "VietNam";
string job = tbjob.Text.ToString();
Fotball_Player_BUS.CapNhapCauThu(ID_FP, Team_ID, FP_FirstName, FP_LastName, Date_of_Birth_FP, Country, job);
dataGridView1.DataSource = Fotball_Player_BUS.TimKiemCauThuTheoMaCauThu(ID_FP);
}
private void btnADD_Click(object sender, EventArgs e)
{
//String ID_FP = tbID_FP.Text.ToString();
string Team_ID = tbTeam.Text;
string FP_FirstName = tbFirst_Name.Text;
string FP_LastName = tbFP_LastName.Text;
string Date_of_Birth_FP = "";
string Country = "VietNam";
string job = tbjob.Text.ToString();
Fotball_Player_BUS.ThemCauThu(Team_ID, FP_FirstName, FP_LastName, Date_of_Birth_FP, Country, job);
dataGridView1.DataSource = Fotball_Player_BUS.TimKiemTheoTenCauThu(tbFP_LastName.Text.ToString());
}
private void btSearch_Click(object sender, EventArgs e)
{
//tim theo ma doi
if (cbMaDoi.Checked)
{
dataGridView2.DataSource = Team_BUS.TimKiemDoiTuyenTheoMaDoi(tbSearch.Text.ToString());
}
else
//tim kiem theo ten doi
if (cbTenĐoi.Checked)
{
dataGridView2.DataSource = Team_BUS.TimKiemTheoTenDoi(tbSearch.Text.ToString());
}
else
if (cbMaCauThu.Checked)
{
dataGridView2.DataSource = Fotball_Player_BUS.TimKiemCauThuTheoMaCauThu(tbSearch.Text.ToString());
}
else
if (cbCauThu.Checked)
{
dataGridView2.DataSource = Fotball_Player_BUS.TimKiemTheoTenCauThu(tbSearch.Text.ToString());
}
}
private void bntLoadDSCauThu_Click(object sender, EventArgs e)
{
dataGridView2.DataSource = Fotball_Player_BUS.LoadDanhSachTatCaCauThu();
}
private void btSearch2_Click(object sender, EventArgs e)
{
dataGridView2.DataSource = Fotball_Player_BUS.TimKiemTheoTenDoiTuyenVaTenCauThu(tbTenDoiHiden.Text.ToString(), tbTenCauThuHiden.Text.ToString());
}
