public frmThemTuyenXe(tblTuyenXe tuyenXe)
{
InitializeComponent();
editMode = true;
cbbBenXeDen.Enabled = false;
cbbBenXeDi.Enabled = false;
foreach (var item in new QUANLYXEKHACHEntities().tblBenXes.ToList())
{
cbbBenXeDen.Items.Add(item.TenBenXe);
cbbBenXeDi.Items.Add(item.TenBenXe);
}
// Edit mode
cbbBenXeDi.SelectedItem = tuyenXe.tblBenXe.TenBenXe;
cbbBenXeDen.SelectedItem = tuyenXe.tblBenXe1.TenBenXe;
txtMaTuyen.Text = tuyenXe.MaTuyen;
dtgChiTietTuyen.Rows.Clear();
QUANLYXEKHACHEntities db = new QUANLYXEKHACHEntities();
List<tblChiTietTuyen> listChiTietTuyen = tuyenXe.tblChiTietTuyens.ToList();
for (int i = 0; i < listChiTietTuyen.Count; i++)
{
DataGridViewComboBoxCell cell = (DataGridViewComboBoxCell)dtgChiTietTuyen.Rows[i].Cells["BenXeTrungGian"];
foreach (var row in db.tblBenXes.Select(t => t.TenBenXe).ToList())
cell.Items.Add(row);
cell.Value = listChiTietTuyen[i].tblBenXe.TenBenXe;
dtgChiTietTuyen.Rows[i].Cells["ThoiGianDung"].Value = listChiTietTuyen[i].ThoiGianDung;
dtgChiTietTuyen.Rows[i].Cells["GhiChu"].Value = listChiTietTuyen[i].GhiChu;
}
}
public frmLichChuyenDi(tblChuyenDi chuyenDi)
{
InitializeComponent();
editMode = true;
try
{
QUANLYXEKHACHEntities db = new QUANLYXEKHACHEntities();
txtMaChuyenDi.Text = chuyenDi.MaChuyenDi.ToString();
txtGiaVe.Text = chuyenDi.DonGia.ToString();
cbbMaTuyen.DataSource = db.tblTuyenXes.Select(t => t.MaTuyen).ToList();
cbbMaTuyen.SelectedItem = chuyenDi.tblXeKhach.MaTuyen;
txtTuyen.Text = chuyenDi.tblXeKhach.tblTuyenXe.tblBenXe.TenBenXe + "-" + chuyenDi.tblXeKhach.tblTuyenXe.tblBenXe1.TenBenXe;
dtpKhoiHanh.Value = chuyenDi.KhoiHanh.Value;
dtpKetThuc.Value = chuyenDi.KhoiHanh.Value.AddMinutes(chuyenDi.tblXeKhach.tblTuyenXe.ThoiGianDi);
dtgBXTrungGian.Rows.Clear();
foreach (var item in db.tblChiTietTuyens.Where(t => t.MaTuyen == chuyenDi.tblXeKhach.MaTuyen).ToList())
{
dtgBXTrungGian.Rows.Add(item.tblBenXe.TenBenXe,
item.ThoiGianDung,
item.GhiChu);
}
cbbMaXe.DataSource = db.tblXeKhaches.Where(t => t.MaTuyen == chuyenDi.tblXeKhach.MaTuyen).Select(t => t.MaXe).ToList();
}
catch
{ }
}
private void btnThem_Click(object sender, EventArgs e)
{
try
{
BLL_BenXe temp = new BLL_BenXe();
if (temp.canInsert(txtMaBenXe.Text.ToString(), txtTenBenXe.Text.ToString()))
{
QUANLYXEKHACHEntities db = new QUANLYXEKHACHEntities();
tblBenXe t = new tblBenXe();
t.MaBenXe = txtMaBenXe.Text.ToString();
t.TenBenXe = txtTenBenXe.Text.ToString();
db.tblBenXes.Add(t);
db.SaveChanges();
btnTaoMoi_Click(sender, e);
MessageBox.Show("Thêm thành công");
}
else
{
MessageBox.Show("Không thành công");
}
}
catch { }
}
private void btThem_Click(object sender, EventArgs e)
{
tblChiTietTrungChuyen temp = new tblChiTietTrungChuyen();
temp.MaPhieu = int.Parse(dtgKhachHang.CurrentRow.Cells["MaPhieu_KH"].Value.ToString());
dynamic selectedItem = cbbXeTrungChuyen.SelectedItem;
string bienSoXe = selectedItem.BienSo;
temp.SoLuong = int.Parse(dtgKhachHang.CurrentRow.Cells["SoVe_KH"].Value.ToString());
try
{
QUANLYXEKHACHEntities db = new QUANLYXEKHACHEntities();
tblXeTrungChuyen xeTC = db.tblXeTrungChuyens.Where(t => t.BienSoXe == bienSoXe).SingleOrDefault();
if(xeTC != null)
{
temp.MaXe = xeTC.MaXe;
temp.DaRuoc = false;
db.tblChiTietTrungChuyens.Add(temp);
db.SaveChanges();
dtgDanhSachTC.Rows.Add(dtgKhachHang.CurrentRow.Cells["HoTen_KH"].Value,
dtgKhachHang.CurrentRow.Cells["MaPhieu_KH"].Value,
dtgKhachHang.CurrentRow.Cells["SDT_KH"].Value,
dtgKhachHang.CurrentRow.Cells["DiaDiem_KH"].Value,
dtgKhachHang.CurrentRow.Cells["SoVe_KH"].Value);
dtgKhachHang.Rows.RemoveAt(dtgKhachHang.CurrentRow.Index);
}
}
catch
{
MessageBox.Show("Lỗi");
}
}
private void cbMaChuyenDi_SelectedIndexChanged(object sender, EventArgs e)
{
khoiPhucTinhTrangGhe();
QUANLYXEKHACHEntities db = new QUANLYXEKHACHEntities();
int maChuyen = int.Parse(cbbMaChuyenDi.SelectedItem.ToString());
tblChuyenDi chuyenDi = db.tblChuyenDis.Where(t => t.MaChuyenDi == maChuyen).SingleOrDefault();
txtTuyen.Text = chuyenDi.tblXeKhach.tblTuyenXe.tblBenXe.TenBenXe.ToString() + "-" + chuyenDi.tblXeKhach.tblTuyenXe.tblBenXe1.TenBenXe.ToString();
txtKhoiHanh.Text = chuyenDi.KhoiHanh.Value.ToString();
txtGia.Text = chuyenDi.DonGia.ToString();
foreach (var item in chuyenDi.tblChiTietPhieuDatChoes.ToList())
{
if(chuyenDi.tblXeKhach.MaLoaiXe == 1) // ghế ngồi
{
if (item.LayVe.Value)
capNhatTinhTrangGhe(idGheThuong + item.ViTriGhe, Color.Red, pnlXeThuong);
else
capNhatTinhTrangGhe(idGheThuong + item.ViTriGhe, Color.Green, pnlXeThuong);
}
else
{
if (item.LayVe.Value)
capNhatTinhTrangGhe(idGheNam + item.ViTriGhe, Color.Red, pnlGiuongNam);
else
capNhatTinhTrangGhe(idGheNam + item.ViTriGhe, Color.Green, pnlGiuongNam);
}
}
tabXeThuong.Visible = tabXeGiuongNam.Visible = true;
if (chuyenDi.tblXeKhach.MaLoaiXe == 1) // ghế ngồi
tabXeGiuongNam.Visible = false;
else
tabXeThuong.Visible = false;
}
private void btSua_Click(object sender, EventArgs e)
{
frmSuaXe form = null;
QUANLYXEKHACHEntities db = new QUANLYXEKHACHEntities();
if(dtgDanhSachXeKhachSelected)
{
int maXe = int.Parse(dtgDSXeKhach.CurrentRow.Cells["MaXe"].Value.ToString());
tblXeKhach xe = db.tblXeKhaches.Where(t => t.MaXe == maXe).SingleOrDefault();
if(xe != null)
{
form = new frmSuaXe(xe);
}
}
else
{
int maXe = int.Parse(dtgDSXeTrungChuyen.CurrentRow.Cells["MaXeTC"].Value.ToString());
tblXeTrungChuyen xe = db.tblXeTrungChuyens.Where(t => t.MaXe == maXe).SingleOrDefault();
if (xe != null)
{
form = new frmSuaXe(xe);
}
}
form.ShowDialog();
frmQuanLyXe_Load(sender, e);
}
public frmTraCuuTrungChuyen()
{
InitializeComponent();
QUANLYXEKHACHEntities db = new QUANLYXEKHACHEntities();
cbbXeTrungChuyen.DataSource = db.tblXeTrungChuyens.Select(t => new { BienSo = t.BienSoXe, DiaDiem = t.DiaDiemTrungChuyen }).ToList();
}
private void btnXoa_Click(object sender, EventArgs e)
{
int rowIndex = dtgChuyenDi.CurrentCell.RowIndex;
DataGridViewRow row = dtgChuyenDi.Rows[rowIndex];
int maChuyenDi = int.Parse(row.Cells["MaChuyenDi"].Value.ToString());
string message = string.Format("Bạn muốn xóa chuyến đi\nBiển sô xe: {0}\nTuyến: {1}\nKhởi hành: {2}", row.Cells["BienSoXe"].Value, row.Cells["TuyenXe"].Value, row.Cells["KhoiHanh"].Value);
DialogResult result = MessageBox.Show(message, "Thông báo", MessageBoxButtons.YesNo);
if(result == System.Windows.Forms.DialogResult.Yes)
{
BLL.BLL_ChuyenDi temp = new BLL.BLL_ChuyenDi();
if (temp.canDelete(maChuyenDi))
{
QUANLYXEKHACHEntities db = new QUANLYXEKHACHEntities();
tblChuyenDi chuyenDi = db.tblChuyenDis.Where(t => t.MaChuyenDi == maChuyenDi).SingleOrDefault();
if (chuyenDi != null)
{
// Xóa báo cáo
tblBaoCaoDoanhThuChuyenDi bcChuyenDi = db.tblBaoCaoDoanhThuChuyenDis.Where(t => t.MaChuyenDi == chuyenDi.MaChuyenDi).SingleOrDefault();
if(bcChuyenDi != null)
db.tblBaoCaoDoanhThuChuyenDis.Remove(bcChuyenDi);
db.tblChuyenDis.Remove(chuyenDi);
db.SaveChanges();
MessageBox.Show("Xóa thành công");
frmQuanLyChuyenDi_Load(sender, e);
}
}
else
MessageBox.Show("Chuyến đi đã có khách hàng đặt vé hoặc mua, không thể xóa");
}
}
private List<tblChiTietTuyen> solveDataInputChiTietTuyen()
{
QUANLYXEKHACHEntities db = new QUANLYXEKHACHEntities();
List<tblChiTietTuyen> list = new List<tblChiTietTuyen>();
foreach (DataGridViewRow row in dtgChiTietTuyen.Rows)
{
if (string.IsNullOrEmpty(row.Cells[0].Value + "") && string.IsNullOrEmpty(row.Cells[1].Value + ""))
break;
string MaBenXeTrungGian = "";
string tenBenXe = row.Cells[0].Value.ToString();
tblBenXe benXe = db.tblBenXes.Where(t => t.TenBenXe == tenBenXe).SingleOrDefault();
if (benXe != null)
MaBenXeTrungGian = benXe.MaBenXe;
tblChiTietTuyen temp = new tblChiTietTuyen();
temp.MaBenXeTrungGiang = MaBenXeTrungGian;
if (!string.IsNullOrEmpty(row.Cells[1].Value + ""))
temp.ThoiGianDung = int.Parse(row.Cells[1].Value.ToString());
else
temp.ThoiGianDung = 0;
temp.MaTuyen = txtMaTuyen.Text.ToString();
if (row.Cells[2].Value != null)
temp.GhiChu = row.Cells[2].Value.ToString();
else
temp.GhiChu = "";
list.Add(temp);
}
return list;
}
private void frmDanhSachDatVe_Load(object sender, EventArgs e)
{
QUANLYXEKHACHEntities db = new QUANLYXEKHACHEntities();
cbbBenXeDen.DataSource = db.tblBenXes.Select(t => t.TenBenXe).ToList();
cbbBenXeDi.DataSource = db.tblBenXes.Select(t => t.TenBenXe).ToList();
}
public bool canDelete(int maNV)
{
QUANLYXEKHACHEntities db = new QUANLYXEKHACHEntities();
if (db.tblNhanViens.Where(t => t.MaNhanVien == maNV).ToArray().Length != 0)
return true;
return false;
}
public bool canUpdate(int maNV, int cmnd)
{
QUANLYXEKHACHEntities db = new QUANLYXEKHACHEntities();
if (db.tblNhanViens.Where(t => t.MaNhanVien != maNV && t.CMND == cmnd).ToArray().Length != 0)
return false;
return true;
}
private void btSua_Click(object sender, EventArgs e)
{
string maTuyen = dtgDanhSachTuyen.CurrentRow.Cells["MaTuyen"].Value.ToString();
tblTuyenXe tuyenXe = new QUANLYXEKHACHEntities().tblTuyenXes.Where(t => t.MaTuyen == maTuyen).SingleOrDefault();
frmThemTuyenXe form = new frmThemTuyenXe(tuyenXe);
form.ShowDialog();
frmQuanLyTuyenXe_Load(sender, e);
}
public bool canDelete(string maBen)
{
QUANLYXEKHACHEntities db = new QUANLYXEKHACHEntities();
if (db.tblBenXes.Where(t => t.MaBenXe == maBen).ToArray().Length != 0)
return true;
return false;
}
public int getLastestIndex()
{
QUANLYXEKHACHEntities db = new QUANLYXEKHACHEntities();
if (db.tblChiTietPhieuDatChoes.ToArray().Length == 0)
return 1;
else
return db.tblChiTietPhieuDatChoes.Max(t => t.MaCTPhieu) + 1;
}
public int getLastestIndex()
{
QUANLYXEKHACHEntities db = new QUANLYXEKHACHEntities();
if (db.tblXeTrungChuyens.ToArray().Length == 0)
return 1;
else
return db.tblXeTrungChuyens.Max(t => t.MaXe) + 1;
}
public bool canUpdate(string tenDN, string mk)
{
QUANLYXEKHACHEntities db = new QUANLYXEKHACHEntities();
if (db.tblTaiKhoans.Where(t => t.TenTaiKhoan == tenDN && t.MatKhau == mk).ToArray().Length != 0)
return false;
return true;
}
private void frmDoiMatKhau_Load(object sender, EventArgs e)
{
int MaNV = ma;
QUANLYXEKHACHEntities db = new QUANLYXEKHACHEntities();
tblTaiKhoan tk = db.tblTaiKhoans.Where(t => t.MaNhanVien == MaNV).SingleOrDefault();
txtTenNguoiDung.Text = tk.tblNhanVien.TenNhanVien.ToString();
txtTenDangNhap.Text = tk.TenTaiKhoan.ToString();
}
public bool canUpdate(int maChuyen, int? maXe)
{
QUANLYXEKHACHEntities db = new QUANLYXEKHACHEntities();
if (db.tblChuyenDis.Where(t => t.MaChuyenDi == maChuyen).ToArray().Length != 0)
return true;
return false;
}
public string validateInput(int maPhieu, string hoTen, int? dienThoai)
{
QUANLYXEKHACHEntities db = new QUANLYXEKHACHEntities();
if (db.tblPhieuDatChoes.Where(t => t.DienThoai == dienThoai || t.MaPhieu == maPhieu).Count() != 0)
return "Hành khách đã tồn tại";
return null;
}
public int getLastestIndex()
{
QUANLYXEKHACHEntities db = new QUANLYXEKHACHEntities();
if (db.tblChuyenDis.Count() == 0)
return 1;
else
return db.tblChuyenDis.Max(t => t.MaChuyenDi) + 1;
}
private void cbMaSanBay_SelectedIndexChanged(object sender, EventArgs e)
{
tblBenXe benXe = new QUANLYXEKHACHEntities().tblBenXes.Where(t => t.MaBenXe == cbMaBenXe.SelectedItem.ToString()).SingleOrDefault();
if(benXe != null)
{
txtTenBenXe.Text = benXe.TenBenXe;
}
}
public bool canDelete(string maTuyen)
{
QUANLYXEKHACHEntities db = new QUANLYXEKHACHEntities();
if (db.tblTuyenXes.Where(t => t.MaTuyen == maTuyen).SingleOrDefault() != null)
return true;
return false;
}
public bool canDelete(int maXe)
{
QUANLYXEKHACHEntities db = new QUANLYXEKHACHEntities();
tblXeTrungChuyen xeKhach = db.tblXeTrungChuyens.Where(t => t.MaXe == maXe).SingleOrDefault();
if (xeKhach != null)
return true;
return false;
}
public bool canUpdate(int maXe, string bienSoXe)
{
QUANLYXEKHACHEntities db = new QUANLYXEKHACHEntities();
tblXeTrungChuyen xe = db.tblXeTrungChuyens.Where(t => t.MaXe != maXe && t.BienSoXe == bienSoXe).SingleOrDefault();
if (xe != null)
return false;
return true;
}
private void btnSua_Click(object sender, EventArgs e)
{
QUANLYXEKHACHEntities db = new QUANLYXEKHACHEntities();
if(tabXeKhach.Visible)
{
int maXe = int.Parse(txtMaXeKhach.Text.ToString());
tblXeKhach xeKhach = db.tblXeKhaches.Where(t=>t.MaXe == maXe).SingleOrDefault();
xeKhach.SoGhe = int.Parse(txtSoGhe.Text.ToString());
xeKhach.MaLoaiXe = db.tblLoaiXes.Where(t => t.TenLoaiXe == cbbLoaiXe.SelectedItem.ToString()).SingleOrDefault().MaLoaiXe;
xeKhach.MaTuyen = cbbMaTuyen.SelectedItem.ToString();
xeKhach.MaTaiXe = db.tblNhanViens.Where(t => t.TenNhanVien == cbbTaiXeXK.SelectedItem.ToString()).SingleOrDefault().MaNhanVien;
xeKhach.BienSoXe = txtBienSoXK.Text.ToString();
BLL_XeKhach temp = new BLL_XeKhach();
string message = temp.validateInput(xeKhach.MaXe, xeKhach.MaTaiXe, xeKhach.MaLoaiXe, xeKhach.BienSoXe, xeKhach.MaTuyen, xeKhach.SoGhe);
if (string.IsNullOrEmpty(message))
{
if (temp.canUpdate(xeKhach.MaXe, xeKhach.BienSoXe))
{
db.SaveChanges();
MessageBox.Show("Cập nhật thành công");
}
else
MessageBox.Show("Thất bại");
}
else
MessageBox.Show(message);
}
else
{
int maXe = int.Parse(txtMaXeTC.Text.ToString());
tblXeTrungChuyen xe = db.tblXeTrungChuyens.Where(t=>t.MaXe == maXe).SingleOrDefault();
xe.MaTaiXe = db.tblNhanViens.Where(t => t.TenNhanVien == cbbTaiXeXTC.SelectedItem.ToString()).SingleOrDefault().MaNhanVien;
xe.BienSoXe = txtBienSoXTC.Text.ToString();
xe.DiaDiemTrungChuyen = txtDiaDiem.Text.ToString();
BLL_XeTrungChuyen temp = new BLL_XeTrungChuyen();
string message = temp.validateInput(xe.MaXe, xe.MaTaiXe, xe.BienSoXe, xe.DiaDiemTrungChuyen);
if (string.IsNullOrEmpty(message))
{
if (temp.canUpdate(xe.MaXe, xe.BienSoXe))
{
db.SaveChanges();
MessageBox.Show("Cập nhật thành công");
}
else
MessageBox.Show("Thất bại");
}
else
MessageBox.Show(message);
}
}
public bool canInsert(int maXe, string bienSoXe)
{
QUANLYXEKHACHEntities db = new QUANLYXEKHACHEntities();
tblXeKhach xeKhach = db.tblXeKhaches.Where(t => t.MaXe == maXe || t.BienSoXe == bienSoXe).SingleOrDefault();
if (xeKhach != null)
return false;
return true;
}
private void frmTraCuuChuyenDi_Load(object sender, EventArgs e)
{
try {
QUANLYXEKHACHEntities db = new QUANLYXEKHACHEntities();
cbBenXeDi.DataSource = db.tblBenXes.Select(t => t.TenBenXe).ToList();
cbBenXeDen.DataSource = db.tblBenXes.Select(t => t.TenBenXe).ToList();
}
catch { }
}
public int getLastestIndex()
{
QUANLYXEKHACHEntities db = new QUANLYXEKHACHEntities();
if (db.tblNhanViens.ToArray().Length == 0)
return 1;
else
return (db.tblNhanViens.Max(t => t.MaNhanVien) + 1);
}
private void btnLapVe_Click(object sender, EventArgs e)
{
QUANLYXEKHACHEntities db = new QUANLYXEKHACHEntities();
int maChuyen = int.Parse(cbbMaChuyenDi.SelectedItem.ToString());
tblChuyenDi chuyenDi = db.tblChuyenDis.Where(t => t.MaChuyenDi == maChuyen).SingleOrDefault();
frmThongTinVe form = new frmThongTinVe(chuyenDi, new tblPhieuDatCho());
form.Show();
}