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