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);
}
}
public static bool Delete(int _hocvienId) //xoa hoc vien
{
try
{
using (TransactionScope ts = new TransactionScope())
{
//Xoa LICHSUTUVAN
List <LICHSUTUVAN> _lstTuVan = LichSuTuVanLogic.SelectTheoHocVien(_hocvienId);
if (_lstTuVan != null && _lstTuVan.Count > 0)
{
Database.LICHSUTUVANs.DeleteAllOnSubmit(_lstTuVan);
}
//Xoa PHIEUGHIDANH
List <PHIEUGHIDANH> _lstPhieuGD = PhieuGhiDanhLogic.SelectTheoHocVien(_hocvienId);
if (_lstPhieuGD != null && _lstPhieuGD.Count > 0)
{
Database.PHIEUGHIDANHs.DeleteAllOnSubmit(_lstPhieuGD);
}
//XOA HOCVIENs
var temp = SelectSingle(_hocvienId);
//int _loaihocvien = temp.LoaiHocVienId ?? 0;
int _TaiKhoanId = temp.TaiKhoanId ?? 0;
Database.HOCVIENs.DeleteOnSubmit(temp);
//Xoa tai khoan
//Xoa phan quyen tai khoan
List <PHANQUYENTAIKHOAN> _lstPhanQuyen = PhanQuyenTaiKhoanLogic.SelectTheoTaiKhoan(_TaiKhoanId);
Database.PHANQUYENTAIKHOANs.DeleteAllOnSubmit(_lstPhanQuyen);
var temp_TK = (from p in Database.TAIKHOANs
where p.TaiKhoanId == _TaiKhoanId
select p).Single();
Database.TAIKHOANs.DeleteOnSubmit(temp_TK);
Database.SubmitChanges();
ts.Complete();
return(true);
}
}
catch (System.Exception ex)
{
return(false);
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);
}
}