private int addNewSingleNoteInDB(string email, string noteHead, string noteText, string date, string noteColor) { int id = -1; try { using (var db = new NotesMEDBContainer()) // DB NAME IS CONTAINER { var note = new Note(); note.NoteDate = date; note.NoteHead = noteHead; note.NoteText = noteText; note.UserId = getUserIdByEmail(email); note.NoteColor = noteColor; db.NoteSet.Add(note); db.SaveChanges(); return(note.Id); } } catch (Exception er) { System.Diagnostics.Debug.Write("NEW SINGLE NOTE EXCEPTION"); System.Diagnostics.Debug.Write(er.ToString()); } return(id); }
private string getAllNotesAndTasks(string email) { string s = @"{ ""suc"": ""1"", ""boxes"": ["; int count = 0; int count2 = 0; try { using (var db = new NotesMEDBContainer()) // DB NAME IS CONTAINER { int userId = getUserIdByEmail(email); var notes = db.NoteSet.Where(i => i.UserId == userId).ToArray(); foreach (var note in notes) { if (count != 0) { s += ','; } count++; s += "{"; s += @"""head"":""" + note.NoteHead + @""","; s += @"""id"":""" + note.Id + @""","; s += @"""color"":""" + note.NoteColor + @""","; if (note.NoteText == "") { s += @"""multiple"":""1"","; var tasks = db.TaskSet.Where(i => i.NoteId == note.Id).ToArray(); System.Diagnostics.Debug.Write("Number of tasks for note " + note.Id + " - " + tasks.Length + " \n"); s += @"""tasks"": ["; foreach (var task in tasks) { System.Diagnostics.Debug.Write("Task Scanning"); if (count2 != 0) { s += ','; } count2++; s += @"{""id"": """ + task.Id + @""",""name"": """ + task.TaskText + @""", ""date"":""" + task.TaskDate + @"""}"; } count2 = 0; s += "]"; } else // MULTIPLE { s += @"""multiple"":""0"","; s += @"""id"": """ + note.Id + @""", ""name"": """ + note.NoteText + @""", ""date"":""" + note.NoteDate + @""""; } s += "}"; } } } catch (Exception exx) { s = "{ suc: '0'"; System.Diagnostics.Debug.Write(exx.ToString()); } return(s + "]}"); }
private String userAuthorationDB(string email, string password) { using (var db = new NotesMEDBContainer()) // DB NAME IS CONTAINER { var user = db.UserSet.Where(i => i.Email == email && i.Password == password).FirstOrDefault(); if (user == null) { return(""); } return(user.Name); } }
private void registerInDB(string name, string email, string password) { using (var db = new NotesMEDBContainer()) // DB NAME IS CONTAINER { var user = new User(); user.Email = email; user.Name = name; user.Password = password; db.UserSet.Add(user); db.SaveChanges(); } }
private Note getNoteById(int id) { using (var db = new NotesMEDBContainer()) // DB NAME IS CONTAINER { var note = db.NoteSet.Where(i => i.Id == id).FirstOrDefault(); if (note == null) { return(null); } return(note); } }
private void updatePassword(string email, string newPassword) { using (var db = new NotesMEDBContainer()) // DB NAME IS CONTAINER { var user = db.UserSet.Where(i => i.Email == email).FirstOrDefault(); if (user != null) { user.Password = newPassword; db.SaveChanges(); } } }
private void updateColor(string id, string color) { using (var db = new NotesMEDBContainer()) // DB NAME IS CONTAINER { var note = db.NoteSet.Where(i => i.Id.ToString() == id).FirstOrDefault(); if (note != null) { note.NoteColor = color; db.SaveChanges(); } } }
private int addNewTask(string noteId, string taskText, string date) { using (var db = new NotesMEDBContainer()) // DB NAME IS CONTAINER { var task = new Task(); task.NoteId = Int32.Parse(noteId); task.TaskDate = date; task.TaskText = taskText; db.TaskSet.Add(task); db.SaveChanges(); return(task.Id); } }
private void changeNote(string id, string taskText, string date) { using (var db = new NotesMEDBContainer()) // DB NAME IS CONTAINER { var note = db.NoteSet.Where(i => i.Id.ToString() == id).FirstOrDefault(); if (note != null) { note.NoteDate = date; note.NoteText = taskText; db.SaveChanges(); } } }
private bool checkUserExistanceInDB(string email) { System.Diagnostics.Debug.Write(email); using (var db = new NotesMEDBContainer()) // DB NAME IS CONTAINER { System.Diagnostics.Debug.Write(email); var user = db.UserSet.Where(i => i.Email == email).FirstOrDefault(); if (user == null) { return(false); } return(true); } }
private int getUserIdByEmail(string email) { using (var db = new NotesMEDBContainer()) // DB NAME IS CONTAINER { var newEmail = email.Replace('"', ' '); newEmail = newEmail.Trim(); var user = db.UserSet.Where(i => i.Email == newEmail).FirstOrDefault(); if (user == null) { return(-1); } return(user.Id); } }
private int addNewMultipleNoteInDB(string email, string noteHead) { using (var db = new NotesMEDBContainer()) // DB NAME IS CONTAINER { var note = new Note(); note.NoteDate = ""; note.NoteHead = noteHead; note.NoteText = ""; note.UserId = getUserIdByEmail(email); note.NoteColor = "white"; db.NoteSet.Add(note); db.SaveChanges(); return(note.Id); } }
private void deleteNote(string id, string email) { using (var db = new NotesMEDBContainer()) // DB NAME IS CONTAINER { System.Diagnostics.Debug.Write("Removing note " + id); var newId = Int32.Parse(id); var note = db.NoteSet.Where(i => i.Id == newId).FirstOrDefault(); if (note != null) { db.NoteSet.Remove(note); db.SaveChanges(); System.Diagnostics.Debug.Write("Note " + id + " Is Deleted."); } } }
private void deleteTask(string id, string email) { using (var db = new NotesMEDBContainer()) // DB NAME IS CONTAINER { System.Diagnostics.Debug.Write("Removing task " + id); var newId = Int32.Parse(id); var task = db.TaskSet.Where(i => i.Id == newId).FirstOrDefault(); if (task != null) { db.TaskSet.Remove(task); db.SaveChanges(); System.Diagnostics.Debug.Write("Not removed the task"); } } }