public bool CreateNote(string login, string password, string title) { using (NotesAppEntities context = new NotesAppEntities()) { try { var entity = context.Member.FirstOrDefault(x => x.Email == login && x.Password == password); if (entity != null) { entity.Note.Add(new Note() { Title = title }); context.SaveChanges(); return(true); } } catch (Exception e) { return(false); } } return(false); }
public Member GetMember(string login, string password) { using (NotesAppEntities context = new NotesAppEntities()) { try { var entity = context.Member.FirstOrDefault(x => x.Email == login && x.Password == password); if (entity != null) { return(new Member() { Id = entity.Id, Email = entity.Email, FirstName = entity.FirstName, LastName = entity.LastName, Note = entity.Note.ToList() }); } } catch (Exception e) { return(null); } } return(null); }
public bool UpdateNote(string login, string password, string title, string content) { using (NotesAppEntities context = new NotesAppEntities()) { try { var entity = context.Member.FirstOrDefault(x => x.Email == login && x.Password == password); if (entity != null) { var noteEntity = entity.Note.FirstOrDefault(x => x.Title == title); noteEntity.Text = content; context.SaveChanges(); return(true); } } catch (Exception e) { return(false); } } return(false); }
public bool Authenticate(string login, string password) { using (NotesAppEntities context = new NotesAppEntities()) { try { var entity = context.Member.FirstOrDefault(x => x.Email == login && x.Password == password); if (entity != null) { return(true); } } catch (Exception e) { return(false); } } return(false); }
public List <Note> GetNotes(string login, string password) { using (NotesAppEntities context = new NotesAppEntities()) { try { var entity = context.Member.FirstOrDefault(x => x.Email == login && x.Password == password); if (entity != null) { List <Note> notes = entity.Note.ToList(); return(notes); } } catch (Exception e) { return(null); } } return(null); }