private void gridViewDSHocVien_Click(object sender, EventArgs e)
{
try
{
var rowHandle = gridViewDSHocVien.FocusedRowHandle;
this.HocVienId_Select = O2S_Common.TypeConvert.Parse.ToInt32(gridViewDSHocVien.GetRowCellValue(rowHandle, "HocVienId").ToString());
this.PhieuGhiDanhId_Select = O2S_Common.TypeConvert.Parse.ToInt32(gridViewDSHocVien.GetRowCellValue(rowHandle, "PhieuGhiDanhId").ToString());
PHIEUGHIDANH _phieugd = PhieuGhiDanhLogic.SelectSingle(this.PhieuGhiDanhId_Select);
lblMaHocVien.Text = _phieugd.HOCVIEN.MaHocVien;
lblTenHocVien.Text = _phieugd.HOCVIEN.TenHocVien;
lblHocPhi.Text = O2S_Common.Number.Convert.NumberToString(O2S_Common.TypeConvert.Parse.ToDecimal(_phieugd.TongTien.ToString()), 0);
lblDaDong.Text = O2S_Common.Number.Convert.NumberToString(O2S_Common.TypeConvert.Parse.ToDecimal(_phieugd.DaDong.ToString()), 0);
lblConNo.Text = O2S_Common.Number.Convert.NumberToString(O2S_Common.TypeConvert.Parse.ToDecimal(_phieugd.ConNo.ToString()), 0);
lblMienGiam_Tien.Text = O2S_Common.Number.Convert.NumberToString(O2S_Common.TypeConvert.Parse.ToDecimal(_phieugd.MienGiam_Tien.ToString()), 0);
numDaDong.Text = _phieugd.ConNo.ToString();
//Load danh sach phieu thu
PhieuThuFilter _filter = new PhieuThuFilter();
_filter.HocVienId = this.HocVienId_Select;
_filter.PhieuGhiDanhId = this.PhieuGhiDanhId_Select;
LoadDanhSachPhieuThu(_filter);
//Load dot hoc theo lop hoc
if (_phieugd.LopHocId != null && _phieugd.LopHocId != 0)
{
cboDotHoc.DataSource = DotHocLogic.SelectDotHocChucDongTien(_phieugd.LopHocId ?? 0, this.PhieuGhiDanhId_Select);
cboDotHoc.DisplayMember = "TenDotHoc";
cboDotHoc.ValueMember = "DotHocId";
}
else
{
cboDotHoc.DataSource = null;
cboDotHoc.DisplayMember = "TenDotHoc";
cboDotHoc.ValueMember = "DotHocId";
}
btnInBienLai.Enabled = false;
//if (_phieugd.ConNo == 0)
//{
// btnLuuLai.Enabled = false;
// numDaDong.ReadOnly = true;
//}
//else
//{
// btnLuuLai.Enabled = true;
// numDaDong.ReadOnly = false;
//}
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Error(ex);
}
}
private void btnThemVaoLop_Click(object sender, EventArgs e)
{
try
{
if (gridViewHV_ChuaXepLop.RowCount > 0)
{
int _lophocId = O2S_Common.TypeConvert.Parse.ToInt32(cboLopHoc.SelectedValue.ToString());
LOPHOC _lophoc = LopHocLogic.SelectSingle(_lophocId);
if (gridViewHV_XepLop.RowCount < _lophoc.SiSoToiDa ||
MessageBox.Show("Số học viên tối đa của lớp là " + _lophoc.SiSoToiDa + Environment.NewLine + "Bạn có chắc sẽ thêm?",
"Cảnh báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
var rowHandle = gridViewHV_ChuaXepLop.FocusedRowHandle;
int _phieughidanhId = O2S_Common.TypeConvert.Parse.ToInt32(gridViewHV_ChuaXepLop.GetRowCellValue(rowHandle, "PhieuGhiDanhId").ToString());
PHIEUGHIDANH _phieuGD = PhieuGhiDanhLogic.SelectSingle(_phieughidanhId);
XepLopDTO _hocvienLop = new XepLopDTO();
_hocvienLop.HocVienId = _phieuGD.HocVienId;
_hocvienLop.MaHocVien = _phieuGD.HOCVIEN.MaHocVien;
_hocvienLop.TenHocVien = _phieuGD.HOCVIEN.TenHocVien;
_hocvienLop.PhieuGhiDanhId = _phieuGD.PhieuGhiDanhId;
_hocvienLop.MaPhieuGhiDanh = _phieuGD.MaPhieuGhiDanh;
_hocvienLop.NgayGhiDanh = _phieuGD.NgayGhiDanh;
_hocvienLop.NgaySinh = _phieuGD.HOCVIEN.NgaySinh;
_hocvienLop.GioiTinh = _phieuGD.HOCVIEN.GioiTinh;
_hocvienLop.DiaChi = _phieuGD.HOCVIEN.DiaChi;
_hocvienLop.Sdt = _phieuGD.HOCVIEN.Sdt;
_hocvienLop.Email = _phieuGD.HOCVIEN.Email;
_hocvienLop.KhoaHocId = _phieuGD.KhoaHocId;
_hocvienLop.MaKhoaHoc = _phieuGD.KHOAHOC.MaKhoaHoc;
_hocvienLop.TenKhoaHoc = _phieuGD.KHOAHOC.TenKhoaHoc;
this.dsXepLopHocVien.Add(_hocvienLop);
XepLopDTO _xoa = this.dsChuaCoLop.Where(o => o.PhieuGhiDanhId == _hocvienLop.PhieuGhiDanhId && o.KhoaHocId == _hocvienLop.KhoaHocId).FirstOrDefault();
this.dsChuaCoLop.Remove(_xoa);
gridControlHV_ChuaXepLop.DataSource = null;
gridControlHV_ChuaXepLop.DataSource = this.dsChuaCoLop;
gridControlHV_XepLop.DataSource = null;
gridControlHV_XepLop.DataSource = this.dsXepLopHocVien;
}
}
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Warn(ex);
}
}
private void btnLuuLai_Click(object sender, EventArgs e)
{
try
{
ValidateLuu();
//Update PHIEUGHIDANH
PHIEUGHIDANH _phieughidanh = PhieuGhiDanhLogic.SelectSingle(this.PhieuGhiDanhId_Select);
_phieughidanh.DaDong = _phieughidanh.DaDong + O2S_Common.TypeConvert.Parse.ToDecimal(numNopThem.Text);
decimal _mienggiam = _phieughidanh.MienGiam_Tien ?? 0;
_phieughidanh.ConNo = _phieughidanh.TongTien - _phieughidanh.DaDong - _mienggiam;
//Insert Phieu Thu
var rowHandle = gridViewDSHocVien.FocusedRowHandle;
PHIEUTHU _phieuthu = new PHIEUTHU();
_phieuthu.CoSoId = GlobalSettings.CoSoId;
_phieuthu.PhieuGhiDanhId = this.PhieuGhiDanhId_Select;
_phieuthu.HocVienId = this.HocVienId_Select;
_phieuthu.ThoiGianThu = DateTime.Now;
_phieuthu.SoTien = O2S_Common.TypeConvert.Parse.ToDecimal(numNopThem.Text);
_phieuthu.GhiChu = "";//gridViewDSHocVien.GetRowCellValue(rowHandle, "TenKhoaHoc").ToString();
if (PhieuGhiDanhLogic.InsertQLHocPhi(_phieughidanh, _phieuthu, ref this.PhieuThu_Insert))
{
O2S_Common.Utilities.ThongBao.frmThongBao frmthongbao = new O2S_Common.Utilities.ThongBao.frmThongBao(Base.ThongBaoLable.LUU_THANH_CONG);
frmthongbao.Show();
//
LoadDanhSachHocVien();
gridViewDSHocVien_Click(null, null);
PhieuThuFilter _filter = new PhieuThuFilter();
_filter.HocVienId = this.HocVienId_Select;
_filter.PhieuGhiDanhId = this.PhieuGhiDanhId_Select;
LoadDanhSachPhieuThu(_filter);
btnInBienLai.Enabled = true;
}
}
catch (ArgumentException ex)
{
MessageBox.Show(ex.Message, "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Error(ex);
}
}
private void gridViewDSHocVien_Click(object sender, EventArgs e)
{
try
{
var rowHandle = gridViewDSHocVien.FocusedRowHandle;
this.HocVienId_Select = O2S_Common.TypeConvert.Parse.ToInt32(gridViewDSHocVien.GetRowCellValue(rowHandle, "HocVienId").ToString());
this.PhieuGhiDanhId_Select = O2S_Common.TypeConvert.Parse.ToInt32(gridViewDSHocVien.GetRowCellValue(rowHandle, "PhieuGhiDanhId").ToString());
PHIEUGHIDANH _phieugd = PhieuGhiDanhLogic.SelectSingle(this.PhieuGhiDanhId_Select);
lblMaHocVien.Text = _phieugd.HOCVIEN.MaHocVien;
lblTenHocVien.Text = _phieugd.HOCVIEN.TenHocVien;
lblHocPhi.Text = O2S_Common.Number.Convert.NumberToString(O2S_Common.TypeConvert.Parse.ToDecimal(_phieugd.TongTien.ToString()), 0);
lblDaDong.Text = O2S_Common.Number.Convert.NumberToString(O2S_Common.TypeConvert.Parse.ToDecimal(_phieugd.DaDong.ToString()), 0);
lblConNo.Text = O2S_Common.Number.Convert.NumberToString(O2S_Common.TypeConvert.Parse.ToDecimal(_phieugd.ConNo.ToString()), 0);
lblMienGiam_Tien.Text = O2S_Common.Number.Convert.NumberToString(O2S_Common.TypeConvert.Parse.ToDecimal(_phieugd.MienGiam_Tien.ToString()), 0);
numNopThem.Text = _phieugd.ConNo.ToString();
//Load danh sach phieu thu
PhieuThuFilter _filter = new PhieuThuFilter();
_filter.HocVienId = this.HocVienId_Select;
_filter.PhieuGhiDanhId = this.PhieuGhiDanhId_Select;
LoadDanhSachPhieuThu(_filter);
btnInBienLai.Enabled = false;
if (_phieugd.ConNo == 0)
{
btnLuuLai.Enabled = false;
numNopThem.ReadOnly = true;
}
else
{
btnLuuLai.Enabled = true;
numNopThem.ReadOnly = false;
}
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Error(ex);
}
}
private void btnLuuThongTin_Click(object sender, EventArgs e)
{
try
{
PHIEUGHIDANH _phieuGD = PhieuGhiDanhLogic.SelectSingle(this.PhieuGhiDanhId);
_phieuGD.IsRemove = 1;
_phieuGD.LyDoXoa = txtLyDoXoa.Text;
_phieuGD.NguoiXoa = GlobalSettings.UserCode;
if (PhieuGhiDanhLogic.XoaPhieuGhiDanh(_phieuGD))
{
MessageBox.Show("Xóa thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else
{
O2S_Common.Utilities.ThongBao.frmThongBao frmthongbao = new O2S_Common.Utilities.ThongBao.frmThongBao(Base.ThongBaoLable.THAO_TAC_THAT_BAI);
frmthongbao.Show();
}
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Error(ex);
}
}
private void InBienLaiThuTien(PHIEUTHU _phieuthu)
{
try
{
SplashScreenManager.ShowForm(typeof(O2S_Common.Utilities.ThongBao.WaitForm_Wait));
PHIEUGHIDANH _phieughidanh = PhieuGhiDanhLogic.SelectSingle(_phieuthu.PhieuGhiDanhId ?? 0);
var rowHandle = gridViewDSHocVien.FocusedRowHandle;
List <reportExcelDTO> thongTinThem = new List <reportExcelDTO>();
reportExcelDTO item_MAPHIEUTHU = new reportExcelDTO();
item_MAPHIEUTHU.name = "MAPHIEUTHU";
item_MAPHIEUTHU.value = _phieuthu.MaPhieuThu;
thongTinThem.Add(item_MAPHIEUTHU);
reportExcelDTO item_MAHOCVIEN = new reportExcelDTO();
item_MAHOCVIEN.name = "MAHOCVIEN";
item_MAHOCVIEN.value = lblMaHocVien.Text;
thongTinThem.Add(item_MAHOCVIEN);
reportExcelDTO item_TENHOCVIEN = new reportExcelDTO();
item_TENHOCVIEN.name = "TENHOCVIEN";
item_TENHOCVIEN.value = lblTenHocVien.Text;
thongTinThem.Add(item_TENHOCVIEN);
reportExcelDTO item_DIACHI = new reportExcelDTO();
item_DIACHI.name = "DIACHI";
item_DIACHI.value = gridViewDSHocVien.GetRowCellValue(rowHandle, "DiaChi").ToString();
thongTinThem.Add(item_DIACHI);
reportExcelDTO item_KHOAHOC = new reportExcelDTO();
item_KHOAHOC.name = "KHOAHOC";
item_KHOAHOC.value = gridViewDSHocVien.GetRowCellValue(rowHandle, "TenKhoaHoc").ToString();
thongTinThem.Add(item_KHOAHOC);
DateTime _namsinh = O2S_Common.TypeConvert.Parse.ToDateTime(gridViewDSHocVien.GetRowCellValue(rowHandle, "NgaySinh").ToString());
reportExcelDTO item_NAMSINH = new reportExcelDTO();
item_NAMSINH.name = "NAMSINH";
item_NAMSINH.value = _namsinh.ToString("dd/MM/yyyy");
thongTinThem.Add(item_NAMSINH);
reportExcelDTO item_LOPHOC = new reportExcelDTO();
item_LOPHOC.name = "LOPHOC";
item_LOPHOC.value = gridViewDSHocVien.GetRowCellValue(rowHandle, "TenLopHoc").ToString();
thongTinThem.Add(item_LOPHOC);
//
reportExcelDTO item_TONGTIEN = new reportExcelDTO()
{
name = "TONGTIEN",
value = O2S_Common.Number.Convert.NumberToString(_phieughidanh.TongTien ?? 0, 0) + " đ",
};
thongTinThem.Add(item_TONGTIEN);
reportExcelDTO item_MIENGIAM_TIEN = new reportExcelDTO()
{
name = "MIENGIAM_TIEN",
value = O2S_Common.Number.Convert.NumberToString(_phieughidanh.MienGiam_Tien ?? 0, 0) + " đ",
};
thongTinThem.Add(item_MIENGIAM_TIEN);
reportExcelDTO item_CONNO = new reportExcelDTO()
{
name = "CONNO",
value = O2S_Common.Number.Convert.NumberToString(_phieughidanh.ConNo ?? 0, 0) + " đ",
};
thongTinThem.Add(item_CONNO);
reportExcelDTO item_SOTIEN = new reportExcelDTO()
{
name = "SOTIEN",
value = O2S_Common.Number.Convert.NumberToString(_phieuthu.SoTien ?? 0, 0) + " đ",
};
thongTinThem.Add(item_SOTIEN);
reportExcelDTO item_sotienchu = new reportExcelDTO();
item_sotienchu.name = "SOTIENBANGCHU";
item_sotienchu.value = O2S_Common.Strings.Convert.CurrencyToVneseString(O2S_Common.Number.Convert.NumberToNumberRoundAuto(_phieuthu.SoTien ?? 0, 0).ToString());
thongTinThem.Add(item_sotienchu);
//
DataTable dataExport = new DataTable();
dataExport.Columns.Add("STT", typeof(string));
dataExport.Columns.Add("KHOANTHU", typeof(string));
dataExport.Columns.Add("SOTIEN", typeof(string));
dataExport.Columns.Add("GHICHU", typeof(string));
HocPhiHocVienFilter _filter = new HocPhiHocVienFilter()
{
PhieuThuId = _phieuthu.PhieuThuId,
HocVienId = this.HocVienId_Select,
};
List <HocPhiHocVien_PlusDTO> _lsthocPhiHV = HocPhiHocVienLogic.Select(_filter);
if (_lsthocPhiHV != null && _lsthocPhiHV.Count > 0)
{
_lsthocPhiHV.OrderBy(o => o.Stt).ToList();
for (int i = 0; i < _lsthocPhiHV.Count; i++)
{
DataRow newRow_khac = dataExport.NewRow();
newRow_khac["STT"] = _lsthocPhiHV[i].Stt;
newRow_khac["KHOANTHU"] = _lsthocPhiHV[i].TenDichVu == null ? "" : _lsthocPhiHV[i].TenDichVu;
newRow_khac["SOTIEN"] = O2S_Common.Number.Convert.NumberToString(O2S_Common.TypeConvert.Parse.ToDecimal(_lsthocPhiHV[i].SoTien.ToString()), 0);
newRow_khac["GHICHU"] = _lsthocPhiHV[i].GhiChu == null ? "" : _lsthocPhiHV[i].GhiChu;
dataExport.Rows.Add(newRow_khac);
}
}
string fileTemplatePath = LuaChonTemplateInBienLai(_lsthocPhiHV);
Utilities.Prints.PrintPreview.ShowPrintPreview_UsingExcelTemplate(fileTemplatePath, thongTinThem, dataExport);
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Error(ex);
}
SplashScreenManager.CloseForm();
}
private void btnLuuLai_Click(object sender, EventArgs e)
{
try
{
ValidateLuu();
//Update PHIEUGHIDANH: dadong
PHIEUGHIDANH _phieughidanh = PhieuGhiDanhLogic.SelectSingle(this.PhieuGhiDanhId_Select);
_phieughidanh.DaDong = _phieughidanh.DaDong + O2S_Common.TypeConvert.Parse.ToDecimal(numDaDong.Text);
//
_phieughidanh.SoTietKH = _phieughidanh.SoTietKH + O2S_Common.TypeConvert.Parse.ToDecimal(numSoTietHoc.Text);//so tiet tren dot hoc da chon
_phieughidanh.HocPhiKH = _phieughidanh.HocPhiKH + O2S_Common.TypeConvert.Parse.ToDecimal(numHocPhi.Text);
_phieughidanh.HocPhiHocVienKH = _phieughidanh.HocPhiHocVienKH + O2S_Common.TypeConvert.Parse.ToDecimal(numTongTien.Text);
_phieughidanh.SoTietHocVienKH = _phieughidanh.SoTietHocVienKH + O2S_Common.TypeConvert.Parse.ToDecimal(numSoBuoiHVDangKy.Text);
decimal _mienggiam = _phieughidanh.MienGiam_Tien ?? 0;
_phieughidanh.ConNo = _phieughidanh.TongTien - _phieughidanh.DaDong - _mienggiam;
//Insert Phieu Thu
var rowHandle = gridViewDSHocVien.FocusedRowHandle;
PHIEUTHU _phieuthu = new PHIEUTHU();
_phieuthu.CoSoId = GlobalSettings.CoSoId;
_phieuthu.PhieuGhiDanhId = this.PhieuGhiDanhId_Select;
_phieuthu.HocVienId = this.HocVienId_Select;
_phieuthu.ThoiGianThu = DateTime.Now;
_phieuthu.SoTien = O2S_Common.TypeConvert.Parse.ToDecimal(numDaDong.Text);
_phieuthu.NoiDung = cboDotHoc.Text;
_phieuthu.GhiChu = "Thu tiền đợt học: " + cboDotHoc.Text;
//Hoc phi hoc vien
DOTHOC _dothoc = DotHocLogic.SelectSingle(O2S_Common.TypeConvert.Parse.ToInt32(cboDotHoc.SelectedValue.ToString()));
decimal _donGia = _dothoc.HocPhi ?? 0;
if (_dothoc.SoBuoiHoc != null && _dothoc.SoBuoiHoc != 0)
{
_donGia = _dothoc.HocPhi / _dothoc.SoBuoiHoc ?? 1;
}
HOCPHIHOCVIEN _hocphiHV = new HOCPHIHOCVIEN()
{
PhieuGhiDanhId = this.PhieuGhiDanhId_Select,
HocVienId = this.HocVienId_Select,
Stt = 1,
DmDichVuId = _dothoc.DotHocId,
TenDichVu = cboDotHoc.Text,
SoTien = O2S_Common.TypeConvert.Parse.ToDecimal(numTongTien.Text),
SoLuong = O2S_Common.TypeConvert.Parse.ToDecimal(numSoBuoiHVDangKy.Text),
DonGia = _donGia,
PhieuThuId = 0,
GhiChu = "",
};
if (PhieuGhiDanhLogic.InsertQLHocPhi_Option1(_phieughidanh, _phieuthu, _hocphiHV, ref this.PhieuThu_Insert))
{
O2S_Common.Utilities.ThongBao.frmThongBao frmthongbao = new O2S_Common.Utilities.ThongBao.frmThongBao(Base.ThongBaoLable.LUU_THANH_CONG);
frmthongbao.Show();
//
LoadDanhSachHocVien();
gridViewDSHocVien_Click(null, null);
PhieuThuFilter _filter = new PhieuThuFilter();
_filter.HocVienId = this.HocVienId_Select;
_filter.PhieuGhiDanhId = this.PhieuGhiDanhId_Select;
LoadDanhSachPhieuThu(_filter);
btnInBienLai.Enabled = true;
}
}
catch (ArgumentException ex)
{
MessageBox.Show(ex.Message, "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Error(ex);
}
}