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