public async Task <int> ThemThongTinGiaoDichKhacNganhang(ThongTinGiaoDichLienNganHangBO thongTinGiaoDichLienNganHang)
{
var result = 0;
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <ThongTinGiaoDichLienNganHangBO, ThongTinGiaoDichLienNganHangDO>();
});
var mapper = config.CreateMapper();
var addParam = mapper.Map <ThongTinGiaoDichLienNganHangDO>(thongTinGiaoDichLienNganHang);
using (DalSession dal = new DalSession())
{
try
{
dal.UnitOfWork.Begin();
result = await dal.UnitOfWork.NganHangLienKetRepository.ThemThongTinGiaoDichKhacNganhang(addParam);
dal.UnitOfWork.Commit();
}
catch (Exception ex)
{
dal.UnitOfWork.Rollback();
}
return(result);
}
}
public bool AddNewAsset(Asset asset)
{
using (DalSession dalSession = new DalSession())
{
UnitOfWork unitOfWork = dalSession.UnitOfWork();
unitOfWork.Begin();
try
{
_assetRepository = new AssetRepository(unitOfWork);
asset.Asset_Id = Guid.NewGuid().ToString();
if (_assetRepository.AddNewAsset(asset) == 1)
{
unitOfWork.Commit();
return(true);
}
else
{
unitOfWork.Rollback();
return(false);
}
}
catch
{
unitOfWork.Rollback();
throw;
}
}
}
public bool AddNewProjectTask(ProjectTask projectTask)
{
using (DalSession dalSession = new DalSession())
{
UnitOfWork unitOfWork = dalSession.UnitOfWork();
unitOfWork.Begin();
try
{
_projectTaskRepository = new ProjectTaskRepository(unitOfWork);
projectTask.Added_Datetime = DateTime.Now;
projectTask.Project_Task_Id = Guid.NewGuid().ToString();
if (_projectTaskRepository.AddNewProjectTask(projectTask) == 1)
{
unitOfWork.Commit();
return(true);
}
else
{
unitOfWork.Rollback();
return(true);
}
}
catch
{
unitOfWork.Rollback();
throw;
}
}
}
public void Add(CreateUserDTO model)
{
using (var _dalSession = new DalSession())
{
UnitOfWork _uow = _dalSession.UnitOfWork;
_uow.Begin();
try
{
var userRepository = new UserRepository(_uow);
if (model.Role == Constant.RoleAssetViewer)
{
CreateAssetViewerDTO dto = new CreateAssetViewerDTO()
{
UserLogin = model.UserLogin,
FirstName = model.FirstName,
LastName = model.LastName,
Password = model.Password,
Phone = model.Phone
};
userRepository.AddAssetViewer(dto);
}
else
{
userRepository.Add(model);
}
_uow.Commit();
}
catch
{
_uow.Rollback();
throw;
}
}
}
public async Task <int> UpdateTrangThai(NhacNo_UpdateBO nhacNo)
{
var result = 0;
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <NhacNo_UpdateBO, NhacNo_UpdateDO>();
});
var mapper = config.CreateMapper();
var addParam = mapper.Map <NhacNo_UpdateDO>(nhacNo);
using (DalSession dal = new DalSession())
{
try
{
dal.UnitOfWork.Begin();
result = await dal.UnitOfWork.NhacNoRepository.UpdateTrangThai(addParam);
dal.UnitOfWork.Commit();
}
catch (Exception ex)
{
dal.UnitOfWork.Rollback();
}
return(result);
}
}
public bool AddNewProject(Project project)
{
using (DalSession dalSession = new DalSession())
{
UnitOfWork unitOfWork = dalSession.UnitOfWork();
unitOfWork.Begin();
try
{
_projectRepository = new ProjectRepository(unitOfWork);
int addNewProject = _projectRepository.AddNewProject(project);
if (addNewProject == 1)
{
unitOfWork.Commit();
return(true);
}
else
{
unitOfWork.Rollback();
return(false);
}
}
catch
{
unitOfWork.Rollback();
throw;
}
}
}
public async Task <int> SuaDanhBa(DanhBaBO danhBa)
{
var result = 0;
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <DanhBaBO, DanhBaDO>();
});
var mapper = config.CreateMapper();
var addParam = mapper.Map <DanhBaDO>(danhBa);
using (DalSession dal = new DalSession())
{
try
{
dal.UnitOfWork.Begin();
result = await dal.UnitOfWork.DanhBaRepository.SuaDanhBa(addParam);
dal.UnitOfWork.Commit();
}
catch (Exception ex)
{
dal.UnitOfWork.Rollback();
}
return(result);
}
}
public bool RemoveEmpFromProject(string Project_Employee_id)
{
using (DalSession dalSession = new DalSession())
{
UnitOfWork unitOfWork = dalSession.UnitOfWork();
unitOfWork.Begin();
try
{
_projectEmployeeRepository = new ProjectEmployeeRepository(unitOfWork);
int response = _projectEmployeeRepository.RemoveEmpFromProject(Project_Employee_id);
if (response == 1)
{
unitOfWork.Commit();
return(true);
}
else
{
unitOfWork.Rollback();
return(false);
}
}
catch
{
throw;
}
}
}
public async Task <IEnumerable <TripSearchDTO> > SearchTrip(string departureStatiom, string arrivalStation, DateTime date)
{
using (IDALSession _dalSession = new DalSession())
{
UnitOfWork unitOfWork = _dalSession.UnitOfWork;
unitOfWork.Begin();
try
{
var trips = await _context.StoredProcedures.GetSearchTrips(departureStatiom, arrivalStation, date);
var res = _mapper.Map <IEnumerable <TripSearch>, List <TripSearchDTO> >(trips);
foreach (var trip in res)
{
trip.FreeSeats = await this.SearchFreeSeatById(trip.Id, departureStatiom, arrivalStation);
}
unitOfWork.Commit();
return(await Task.FromResult(res));
}
catch
{
unitOfWork.Rollback();
return(null);
}
}
}
public CustomerDtoRes Add(Guid userId, CustomerDtoReq dtoReq)
{
//With transaction
using (DalSession dalSession = new DalSession())
{
UnitOfWork unitOfWork = dalSession.UnitOfWork;
unitOfWork.Begin();
try
{
var tm_Customer = new Tm_Customer
{
CustomerCode = dtoReq.CustomerCode,
CustomerName = dtoReq.CustomerName,
CreatedUser = userId,
CreatedDate = DateTime.Now,
ModifiedUser = userId,
ModifiedDate = DateTime.Now
};
var customerRepository = new CustomerRepository(unitOfWork);
customerRepository.Add(tm_Customer);
unitOfWork.Commit();
}
catch
{
unitOfWork.Rollback();
throw;
}
}
return(GetById(userId, dtoReq.CustomerCode));
}
public async Task <int> ThemTaiKhoanNhanVien(TaiKhoanNhanVienBO taiKhoanNhanVien)
{
var result = 0;
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <TaiKhoanNhanVienBO, TaiKhoanNhanVienDO>();
});
var mapper = config.CreateMapper();
var addParam = mapper.Map <TaiKhoanNhanVienDO>(taiKhoanNhanVien);
using (DalSession dal = new DalSession())
{
try
{
dal.UnitOfWork.Begin();
result = await dal.UnitOfWork.UserRepository.ThemTaiKhoanNhanVien(addParam);
dal.UnitOfWork.Commit();
}
catch (Exception ex)
{
dal.UnitOfWork.Rollback();
throw new AggregateException(ex);
}
return(result);
}
}
public async Task <int> Them(NganHangLienKetBO nganHangLienKet)
{
var result = 0;
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <NganHangLienKetBO, NganHangLienKetDO>();
});
var mapper = config.CreateMapper();
var addParam = mapper.Map <NganHangLienKetDO>(nganHangLienKet);
using (DalSession dal = new DalSession())
{
try
{
dal.UnitOfWork.Begin();
result = await dal.UnitOfWork.NganHangLienKetRepository.Them(addParam);
dal.UnitOfWork.Commit();
}
catch (Exception ex)
{
dal.UnitOfWork.Rollback();
}
return(result);
}
}
public async Task <int> ChuyenKhoanNoiBo(ThongTinChuyenTienNoiBoBO thongTinChuyenTienNoiBo)
{
var result = 0;
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <ThongTinChuyenTienNoiBoBO, ThongTinChuyenTienNoiBoDO>();
});
var mapper = config.CreateMapper();
var addParam = mapper.Map <ThongTinChuyenTienNoiBoDO>(thongTinChuyenTienNoiBo);
using (DalSession dal = new DalSession())
{
try
{
dal.UnitOfWork.Begin();
result = await dal.UnitOfWork.ThongTinChuyenTienNoiBoRepository.ChuyenKhoanNoiBo(addParam);
dal.UnitOfWork.Commit();
}
catch (Exception ex)
{
dal.UnitOfWork.Rollback();
}
return(result);
}
}
public string GetPasswordByMaTk(string maTaiKhoan)
{
using (DalSession dal = new DalSession())
{
var result = dal.UnitOfWork.UserRepository.GetPasswordByMaTk(maTaiKhoan);
return(result);
}
}
public async Task <UserBO> GetThongTinTaiKhoanBySoTaiKhoan(string soTaiKhoan)
{
using (DalSession dal = new DalSession())
{
var result = await dal.UnitOfWork.UserRepository.GetThongTinTaiKhoanBySoTaiKhoan(soTaiKhoan);
return(MapperHelper.Map <UserDO, UserBO>(result));
}
}
public async Task <UserBO> GetUserByTenDangNhap(string tenDangNhap)
{
using (DalSession dal = new DalSession())
{
var result = await dal.UnitOfWork.UserRepository.GetUserByTenDangNhap(tenDangNhap);
return(MapperHelper.Map <UserDO, UserBO>(result));
}
}
public async Task <int> Them(string maTaiKhoan, string noiDung)
{
using (DalSession dal = new DalSession())
{
var result = await dal.UnitOfWork.ThongBaoRepository.Them(maTaiKhoan, noiDung);
return(result);
}
}
public async Task <string> GetRefreshTokenByMaTk(string maTaiKhoan)
{
using (DalSession dal = new DalSession())
{
var result = await dal.UnitOfWork.UserRepository.GetRefreshTokenByMaTk(maTaiKhoan);
return(result);
}
}
public async Task <int> Update(int id)
{
using (DalSession dal = new DalSession())
{
var result = await dal.UnitOfWork.ThongBaoRepository.Update(id);
return(result);
}
}
public List <Employee> SearchEMPByData(string data)
{
using (DalSession dalSession = new DalSession())
{
UnitOfWork unitOfWork = dalSession.UnitOfWork();
unitOfWork.Begin();
_employeeRepo = new EmployeeRepo(unitOfWork);
return(_employeeRepo.SearchEMPByData(data));
}
}
// GET: MembersController
public ActionResult Index()
{
var members = new List <Member>();
using (var dal = new DalSession(config))
{
members = new MemberRepository(dal.UnitOfWork).Get();
}
return(View(members));
}
public async Task <int> DongTaiKhoanThanhToan(string maTaiKhoan)
{
var result = 0;
using (DalSession dal = new DalSession())
{
result = await dal.UnitOfWork.UserRepository.DongTaiKhoanThanhToan(maTaiKhoan);
return(result);
}
}
public ActionResult Index2(int page = 0, int size = 10)
{
PagedResults <Member> pagedResults;
using (var dal = new DalSession(config))
{
pagedResults = new MemberRepository(dal.UnitOfWork).GetPaged(page, size);
}
return(View(pagedResults));
}
public async Task <List <TaiKhoanNhanVienBO> > GetDanhSachTaiKhoanAdmin()
{
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <TaiKhoanNhanVienDO, TaiKhoanNhanVienBO>();
});
var mapper = config.CreateMapper();
using (DalSession dal = new DalSession())
{
var result = await dal.UnitOfWork.UserRepository.GetDanhSachTaiKhoanAdmin();
return(mapper.Map <List <TaiKhoanNhanVienBO> >(result));
}
}
public async Task <NganHangLienKetBO> GetNganHangLienKetByIdOrTenNganHang(int id, string tenNganHang)
{
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <NganHangLienKetDO, NganHangLienKetBO>();
});
var mapper = config.CreateMapper();
using (DalSession dal = new DalSession())
{
var result = await dal.UnitOfWork.NganHangLienKetRepository.GetNganHangLienKetByIdOrTenNganHang(id, tenNganHang);
return(mapper.Map <NganHangLienKetBO>(result));
}
}
public async Task <UserBO> GetThongTinTaiKhoanKhachHang(string maTaiKhoan)
{
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <UserDO, UserBO>();
});
var mapper = config.CreateMapper();
using (DalSession dal = new DalSession())
{
var result = await dal.UnitOfWork.UserRepository.GetThongTinTaiKhoanKhachHang(maTaiKhoan);
return(MapperHelper.Map <UserDO, UserBO>(result));
}
}
public CustomerDtoRes GetById(Guid userId, string id)
{
using (DalSession dalSession = new DalSession())
{
//Without Transaction
var customerRepository = new CustomerRepository(dalSession.UnitOfWork);//UoW have no effect here as Begin() is not called.
var tm_Customer = customerRepository.GetById(id);
var res = new CustomerDtoRes();
res.CustomerCode = tm_Customer.CustomerCode;
res.CustomerName = tm_Customer.CustomerName;
return(res);
}
}
public async Task <UserBO> GetUserByUserNamePassword(string userName, string password)
{
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <UserDO, UserBO>();
});
var mapper = config.CreateMapper();
using (DalSession dal = new DalSession())
{
var result = await dal.UnitOfWork.UserRepository.GetUserByUserNamePassword(userName, password);
return(mapper.Map <UserBO>(result));
}
}
public async Task <List <DanhBaBO> > GetDanhSachDanhBa(string maTaiKhoan)
{
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <DanhBaDO, DanhBaBO>();
});
var mapper = config.CreateMapper();
using (DalSession dal = new DalSession())
{
var result = await dal.UnitOfWork.DanhBaRepository.GetDanhSachDanhBa(maTaiKhoan);
return(mapper.Map <List <DanhBaBO> >(result));
}
}
public async Task <List <ThongTinChuyenTienNoiBoBO> > TimKiemGiaoDich(string key)
{
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <ThongTinChuyenTienNoiBoDO, ThongTinChuyenTienNoiBoBO>();
});
var mapper = config.CreateMapper();
using (DalSession dal = new DalSession())
{
var result = await dal.UnitOfWork.ThongTinChuyenTienNoiBoRepository.TimKiemGiaoDich(key);
return(mapper.Map <List <ThongTinChuyenTienNoiBoBO> >(result));
}
}
