public static bool HuyPhieuThuTien(PHIEUTHU _phieuthu)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
var phieuthuCu = SelectSingle(_phieuthu.PhieuThuId);
phieuthuCu.IsRemove = _phieuthu.IsRemove;
phieuthuCu.LyDoHuy = _phieuthu.LyDoHuy;
phieuthuCu.NguoiHuy = _phieuthu.NguoiHuy;
phieuthuCu.ThoiGianHuy = _phieuthu.ThoiGianHuy;
phieuthuCu.ModifiedDate = DateTime.Now;
phieuthuCu.ModifiedBy = GlobalSettings.UserCode;
phieuthuCu.ModifiedLog = GlobalSettings.SessionMyIP;
Database.SubmitChanges();
//update PHIEUGHIDANH
PHIEUGHIDANH _pgdanh = PhieuGhiDanhLogic.SelectSingle(_phieuthu.PhieuGhiDanhId ?? 0);
_pgdanh.DaDong = _pgdanh.DaDong - _phieuthu.SoTien;
_pgdanh.ConNo = _pgdanh.ConNo + _phieuthu.SoTien;
_pgdanh.ModifiedDate = DateTime.Now;
_pgdanh.ModifiedBy = GlobalSettings.UserCode;
_pgdanh.ModifiedLog = GlobalSettings.SessionMyIP;
ts.Complete();
return(true);
}
}
catch (System.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);
}
}