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