private void cboKhoaHoc_SelectedValueChanged(object sender, EventArgs e)
{
try
{
KHOAHOC _khoahoc = KhoaHocLogic.SelectSingle(O2S_Common.TypeConvert.Parse.ToInt32(cboKhoaHoc.SelectedValue.ToString()));
if (_khoahoc != null)
{
numHocPhi.Text = O2S_Common.Number.Convert.NumberToString((_khoahoc.HocPhi ?? 0), 0);
numSoTietHoc.Text = O2S_Common.Number.Convert.NumberToString((_khoahoc.SoTietHoc ?? 0), 0);
numSoBuoiHVDangKy.Text = O2S_Common.Number.Convert.NumberToString((_khoahoc.SoTietHoc ?? 0), 0);
//
decimal _sotiethoc = O2S_Common.TypeConvert.Parse.ToDecimal(numSoTietHoc.Text);
if (_sotiethoc != 0)
{
decimal _thanhtien = O2S_Common.TypeConvert.Parse.ToDecimal(numHocPhi.Text) * (O2S_Common.TypeConvert.Parse.ToDecimal(numSoBuoiHVDangKy.Text) / _sotiethoc);
lblThanhTienKhoaHoc.Text = O2S_Common.Number.Convert.NumberToString(_thanhtien, 0);
}
else
{
lblThanhTienKhoaHoc.Text = "0";
}
}
//numDaDong.Maximum = O2S_Common.TypeConvert.Parse.ToDecimal(numHocPhi.Text);
numTongTien.Text = O2S_Common.Number.Convert.NumberToString(TinhTongTien(), 0);
numConNo.Text = O2S_Common.Number.Convert.NumberToString((O2S_Common.TypeConvert.Parse.ToDecimal(numTongTien.Text) - O2S_Common.TypeConvert.Parse.ToDecimal(numDaDong.Text.Replace(",", ""))), 0);
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Warn(ex);
}
}
private void btnInAn_Click(object sender, EventArgs e)
{
try
{
SplashScreenManager.ShowForm(typeof(O2S_Common.Utilities.ThongBao.WaitForm_Wait));
string tungay = DateTime.ParseExact(date_TuNgay.Text, "HH:mm:ss dd/MM/yyyy", CultureInfo.InvariantCulture).ToString("HH:mm dd/MM/yyyy");
string denngay = DateTime.ParseExact(date_DenNgay.Text, "HH:mm:ss dd/MM/yyyy", CultureInfo.InvariantCulture).ToString("HH:mm dd/MM/yyyy");
string tungaydenngay = "( Từ " + tungay + " - " + denngay + " )";
List <reportExcelDTO> thongTinThem = new List <reportExcelDTO>();
reportExcelDTO reportitem = new reportExcelDTO();
reportitem.name = Base.bienTrongBaoCao.THOIGIANBAOCAO;
reportitem.value = tungaydenngay;
thongTinThem.Add(reportitem);
//khoa hoc, lop hoc
int _KhoaHocId = O2S_Common.TypeConvert.Parse.ToInt32(cboKhoaHoc.SelectedValue.ToString());
KHOAHOC _khoahoc = KhoaHocLogic.SelectSingle(_KhoaHocId);
int _lophocId = O2S_Common.TypeConvert.Parse.ToInt32(cboLopHoc.SelectedValue.ToString());
LOPHOC _lophoc = LopHocLogic.SelectSingle(_lophocId);
reportExcelDTO _item_makhoahoc = new reportExcelDTO()
{
name = Base.bienTrongBaoCao.MAKHOAHOC,
value = _khoahoc.MaKhoaHoc,
};
thongTinThem.Add(_item_makhoahoc);
reportExcelDTO _item_tenkhoahoc = new reportExcelDTO()
{
name = Base.bienTrongBaoCao.TENKHOAHOC,
value = _khoahoc.TenKhoaHoc,
};
thongTinThem.Add(_item_tenkhoahoc);
//
reportExcelDTO _item_malophoc = new reportExcelDTO()
{
name = Base.bienTrongBaoCao.MALOPHOC,
value = _lophoc.MaLopHoc,
};
thongTinThem.Add(_item_malophoc);
reportExcelDTO _item_tenlophoc = new reportExcelDTO()
{
name = Base.bienTrongBaoCao.TENLOPHOC,
value = _lophoc.TenLopHoc,
};
thongTinThem.Add(_item_tenlophoc);
string fileTemplatePath = "BC03_ThongKeTheoDoiDiem.xlsx";
DataTable _databaocao = O2S_Common.DataTables.Convert.ListToDataTable(this.lstBangDiem);
Utilities.Prints.PrintPreview.ShowPrintPreview_UsingExcelTemplate(fileTemplatePath, thongTinThem, _databaocao);
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Error(ex);
}
SplashScreenManager.CloseForm();
}
private void btnInAn_DSLop_Click(object sender, EventArgs e)
{
try
{
SplashScreenManager.ShowForm(typeof(O2S_Common.Utilities.ThongBao.WaitForm_Wait));
if (cboLopHoc.SelectedValue != null)
{
List <reportExcelDTO> thongTinThem = new List <reportExcelDTO>();
//khoa hoc, lop hoc
int _KhoaHocId = O2S_Common.TypeConvert.Parse.ToInt32(cboKhoaHoc.SelectedValue.ToString());
KHOAHOC _khoahoc = KhoaHocLogic.SelectSingle(_KhoaHocId);
int _lophocId = O2S_Common.TypeConvert.Parse.ToInt32(cboLopHoc.SelectedValue.ToString());
LOPHOC _lophoc = LopHocLogic.SelectSingle(_lophocId);
reportExcelDTO _item_makhoahoc = new reportExcelDTO()
{
name = Base.bienTrongBaoCao.MAKHOAHOC,
value = _khoahoc.MaKhoaHoc,
};
thongTinThem.Add(_item_makhoahoc);
reportExcelDTO _item_tenkhoahoc = new reportExcelDTO()
{
name = Base.bienTrongBaoCao.TENKHOAHOC,
value = _khoahoc.TenKhoaHoc,
};
thongTinThem.Add(_item_tenkhoahoc);
//
reportExcelDTO _item_malophoc = new reportExcelDTO()
{
name = Base.bienTrongBaoCao.MALOPHOC,
value = _lophoc.MaLopHoc,
};
thongTinThem.Add(_item_malophoc);
reportExcelDTO _item_tenlophoc = new reportExcelDTO()
{
name = Base.bienTrongBaoCao.TENLOPHOC,
value = _lophoc.TenLopHoc,
};
thongTinThem.Add(_item_tenlophoc);
List <XepLopDTO> _lstXepLop = BangDiemLogic.SelectDSHV_Lop(_lophocId);
string fileTemplatePath = "FUN_XepLop_DanhSachLopHoc.xlsx";
DataTable _databaocao = O2S_Common.DataTables.Convert.ListToDataTable(_lstXepLop);
Utilities.Prints.PrintPreview.ShowPrintPreview_UsingExcelTemplate(fileTemplatePath, thongTinThem, _databaocao);
}
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Error(ex);
}
SplashScreenManager.CloseForm();
}
private void gridViewKhoaHoc_Click(object sender, EventArgs e)
{
try
{
if (gridViewKhoaHoc.RowCount > 0)
{
var rowHandle = gridViewKhoaHoc.FocusedRowHandle;
int _KhoaHocId = O2S_Common.TypeConvert.Parse.ToInt32(gridViewKhoaHoc.GetRowCellValue(rowHandle, "KhoaHocId").ToString());
this.khoaHocSelect = KhoaHocLogic.SelectSingle(_KhoaHocId);
if (this.khoaHocSelect != null)
{
KhoaHoc_ClickData(this.khoaHocSelect);
LockPanelControl(false);
}
}
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Warn(ex);
}
}
private void btnLuuPhieu_Click(object sender, EventArgs e)
{
try
{
ValidateLuuPhieu();
KHOAHOC _khoahoc = KhoaHocLogic.SelectSingle(O2S_Common.TypeConvert.Parse.ToInt32(cboKhoaHoc.SelectedValue.ToString()));
//var rowHandle = gridViewKhoanKhac.FocusedRowHandle;
//Insert bang PHIEUGHIDANH
//insert bang PHIEUTHU; HOCPHIHOCVIEN
//cap nhat bang HOCVIEN trang thai hoc vien = hoc vien chinh thuc + TAIKHOAN=chinh thuc
PHIEUGHIDANH _phieughidanh = new PHIEUGHIDANH();
_phieughidanh.HocVienId = this.HocVienId_Select;
_phieughidanh.KhoaHocId = _khoahoc.KhoaHocId;
_phieughidanh.NgayGhiDanh = DateTime.ParseExact(dateNgayGhiDanh.Text, "HH:mm:ss dd/MM/yyyy", CultureInfo.InvariantCulture);
//
_phieughidanh.HocPhiKH = _khoahoc.HocPhi;
_phieughidanh.SoTietKH = _khoahoc.SoTietHoc;
_phieughidanh.HocPhiHocVienKH = O2S_Common.TypeConvert.Parse.ToDecimal(lblThanhTienKhoaHoc.Text.Replace(",", ""));
_phieughidanh.SoTietHocVienKH = O2S_Common.TypeConvert.Parse.ToDecimal(numSoBuoiHVDangKy.Text);
_phieughidanh.ThuKhoanKhac = TinhTongTien_ThuThem();
_phieughidanh.TongTien = O2S_Common.TypeConvert.Parse.ToDecimal(numTongTien.Text);
_phieughidanh.DaDong = O2S_Common.TypeConvert.Parse.ToDecimal(numDaDong.Text.Replace(",", ""));
_phieughidanh.ConNo = O2S_Common.TypeConvert.Parse.ToDecimal(numConNo.Text);
_phieughidanh.MienGiam_PhanTram = O2S_Common.TypeConvert.Parse.ToInt16(numMienGiam_PTram.Value.ToString());
_phieughidanh.MienGiam_Tien = O2S_Common.TypeConvert.Parse.ToDecimal(numMienGiam_Tien.Text.Replace(",", ""));
_phieughidanh.LyDoMienGiam = txtLyDoMienGiam.Text;
if (GlobalSettings.UserID != -1)
{
_phieughidanh.NhanVienId = GlobalSettings.UserID;
}
//insert bang PHIEUTHU
PHIEUTHU _phieuthu = new PHIEUTHU();
List <HOCPHIHOCVIEN> _lsthphv = new List <HOCPHIHOCVIEN>();
if (O2S_Common.TypeConvert.Parse.ToDecimal(numDaDong.Text.Replace(",", "")) > 0)
{
//_phieuthuInsert.PhieuGhiDanhId = this.PhieuGhiDanhId;
_phieuthu.CoSoId = GlobalSettings.CoSoId;
_phieuthu.HocVienId = this.HocVienId_Select;
_phieuthu.ThoiGianThu = DateTime.Now;
_phieuthu.SoTien = O2S_Common.TypeConvert.Parse.ToDecimal(numDaDong.Text.Replace(",", ""));
_phieuthu.GhiChu = "";
//Tien Khoa Hoc
HOCPHIHOCVIEN _hphv_kh = new HOCPHIHOCVIEN()
{
Stt = 1,
HocVienId = this.HocVienId_Select,
DmDichVuId = O2S_Common.TypeConvert.Parse.ToInt32(cboKhoaHoc.SelectedValue.ToString()),
TenDichVu = cboKhoaHoc.Text,
SoTien = O2S_Common.TypeConvert.Parse.ToDecimal(numHocPhi.Text),
SoLuong = 1,
//PhieuThuId = _phieuthuId,
GhiChu = "",
};
_lsthphv.Add(_hphv_kh);
//tien khoan Khac
if (gridViewKhoanKhac.RowCount > 0)
{
int _stt_thuthem = 2;
for (int i = 0; i < gridViewKhoanKhac.RowCount; i++)
{
object _noidungkt = gridViewKhoanKhac.GetRowCellValue(i, "noidung");
if (_noidungkt != null)
{
HOCPHIHOCVIEN _hphv_khac = new HOCPHIHOCVIEN()
{
Stt = _stt_thuthem,
HocVienId = this.HocVienId_Select,
DmDichVuId = 0,
TenDichVu = gridViewKhoanKhac.GetRowCellValue(i, "noidung") == null ? "" : gridViewKhoanKhac.GetRowCellValue(i, "noidung").ToString(),
SoTien = O2S_Common.TypeConvert.Parse.ToDecimal(gridViewKhoanKhac.GetRowCellValue(i, "sotien").ToString()),
SoLuong = 1,
//PhieuThuId = _phieuthuId,
GhiChu = gridViewKhoanKhac.GetRowCellValue(i, "ghichu") == null ? "" : gridViewKhoanKhac.GetRowCellValue(i, "ghichu").ToString(),
};
_lsthphv.Add(_hphv_khac);
_stt_thuthem += 1;
}
}
}
}
if (PhieuGhiDanhLogic.InsertPGDFull(_phieughidanh, _phieuthu, _lsthphv, ref this.PhieuGhiDanhId, ref this.PhieuThuId))
{
HOCVIEN _hv = HocVienLogic.SelectSingle(this.HocVienId_Select);
MessageBox.Show(string.Format("Học viên {0} đã được chuyển thành học viên chính thức với tài khoản:{1}Tên đăng nhập: {2}{3}Mật khẩu: {4}",
_hv.TenHocVien, Environment.NewLine, _hv.MaHocVien, Environment.NewLine, _hv.MaHocVien),
"Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
isSave = true;
btnLuuPhieu.Enabled = false;
LoadPhieuGhiDanh();
if (this.PhieuThuId != 0)
{
btnInBienLai.Enabled = true;
if (MessageBox.Show("Bạn có muốn in phiếu ghi danh vừa lưu?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
InBienLaiThuTien_Process(this.PhieuThuId);
}
}
}
else
{
O2S_Common.Utilities.ThongBao.frmThongBao frmthongbao = new O2S_Common.Utilities.ThongBao.frmThongBao(Base.ThongBaoLable.THEM_MOI_THAT_BAI);
frmthongbao.Show();
}
}
catch (ArgumentException ex)
{
MessageBox.Show(ex.Message, "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}