public void Create(UserModel model) { IMapper mapper = MapperHelper.Create <UserModel, User>(); User user = mapper.Map <User>(model); user.Password = EncryptHelper.EncryptDES(user.Password); _userIRepository.Create(user); }
public UserModel GetById(Guid id) { IMapper mapper = MapperHelper.Create <User, UserModel>(); User user = _userIRepository.GetById(id); user.Password = EncryptHelper.DecryptDES(user.Password); return(mapper.Map <UserModel>(user)); }
public UserModel GetUserByLogin(string account, string password) { IMapper mapper = MapperHelper.Create <User, UserModel>(); IQueryable <User> query = _userIRepository.GetAll(); string hashPassword = EncryptHelper.EncryptDES(password); User user = query.AsNoTracking() .FirstOrDefault(f => f.Account == account && f.Password == hashPassword); return(user != null?mapper.Map <UserModel>(user) : null); }
public IDailyReg Create(IDailyReg entity) { using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required)) { mapperHelper.Create(entity, (cmd, dailyReg) => InsertParameters(cmd, dailyReg), "INSERT INTO DailyReg (isin, minval, openingval, maxval, closingval, dailydate) VALUES(@id, @minval, @openingval, @maxval, @closingval, @datetime); select @id=isin, @datetime=dailydate" ); ts.Complete(); return(entity); } }
public IExttriple Create(IExttriple entity) { using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required)) { mapperHelper.Create(entity, (cmd, exttriple) => InsertParameters(cmd, exttriple), "INSERT INTO EXttriple(id, datetime, value) values(@id, @datetime, @value); select @id=id, @datetime=datetime from Exttriple;" ); ts.Complete(); return(entity); } }
public IInstrument Create(IInstrument instrument) { using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required)) { mapperHelper.Create(instrument, (cmd, ins) => InsertParameters(cmd, ins), "INSERT INTO Instrument (isin, description, mrktcode) VALUES(@id, @desc, @code); select @id=isin" ); ts.Complete(); return(instrument); } }
public IMarket Create(IMarket market) { using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required)) { mapperHelper.Create(market, (cmd, market) => InsertParameters(cmd, market), "INSERT INTO Market (code, description, name) VALUES(@id,@desc,@name)" ); ts.Complete(); return(market); } }
public IDailyMarket Create(IDailyMarket idm) { using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required)) { mapperHelper.Create(idm, (cmd, idailymarket) => InsertParameters(cmd, idailymarket), "INSERT INTO DailyMarket (idxmrkt,dailyvar,idxopeningval, code, date) VALUES(@idxmrkt, @dailyvar, @idxopv, @id, @datetime); select @id=code, @datetime=date" ); ts.Complete(); return(idm); } }
public IPhone Create(IPhone phone) { using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required)) { mapperHelper.Create(phone, (cmd, phone) => InsertParameters(cmd, phone), "INSERT INTO Phone (code, areacode, number, description, nif) VALUES(@id, @area, @numb, @desc, @nif); select @id=code" ); ts.Complete(); return(phone); } }
public IClient Create(IClient iclient) { using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required)) { mapperHelper.Create(iclient, (cmd, client) => InsertParameters(cmd, client), "INSERT INTO Client (Name, ncc, nif) VALUES(@Name, @ncc, @id); select @id=nif" ); ts.Complete(); return(iclient); } }
public IPosition Create(IPosition entity) { using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required)) { mapperHelper.Create(entity, (cmd, position) => InsertParameters(cmd, position), "INSERT INTO Position (name, isin, quantity) VALUES(@id2, @id1, @quantity); select @id1=isin and @id2=name" ); ts.Complete(); return(entity); } }
public IEmail Create(IEmail entity) { using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required)) { mapperHelper.Create(entity, (cmd, email) => InsertParameters(cmd, email), "INSERT INTO Email (code, addr, description, nif) VALUES(@id, @addr, @desc,@nif); select @id=code" ); ts.Complete(); return(entity); } }
public IPortfolio Create(IPortfolio entity) { using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required)) { mapperHelper.Create(entity, (cmd, portfolio) => InsertParameters(cmd, portfolio), "INSERT INTO portfolio (name, totalval) VALUES(@id, @total); select @id=name" ); ts.Complete(); return(entity); } }
public IPagedList <UserModel> GetAll(int page, int size) { IMapper mapper = MapperHelper.Create <User, UserModel>(); IQueryable <User> query = _userIRepository.GetAll() .AsNoTracking() .OrderByDescending(o => o.CreateDatetime) .Skip(page * size) .Take(size); Search(ref query); return(mapper.Map <List <UserModel> >(query).ToPagedList(page + 1, size)); }