private void btnLuu_Click(object sender, EventArgs e)
{
List <KiemTra> kiemTras = new List <KiemTra>()
{
new KiemTra()
{
_Control = iSignIn, _Tu = 2, _Den = 20, _ChoQua = !new D_SIGNIN().DaTonTai(string.Format("WHERE SignIn='{0}' AND ID <> {1}", iSignIn.Text, _SignInO.ID)), _ThongBao2 = "Đã tồn tại"
}
};
XuLyGiaoDien.KiemTra(kiemTras, dxValidationProvider1);
if (!dxValidationProvider1.Validate())
{
XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning);
return;
}
Dictionary <string, object> dic = new Dictionary <string, object>();
dic = XuLyDuLieu.FormToDictionary(this, dic);
long CapNhatNum = (_SignInO.ID > 0) ? (_SignInD.CapNhat(dic, _SignInO.ID) > 0 ? _SignInO.ID : 0) : _SignInD.ThemMoi(dic, true);
if (XuLyGiaoDien.ThongBao(Text, CapNhatNum > 0))
{
if (Owner is frmSignIn)
{
(Owner as frmSignIn).TaiLaiSignIn();
}
Close();
}
}
private void btnDongY_Click(object sender, EventArgs e)
{
List <KiemTra> kiemTras = new List <KiemTra>()
{
new KiemTra()
{
_Control = txtMatKhauCu, _ChoQuaThang = TMD5.TMd5Hash(txtMatKhauCu.Text) == DuLieuTaoSan.NV.MatKhauCty, _ThongBao2 = "Mật khẩu sai"
},
new KiemTra()
{
_Control = txtMatKhauMoi
},
new KiemTra()
{
_Control = iMatKhauCty, _ChoQuaThang = iMatKhauCty.Text == txtMatKhauMoi.Text, _ThongBao2 = "Mật khẩu mới không khớp"
}
};
XuLyGiaoDien.KiemTra(kiemTras, dxValidationProvider1);
if (!dxValidationProvider1.Validate())
{
XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning);
return;
}
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("MatKhauCty", TMD5.TMd5Hash(iMatKhauCty.Text));
if (XuLyGiaoDien.ThongBao(Text, new D_DAILY().CapNhat(dic, DuLieuTaoSan.NV.ID) > 0))
{
Close();
}
}
private void btnLuu2_Click(object sender, EventArgs e)
{
if (!checkEdit2.Checked && _TinhTrangO.ID < 1)
{
XtraMessageBox.Show("Nếu muốn thêm mới vui lòng chọn vào [Thêm]", "Thông báo");
return;
}
List <KiemTra> kiemTras = new List <KiemTra>();
kiemTras.Add(new KiemTra()
{
_Control = iTenTrangThai, _Tu = 3, _Den = 30, _ChoQua = !(_ListTinhTrangO.Where(w => w.TenTrangThai.Equals(iTenTrangThai.Text) && !w.ID.Equals(checkEdit2.Checked ? 0 : _TinhTrangO.ID)).Count() > 0), _ThongBao2 = "Giá trị này đã tồn tại"
});
XuLyGiaoDien.KiemTra(kiemTras, dxValidationProvider1);
if (!dxValidationProvider1.Validate())
{
XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning);
return;
}
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("TenTrangThai", iTenTrangThai.Text);
dic.Add("LoaiKhachHang", _LoaiKhachHang);
long a = !checkEdit2.Checked ? _TinhTrangD.CapNhat(dic, _TinhTrangO.ID) : _TinhTrangD.ThemMoi(dic, true);
if (XuLyGiaoDien.ThongBao("Tình trạng " + (checkEdit1.Checked ? "thêm" : "sửa"), a > 0))
{
_ListTinhTrangO = _TinhTrangD.DuLieu(_LoaiKhachHang, false);
trangThaiOBindingSource.DataSource = _ListTinhTrangO;
(Owner.ActiveMdiChild as frmDaiLy).DuLieu();
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
string CoDe = string.Empty;
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
CoDe += row[0].ToString() + ", ";
}
CoDe = CoDe.Substring(0, CoDe.Length - 2);
}
D_KHOANGAY bus = new D_KHOANGAY();
Dictionary <string, object> dic = new Dictionary <string, object>()
{
{ "HoatDong", chkGD.Checked },
{ "Them", chkThem.Checked },
{ "Sua", chkSua.Checked },
{ "Xoa", chkXoa.Checked },
{ "NganHang", chkNH.Checked },
{ "Code", CoDe },
{ "ThemNH", chkThemNH.Checked },
{ "SuaNH", chkSuaNH.Checked },
{ "XoaNH", chkXoaNH.Checked },
};
if (XuLyGiaoDien.ThongBao(Text + " sửa", bus.CapNhat(dic, _KhoaNgayO.MaNgay, "WHERE MaNgay = {0}") > 0))
{
chkGD.Checked = chkNH.Checked = chkSua.Checked = chkThem.Checked = chkXoa.Checked = chkSuaNH.Checked = chkThemNH.Checked = chkXoaNH.Checked = false;
dt.Clear();
GM.Enabled = false;
DuLieu();
}
}
void XulyDuLieuTruocKhiThem(Dictionary <string, object> Dic)
{
long a = 0;
List <Dictionary <string, object> > lstDicS = new List <Dictionary <string, object> >();
List <string> lstCTV = new List <string>();
for (int i = 0; i < GaVGD.RowCount; i++)
{
Dictionary <string, object> dicS = new Dictionary <string, object>(Dic);
for (int y = 0; y < GaVGD.Columns.Count; y++) //Dòng
{
if (GaVGD.Columns[y].Visible) //Cột
{
object G = GaVGD.GetRowCellValue(i, GaVGD.Columns[y]);
dicS.Add(GaVGD.Columns[y].FieldName, G);
}
else if (y == GaVGD.Columns.Count - 1)
{
object G = GaVGD.GetRowCellValue(i, GaVGD.Columns[y]);
lstCTV.Add(string.Format("WHERE ID = {0}", G));
lstDicS.Add(dicS);
}
}
}
a = (_ks.ID > 0) ? _ksD.SuaNhieu1Ban(lstDicS, lstCTV) : _ksD.ThemNhieu1Ban(lstDicS);
if (XuLyGiaoDien.ThongBao(Text, a == lstDicS.Count))
{
GhiChuCmt(_ks.ID);
(Owner.ActiveMdiChild as frmKhachSan).DuLieu();
Close();
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
List <KiemTra> kiemTras = new List <KiemTra>();
kiemTras.Add(new KiemTra()
{
_Control = iTenHang, _Tu = 5, _Den = 30,
});
kiemTras.Add(new KiemTra()
{
_Control = iTenTat, _Tu = 2, _Den = 5, _ChoQua = !_HangBayD.DaTonTai("TenTat", iTenTat.Text, _HangBay.ID), _ThongBao2 = "Đã tồn tại"
});
XuLyGiaoDien.KiemTra(kiemTras, dxValidationProvider1);
if (!dxValidationProvider1.Validate())
{
XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning);
return;
}
Dictionary <string, object> dic = new Dictionary <string, object>();
dic = XuLyDuLieu.FormToDictionary(this, dic);
long a = (_HangBay.ID > 0) ? _HangBayD.CapNhat(dic, _HangBay.ID) : _HangBayD.ThemMoi(dic, true);
if (XuLyGiaoDien.ThongBao(Text, a > 0))
{
(Owner.ActiveMdiChild as frmHangBay).DuLieu();
Close();
}
}
private void btnXoa_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
_KhachSanO = GVGD.GetRow(GVGD.GetSelectedRows()[0]) as O_KHACHSAN;
List <object> lstCtv = new List <object>();
List <O_KHACHSAN> lst = __ListKhachSanO.Where(w => w.MaCho.Equals(_KhachSanO.MaCho) && w.IDKhachHang.Equals(_KhachSanO.IDKhachHang) && w.NgayGD.ToString("ddMMyyy").Equals(_KhachSanO.NgayGD.ToString("ddMMyyy"))).ToList();
bool ThanhCong = false;
if (lst.Count == 1)
{
DialogResult dc = XtraMessageBox.Show("Bạn muốn xóa giao dịch ?", "Câu hỏi", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
switch (dc)
{
case DialogResult.Yes:
ThanhCong = _KhachSanD.Xoa(_KhachSanO.ID) > 0;
break;
default:
return;
}
}
else
{
DialogResult dc = XtraMessageBox.Show("Bạn muốn xóa tất cả giao dịch cùng Mã Chỗ ?", "Câu hỏi", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question);
switch (dc)
{
case DialogResult.Yes:
foreach (O_KHACHSAN gdoz in lst)
{
lstCtv.Add(gdoz.ID);
}
ThanhCong = _KhachSanD.XoaNhieu1Ban(lstCtv) > 0;
break;
case DialogResult.No:
ThanhCong = _KhachSanD.Xoa(_KhachSanO.ID) > 0;
break;
default:
return;
}
}
if (XuLyGiaoDien.ThongBao(Text, ThanhCong, true))
{
string NoiDung = string.Empty;
NoiDung = string.Format("Xóa {0} GD với tổng giá hệ thống là {1} \r\n", lst.Count(), lst.Sum(w => w.GiaHeThong).ToString("#,###"));
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("FormName", Text);
dic.Add("MaCho", _KhachSanO.MaCho);
dic.Add("NoiDung", NoiDung);
dic.Add("NVGiaoDich", DuLieuTaoSan.NV.ID);
dic.Add("LoaiKhachHang", 1);
dic.Add("Ma", _KhachSanO.IDKhachHang);
new D_LS_GIAODICH().ThemMoi(dic);
new D_DAILY().ChayLaiPhi(_KhachSanO.NgayGD);
DuLieu();
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
string NCC = string.Empty;
if (_DataHangBay.Rows.Count > 0)
{
foreach (DataRow row in _DataHangBay.Rows)
{
NCC += row["ID"].ToString() + "|";
}
}
List <KiemTra> kiemTras = new List <KiemTra>();
kiemTras.Add(new KiemTra()
{
_Control = iTenDayDu, _Tu = 2, _Den = 50
});
kiemTras.Add(new KiemTra()
{
_Control = iTen, _Tu = 2, _Den = 50, _ChoQua = !_NCCD.DaTonTai("Ten", iTen.Text, _NCCO.ID), _ThongBao2 = "Đã tồn tại"
});
XuLyGiaoDien.KiemTra(kiemTras, dxValidationProvider1);
if (!dxValidationProvider1.Validate())
{
XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning);
return;
}
Dictionary <string, object> dic = new Dictionary <string, object>();
dic = XuLyDuLieu.FormToDictionary(this, dic);
dic.Add("HangBay", NCC);
long CapNhatNum = (_NCCO.ID > 0) ? _NCCD.CapNhat(dic, _NCCO.ID) : _NCCD.ThemMoi(dic, true);
if (XuLyGiaoDien.ThongBao(Text, CapNhatNum > 0))
{
if (_NCCO.ID < 1)
{
List <Dictionary <string, object> > lstDicS = new List <Dictionary <string, object> >();
for (int i = 0; i < 180; i++)
{
dic = new Dictionary <string, object>();
dic.Add("NCCID", CapNhatNum);
dic.Add("SoDuCuoi", 0);
dic.Add("SoDuThucTe", 0);
dic.Add("Ngay", "getdate() - " + i);
lstDicS.Add(dic);
}
new D_SODU_HANG().ThemNhieu1Ban(lstDicS);
}
(Owner.ActiveMdiChild as frmHangBay).DuLieu();
Close();
}
}
private void btnSave_Click(Object sender, EventArgs e)
{
#region kiểm tra điều kiện
List<KiemTra> kiemTras = new List<KiemTra>() {
new KiemTra() { _Control = iTen } };
XuLyGiaoDien.KiemTra(kiemTras, dxValidationProvider1);
if (!dxValidationProvider1.Validate())
{
XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning);
return;
}
#endregion
D_NHOMQUYEN cvb = new D_NHOMQUYEN();
#region Kiểm tra tên tắt hãng bay
if (cvb.KiemTraTonTai(iTen.Text, ID))
{
XuLyGiaoDien.Alert("Tên nhóm quyền đã tồn tại", Form_Alert.enmType.Warning);
return;
}
#endregion
#region Lưu
Dictionary<string, object> dic = new Dictionary<string, object>();
dic.Add("Ten", iTen.Text);
foreach (Control ctl in Controls)
{
if (ctl is GroupControl)
{
if ((ctl as GroupControl).CustomHeaderButtons.Count > 0)
dic.Add(ctl.Name, (ctl as GroupControl).CustomHeaderButtons[0].Properties.Checked);
foreach (Control ctl1 in (ctl as GroupControl).Controls)
{
if (ctl1 is CheckEdit)
dic.Add(ctl1.Name, (ctl1 as CheckEdit).Checked);
else if (ctl1 is GroupControl)
{
if ((ctl1 as GroupControl).CustomHeaderButtons.Count > 0)
dic.Add(ctl1.Name, (ctl1 as GroupControl).CustomHeaderButtons[0].Properties.Checked);
foreach (Control ctl2 in (ctl1 as GroupControl).Controls)
{
dic.Add(ctl2.Name, (ctl2 as CheckEdit).Checked);
}
}
}
}
}
if (XuLyGiaoDien.ThongBao(Text, (ID != 0) ? (cvb.CapNhat(dic, ID) > 0) : (cvb.ThemMoi(dic) > 0)))
{
(Owner.ActiveMdiChild as frmQuyenNhanVien).QuyenNhanVienOBindingSource.DataSource = new D_NHOMQUYEN().DuLieu();
Close();
}
#endregion
}
private void simpleButton3_Click(object sender, EventArgs e)
{
List <KiemTra> kiemTras = new List <KiemTra>();
kiemTras.Add(new KiemTra()
{
_Control = iTenDangNhapCty, _Tu = 5, _Den = 30, _ChoQua = !_DaiLyD.DaTonTai("TenDangNhapCty", iTenDangNhapCty.Text, _KhachHangO.ID), _ThongBao2 = "Đã tồn tại"
});
kiemTras.Add(new KiemTra()
{
_Control = txtMatKhauCty, _Tu = 5, _Den = 30, _ChoQuaThang = !txtMatKhauCty.Enabled
});
XuLyGiaoDien.KiemTra(kiemTras, dxValidationProvider1);
if (!dxValidationProvider1.Validate())
{
XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning);
return;
}
Dictionary <string, object> dic = new Dictionary <string, object>();
dic = XuLyDuLieu.FormToDictionary(this, dic);
dic.Add("Ten", iTenDangNhapCty.Text);
if (txtMatKhauCty.Enabled)
{
dic.Add("MatKhauCty", TMD5.TMd5Hash(txtMatKhauCty.Text));
}
dic.Add("LoaiKhachHang", 0);
NguoiThanKhach(false);
dic.Add("ThongTinLienLac", _HoHang);
long a = (_KhachHangO.ID > 0) ? _DaiLyD.CapNhat(dic, _KhachHangO.ID) : _DaiLyD.ThemMoi(dic, true);
if (XuLyGiaoDien.ThongBao(Text, a > 0))
{
if (_KhachHangO.ID < 1)
{
List <Dictionary <string, object> > lstDicS = new List <Dictionary <string, object> >();
for (int i = 0; i < 90; i++)
{
dic = new Dictionary <string, object>();
dic.Add("LoaiKhachHangSD", _KhachHangO.LoaiKhachHang);
dic.Add("ChinhSachID", iChinhSach.EditValue);
dic.Add("DaiLyID", a);
dic.Add("Ngay", "getdate() - " + i);
lstDicS.Add(dic);
}
new D_SODU_DAILY().ThemNhieu1Ban(lstDicS);
}
(Owner.ActiveMdiChild as frmNhanVien).DuLieu();
Close();
}
}
private void btnLuuMau_Click(object sender, EventArgs e)
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("NoiDung", txtMauEmail.HtmlText);
dic.Add("TenMau", iTen.Text);
long Suc = (iThem.Checked) ? mauEmailD.ThemMoi(dic, false) : mauEmailD.CapNhat(dic, iMau.EditValue);
if (XuLyGiaoDien.ThongBao("Mẫu Email" + (!iThem.Checked ? " sửa" : " thêm"), Suc > 0))
{
mauEmailOBindingSource.DataSource = mauEmailD.DuLieu();
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("Host", txtHost.Text);
dic.Add("Port", nudPort.Value);
dic.Add("SSL", chkSSL.Checked);
dic.Add("Email", txtEmail.Text);
dic.Add("Password", txtMatKhau.Text);
long Suc = cauHinhSMTPD.CapNhat(dic, nudPort.Value, " WHERE Port <> 0");
XuLyGiaoDien.ThongBao("Cấu hình Email sửa", Suc > 0);
}
private void btnXoa_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (GVNKH.GetSelectedRows().Count() > 0)
{
_NhomDaiLyO = GVNKH.GetRow(GVNKH.GetSelectedRows()[0]) as O_NHOMDAILY;
if (_NhomDaiLyO != null)
{
XuLyGiaoDien.ThongBao(Text, _NhomDaiLyD.Xoa(_NhomDaiLyO.ID) > 0, true);
_ListNhomDaiLyO = _NhomDaiLyD.DuLieu(_LoaiKhachHang);
nhomKhachHangOBindingSource.DataSource = _ListNhomDaiLyO;
}
}
}
private void btnLuu2_Click(object sender, EventArgs e)
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic = XuLyDuLieu.FormToDictionary(this, dic);
dic.Add("NoiDung", txtMauEmail.Text);
long CapNhatNum = (kpi.ID > 0) ? (kpid.CapNhat(dic, kpi.ID) > 0 ? kpi.ID : 0) : kpid.ThemMoi(dic, true);
if (XuLyGiaoDien.ThongBao(Text, CapNhatNum > 0))
{
(Owner.ActiveMdiChild as frmKPIHangMuc).TaiLaiKPI();
Close();
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
List <KiemTra> kiemTras = new List <KiemTra>();
kiemTras.Add(new KiemTra()
{
_Control = iTen, _Tu = 3, _Den = 30,
});
kiemTras.Add(new KiemTra()
{
_Control = iNguoiDaiDienHD, _Tu = 3, _Den = 30,
});
kiemTras.Add(new KiemTra()
{
_Control = iDiDong, _SDT = true, _ChoQua = !_DaiLyD.DaTonTai("DiDong", iDiDong.Text, _DaiLyO.ID, "AND LoaiKhachHang = 3"), _ThongBao2 = "Đã tồn tại"
});
XuLyGiaoDien.KiemTra(kiemTras, dxValidationProvider1);
if (!dxValidationProvider1.Validate())
{
XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning);
return;
}
Dictionary <string, object> dic = new Dictionary <string, object>();
dic = XuLyDuLieu.FormToDictionary(this, dic);
dic.Add("LoaiKhachHang", 3);
long a = (_DaiLyO.ID > 0) ? _DaiLyD.CapNhat(dic, _DaiLyO.ID) : _DaiLyD.ThemMoi(dic, true);
if (XuLyGiaoDien.ThongBao(Text, a > 0))
{
if (Owner.ActiveMdiChild is frmKhachLe)
{
(Owner.ActiveMdiChild as frmKhachLe).DuLieu();
}
else if (Owner is frmVeThem)
{
(Owner as frmVeThem).DuLieuKhachLe(a);
}
else
{
(Owner as frmKhachSanThem).DuLieuKhachLe(a);
}
Close();
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
if (!checkEdit1.Checked && _NhomDaiLyO.ID < 1)
{
XtraMessageBox.Show("Nếu muốn thêm mới vui lòng chọn vào [Thêm]", "Thông báo");
return;
}
List <KiemTra> kiemTras = new List <KiemTra>();
kiemTras.Add(new KiemTra()
{
_Control = iTen, _Tu = 3, _Den = 30,
});
kiemTras.Add(new KiemTra()
{
_Control = iTu, _Tu = 0, _Den = 30, _ChoQua = !(_ListNhomDaiLyO.Where(w => iTu.Value > w.Tu - 1 && w.Den + 1 > iTu.Value && !w.ID.Equals(checkEdit1.Checked ? 0 : _NhomDaiLyO.ID)).Count() > 0), _ThongBao2 = "Giá trị này đã tồn tại"
});
kiemTras.Add(new KiemTra()
{
_Control = iDen, _Tu = 0, _Den = 30, _ChoQua = !(_ListNhomDaiLyO.Where(w => iDen.Value > w.Tu - 1 && w.Den + 1 > iDen.Value && !w.ID.Equals(checkEdit1.Checked ? 0 : _NhomDaiLyO.ID)).Count() > 0) && iDen.Value - 1000000 > iTu.Value, _ThongBao2 = "Giá trị này đã tồn tại"
});
XuLyGiaoDien.KiemTra(kiemTras, dxValidationProvider1);
if (!dxValidationProvider1.Validate())
{
XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning);
return;
}
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("LoaiKhachHang", _LoaiKhachHang);
dic.Add("Den", iDen.Value);
dic.Add("Tu", iTu.Value);
dic.Add("Ten", iTen.EditValue);
long a = !checkEdit1.Checked ? _NhomDaiLyD.CapNhat(dic, _NhomDaiLyO.ID) : _NhomDaiLyD.ThemMoi(dic, true);
if (XuLyGiaoDien.ThongBao("Nhóm " + (checkEdit1.Checked ? "thêm" : "sửa"), a > 0))
{
_ListNhomDaiLyO = _NhomDaiLyD.DuLieu(_LoaiKhachHang);
nhomKhachHangOBindingSource.DataSource = _ListNhomDaiLyO;
(Owner.ActiveMdiChild as frmDaiLy).DuLieu();
}
}
private void btnLuu2_Click(object sender, EventArgs e)
{
List <KiemTra> kiemTras = new List <KiemTra>()
{
new KiemTra()
{
_Control = iKyHieuDi, _Tu = 3, _Den = 100,
},
new KiemTra()
{
_Control = iKyHieuDen, _Tu = 3, _Den = 5, _ChoQua = !_TuyenBayD.DaTonTai("Ten", iKyHieuDi.Text + "-" + iKyHieuDen.Text, _TuyenBayO.ID), _ThongBao2 = "Tuyến bay đã tồn tại"
}
};
XuLyGiaoDien.KiemTra(kiemTras, dxValidationProvider1);
if (!dxValidationProvider1.Validate())
{
XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning);
return;
}
List <Dictionary <string, object> > Lstdic = new List <Dictionary <string, object> >();
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("KyHieuDen", iKyHieuDi.EditValue);
dic.Add("KyHieuDi", iKyHieuDen.EditValue);
dic.Add("Ten", iKyHieuDen.Text + "-" + iKyHieuDi.Text);
Dictionary <string, object> dic2 = new Dictionary <string, object>();
dic2.Add("KyHieuDen", iKyHieuDen.EditValue);
dic2.Add("KyHieuDi", iKyHieuDi.EditValue);
dic2.Add("Ten", iKyHieuDi.Text + "-" + iKyHieuDen.Text);
Lstdic.Add(dic);
Lstdic.Add(dic2);
long a = _TuyenBayD.ThemNhieu1Ban(Lstdic);
if (XuLyGiaoDien.ThongBao(Text, a > 0))
{
(Owner.ActiveMdiChild as frmTuyenBay).DuLieuSanBay();
Close();
}
}
void XulyDuLieuTruocKhiThem(Dictionary <string, object> Dic)
{
long a = 0;
List <Dictionary <string, object> > lstDicS = new List <Dictionary <string, object> >();
List <string> lstCTV = new List <string>();
for (int i = 0; i < GVH.RowCount; i++)
{
Dictionary <string, object> dicS = new Dictionary <string, object>(Dic);
for (int y = 0; y < GVH.Columns.Count; y++) //Dòng
{
if (y == GVH.Columns.Count - 1)
{
object G = GVH.GetRowCellValue(i, GVH.Columns[y]);
lstCTV.Add(string.Format("WHERE ID = {0}", G));
lstDicS.Add(dicS);
}
else
{
object G = GVH.GetRowCellValue(i, GVH.Columns[y]);
dicS.Add(GVH.Columns[y].FieldName, G);
}
}
}
a = (_GiaoDichO.ID > 0) ? _GiaoDichD.SuaNhieu1Ban(lstDicS, lstCTV) : _GiaoDichD.ThemNhieu1Ban(lstDicS);
if (XuLyGiaoDien.ThongBao(Text, a == lstDicS.Count))
{
GhiChuCmt(_GiaoDichO.ID);
if (iLoaiKhachHang.EditValue.ToString() != "3")
{
new D_DAILY().ChayLaiPhi((_GiaoDichO.NgayGD > iNgayGD.DateTime) ? iNgayGD.DateTime : _GiaoDichO.NgayGD);
}
if (Owner.ActiveMdiChild is frmVe)
{
(Owner.ActiveMdiChild as frmVe).DuLieu();
}
else
{
(Owner.ActiveMdiChild as frmTheoDoiHoan).DuLieu();
}
Close();
}
}
private void btnLuu2_Click(object sender, EventArgs e)
{
if (iDiem.Value == 0)
{
XuLyGiaoDien.ShowToolTip(iDiem, "Vui lòng cho điểm");
return;
}
Dictionary <string, object> dic = new Dictionary <string, object>();
dic = XuLyDuLieu.FormToDictionary(this, dic);
dic.Add("NhanVien", _NhanVien);
long CapNhatNum = (kpi.ID > 0) ? (kpid.CapNhat(dic, kpi.ID) > 0 ? kpi.ID : 0) : kpid.ThemMoi(dic, true);
if (XuLyGiaoDien.ThongBao(Text, CapNhatNum > 0))
{
(Owner as frmNhanVienThem).TaiLaiKPI();
Close();
}
}
private void btnLuu2_Click(object sender, EventArgs e)
{
List <KiemTra> kiemTras = new List <KiemTra>()
{
new KiemTra()
{
_Control = iTenDayDu, _Tu = 3, _Den = 100, _ChoQuaThang = !_SanBayD.DaTonTai("TenDayDu", iKyHieu.Text, _SanBayO.ID), _ThongBao2 = "Sân bay đã tồn tại"
},
new KiemTra()
{
_Control = iKyHieu, _Tu = 3, _Den = 5, _ChoQuaThang = !_SanBayD.DaTonTai("KyHieu", iKyHieu.Text, _SanBayO.ID), _ThongBao2 = "Sân bay đã tồn tại"
}
};
XuLyGiaoDien.KiemTra(kiemTras, dxValidationProvider1);
if (!dxValidationProvider1.Validate())
{
XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning);
return;
}
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("TenDayDu", iTenDayDu.Text);
dic.Add("KyHieu", iKyHieu.Text);
dic.Add("NoiDia", iNoiDia.Checked);
dic.Add("KhuVuc", (Text.StartsWith("Khu vực")));
long CapNhatNum = (_SanBayO.ID > 0) ? (_SanBayD.CapNhat(dic, _SanBayO.ID) > 0 ? _SanBayO.ID : 0) : _SanBayD.ThemMoi(dic, true);
if (XuLyGiaoDien.ThongBao(Text, CapNhatNum > 0))
{
if (Text.StartsWith("Khu vực"))
{
(Owner as frmNCCThem).KhuVuc();
}
else
{
(Owner.ActiveMdiChild as frmTuyenBay).DuLieuSanBay();
}
Close();
}
}
private void iAC1_CustomButtonClick(object sender, DevExpress.XtraBars.Docking2010.BaseButtonEventArgs e)
{
BindingSource bs = (BindingSource)GVKPI.DataSource;
List <O_KPI> dt = bs.DataSource as List <O_KPI>;
int sumObject = 0;
if (dt != null)
{
sumObject = dt.Select(w => w.Diem).Sum();
}
else
{
sumObject = 0;
}
switch (int.Parse(e.Button.Properties.Tag.ToString()))
{
case 1:
new frmKPIThem(_KhachHangO.ID, sumObject).ShowDialog(this);
break;
case 2:
if (dt.Count > 0)
{
O_KPI SignInOz = GVKPI.GetRow(GVKPI.GetSelectedRows()[0]) as O_KPI;
if (SignInOz != null)
{
new frmKPIThem(SignInOz, sumObject).ShowDialog(this);
}
}
break;
case 3:
if (dt.Count > 0)
{
O_KPI SignInOz = GVKPI.GetRow(GVKPI.GetSelectedRows()[0]) as O_KPI;
XuLyGiaoDien.ThongBao(Text, new D_KPI().Xoa(SignInOz.ID) > 0, true);
TaiLaiKPI();
}
break;
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
Dictionary <string, object> dic = new Dictionary <string, object>();
if (!btnHuy.Enabled)
{
dic.Add("NgayLuu", "GETDATE()");
}
dic.Add("TieuDe", iTieuDe.Text);
dic.Add("NoiDung", iNoiDung.Text);
dic.Add("GhiChuRieng", iGhiChu.Text);
dic.Add("TenNV", DuLieuTaoSan.NV.TenDangNhapCty);
long CapNhatNum = (ghiChu.ID > 0) ? (ghiChuD.CapNhat(dic, ghiChu.ID) > 0 ? ghiChu.ID : 0) : ghiChuD.ThemMoi(dic, true);
if (XuLyGiaoDien.ThongBao(Text + ((ghiChu.ID > 0) ? " sửa" : " thêm"), CapNhatNum > 0))
{
DSGhiChu.DataSource = ghiChuD.LayDanhSach();
iTieuDe.Text = iNoiDung.Text = iGhiChu.Text = string.Empty;
btnHuy.Enabled = false;
}
}
private void btnXDC_ItemClick(object sender, ItemClickEventArgs e)
{
O_GIAODICH GD = (GVDC.GetRow(GVDC.GetSelectedRows()[0]) as O_GIAODICH);
switch (GD.LoaiGiaoDich)
{
case 1:
case 0:
if (!DuLieuTaoSan.Q.KhacXoa)
{
return;
}
break;
default:
if (!DuLieuTaoSan.Q.KhacAdminXoa)
{
return;
}
break;
}
if (XuLyGiaoDien.ThongBao("giao dịch", new D_GIAODICH().Xoa(GD.ID) > 0, true))
{
string NoiDung = string.Format("Xóa GD ", GD.GhiChu);
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("FormName", Text);
dic.Add("MaCho", GD.MaCho);
dic.Add("NoiDung", NoiDung);
dic.Add("NVGiaoDich", DuLieuTaoSan.NV.ID);
dic.Add("LoaiKhachHang", GD.LoaiKhachHang);
dic.Add("Ma", GD.IDKhachHang);
new D_LS_GIAODICH().ThemMoi(dic);
NapDatCho();
}
else
{
XuLyGiaoDien.Alert("Xóa không thành công", Form_Alert.enmType.Error);
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
List <KiemTra> kiemTras = new List <KiemTra>()
{
new KiemTra()
{
_Control = iNCC, _Tu = 2, _Den = 50
},
new KiemTra()
{
_Control = iLoaiGiaoDich, _Tu = 2, _Den = 50
},
new KiemTra()
{
_Control = iGhiChu, _Tu = 2, _Den = 50
},
new KiemTra()
{
_Control = iSoTien, _Tu = 2, _Den = 5000
}
};
XuLyGiaoDien.KiemTra(kiemTras, dxValidationProvider1);
if (!dxValidationProvider1.Validate())
{
XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning);
return;
}
Dictionary <string, object> dic = new Dictionary <string, object>();
dic = XuLyDuLieu.FormToDictionary(this, dic);
if (XuLyGiaoDien.ThongBao(Text, _nCCGDO.ID != 0 ? (_nCCGDD.CapNhat(dic, _nCCGDO.ID) > 0) : (_nCCGDD.ThemMoi(dic) > 0)))
{
(Owner.ActiveMdiChild as frmHangBay).DuLieu();
Close();
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
if (!dxValidationProvider1.Validate())
{
XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning);
return;
}
D_NGANHANG nhb = new D_NGANHANG();
Dictionary <string, object> dic = new Dictionary <string, object>();
dic = XuLyDuLieu.FormToDictionary(this, dic);
long CapNhatNum = nho.ID > 0 ? nhb.CapNhat(dic, nho.ID) : nhb.ThemMoi(dic, true);
if (XuLyGiaoDien.ThongBao(Text, CapNhatNum > 0))
{
if (nho.ID < 1)
{
List <Dictionary <string, object> > lstDicS = new List <Dictionary <string, object> >();
for (int i = 0; i < 30; i++)
{
dic = new Dictionary <string, object>();
dic.Add("NganHangID", CapNhatNum);
dic.Add("SoDuCuoi", 0);
dic.Add("Ngay", "getdate() - " + i);
lstDicS.Add(dic);
}
new D_SODU_NGANHANG().ThemNhieu1Ban(lstDicS);
}
(Owner.ActiveMdiChild as frmNganHang).LayDLNganHang();
(Owner.ActiveMdiChild as frmNganHang).TaiLaiDuLieu();
(Owner.ActiveMdiChild as frmNganHang).LayDLKhac();
GhiChuCmt(nho.ID);
Close();
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
if (iTN.DateTime < iDN.DateTime && iCS.EditValue != null)
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("ChinhSachID", iCS.EditValue);
if (XuLyGiaoDien.ThongBao("Chi tiết chính sách sửa", _SODU_DAILYD.CapNhat(dic, IDDaiLy, "WHERE DAILYID= {0} and convert(date,Ngay) between '" + iTN.DateTime.ToString("yyyyMMdd") + "' and '" + iDN.DateTime.ToString("yyyyMMdd") + "'") > 0))
{
if (DateTime.Now.ToString("ddMMyyyy") == iDN.DateTime.ToString("ddMMyyyy"))
{
(Owner as frmDaiLyThem).iChinhSach.EditValue = iCS.EditValue;
dic = new Dictionary <string, object>();
dic.Add("ChinhSach", iCS.EditValue);
DaiLyD.CapNhat(dic, IDDaiLy);
}
DaiLyD.ChayLaiPhi(iTN.DateTime);
Close();
}
}
else
{
XtraMessageBox.Show("Thông tin nhập không hợp lệ. Vui lòng kiểm tra lại", "Thông báo");
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
bool ChoQua = false;
if (iMaHD.Text == "0" || !iMaHD.Enabled)
{
ChoQua = true;
}
else
{
ChoQua = !_HoaDonD.DaTonTai(string.Format("WHERE MaHD = N'{0}' AND ID not in ({1})", iMaHD.Text, String.Join(" ,", IDHD.ToArray())));
}
List <KiemTra> kiemTras = new List <KiemTra>()
{
new KiemTra()
{
_Control = iMaHD, _ChoQuaThang = ChoQua, _ThongBao2 = "Đã tồn tại", _Tu = 1
},
new KiemTra()
{
_Control = iIDKhachHang, _Tu = 2, _Den = 50
},
new KiemTra()
{
_Control = iDiaChi, _Tu = 10, _Den = 500
},
new KiemTra()
{
_Control = iMail, _Tu = 10, _Den = 200
},
};
XuLyGiaoDien.KiemTra(kiemTras, dxValidationProvider1);
if (!dxValidationProvider1.Validate())
{
XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning);
return;
}
Dictionary <string, object> dic = new Dictionary <string, object>();
dic = XuLyDuLieu.FormToDictionary(this, dic);
List <Dictionary <string, object> > lstDicS = new List <Dictionary <string, object> >();
List <string> lstCTV = new List <string>();
if (!aaa.Visible)
{
dic.Add("SoChungTu", _HoaDonD.TaoChungTu());
}
else
if (_HoaDonO.HoTro < 1)
{
_HoaDonO.HoTro = DuLieuTaoSan.NV.ID;
}
for (int i = 0; i < bandedGridView1.RowCount; i++)
{
Dictionary <string, object> dicS = new Dictionary <string, object>(dic);
for (int y = 0; y < bandedGridView1.Columns.Count; y++) //Dòng
{
if (bandedGridView1.Columns[y].FieldName.StartsWith("CL"))
{
continue;
}
if (bandedGridView1.Columns[y].Visible)//Cột
{
object G = bandedGridView1.GetRowCellValue(i, bandedGridView1.Columns[y]);
dicS.Add(bandedGridView1.Columns[y].FieldName, G);
}
else if (y == bandedGridView1.Columns.Count - 1)
{
object G = bandedGridView1.GetRowCellValue(i, bandedGridView1.Columns[y]);
lstCTV.Add(string.Format("WHERE ID = {0}", G));
lstDicS.Add(dicS);
}
}
}
long a = (_HoaDonO.ID > 0) ? _HoaDonD.SuaNhieu1Ban(lstDicS, lstCTV) : _HoaDonD.ThemNhieu1Ban(lstDicS);
if (XuLyGiaoDien.ThongBao(Text, a == lstDicS.Count))
{
(Owner.ActiveMdiChild as frmHoaDon).DuLieu();
Close();
}
}
private void btnEx_ItemClick(object sender, ItemClickEventArgs e)
{
DialogResult dal = XtraMessageBox.Show("Thu hồi chọn [OK], trả chiết khấu chọn [Cancel]", "Thông báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (XtraMessageBox.Show("Chỉ dùng cho đại lý. File gồm các cột [TenDaiLy,Gia,NoiDung]", "Thông báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Information) == DialogResult.Cancel)
{
return;
}
List <Dictionary <string, object> > lstdic = new List <Dictionary <string, object> >();
List <O_GIAODICH> giaoDichOs = new List <O_GIAODICH>();
XtraOpenFileDialog ofd = new XtraOpenFileDialog();
ofd.Title = "Mở File";
ofd.Filter = "Excel File (*.xlsx, *.xls) | *.xlsx; *.xls";
ofd.DefaultExt = ".xlsx";
if (ofd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
string ChuoiKetNoi = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + ofd.FileName + "; Extended Properties='Excel 12.0 Xml;HDR=YES';";
using (OleDbConnection conn = new OleDbConnection(ChuoiKetNoi))
{
conn.Open();
DataTable dbSchema = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
string CauTruyVan = "SELECT * FROM [" + dbSchema.Rows[0].Field <string>("TABLE_NAME").Replace("'", string.Empty) + ']';
OleDbDataAdapter da = new OleDbDataAdapter(CauTruyVan, conn);
DataTable dt = new DataTable();
da.Fill(dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow row = dt.Rows[i];
if ((row["TenDaiLy"] ?? "").ToString().Length > 0 && int.Parse((row["Gia"] ?? 0).ToString()) != 0)
{
if (lstDaiLy.Where(w => w.Ten.ToUpper().Equals(row["TenDaiLy"].ToString().Replace(" Total", "").ToUpper())).Count() > 0)
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("NgayGD", "getdate()");
dic.Add("NgayCuonChieu", "getdate()");
dic.Add("NVGiaoDich", DuLieuTaoSan.NV.ID);
dic.Add("CoDinh", 1);
dic.Add("LoaiKhachHang", "1");
dic.Add("IDKhachHang", lstDaiLy.Where(w => w.Ten.ToUpper().Equals(row["TenDaiLy"].ToString().Replace(" Total", "").ToUpper())).First().ID);
if (dal == DialogResult.OK)
{
dic.Add("GiaHeThong", int.Parse(row["Gia"].ToString().Replace("-", "")));
dic.Add("GiaThu", int.Parse(row["Gia"].ToString().Replace("-", "")));
dic.Add("LoaiGiaoDich", 6);
dic.Add("GiaHoan", 0);
}
else
{
dic.Add("GiaHeThong", 0);
dic.Add("GiaThu", 0);
dic.Add("LoaiGiaoDich", 12);
dic.Add("GiaHoan", int.Parse(row["Gia"].ToString().Replace("-", "")));
}
dic.Add("TenKhach", row["NoiDung"].ToString());
lstdic.Add(dic);
}
else
{
XuLyGiaoDien.Alert($"Thông tin đại lý dòng {i} sai", Form_Alert.enmType.Error);
return;
}
}
else
{
XuLyGiaoDien.Alert("Cột Tên đại lý hoặc Giá thiếu thông tin", Form_Alert.enmType.Error);
return;
}
}
if (dt.Rows.Count == lstdic.Count)
{
if (XuLyGiaoDien.ThongBao(Text, new D_GIAODICH().ThemNhieu1Ban(lstdic) > 0))
{
NapDatCho();
Close();
}
}
}
}
}
private void btnDel_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (XtraMessageBox.Show("Bạn có chắc xóa", "Thông báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.Cancel)
{
return;
}
cTNgan = (GVCTNH.GetRow(GVCTNH.GetSelectedRows()[0]) as O_CTNGANHANG);
D_CTNGANHANG nh = new D_CTNGANHANG();
List <object> lstCtv = new List <object>();
if (cTNgan.LoaiKhachHang == 7)
{
List <O_CTNGANHANG> cTNganHangOs = new D_CTNGANHANG().Dem($"WHERE MaLienKet = '{cTNgan.MaLienKet}'");
if (cTNganHangOs.Count == 2)
{
lstCtv.Add(cTNganHangOs[0].ID);
lstCtv.Add(cTNganHangOs[1].ID);
}
else
{
XuLyGiaoDien.Alert("Sai định dạng", Form_Alert.enmType.Info);
return;
}
}
else
{
lstCtv.Add(cTNgan.ID);
new D_BAOCAOCTNH().Xoa(cTNgan.ID, "WHERE IDCTNganHang = {0}");
}
if (XuLyGiaoDien.ThongBao(Text, nh.XoaNhieu1Ban(lstCtv, "CTNGANHANG") > 0, true))
{
if (cTNgan.LoaiKhachHang == 1 || cTNgan.LoaiKhachHang == 2)
{
new D_DAILY().ChayLaiPhi(cTNgan.NgayHT);
}
else if (cTNgan.LoaiKhachHang == 4 || cTNgan.LoaiKhachHang == 30)
{
List <O_GIAODICH> _GiaoDich = new D_GIAODICH().DuLieuNganHang(cTNgan.IDGiaoDich);
List <Dictionary <string, object> > lstdic2 = new List <Dictionary <string, object> >();
List <string> CTV = new List <string>();
Dictionary <string, object> dic2 = new Dictionary <string, object>();
for (int i = 0; i < _GiaoDich.Count; i++)
{
O_GIAODICH gd = _GiaoDich[i];
dic2 = new Dictionary <string, object>();
CTV.Add(string.Format("WHERE ID = {0}", gd.ID));
dic2.Add("Khoa", false);
lstdic2.Add(dic2);
}
new D_GIAODICH().SuaNhieu1Ban(lstdic2, CTV);
}
nhD.ChayLaiSD();
string NoiDung = string.Format("Xóa GD Ngân Hàng : {0} VNĐ [{1}]", cTNgan.SoTien.ToString("#,###"), cTNgan.GhiChu);
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("FormName", Text);
dic.Add("MaCho", cTNgan.MaLienKet);
dic.Add("NoiDung", NoiDung);
dic.Add("NVGiaoDich", DuLieuTaoSan.NV.ID);
dic.Add("LoaiKhachHang", cTNgan.LoaiKhachHang);
dic.Add("Ma", cTNgan.MaDL);
if (NoiDung.Length > 10)
{
new D_LS_GIAODICH().ThemMoi(dic);
}
TaiLaiDuLieu();
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
D_GIAODICH nhb = new D_GIAODICH();
switch (iLoaiGiaoDich.EditValue.ToString())
{
case "1":
case "0":
if (!DuLieuTaoSan.Q.KhacThemSua)
{
return;
}
break;
default:
if (!DuLieuTaoSan.Q.Lv2KhacAdmin)
{
return;
}
break;
}
List <KiemTra> kiemTras = new List <KiemTra>()
{
new KiemTra()
{
_Control = iIDKhachHang, _Tu = 2, _Den = 50
},
new KiemTra()
{
_Control = iLoaiKhachHang, _Tu = 2, _Den = 50
},
new KiemTra()
{
_Control = iLoaiGiaoDich, _Tu = 2, _Den = 50
},
new KiemTra()
{
_Control = iTenKhach, _Tu = 2, _Den = 50
},
new KiemTra()
{
_Control = iMaCho, _Tu = 2, _Den = 50, _ChoQuaThang = !(new List <int>()
{
1, 0
}).Contains((int)iLoaiGiaoDich.EditValue)
}
};
XuLyGiaoDien.KiemTra(kiemTras, dxValidationProvider1);
if (!dxValidationProvider1.Validate())
{
XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning);
return;
}
#region Lưu
Dictionary <string, object> dic = new Dictionary <string, object>();
dic = XuLyDuLieu.FormToDictionary(this, dic);
dic.Add("NgayCuonChieu", "getdate()");
dic.Add("NVGiaoDich", DuLieuTaoSan.NV.ID);
dic.Add("CoDinh", 1);
if ((new List <int>()
{
7, 11, 12
}).Contains((int)iLoaiGiaoDich.EditValue))
{
dic.Remove("GiaThu");
dic.Add("GiaHeThong", 0);
dic.Add("GiaThu", 0);
dic.Add("GiaHoan", iGiaThu.Value);
}
else
{
dic.Add("GiaHeThong", iGiaThu.Value);
}
if (XuLyGiaoDien.ThongBao(Text, Gd.ID != 0 ? (nhb.CapNhat(dic, Gd.ID) > 0) : (nhb.ThemMoi(dic) > 0)))
{
(Owner.ActiveMdiChild as frmTongHop).NapDatCho();
GhiChuCmt(Gd.ID);
Close();
}
#endregion
}
