private void gunaButton6_Click(object sender, EventArgs e)
{
{
if (!kiemtra())
{
return;
}
using (QLBCMBEntities2 quanli = new QLBCMBEntities2())
{
string manv = quanli.Nhanviens.Max(p => p.MaNV);
string ma = manv.Substring(2, manv.Length - 2);
int manhanvien = int.Parse(ma) + 1;
if (manhanvien <= 9)
{
manv = "NV0" + manhanvien;
}
else
{
manv = "NV" + manhanvien;
}
Nhanvien nv = new Nhanvien();
nv.MaNV = manv;
nv.Hoten = txtten.Text;
nv.SĐT = txtsdt.Text;
nv.Diachi = txtdiachi.Text;
nv.CMND = int.Parse(txtcmnd.Text);
quanli.Nhanviens.Add(nv);
quanli.SaveChanges();
Form9_Load(sender, e);
}
}
}
private void gunaButton6_Click(object sender, EventArgs e)
{
{
if (!kiemtra())
{
return;
}
using (QLBCMBEntities2 quanli = new QLBCMBEntities2())
{
string mamb = quanli.Maybays.Max(p => p.MaMB);
string ma = mamb.Substring(2, mamb.Length - 2);
int manhanvien = int.Parse(ma) + 1;
if (manhanvien <= 9)
{
mamb = "MB0" + manhanvien;
}
else
{
mamb = "MB" + manhanvien;
}
Maybay nv = new Maybay();
nv.MaMB = mamb;
nv.TenMB = txtten.Text;
nv.Hang = cbGT.Text;
nv.Gheloai1 = txtI.Text;
nv.Gheloai2 = txtII.Text;
quanli.Maybays.Add(nv);
quanli.SaveChanges();
Form10_Load(sender, e);
}
}
}
private void gunaButton4_Click(object sender, EventArgs e)
{
using (QLBCMBEntities2 quanli = new QLBCMBEntities2())
{
dtmaybay.DataSource = quanli.Maybays.Where(p => p.MaMB.Contains(txttimkiem.Text.Trim())).ToList();
MessageBox.Show("Tìm kiếm thành công", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
}
}
private void gunaButton3_Click(object sender, EventArgs e)
{
using (QLBCMBEntities2 quanli = new QLBCMBEntities2())
{
quanli.deletemb(mamb);
quanli.SaveChanges();
MessageBox.Show("đã xóa", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
Form10_Load(sender, e);
}
}
private void gunaButton1_Click(object sender, EventArgs e)
{
using (QLBCMBEntities2 quanli = new QLBCMBEntities2())
{
Chuyenbay cb = new Chuyenbay();;
string macb = quanli.Chuyenbays.Max(p => p.MaCB);
macb = macb.Substring(2, macb.Length - 2);
if (int.Parse(macb) < 9)
{
macb = "CB0" + (int.Parse(macb) + 1);
}
else
{
macb = "CB" + (int.Parse(macb) + 1);
}
cb.MaCB = macb;
cb.Ngaybay = dtngay.Value;
cb.MaMB = cbMayBay.SelectedValue.ToString();
TimeSpan time = TimeSpan.Parse(tbgiobay.Text);
cb.Thoigianbay = time;
quanli.Chuyenbays.Add(cb);
quanli.SaveChanges();
CTchuyenbay ct = new CTchuyenbay();;
string matb = quanli.CTchuyenbays.Max(p => p.MaTB);
matb = matb.Substring(2, matb.Length - 2);
if (int.Parse(matb) < 9)
{
matb = "TB0" + (int.Parse(matb) + 1);
}
else
{
matb = "TB" + (int.Parse(matb) + 1);
}
ct.MaCB = macb;
ct.MaTB = matb;
TimeSpan time1 = TimeSpan.Parse(dtThoiGiandung.Text);
ct.Thoigiandung = time;
ct.SBtrunggian = cbTrungGian.SelectedValue.ToString();
quanli.CTchuyenbays.Add(ct);
quanli.SaveChanges();
Tuyenbay tb = new Tuyenbay();
tb.MaTB = matb;
tb.SBdi = cbdi.SelectedValue.ToString();
tb.SBden = cbden.SelectedValue.ToString();
quanli.Tuyenbays.Add(tb);
quanli.SaveChanges();
MessageBox.Show("Da them");
}
this.Close();
}
private void dtnhanvien_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
manv = dtnhanvien.CurrentRow.Cells[0].Value.ToString();
txtten.Text = dtnhanvien.CurrentRow.Cells[1].Value.ToString();
txtcmnd.Text = dtnhanvien.CurrentRow.Cells[2].Value.ToString();
txtdiachi.Text = dtnhanvien.CurrentRow.Cells[3].Value.ToString();
txtsdt.Text = dtnhanvien.CurrentRow.Cells[4].Value.ToString();
if (e.ColumnIndex == 5)
{
if (MessageBox.Show("Bạn có muốn xóa nhà khách hàng không ?", "xóa", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
using (QLBCMBEntities2 quanli = new QLBCMBEntities2())
{
quanli.deletenv(manv);
MessageBox.Show("đã xóa", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
Form9_Load(sender, e);
}
}
}
}
private void gunaButton4_Click(object sender, EventArgs e)
{
{
if (manv == "")
{
MessageBox.Show("Hãy chọn nhân viên cần sửa!");
return;
}
using (QLBCMBEntities2 quanli = new QLBCMBEntities2())
{
Nhanvien nv = quanli.Nhanviens.FirstOrDefault(p => p.MaNV == manv);
nv.Hoten = txtten.Text;
nv.SĐT = txtsdt.Text;
nv.Diachi = txtdiachi.Text;
nv.CMND = int.Parse(txtcmnd.Text);
quanli.SaveChanges();
MessageBox.Show("Sua thanh cong!");
Form9_Load(sender, e);
}
}
}
//public void Loadchuyenbay()
//{
// string query = " select * from Tuyenbay";
// DataTable data = Connect.Instace.excutequery(query);
// dtchuyenbay.DataSource = data;
//}
//public void LoadCombox()
// {
// string query = "select * from Tuyenbay";
// DataTable data = Connect.Instace.excutequery(query);
// cbdi.DataSource = data;
// cbdi.ValueMember = "MaTB";
// cbdi.DisplayMember = "SBdi";
// }
private void Form5_Load(object sender, EventArgs e)
{
DataTable table = new DataTable();
table.Columns.Add("MaCB");
table.Columns.Add("MaMB");
table.Columns.Add("NgayBay");
table.Columns.Add("ThoiGianBay");
table.Columns.Add("GheLoai1");
table.Columns.Add("GheLoai2");
using (QLBCMBEntities2 quanli = new QLBCMBEntities2())
{
List <Chuyenbay> ds_cb = quanli.Chuyenbays.ToList();
foreach (var item in ds_cb)
{
Maybay mb = quanli.Maybays.FirstOrDefault(p => p.MaMB == item.MaMB);
table.Rows.Add(item.MaCB, item.MaMB, item.Ngaybay, item.Thoigianbay, mb.Gheloai1, mb.Gheloai2);
}
}
gunaDataGridView1.AutoGenerateColumns = false;
gunaDataGridView1.DataSource = table;
}
