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