private void ThemLichThiDau_Load(object sender, EventArgs e)
{
QLGVDBDQGEntities qlbd = new QLGVDBDQGEntities();
cBvongDau.DataSource = qlbd.VONGDAUs.ToList();
cBvongDau.DisplayMember = "TenVD";
}
private void btnXacNhan_Click(object sender, EventArgs e)
{
QLGVDBDQGEntities qlbdadd = new QLGVDBDQGEntities();
QLGVDBDQGEntities qlbdadd1 = new QLGVDBDQGEntities();
string madoibong = "";
DOIBONG DB = qlbdadd.DOIBONGs.Where(db => db.MaDB == madoibong).SingleOrDefault();
if (DB == null)
{
DOIBONG item = new DOIBONG();
BANGXEPHANG item1 = new BANGXEPHANG();
item.MaDB = Convert.ToString(tBmaDB.Text);
item.TenDB = Convert.ToString(tBtenDB.Text);
item.SanNha = Convert.ToString(tBsanNha.Text);
item1.MaDB = item.MaDB;
item1.Thang = 0;
item1.Hoa = 0;
item1.Thua = 0;
item1.HieuSo = 0;
item1.Diem = 0;
qlbdadd.DOIBONGs.Add(item);
qlbdadd1.BANGXEPHANGs.Add(item1);
qlbdadd.SaveChanges();
qlbdadd1.SaveChanges();
MessageBox.Show("Đã nhập vào thành công", "Thông báo");
tBmaDB.Text = "DB";
tBtenDB.Text = "";
tBsanNha.Text = "";
ql.xemdulieu();
}
else
{
MessageBox.Show("Vui lòng kiểm tra lại....", "Lỗi");
}
}
private void btnXacNhan_Click(object sender, EventArgs e)
{
QLGVDBDQGEntities qlbdadd = new QLGVDBDQGEntities();
string macauthu = "";
CAUTHU CT = qlbdadd.CAUTHUs.Where(ct => ct.MaCT == macauthu).SingleOrDefault();
if (CT == null)
{
CAUTHU item = new CAUTHU();
item.MaCT = Convert.ToString(tBmaCT.Text);
item.TenCT = Convert.ToString(tBtenCT.Text);
item.NgaySinh = dTPngaySinh.Value.Date;
item.MaLoaiCT = ((LOAICAUTHU)cBloaiCT.SelectedValue).MaLoaiCT;
item.MaDB = ((DOIBONG)cBdoiBong.SelectedValue).MaDB;
qlbdadd.CAUTHUs.Add(item);
qlbdadd.SaveChanges();
MessageBox.Show("Đã nhập vào thành công", "Thông báo");
tBmaCT.Text = "";
tBtenCT.Text = "";
ql.xemdulieu();
}
else
{
MessageBox.Show("Vui lòng kiểm tra lại...", "Lỗi");
}
}
private void ThemCauThu_Load(object sender, EventArgs e)
{
QLGVDBDQGEntities qlbdthemcauthu = new QLGVDBDQGEntities();
cBloaiCT.DataSource = qlbdthemcauthu.LOAICAUTHUs.ToList();
cBloaiCT.DisplayMember = "TenLoaiCT";
cBdoiBong.DataSource = qlbdthemcauthu.DOIBONGs.ToList();
cBdoiBong.DisplayMember = "TenDB";
}
private void QLLichThiDau_Load(object sender, EventArgs e)
{
QLGVDBDQGEntities qlbd = new QLGVDBDQGEntities();
xemdulieu();
changegridview();
cBvongDau.DataSource = qlbd.VONGDAUs.ToList();
cBvongDau.DisplayMember = "TenVD";
}
public void xemdulieu()
{
QLGVDBDQGEntities qlbd = new QLGVDBDQGEntities();
var dsvongdau = from u in qlbd.VONGDAUs select new { MaVD = u.MaVD, TenVD = u.TenVD };
dGVvongDau.DataSource = dsvongdau.ToList();
tBmaVD.DataBindings.Clear();
tBmaVD.DataBindings.Add(new Binding("Text", dGVvongDau.DataSource, "MaVD"));
tBtenVD.DataBindings.Clear();
tBtenVD.DataBindings.Add(new Binding("Text", dGVvongDau.DataSource, "TenVD"));
}
private void cBdoi1_SelectedValueChanged(object sender, EventArgs e)
{
QLGVDBDQGEntities qlbd = new QLGVDBDQGEntities();
foreach (var item in qlbd.DOIBONGs)
{
if (((DOIBONG)cBdoi1.SelectedValue).MaDB == item.MaDB)
{
tBsanThiDau.Text = item.SanNha;
}
}
}
public void xemdulieu()
{
QLGVDBDQGEntities qlbd = new QLGVDBDQGEntities();
var dsdoibong = from u in qlbd.DOIBONGs select new { MaDB = u.MaDB, TenDB = u.TenDB, SanNha = u.SanNha };
dGVdoiBong.DataSource = dsdoibong.ToList();
tBmaDB.DataBindings.Clear();
tBmaDB.DataBindings.Add(new Binding("Text", dGVdoiBong.DataSource, "MaDB"));
tBtenDB.DataBindings.Clear();
tBtenDB.DataBindings.Add(new Binding("Text", dGVdoiBong.DataSource, "TenDB"));
tBsanNha.DataBindings.Clear();
tBsanNha.DataBindings.Add(new Binding("Text", dGVdoiBong.DataSource, "SanNha"));
}
private void btnXoa_Click(object sender, EventArgs e)
{
QLGVDBDQGEntities qlbddel = new QLGVDBDQGEntities();
string mavongdau = tBmaVD.Text;
VONGDAU VD = qlbddel.VONGDAUs.Where(vd => vd.MaVD == mavongdau).SingleOrDefault();
if (VD != null)
{
qlbddel.VONGDAUs.Remove(VD);
qlbddel.SaveChanges();
MessageBox.Show("Đã xóa", "Thông báo");
xemdulieu();
}
else
{
MessageBox.Show("Có lỗi xảy ra...", "Lỗi");
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
QLGVDBDQGEntities qlbddel = new QLGVDBDQGEntities();
string matrandau = tBmaTD.Text;
LICHTHIDAU LTD = qlbddel.LICHTHIDAUs.Where(ltd => ltd.MaTD == matrandau).SingleOrDefault();
if (LTD != null)
{
qlbddel.LICHTHIDAUs.Remove(LTD);
qlbddel.SaveChanges();
MessageBox.Show("Đã xóa", "Thông báo");
xemdulieu();
}
else
{
MessageBox.Show("Có lỗi xảy ra...", "Lỗi");
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
QLGVDBDQGEntities qlbddel = new QLGVDBDQGEntities();
string madoibong = tBmaDB.Text;
DOIBONG DB = qlbddel.DOIBONGs.Where(db => db.MaDB == madoibong).SingleOrDefault();
if (DB != null)
{
qlbddel.DOIBONGs.Remove(DB);
qlbddel.SaveChanges();
MessageBox.Show("Đã xóa", "Thông báo");
xemdulieu();
}
else
{
MessageBox.Show("Có lỗi xảy ra...", "Lỗi");
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
QLGVDBDQGEntities qlbddel = new QLGVDBDQGEntities();
string macauthu = tBmaCT.Text;
CAUTHU CT = qlbddel.CAUTHUs.Where(ct => ct.MaCT == macauthu).SingleOrDefault();
if (CT != null)
{
qlbddel.CAUTHUs.Remove(CT);
qlbddel.SaveChanges();
MessageBox.Show("Đã xóa", "Thông báo");
xemdulieu();
}
else
{
MessageBox.Show("Có lỗi xảy ra...", "Lỗi");
}
}
private void btnSua_Click(object sender, EventArgs e)
{
QLGVDBDQGEntities qlbdedit = new QLGVDBDQGEntities();
string mavongdau = tBmaVD.Text;
VONGDAU VD = qlbdedit.VONGDAUs.Where(vd => vd.MaVD == mavongdau).SingleOrDefault();
if (VD != null)
{
VD.MaVD = Convert.ToString(tBmaVD.Text);
VD.TenVD = Convert.ToString(tBtenVD.Text);
qlbdedit.SaveChanges();
MessageBox.Show("Đã sửa", "Thông báo");
xemdulieu();
}
else
{
MessageBox.Show("Có lỗi xảy ra...", "Lỗi");
}
}
private void btnSua_Click(object sender, EventArgs e)
{
QLGVDBDQGEntities qlbdedit = new QLGVDBDQGEntities();
string madoibong = tBmaDB.Text;
DOIBONG DB = qlbdedit.DOIBONGs.Where(db => db.MaDB == madoibong).SingleOrDefault();
if (DB != null)
{
DB.MaDB = Convert.ToString(tBmaDB.Text);
DB.TenDB = Convert.ToString(tBtenDB.Text);
DB.SanNha = Convert.ToString(tBsanNha.Text);
qlbdedit.SaveChanges();
MessageBox.Show("Đã sửa", "Thông báo");
xemdulieu();
}
else
{
MessageBox.Show("Có lỗi xảy ra...", "Lỗi");
}
}
public void xemdulieu()
{
QLGVDBDQGEntities qlbd = new QLGVDBDQGEntities();
var dscauthu = from u in qlbd.CAUTHUs select new { MaCT = u.MaCT, TenCT = u.TenCT, NgaySinh = u.NgaySinh, TenLoaiCT = u.LOAICAUTHU.TenLoaiCT, TenDB = u.DOIBONG.TenDB, GhiChu = u.GhiChu };
dGVcauThu.DataSource = dscauthu.ToList();
tBmaCT.DataBindings.Clear();
tBmaCT.DataBindings.Add(new Binding("Text", dGVcauThu.DataSource, "MaCT"));
tBtenCT.DataBindings.Clear();
tBtenCT.DataBindings.Add(new Binding("Text", dGVcauThu.DataSource, "TenCT"));
dTPngaySinh.DataBindings.Clear();
dTPngaySinh.DataBindings.Add(new Binding("Text", dGVcauThu.DataSource, "NgaySinh", true, DataSourceUpdateMode.OnValidation, "", "MM/dd/yyyy"));
cBloaiCT.DataSource = qlbd.LOAICAUTHUs.ToList();
cBloaiCT.DisplayMember = "TenLoaiCT";
cBloaiCT.DataBindings.Clear();
cBloaiCT.DataBindings.Add(new Binding("Text", dGVcauThu.DataSource, "TenLoaiCT"));
cBdoiBong.DataSource = qlbd.DOIBONGs.ToList();
cBdoiBong.DisplayMember = "TenDB";
cBdoiBong.DataBindings.Clear();
cBdoiBong.DataBindings.Add(new Binding("Text", dGVcauThu.DataSource, "TenDB"));
}
private void btnSua_Click(object sender, EventArgs e)
{
QLGVDBDQGEntities qlbdedit = new QLGVDBDQGEntities();
string matrandau = tBmaTD.Text;
LICHTHIDAU LTD = qlbdedit.LICHTHIDAUs.Where(ltd => ltd.MaTD == matrandau).SingleOrDefault();
if (LTD != null)
{
LTD.DoiChuNha = ((DOIBONG)cBdoi1.SelectedValue).MaDB;
LTD.DoiKhach = ((DOIBONG)cBdoi2.SelectedValue).MaDB;
LTD.NgayThiDau = Convert.ToDateTime(tBngayGio.Text);
LTD.SanThiDau = Convert.ToString(tBsanThiDau.Text);
LTD.MaVD = ((VONGDAU)cBvongDau.SelectedValue).MaVD;
qlbdedit.SaveChanges();
MessageBox.Show("Đã sửa", "Thông báo");
xemdulieu();
}
else
{
MessageBox.Show("Có lỗi xảy ra...", "Lỗi");
}
}
private void btnThem_Click(object sender, EventArgs e)
{
QLGVDBDQGEntities qlbdadd = new QLGVDBDQGEntities();
string mavongdau = "";
VONGDAU VD = qlbdadd.VONGDAUs.Where(vd => vd.MaVD == mavongdau).SingleOrDefault();
if (VD == null)
{
VONGDAU item = new VONGDAU();
item.MaVD = Convert.ToString(tBmaVD.Text);
item.TenVD = Convert.ToString(tBtenVD.Text);
qlbdadd.VONGDAUs.Add(item);
qlbdadd.SaveChanges();
MessageBox.Show("Đã nhập vào thành công", "Thông báo");
tBmaVD.Text = "VD";
tBtenVD.Text = "";
xemdulieu();
}
else
{
MessageBox.Show("Vui lòng kiểm tra lại...", "Lỗi");
}
}
private void btnSua_Click(object sender, EventArgs e)
{
QLGVDBDQGEntities qlbdedit = new QLGVDBDQGEntities();
string macauthu = tBmaCT.Text;
CAUTHU CT = qlbdedit.CAUTHUs.Where(ct => ct.MaCT == macauthu).SingleOrDefault();
if (CT != null)
{
CT.MaCT = Convert.ToString(tBmaCT.Text);
CT.TenCT = Convert.ToString(tBtenCT.Text);
CT.NgaySinh = dTPngaySinh.Value.Date;
CT.MaLoaiCT = ((LOAICAUTHU)cBloaiCT.SelectedValue).MaLoaiCT;
CT.MaDB = ((DOIBONG)cBdoiBong.SelectedValue).MaDB;
CT.GhiChu = Convert.ToString(tBghiChu.Text);
qlbdedit.SaveChanges();
MessageBox.Show("Đã sửa", "Thông báo");
xemdulieu();
}
else
{
MessageBox.Show("Có lỗi xảy ra...", "Lỗi");
}
}
public void xemdulieu()
{
QLGVDBDQGEntities qlbd = new QLGVDBDQGEntities();
var dslichthidau = from u in qlbd.LICHTHIDAUs select new { MaTD = u.MaTD, DoiChuNha = u.DOIBONG1.TenDB, DoiKhach = u.DOIBONG.TenDB, NgayThiDau = u.NgayThiDau, SanThiDau = u.SanThiDau, VongDau = u.VONGDAU.TenVD };
dGVlichThiDau.DataSource = dslichthidau.ToList();
tBmaTD.DataBindings.Clear();
tBmaTD.DataBindings.Add("Text", dGVlichThiDau.DataSource, "MaTD");
cBdoi1.DataSource = qlbd.DOIBONGs.ToList();
cBdoi1.DisplayMember = "TenDB";
cBdoi1.DataBindings.Clear();
cBdoi1.DataBindings.Add("Text", dGVlichThiDau.DataSource, "DoiChuNha");
cBdoi2.DataSource = qlbd.DOIBONGs.ToList();
cBdoi2.DisplayMember = "TenDB";
cBdoi2.DataBindings.Clear();
cBdoi2.DataBindings.Add("Text", dGVlichThiDau.DataSource, "DoiKhach");
tBngayGio.DataBindings.Clear();
tBngayGio.DataBindings.Add("Text", dGVlichThiDau.DataSource, "NgayThiDau");
tBsanThiDau.DataBindings.Clear();
tBsanThiDau.DataBindings.Add("Text", dGVlichThiDau.DataSource, "SanThiDau");
cBvongDau.DataBindings.Clear();
cBvongDau.DataBindings.Add("Text", dGVlichThiDau.DataSource, "VongDau");
}
