public static bool Insert(HOCPHIHOCVIEN _hocphihocvien) { try { _hocphihocvien.CreatedDate = DateTime.Now; _hocphihocvien.CreatedBy = GlobalSettings.UserCode; _hocphihocvien.CreatedLog = GlobalSettings.SessionMyIP; _hocphihocvien.IsRemove = 0; Database.HOCPHIHOCVIENs.InsertOnSubmit(_hocphihocvien); Database.SubmitChanges(); // _hocphihocvienId = _hocphihocvien.HocPhiHocVienId; //_hocphihocvien.MaHocPhiHocVien = string.Format("{0}{1:D5}", "PT", _hocphihocvienId); //Database.SubmitChanges(); return(true); } catch (System.Exception ex) { return(false); O2S_Common.Logging.LogSystem.Error(ex); } }
public static bool Update(HOCPHIHOCVIEN _hocphihocvien, TAIKHOAN taiKhoan = null) { try { var hocphihocvienCu = SelectSingle(_hocphihocvien.HocPhiHocVienId); hocphihocvienCu.HocVienId = _hocphihocvien.HocVienId; hocphihocvienCu.SoTien = _hocphihocvien.SoTien; hocphihocvienCu.SoLuong = _hocphihocvien.SoLuong; hocphihocvienCu.GhiChu = _hocphihocvien.GhiChu; hocphihocvienCu.ModifiedDate = DateTime.Now; hocphihocvienCu.ModifiedBy = GlobalSettings.UserCode; hocphihocvienCu.ModifiedLog = GlobalSettings.SessionMyIP; Database.SubmitChanges(); return(true); } catch (Exception ex) { return(false); O2S_Common.Logging.LogSystem.Error(ex); } }
public static bool InsertQLHocPhi_Option1(PHIEUGHIDANH _phieughidanh, PHIEUTHU _phieuthu, HOCPHIHOCVIEN _hocphiHV, ref int _PhieuThuId) { try { using (TransactionScope ts = new TransactionScope()) { //update Phieu ghi danh PHIEUGHIDANH _PGD_select = PhieuGhiDanhLogic.SelectSingle(_phieughidanh.PhieuGhiDanhId); _PGD_select.DaDong = _phieughidanh.DaDong; _PGD_select.ConNo = _phieughidanh.ConNo; _PGD_select.ModifiedDate = DateTime.Now; _PGD_select.ModifiedBy = GlobalSettings.UserCode; _PGD_select.ModifiedLog = GlobalSettings.SessionMyIP; Database.SubmitChanges(); //insert bang PHIEUTHU if (_phieuthu != null && _phieuthu.HocVienId > 0) { _phieuthu.PhieuGhiDanhId = _phieughidanh.PhieuGhiDanhId; _phieuthu.CreatedDate = DateTime.Now; _phieuthu.CreatedBy = GlobalSettings.UserCode; _phieuthu.CreatedLog = GlobalSettings.SessionMyIP; _phieuthu.IsRemove = 0; Database.PHIEUTHUs.InsertOnSubmit(_phieuthu); Database.SubmitChanges(); _PhieuThuId = _phieuthu.PhieuThuId; _phieuthu.MaPhieuThu = string.Format("{0}{1:D7}", "PT", _phieuthu.PhieuThuId); Database.SubmitChanges(); } //Insert HocPhiHocVien if (_phieuthu.PhieuThuId != 0) { _hocphiHV.PhieuThuId = _phieuthu.PhieuThuId; _hocphiHV.CreatedDate = DateTime.Now; _hocphiHV.CreatedBy = GlobalSettings.UserCode; _hocphiHV.CreatedLog = GlobalSettings.SessionMyIP; _hocphiHV.IsRemove = 0; Database.HOCPHIHOCVIENs.InsertOnSubmit(_hocphiHV); Database.SubmitChanges(); } ts.Complete(); return(true); } } catch (System.Exception ex) { return(false); O2S_Common.Logging.LogSystem.Error(ex); } }
private void btnLuuPhieu_Click(object sender, EventArgs e) { try { ValidateLuuPhieu(); DOTHOC _dotHoc = null; if (cboDotHoc.SelectedValue != null) { _dotHoc = DotHocLogic.SelectSingle(O2S_Common.TypeConvert.Parse.ToInt32(cboDotHoc.SelectedValue.ToString())); } //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 = O2S_Common.TypeConvert.Parse.ToInt32(cboKhoaHoc.SelectedValue.ToString()); _phieughidanh.LopHocId = O2S_Common.TypeConvert.Parse.ToInt32(cboLopHoc.SelectedValue.ToString()); _phieughidanh.NgayGhiDanh = DateTime.ParseExact(dateNgayGhiDanh.Text, "HH:mm:ss dd/MM/yyyy", CultureInfo.InvariantCulture); //tong tien cua lop hoc den thoi diem hien tai List <DOTHOC> _lstDotHoc = DotHocLogic.SelectTheoLopHoc(_phieughidanh.LopHocId ?? 0); _phieughidanh.HocPhiKH = _lstDotHoc != null?_lstDotHoc.Sum(o => o.HocPhi) : 0; _phieughidanh.SoTietKH = _lstDotHoc != null?_lstDotHoc.Sum(o => o.SoBuoiHoc) : 0; _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.NoiDung = cboDotHoc.Text; _phieuthu.GhiChu = "Thu tiền đợt học: " + cboDotHoc.Text; //Tien Dot Hoc if (cboDotHoc.SelectedValue != null) { HOCPHIHOCVIEN _hphv_kh = new HOCPHIHOCVIEN() { Stt = 1, HocVienId = this.HocVienId_Select, DmDichVuId = O2S_Common.TypeConvert.Parse.ToInt32(cboDotHoc.SelectedValue.ToString()), TenDichVu = cboDotHoc.Text, SoTien = O2S_Common.TypeConvert.Parse.ToDecimal(lblThanhTienKhoaHoc.Text.Replace(",", "")), SoLuong = O2S_Common.TypeConvert.Parse.ToDecimal(numSoBuoiHVDangKy.Text.Replace(",", "")), DonGia = O2S_Common.TypeConvert.Parse.ToDecimal(numHocPhi.Text) / O2S_Common.TypeConvert.Parse.ToDecimal(numSoTietHoc.Text), //PhieuThuId = _phieuthuId, GhiChu = "", }; _lsthphv.Add(_hphv_kh); } //tien khoan Khac if (gridViewKhoanKhac.RowCount > 0) { _phieuthu.NoiDung += " và khoản khác"; _phieuthu.GhiChu += " và khoản khác"; 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, DonGia = O2S_Common.TypeConvert.Parse.ToDecimal(gridViewKhoanKhac.GetRowCellValue(i, "sotien").ToString()), //PhieuThuId = _phieuthuId, GhiChu = gridViewKhoanKhac.GetRowCellValue(i, "ghichu") == null ? "" : gridViewKhoanKhac.GetRowCellValue(i, "ghichu").ToString(), }; _lsthphv.Add(_hphv_khac); _stt_thuthem += 1; } } } } //bang diem BANGDIEM _bangdiem = new BANGDIEM(); _bangdiem.HocVienId = this.HocVienId_Select; _bangdiem.LopHocId = O2S_Common.TypeConvert.Parse.ToInt32(cboLopHoc.SelectedValue.ToString()); // _bangdiem.PhieuGhiDanhId = item.PhieuGhiDanhId ?? 0; _bangdiem.KhoaHocId = O2S_Common.TypeConvert.Parse.ToInt32(cboKhoaHoc.SelectedValue.ToString()); _bangdiem.TrangThai = 0;//=0: xep lop; =1: dang hoc; =3: co diem; =99:ket thu if (PhieuGhiDanhLogic.InsertPGDFull_XepLop(_phieughidanh, _phieuthu, _lsthphv, _bangdiem, 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); } }
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); } }