public static EntityModel.Account getUserbyid(int id)
{
try
{
EntityModel.Account user = new EntityModel.Account();
using (var Contexto = new WBTaskEntities1())
{
var query = (from c in Contexto.Account
where c.IdAccount == id
select c);
var userlogined = query.First <Account>();
user.IdAccount = userlogined.IdAccount;
user.Email = userlogined.Email;
user.Name = userlogined.Nombre;
user.Password = userlogined.PassWord;
}
return(user);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <EntityModel.Message> getAllMessage( )
{
try{
using (var Contexto = new WBTaskEntities1())
{
var query = (from c in Contexto.Messsage
orderby c.Date descending
select c);
List <EntityModel.Message> list = new List <EntityModel.Message>();
foreach (DataAccesLayer.Messsage item in query)
{
EntityModel.Message message = new EntityModel.Message();
message.Text = item.Text;
message.Autor = item.Account.Nombre;
message.Email = item.Account.Email;
message.DateFromNow = GetDateFromNow.getDateFromNow(item.Date);
message.Date = (DateTime)item.Date;
list.Add(message);
}
return(list);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool verifyAccount(string password, string email)
{
try
{
using (var Contexto = new WBTaskEntities1())
{
var query = (from c in Contexto.Account
where c.PassWord == password && c.Email == email
select c);
if (query.Count() != 0)
{
return(true);
}
else
{
return(false);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static void newMessage(EntityModel.Message msj)
{
try{
using (var Contexto = new WBTaskEntities1())
{
DataAccesLayer.Messsage msg = new DataAccesLayer.Messsage();
msg.Date = DateTime.Now.ToLocalTime();
msg.IdAccount = msj.Account.IdAccount;
msg.Text = msj.Text;
Contexto.AddToMesssage(msg);
Contexto.SaveChanges();
Contexto.Refresh(System.Data.Objects.RefreshMode.StoreWins, msg);
}
}
catch (Exception ex)
{
throw ex;
}
}
