public static Log InsertUser(string email, string password, string username)
{
bool exist = GetUser(email);
if (exist)
{
return(new Log(false, "El usuario existe"));
}
else
{
string hash = Helpers.EncodePassword(string.Concat(email, password));
try
{
ECAEntities db = new ECAEntities();
EC_Users user = new EC_Users();
user.Email = email;
user.Enabled = false;
user.password = hash;
user.Username = username;
db.EC_Users.Add(user);
db.SaveChanges();
return(new Log(true, "Creado correctamente"));
}
catch (Exception ex)
{
return(new Log(false, ex.ToString()));
}
}
}
public static Boolean GetUser(string email)
{
ECAEntities db = new ECAEntities();
int user = db.EC_Users.Where(usu => usu.Email == email).Count();
if (user > 0)
{
return(true);
}
else
{
return(false);
}
}
public static Log UpdateAdicionalInfoUser(EC_InfoUser _infoUser)
{
try
{
ECAEntities db = new ECAEntities();
EC_InfoUser infoUser = db.EC_InfoUser.Where(info => info.IdUsuario == _infoUser.IdUsuario).FirstOrDefault();
db.EC_InfoUser.Attach(infoUser);
db.SaveChanges();
return(new Log(true, string.Empty));
}
catch (Exception ex)
{
return(new Log(false, ex.ToString()));
}
}
public static Log InsertAdicionalInfoUser(EC_InfoUser infoUser)
{
try
{
ECAEntities db = new ECAEntities();
db.EC_InfoUser.Add(infoUser);
db.SaveChanges();
return(new Log(true, string.Empty));
}
catch (Exception ex)
{
return(new Log(false, ex.ToString()));
}
}
public static Boolean GetInfoUser(string email, string password)
{
Boolean valid = false;
ECAEntities db = new ECAEntities();
string hash = Helpers.EncodePassword(string.Concat(email, password));
int founduser = db.EC_Users.Where(usu => usu.Email == email && usu.Email == password).Count();
if (founduser == 1)
{
return(true);
}
else
{
return(false);
}
}
public static List <Usuario> GetAllUsers()
{
ECAEntities db = new ECAEntities();
List <Usuario> users = new List <Usuario>();
var userdb = db.EC_Users.ToList();
foreach (var user in userdb)
{
users.Add(new Usuario
{
Apellido = user.EC_InfoUser.Apellidos,
Descripcion = user.EC_InfoUser.Description,
Email = user.Email,
Id = user.Id,
Nombre = user.EC_InfoUser.Nombres,
Username = user.Username
});
}
return(users.ToList());
}
public List <EC_News> GetAllNews()
{
ECAEntities contexto = new ECAEntities();
return(contexto.EC_News.ToList());
}
public List <EC_TypeContent> GetAllTypeContent()
{
ECAEntities contexto = new ECAEntities();
return(contexto.EC_TypeContent.ToList());
}
public EC_DetailContent GetContentbyIdParent(int idParent)
{
ECAEntities contexto = new ECAEntities();
return(contexto.EC_DetailContent.Where(detail => detail.IdContent == idParent).FirstOrDefault());
}
public List <EC_Content> GetAllContentByAuthor(int usuario)
{
ECAEntities contexto = new ECAEntities();
return(contexto.EC_Content.Where(content => content.IdUserAuthor == usuario).ToList());
}
public EC_DetailContent getDetailContentById(int content)
{
ECAEntities contexto = new ECAEntities();
return(contexto.EC_DetailContent.Where(detail => detail.Id == content).FirstOrDefault());
}
public List <EC_Content> GetAllContentByParent(int parent)
{
ECAEntities contexto = new ECAEntities();
return(contexto.EC_Content.Where(cont => cont.IdParent == parent).ToList());
}
public List <EC_Content> GetAllContentByType(int typeContent)
{
ECAEntities contexto = new ECAEntities();
return(contexto.EC_Content.Where(cont => cont.IdTypeContent == typeContent && cont.IdParent == null).ToList());
}
public EC_Content GetContentById(int id)
{
ECAEntities contexto = new ECAEntities();
return(contexto.EC_Content.Where(s => s.Id == id).FirstOrDefault());
}
