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)); } }