public UserDbModel Login(UserDbModel dbModel)
{
using (DesarrolloDocenteBDEntities db = new DesarrolloDocenteBDEntities())
{
var login = (from user in db.SEC_USER
where user.EMAIL.ToUpper().Equals(dbModel.Email.ToUpper()) && user.USER_PASSWORD.Equals(dbModel.Password)
select user).FirstOrDefault();
if (login == null)
{
return(null);
}
var date = dbModel.CurrentDate;
SEC_SESSION session = new SEC_SESSION()
{
USERID = login.ID,
LOGIN_DATE = date,
TOKEN_STATUS = true,
TOKEN = this.GetToken(String.Concat(login.ID, date)),
IP_ADDRESS = this.GetIpAddress()
};
db.SEC_SESSION.Add(session);
db.SaveChanges();
UserModelMapper mapper = new UserModelMapper();
return(mapper.MapperT1T2(login));
}
}
/// <summary>
///
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public IEnumerable <UserDbModel> RecordList(string filter)
{
using (DesarrolloDocenteBDEntities db = new DesarrolloDocenteBDEntities())
{
var lista = from role in db.SEC_USER
where !role.REMOVED && role.NAME.ToUpper().Contains(filter.ToUpper())
select role;
UserModelMapper mapper = new UserModelMapper();
var listaFinal = mapper.MapperT1T2(lista);
return(listaFinal);
}
}