public int Get_MaxID(int dayNumber) { using (CuckooEntities ce = new CuckooEntities()) { int maxID = 0; if (CheckNotesAtDay(dayNumber) == 0) { maxID = -1; } else { var allIDs = ce.Note_; List <int> numberList = new List <int>(); foreach (Note_ n in allIDs) { numberList.Add(Int32.Parse(n.Id.Substring(2))); } if (numberList != null) { numberList.Sort(); maxID = numberList[numberList.Count - 1]; } } return(maxID); } }
public Note_ Search_DataBase(string ID) { using (CuckooEntities ce = new CuckooEntities()) { Note_ found = ce.Note_.Find(ID); return(found); } }
public void Add_DataBase(Note_ newNote) { using (CuckooEntities ce = new CuckooEntities()) { ce.Note_.Add(newNote); ce.SaveChanges(); } }
public int CheckNotesAtDay(int dayNumber) { using (CuckooEntities ce = new CuckooEntities()) { var all_Notes = ce.Note_.Where(p => p.Id.StartsWith("" + dayNumber + ".")); int x = all_Notes.Count(); return(x); } }
public void Remove_Note(string ID) { using (CuckooEntities ce = new CuckooEntities()) { Note_ found = ce.Note_.Find(ID); ce.Note_.Remove(found); ce.SaveChanges(); } }
public List <Note_> Select_all_Notes_at_Day(int dayNumber) { using (CuckooEntities ce = new CuckooEntities()) { List <Note_> nList = new List <Note_>(); var all_Notes = ce.Note_.Where(y => y.Id.StartsWith("" + dayNumber + ".")); foreach (Note_ n in all_Notes) { nList.Add(n); } return(nList); } }
public List <Note_> Select_all_Notes() { using (CuckooEntities ce = new CuckooEntities()) { List <Note_> nList = new List <Note_>(); var all_Notes = ce.Note_; foreach (Note_ n in all_Notes) { nList.Add(n); } return(nList); } }
public void Replace_DB(string ID, Note_ newNote) { using (CuckooEntities ce = new CuckooEntities()) { Note_ note = Search_DataBase(ID); if (note != null) { ce.Note_.Attach(note); note.Time = newNote.Time; note.ToDo = newNote.ToDo; note.Cathegory = newNote.Cathegory; note.Comment = newNote.Comment; ce.SaveChanges(); } } }
public List <Note_> [] Sort_Notes() { using (CuckooEntities ce = new CuckooEntities()) { List <Note_>[] allNotes = new List <Note_> [7]; for (int i = 0; i < allNotes.Length; i++) { allNotes[i] = new List <Note_>(); } for (int i = 0; i < 7; i++) { var dayNotes = ce.Note_.Where(e => e.Id.StartsWith(i.ToString())) .OrderBy(s => s.Time.Hour) .ThenBy(s => s.Time.Minute); foreach (var n in dayNotes) { allNotes[i].Add(n); } } return(allNotes); } }