private void dtmaybay_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { mamb = dtmaybay.CurrentRow.Cells[0].Value.ToString(); txtten.Text = dtmaybay.CurrentRow.Cells[1].Value.ToString(); cbGT.Text = dtmaybay.CurrentRow.Cells[2].Value.ToString(); txtI.Text = dtmaybay.CurrentRow.Cells[3].Value.ToString(); txtII.Text = dtmaybay.CurrentRow.Cells[4].Value.ToString(); btnsua.Enabled = true; } catch { btnsua.Enabled = false; } 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 (QLBCMBEntities3 quanli = new QLBCMBEntities3()) { quanli.deletemb(mamb); quanli.SaveChanges(); MessageBox.Show("đã xóa", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Information); Form10_Load(sender, e); } } } }
private void gunaButton3_Click(object sender, EventArgs e) { using (QLBCMBEntities3 quanli = new QLBCMBEntities3()) { quanli.deletekh(makh); quanli.SaveChanges(); MessageBox.Show("đã xóa", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Information); Form8_Load(sender, e); } }
private void gunaButton3_Click(object sender, EventArgs e) { if (MessageBox.Show("Bạn có muốn xóa hóa đơn này không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { using (QLBCMBEntities3 quanli = new QLBCMBEntities3()) { Maybay hd = quanli.Maybays.FirstOrDefault(p => p.MaMB == mamb); if (hd != null) { quanli.Maybays.Remove(hd); quanli.SaveChanges(); MessageBox.Show("Đã xóa!"); Form10_Load(sender, e); } } } }
private void txtI_TextChanged(object sender, EventArgs e) { int tongtien = 0; giave1 = 0; int giaveloai1; Chuyenbay chuyenbay = dt.Chuyenbays.Where(s => s.MaCB == label3.Text).FirstOrDefault(); if (chuyenbay != null) { string a = chuyenbay.MaCB.ToString(); Ve ve1 = dt.Ves.Where(s => s.MaCB == a.ToString()).FirstOrDefault(); if (ve1 != null) { giave1 = int.Parse(ve1.Giave); giave1 = int.Parse(ve1.Giave); } if (txtI.Text == "") { if (txtII.Text != "") { giaveloai1 = (giave2 * int.Parse(txtII.Text.Trim()) * 80) / 100; tongtien = giaveloai1; lbTongTien.Text = tongtien.ToString(); } else { lbTongTien.Text = "0"; } return; } giaveloai1 = giave1 * int.Parse(txtI.Text.Trim()); tongtien = int.Parse(lbTongTien.Text); tongtien += giaveloai1; lbTongTien.Text = tongtien.ToString(); dt.SaveChanges(); Form3_Load(sender, e); } }
private void txtII_TextChanged(object sender, EventArgs e) { QLBCMBEntities3 dt = new QLBCMBEntities3(); giave2 = 0; int giaveloai2, tongtien; Chuyenbay chuyenbay = dt.Chuyenbays.Where(s => s.MaCB == label3.Text).FirstOrDefault(); if (chuyenbay != null) { string a = chuyenbay.MaCB.ToString(); Ve ve1 = dt.Ves.Where(s => s.MaCB == a.ToString()).FirstOrDefault(); giave2 = int.Parse(ve1.Giave); if (txtII.Text == "") { if (txtI.Text != "") { giaveloai2 = giave1 * int.Parse(txtI.Text.Trim()); tongtien = giaveloai2; lbTongTien.Text = tongtien.ToString(); } else { lbTongTien.Text = "0"; } return; } giaveloai2 = (giave2 * int.Parse(txtII.Text.Trim())) * 80 / 100; tongtien = int.Parse(lbTongTien.Text); tongtien += giaveloai2; lbTongTien.Text = tongtien.ToString(); // hoadon.Tongtien = tongtien; //hoadon.MaNV = txtmahd.Text; dt.SaveChanges(); Form3_Load(sender, e); } }
private void btnLuu_Click(object sender, EventArgs e) { if (temp) { if (!kiemtra()) { return; } { using (QLBCMBEntities3 quanli = new QLBCMBEntities3()) { string makh = quanli.Khachhangs.Max(p => p.Makh); string ma = makh.Substring(2, makh.Length - 2); int manhanvien = int.Parse(ma) + 1; if (manhanvien <= 9) { makh = "KH0" + manhanvien; } else { makh = "KH" + manhanvien; } Khachhang kh = new Khachhang(); kh.Makh = makh; kh.Tenkh = txtten.Text; kh.Tuoi = int.Parse(txttuoi.Text); kh.SDTkh = txtsdt.Text; kh.ĐCkh = txtdiachi.Text; kh.CMND = int.Parse(txtcmnd.Text); kh.Email = txtemail.Text; quanli.Khachhangs.Add(kh); quanli.SaveChanges(); Form8_Load(sender, e); btnthem.Enabled = true; clearData(); dataGridView1.Enabled = true; } } } { if (makh == "") { MessageBox.Show("Hãy chọn khách hàng cần sửa!"); return; } using (QLBCMBEntities3 quanli = new QLBCMBEntities3()) { Khachhang kh = quanli.Khachhangs.FirstOrDefault(p => p.Makh == makh); kh.Makh = makh; kh.Tenkh = txtten.Text; kh.Tuoi = int.Parse(txttuoi.Text); kh.SDTkh = txtsdt.Text; kh.ĐCkh = txtdiachi.Text; kh.CMND = int.Parse(txtcmnd.Text); kh.Email = txtemail.Text; quanli.SaveChanges(); MessageBox.Show("Sua thanh cong!"); Form8_Load(sender, e); } } }
private void btnLuu_Click(object sender, EventArgs e) { { if (temp) { if (!kiemtra()) { return; } using (QLBCMBEntities3 quanli = new QLBCMBEntities3()) { 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); clearData(); btnthem.Enabled = true; dtmaybay.Enabled = true; } } else { if (mamb == "") { MessageBox.Show("Hãy chọn máy bay cần sửa!"); return; } { using (QLBCMBEntities3 quanli = new QLBCMBEntities3()) { if (mamb == "") { MessageBox.Show("Hãy chọn sân bay cần sửa!"); return; } using (QLBCMBEntities3 quanli1 = new QLBCMBEntities3()) { Maybay nv = quanli1.Maybays.FirstOrDefault(p => p.MaMB == mamb); nv.TenMB = txtten.Text; nv.Hang = cbGT.Text; nv.Gheloai1 = txtI.Text; nv.Gheloai2 = txtII.Text; quanli1.SaveChanges(); DialogResult dr = MessageBox.Show("Sửa thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); Form10_Load(sender, e); clearData(); btnthem.Enabled = true; dtmaybay.Enabled = true; } } } } } }
private void btnluu_Click(object sender, EventArgs e) { if (temp) { { if (!kiemtra()) { return; } using (QLBCMBEntities3 quanli = new QLBCMBEntities3()) { 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); btnthem.Enabled = true; dtnhanvien.Enabled = true; clearData(); } } } { if (manv == "") { MessageBox.Show("Hãy chọn nhân viên cần sửa!"); return; } using (QLBCMBEntities3 quanli = new QLBCMBEntities3()) { 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); nv.Chucvu = txtchucvu.Text; quanli.SaveChanges(); MessageBox.Show("Sua thanh cong!"); Form9_Load(sender, e); btnthem.Enabled = true; dtnhanvien.Enabled = true; clearData(); } } }
private void gunaButton2_Click_1(object sender, EventArgs e) { { if (temp) { { if (!kiemtra()) { return; } else { string masb = quanlichuan.Sanbays.Max(p => p.MaSb); string ma = masb.Substring(2, masb.Length - 2); int manhanvien = int.Parse(ma) + 1; if (manhanvien <= 9) { masb = "SB0" + manhanvien; } else { masb = "SB" + manhanvien; } Sanbay nv = new Sanbay(); nv.MaSb = masb; nv.TenSb = txtten.Text; nv.Diachi = txtdiachi.Text; quanlichuan.Sanbays.Add(nv); quanlichuan.SaveChanges(); btnthen.Enabled = true; dataGridView1.Enabled = true; Form12_Load(sender, e); clearData(); } } } { if (masb == "") { MessageBox.Show("Hãy chọn sân bay cần sửa!"); return; } Sanbay nv = quanlichuan.Sanbays.FirstOrDefault(p => p.MaSb == masb); nv.TenSb = txtten.Text; nv.Diachi = txtdiachi.Text; quanlichuan.SaveChanges(); DialogResult dr = MessageBox.Show("Sửa thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); if (dr == DialogResult.OK) { Form12_Load(sender, e); btnthen.Enabled = true; dataGridView1.Enabled = true; clearData(); } } } }
private void btnDatVe_Click(object sender, EventArgs e) { using (QLBCMBEntities3 quanli = new QLBCMBEntities3()) { // Hoadon hd = new Hoadon(); // hd.MaHD = txtmahd.Text; // hd.Nlap = DateTime.Now; // hd.MaNV = cbnv.SelectedValue.ToString(); // hd.Makh = cbkh.SelectedValue.ToString(); // hd.MaCB = label3.Text; //hd.Tongtien = int.Parse(lbTongTien.Text); //quanli.Hoadons.Add(hd); //quanli.SaveChanges(); // quanli.mahoadon(cbnv.SelectedValue, Convert.ToDateTime(dtngay.Text), lbTongTien.Text, cbkh.SelectedValue); quanli.themHoaDon(cbnv.SelectedValue.ToString() , int.Parse(lbTongTien.Text), cbkh.SelectedValue.ToString(), DateTime.Now, textBox1.Text); CTVe ct = new CTVe(); ct.MaHD = quanli.Hoadons.Max(p => p.MaHD); ct.Mave = textBox1.Text; quanli.CTVes.Add(ct); int n = int.Parse(txtI.Text) + int.Parse(txtII.Text); ct.Soluongban = n; quanli.SaveChanges(); //if (String.IsNullOrEmpty(txtI.Text)) //{ // CTVe cT = new CTVe(); // cT.MaHD = txtmahd.Text; // cT.Mave = "V01"; // cT.Soluongban = int.Parse(txtI.Text); // quanli.CTVes.Add(cT); // quanli.SaveChanges(); //} //if (String.IsNullOrEmpty(txtII.Text)) //{ // CTVe cT = new CTVe(); // cT.MaHD = txtmahd.Text; // cT.Mave = "V02"; // cT.Soluongban = int.Parse(txtI.Text); // quanli.CTVes.Add(cT); // quanli.SaveChanges(); //} MessageBox.Show("Thêm thành công"); } int giaveloai1, giaveloai2; if (txtI.Text != "" && txtII.Text != "") { giaveloai1 = int.Parse(txtI.Text) * giave1; giaveloai2 = int.Parse(txtII.Text) * giave2; int tong = giaveloai1 + giaveloai2; lbTongTien.Text = tong.ToString(); } // //dt.themhd(cbnv.SelectedValue.ToString(), Convert.ToDateTime(dtngaylap.Text), int.Parse(lbTongTien.Text), comboBox3.SelectedValue.ToString(), int.Parse(textBox1.Text), textBox2.Text, cbcb.SelectedValue.ToString(), cbmakh.SelectedValue.ToString()); //} //Chuyenbay chuyenbay = dt.Chuyenbays.Where(s => s.MaCB == label3.Text.Trim()).FirstOrDefault(); //Hoadon hoadon = dt.Hoadons.Where(s => s.MaCB == chuyenbay.MaCB.ToString()).FirstOrDefault(); //CTVe cTVe = dt.CTVes.Where(s => s.MaHD == hoadon.MaHD.ToString()).FirstOrDefault(); //Ve ve = dt.Ves.Where(s => s.Mave == cTVe.Mave.ToString()).FirstOrDefault(); //giave = int.Parse(ve.Giave); //lbTongTien.Text = giave.ToString(); //giave = Convert.ToDouble(ve.Giave); //lbTongtien.Text = giave.ToString(); }