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