private void LoadDanhSachHocVien()
{
try
{
PhieuGhiDanhFilter _filter = new PhieuGhiDanhFilter();
_filter.CoSoId = GlobalSettings.CoSoId;
_filter.NgayGhiDanh_Tu = date_TuNgay.DateTime;
_filter.NgayGhiDanh_Den = date_DenNgay.DateTime;
List <QLHocPhi_PlusDTO> _lstQLHocPhi = PhieuGhiDanhLogic.SelectQLHocPhi(_filter);
if (_lstQLHocPhi != null)
{
gridControlDSHocVien.DataSource = _lstQLHocPhi;
}
else
{
gridControlDSHocVien.DataSource = null;
}
gridControlPhieuThu.DataSource = null;
lblMaHocVien.Text = String.Empty;
lblTenHocVien.Text = String.Empty;
lblHocPhi.Text = String.Empty;
lblDaDong.Text = String.Empty;
lblConNo.Text = String.Empty;
lblMienGiam_Tien.Text = string.Empty;
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Warn(ex);
}
}
private void btnTimKiem_Click(object sender, EventArgs e)
{
SplashScreenManager.ShowForm(typeof(O2S_Common.Utilities.ThongBao.WaitForm_Wait));
try
{
PhieuGhiDanhFilter _filter = new PhieuGhiDanhFilter();
_filter.CoSoId = GlobalSettings.CoSoId;
_filter.NgayGhiDanh_Tu = date_TuNgay.DateTime;
_filter.NgayGhiDanh_Den = date_DenNgay.DateTime;
this.lstHVNoHocPhi = PhieuGhiDanhLogic.Select(_filter).Where(o => o.ConNo > 0).ToList();
if (this.lstHVNoHocPhi != null && this.lstHVNoHocPhi.Count > 0)
{
for (int i = 0; i < this.lstHVNoHocPhi.Count; i++)
{
this.lstHVNoHocPhi[i].Stt = i + 1;
}
gridControlDSBaoCao.DataSource = this.lstHVNoHocPhi;
}
else
{
gridControlDSBaoCao.DataSource = null;
}
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Error(ex);
}
SplashScreenManager.CloseForm();
}
private void btnTimKiem_Click(object sender, EventArgs e)
{
SplashScreenManager.ShowForm(typeof(O2S_Common.Utilities.ThongBao.WaitForm_Wait));
try
{
PhieuGhiDanhFilter _filter = new PhieuGhiDanhFilter();
_filter.CoSoId = GlobalSettings.CoSoId;
_filter.NgayGhiDanh_Tu = date_TuNgay.DateTime;
_filter.NgayGhiDanh_Den = date_DenNgay.DateTime;
this._lstPhieuGhiDanh = PhieuGhiDanhLogic.Select(_filter);
if (this._lstPhieuGhiDanh != null && this._lstPhieuGhiDanh.Count > 0)
{
gridControlDSPhieuGhiDanh.DataSource = this._lstPhieuGhiDanh;
}
else
{
gridControlDSPhieuGhiDanh.DataSource = null;
}
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Error(ex);
}
SplashScreenManager.CloseForm();
}
private void LoadDanhSachHocVien()
{
SplashScreenManager.ShowForm(typeof(O2S_Common.Utilities.ThongBao.WaitForm_Wait));
try
{
PhieuGhiDanhFilter _filter = new PhieuGhiDanhFilter();
_filter.CoSoId = GlobalSettings.CoSoId;
_filter.NgayGhiDanh_Tu = date_TuNgay.DateTime;
_filter.NgayGhiDanh_Den = date_DenNgay.DateTime;
List <QLHocPhi_PlusDTO> _lstQLHocPhi = PhieuGhiDanhLogic.SelectQLHocPhiOption1(_filter);
if (_lstQLHocPhi != null)
{
gridControlDSHocVien.DataSource = _lstQLHocPhi;
}
else
{
gridControlDSHocVien.DataSource = null;
}
gridControlPhieuThu.DataSource = null;
lblMaHocVien.Text = String.Empty;
lblTenHocVien.Text = String.Empty;
lblHocPhi.Text = String.Empty;
lblDaDong.Text = String.Empty;
lblConNo.Text = String.Empty;
lblMienGiam_Tien.Text = string.Empty;
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Warn(ex);
}
SplashScreenManager.CloseForm();
}
public void LoadPhieuGhiDanh()
{
PhieuGhiDanhFilter _filter = new PhieuGhiDanhFilter();
_filter.CoSoId = GlobalSettings.CoSoId;
_filter.NgayGhiDanh_Tu = date_TuNgay.DateTime;
_filter.NgayGhiDanh_Den = date_DenNgay.DateTime;
List <PhieuGhiDanh_PlusDTO> _lstPhieuGhiDanh = PhieuGhiDanhLogic.SelectOption1(_filter);
gridControlDSPhieuGhiDanh.DataSource = _lstPhieuGhiDanh;
lblTongCongPhieu.Text = string.Format("Tổng cộng: {0} phiếu ghi danh", gridViewDSPhieuGhiDanh.RowCount);
}
private void ValidateXoaHocVien(int _hocvienId)
{
//hv khong cho xoa: da lap phieu ghi danh
PhieuGhiDanhFilter _filter = new PhieuGhiDanhFilter()
{
HocVienId = _hocvienId,
};
List <PhieuGhiDanh_PlusDTO> _lstphieugd = PhieuGhiDanhLogic.Select(_filter);
if (_lstphieugd != null && _lstphieugd.Count > 0)
{
throw new ArgumentException("Học viên đã lập phiếu ghi danh nên không thể xóa được.");
}
}
private void ValidateXoaKhoaHoc(int _KhoaHocId)
{
//kiem tra neu khóa học đã có trong PHIEUGHIDANH thì không cho xóa
PhieuGhiDanhFilter _filter = new PhieuGhiDanhFilter();
_filter.KhoaHocId = _KhoaHocId;
_filter.CoSoId = GlobalSettings.CoSoId;
List <PhieuGhiDanh_PlusDTO> _lstPhieuGD = PhieuGhiDanhLogic.Select(_filter);
if (_lstPhieuGD != null && _lstPhieuGD.Count > 0)
{
throw new ArgumentException("Khóa học đã được sử dụng nên không thể xóa");
}
}
private void ValidateLuuPhieu()
{
var rowHandle = gridViewDSHocVien.FocusedRowHandle;
PhieuGhiDanhFilter _filter = new PhieuGhiDanhFilter();
_filter.HocVienId = O2S_Common.TypeConvert.Parse.ToInt32(gridViewDSHocVien.GetRowCellValue(rowHandle, "HocVienId").ToString());
var f = PhieuGhiDanhLogic.Select(_filter);
foreach (var i in f)
{
if (i.ConNo > 0)
{
throw new Exception("Học viên đang nợ không được phép ghi danh mới");
}
}
if (O2S_Common.TypeConvert.Parse.ToDecimal(numDaDong.Text) < O2S_Common.TypeConvert.Parse.ToDecimal(GlobalSettings.lstQuyDinh["QD0001"]))
{
throw new Exception(string.Format("Số tiền đóng khi ghi danh phải ít nhất bằng {0:C0}", GlobalSettings.lstQuyDinh["QD0001"]));
}
}
public static List <PhieuGhiDanh_PlusDTO> Select(PhieuGhiDanhFilter _filter)
{
try
{
var query = (from obj in GlobalSettings.Database.PHIEUGHIDANHs
where obj.IsRemove != 1
select new PhieuGhiDanh_PlusDTO
{
CoSoId = obj.HOCVIEN.CoSoId,
PhieuGhiDanhId = obj.PhieuGhiDanhId,
HocVienId = obj.HocVienId,
MaHocVien = obj.HOCVIEN.MaHocVien,
TenHocVien = obj.HOCVIEN.TenHocVien,
NgaySinh = obj.HOCVIEN.NgaySinh,
GioiTinh = obj.HOCVIEN.GioiTinh,
KhoaHocId = obj.KhoaHocId,
TenKhoaHoc = obj.KHOAHOC.TenKhoaHoc,
MaPhieuGhiDanh = obj.MaPhieuGhiDanh,
NgayGhiDanh = obj.NgayGhiDanh,
HocPhiKH = obj.HocPhiKH,
SoTietKH = obj.SoTietKH,
HocPhiHocVienKH = obj.HocPhiHocVienKH,
SoTietHocVienKH = obj.SoTietHocVienKH,
ThuKhoanKhac = obj.ThuKhoanKhac,
TongTien = obj.TongTien,
DaDong = obj.DaDong,
MienGiam_PhanTram = obj.MienGiam_PhanTram,
MienGiam_Tien = obj.MienGiam_Tien,
LyDoMienGiam = obj.LyDoMienGiam,
ConNo = obj.ConNo,
IsRemove = obj.IsRemove,
NhanVienId = obj.NhanVienId,
CreatedDate = obj.CreatedDate,
CreatedBy = obj.CreatedBy,
CreatedLog = obj.CreatedLog,
ModifiedDate = obj.ModifiedDate,
ModifiedBy = obj.ModifiedBy,
ModifiedLog = obj.ModifiedLog,
}).ToList();
if (_filter.CoSoId != null && _filter.CoSoId != 0)
{
query = query.Where(o => o.CoSoId == _filter.CoSoId).ToList();
}
if (_filter.KhoaHocId != null && _filter.KhoaHocId != 0)
{
query = query.Where(o => o.KhoaHocId == _filter.KhoaHocId).ToList();
}
if (_filter.PhieuGhiDanhId != null && _filter.PhieuGhiDanhId != 0)
{
query = query.Where(o => o.PhieuGhiDanhId == _filter.PhieuGhiDanhId).ToList();
}
if (_filter.HocVienId != null && _filter.HocVienId != 0)
{
query = query.Where(o => o.HocVienId == _filter.HocVienId).ToList();
}
if (_filter.NgayGhiDanh_Tu != null && _filter.NgayGhiDanh_Den != null)
{
query = query.Where(o => o.NgayGhiDanh >= _filter.NgayGhiDanh_Tu && o.NgayGhiDanh <= _filter.NgayGhiDanh_Den).ToList();
}
for (int i = 0; i < query.Count; i++)
{
query[i].Stt = i + 1;
}
return(query.ToList());
}
catch (System.Exception ex)
{
return(null);
O2S_Common.Logging.LogSystem.Error(ex);
}
}
public static bool XoaPhieuGhiDanh(PHIEUGHIDANH _phieuGD)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
//xoa HOCPHIHOCVIEN
List <HOCPHIHOCVIEN> _lstHPHV = HocPhiHocVienLogic.SelectTheoPhieuGhiDanh(_phieuGD.PhieuGhiDanhId);
if (_lstHPHV != null && _lstHPHV.Count > 0)
{
Database.HOCPHIHOCVIENs.DeleteAllOnSubmit(_lstHPHV);
//Database.SubmitChanges();
}
//Xoa bang PHIEUTHU;
List <PHIEUTHU> _lstPhieuThu = PhieuThuLogic.SelectTheoPhieuGhiDanh(_phieuGD.PhieuGhiDanhId);
if (_lstPhieuThu != null && _lstPhieuThu.Count > 0)
{
Database.PHIEUTHUs.DeleteAllOnSubmit(_lstPhieuThu);
// Database.SubmitChanges();
}
//update=Xoa bang PHIEUGHIDANH
//PHIEUGHIDANH _phieuGDUpdate = SelectSingle(_phieuGD.PhieuGhiDanhId);
_phieuGD.IsRemove = _phieuGD.IsRemove;
_phieuGD.LyDoXoa = _phieuGD.LyDoXoa;
_phieuGD.NguoiXoa = _phieuGD.NguoiXoa;
_phieuGD.ModifiedDate = DateTime.Now;
_phieuGD.ModifiedBy = GlobalSettings.UserCode;
_phieuGD.ModifiedLog = GlobalSettings.SessionMyIP;
//Database.SubmitChanges();
//cap nhat bang HOCVIEN va bang tai khoan: kiem tra HV hoc khoa nao ko? neu=1 thi update
PhieuGhiDanhFilter _filter = new PhieuGhiDanhFilter();
_filter.HocVienId = _phieuGD.HocVienId;
List <PhieuGhiDanh_PlusDTO> _PGD_Kiemtra = PhieuGhiDanhLogic.Select(_filter);
if (_PGD_Kiemtra == null || _PGD_Kiemtra.Count <= 1)
{
HOCVIEN _hocvien = HocVienLogic.SelectSingle(_phieuGD.HocVienId ?? 0);
_hocvien.LOAIHOCVIEN = LoaiHocVienLogic.Select(KeySetting.LOAIHOCVIEN_TIEMNANG);
Database.SubmitChanges();
TAIKHOAN _taikhoan = TaiKhoanLogic.SelectTheoTenDangNhap(_hocvien.TAIKHOAN.TenDangNhap);
_taikhoan.IsRemove = 1;
//Database.SubmitChanges();
}
//Kiem tra lop hoc va xoa bang diem
List <BANGDIEM> _bangdiem = BangDiemLogic.SelectTheoPhieuGhiDanh(_phieuGD.PhieuGhiDanhId);
if (_bangdiem != null && _bangdiem.Count > 0)
{
Database.BANGDIEMs.DeleteAllOnSubmit(_bangdiem);
//Update So luong hoc vien trong lop hoc...
LOPHOC _lopHoc = LopHocLogic.SelectSingle(_phieuGD.LopHocId ?? 0);
if (_lopHoc != null)
{
_lopHoc.SiSo = (from p in Database.BANGDIEMs
where p.LopHocId == (_phieuGD.LopHocId ?? 0) && p.IsRemove != 1
select p).Count();
_lopHoc.ModifiedDate = DateTime.Now;
_lopHoc.ModifiedBy = GlobalSettings.UserCode;
_lopHoc.ModifiedLog = GlobalSettings.SessionMyIP;
Database.SubmitChanges();
}
}
Database.SubmitChanges();
ts.Complete();
return(true);
}
}
catch (System.Exception ex)
{
return(false);
O2S_Common.Logging.LogSystem.Error(ex);
}
}
public static List <QLHocPhi_PlusDTO> SelectQLHocPhiOption1(PhieuGhiDanhFilter _filter)
{
try
{
var query = (from p in GlobalSettings.Database.PHIEUGHIDANHs
where p.IsRemove != 1
select p).AsEnumerable().Select((obj, index) => new QLHocPhi_PlusDTO
{
Stt = index + 1,
PhieuGhiDanhId = obj.PhieuGhiDanhId,
CoSoId = obj.CoSoId,
HocVienId = obj.HocVienId,
TenHocVien = obj.HOCVIEN.TenHocVien,
MaHocVien = obj.HOCVIEN.MaHocVien,
GioiTinh = obj.HOCVIEN.GioiTinh,
NgaySinh = obj.HOCVIEN.NgaySinh,
DiaChi = obj.HOCVIEN.DiaChi,
KhoaHocId = obj.KhoaHocId,
TenKhoaHoc = obj.KHOAHOC.TenKhoaHoc,
TenLopHoc = (from diem in GlobalSettings.Database.BANGDIEMs where diem.PhieuGhiDanhId == obj.PhieuGhiDanhId select diem.LOPHOC.TenLopHoc).SingleOrDefault() ?? "",
//obj.BANGDIEMs.Where(o=>o.PhieuGhiDanhId==obj.PhieuGhiDanhId).SingleOrDefault().LOPHOC.TenLopHoc,
MaPhieuGhiDanh = obj.MaPhieuGhiDanh,
NgayGhiDanh = obj.NgayGhiDanh,
SoTietKH = (from dot in Database.DOTHOCs where dot.LopHocId == obj.LopHocId select dot.SoBuoiHoc).Sum(),
HocPhiKH = (from dot in Database.DOTHOCs where dot.LopHocId == obj.LopHocId select dot.HocPhi).Sum(),
SoLuongDotHoc = (from dot in Database.DOTHOCs where dot.LopHocId == obj.LopHocId select dot).Count(),
SoTietHocVienKH = (from _hocPhi in Database.HOCPHIHOCVIENs where _hocPhi.PhieuGhiDanhId == obj.PhieuGhiDanhId && _hocPhi.DmDichVuId != 0 select _hocPhi.SoLuong).Sum(),
HocPhiHocVienKH = (from _hocPhi in Database.HOCPHIHOCVIENs where _hocPhi.PhieuGhiDanhId == obj.PhieuGhiDanhId && _hocPhi.DmDichVuId != 0 select _hocPhi.SoTien).Sum(),
TongTien = (from _hocPhi in Database.HOCPHIHOCVIENs where _hocPhi.PhieuGhiDanhId == obj.PhieuGhiDanhId select _hocPhi.SoTien).Sum(),
ThuKhoanKhac = (from _hocPhi in Database.HOCPHIHOCVIENs where _hocPhi.PhieuGhiDanhId == obj.PhieuGhiDanhId && _hocPhi.DmDichVuId == 0 select _hocPhi.SoTien).Sum(),
DaDong = (from _phieuthu in Database.PHIEUTHUs where _phieuthu.PhieuGhiDanhId == obj.PhieuGhiDanhId && _phieuthu.IsRemove == 0 select _phieuthu.SoTien).Sum(),
MienGiam_PhanTram = obj.MienGiam_PhanTram,
MienGiam_Tien = obj.MienGiam_Tien,
LyDoMienGiam = obj.LyDoMienGiam,
ConNo = (from _hocPhi in Database.HOCPHIHOCVIENs where _hocPhi.PhieuGhiDanhId == obj.PhieuGhiDanhId select _hocPhi.SoTien).Sum() - (from _phieuthu in Database.PHIEUTHUs where _phieuthu.PhieuGhiDanhId == obj.PhieuGhiDanhId && _phieuthu.IsRemove == 0 select _phieuthu.SoTien).Sum(),
IsRemove = obj.IsRemove,
NhanVienId = obj.NhanVienId,
CreatedDate = obj.CreatedDate,
CreatedBy = obj.CreatedBy,
CreatedLog = obj.CreatedLog,
ModifiedDate = obj.ModifiedDate,
ModifiedBy = obj.ModifiedBy,
ModifiedLog = obj.ModifiedLog,
});
if (_filter.CoSoId != null && _filter.CoSoId != 0)
{
query = query.Where(o => o.CoSoId == _filter.CoSoId).ToList();
}
if (_filter.KhoaHocId != null && _filter.KhoaHocId != 0)
{
query = query.Where(o => o.KhoaHocId == _filter.KhoaHocId).ToList();
}
if (_filter.PhieuGhiDanhId != null && _filter.PhieuGhiDanhId != 0)
{
query = query.Where(o => o.PhieuGhiDanhId == _filter.PhieuGhiDanhId).ToList();
}
if (_filter.HocVienId != null && _filter.HocVienId != 0)
{
query = query.Where(o => o.HocVienId == _filter.HocVienId).ToList();
}
if (_filter.NgayGhiDanh_Tu != null && _filter.NgayGhiDanh_Den != null)
{
query = query.Where(o => o.NgayGhiDanh >= _filter.NgayGhiDanh_Tu && o.NgayGhiDanh <= _filter.NgayGhiDanh_Den).ToList();
}
return(query.ToList());
}
catch (System.Exception ex)
{
return(null);
O2S_Common.Logging.LogSystem.Error(ex);
}
}
public static List <QLHocPhi_PlusDTO> SelectQLHocPhi(PhieuGhiDanhFilter _filter)
{
try
{
var query = (from p in GlobalSettings.Database.PHIEUGHIDANHs
where p.IsRemove != 1
select p).AsEnumerable().Select((obj, index) => new QLHocPhi_PlusDTO
{
Stt = index + 1,
PhieuGhiDanhId = obj.PhieuGhiDanhId,
CoSoId = obj.CoSoId,
HocVienId = obj.HocVienId,
TenHocVien = obj.HOCVIEN.TenHocVien,
MaHocVien = obj.HOCVIEN.MaHocVien,
GioiTinh = obj.HOCVIEN.GioiTinh,
NgaySinh = obj.HOCVIEN.NgaySinh,
DiaChi = obj.HOCVIEN.DiaChi,
KhoaHocId = obj.KhoaHocId,
TenKhoaHoc = obj.KHOAHOC.TenKhoaHoc,
TenLopHoc = (from diem in GlobalSettings.Database.BANGDIEMs where diem.PhieuGhiDanhId == obj.PhieuGhiDanhId select diem.LOPHOC.TenLopHoc).SingleOrDefault() ?? "",
//obj.BANGDIEMs.Where(o=>o.PhieuGhiDanhId==obj.PhieuGhiDanhId).SingleOrDefault().LOPHOC.TenLopHoc,
MaPhieuGhiDanh = obj.MaPhieuGhiDanh,
NgayGhiDanh = obj.NgayGhiDanh,
TongTien = obj.TongTien,
DaDong = obj.DaDong,
MienGiam_PhanTram = obj.MienGiam_PhanTram,
MienGiam_Tien = obj.MienGiam_Tien,
LyDoMienGiam = obj.LyDoMienGiam,
ConNo = obj.ConNo,
IsRemove = obj.IsRemove,
NhanVienId = obj.NhanVienId,
CreatedDate = obj.CreatedDate,
CreatedBy = obj.CreatedBy,
CreatedLog = obj.CreatedLog,
ModifiedDate = obj.ModifiedDate,
ModifiedBy = obj.ModifiedBy,
ModifiedLog = obj.ModifiedLog,
});
if (_filter.CoSoId != null && _filter.CoSoId != 0)
{
query = query.Where(o => o.CoSoId == _filter.CoSoId).ToList();
}
if (_filter.KhoaHocId != null && _filter.KhoaHocId != 0)
{
query = query.Where(o => o.KhoaHocId == _filter.KhoaHocId).ToList();
}
if (_filter.PhieuGhiDanhId != null && _filter.PhieuGhiDanhId != 0)
{
query = query.Where(o => o.PhieuGhiDanhId == _filter.PhieuGhiDanhId).ToList();
}
if (_filter.HocVienId != null && _filter.HocVienId != 0)
{
query = query.Where(o => o.HocVienId == _filter.HocVienId).ToList();
}
if (_filter.NgayGhiDanh_Tu != null && _filter.NgayGhiDanh_Den != null)
{
query = query.Where(o => o.NgayGhiDanh >= _filter.NgayGhiDanh_Tu && o.NgayGhiDanh <= _filter.NgayGhiDanh_Den).ToList();
}
return(query.ToList());
}
catch (System.Exception ex)
{
return(null);
O2S_Common.Logging.LogSystem.Error(ex);
}
}