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