public List <NoteModel> GetNotes(string userId)
{
using (var dbContext = new CodeTestContext())
{
((IObjectContextAdapter)dbContext).ObjectContext.Connection.Open();
List <NoteModel> notes = (from m in dbContext.Notes
where m.UserId == userId
select new NoteModel()
{
Id = m.Id,
Content = m.Content,
Topic = m.Topic,
UserId = m.UserId
}).ToList();
return(notes);
}
}
public UserModel GetUser(UserModel model)
{
using (var dbContext = new CodeTestContext())
{
((IObjectContextAdapter)dbContext).ObjectContext.Connection.Open();
var users = (from m in dbContext.Users select m).ToList();
UserModel user = (from m in dbContext.Users
where m.UserName == model.UserName && m.Password == model.Password
select new UserModel()
{
Id = m.Id,
UserName = m.UserName
}).FirstOrDefault();
return(user);
}
}