private string DuplicateNote(string[] args)
{
if (!ArgsHelper.CheckArgs(args, 6, 2, 3, 4, 5))
{
return("ae");
}
if (!ArgsHelper.CheckLoginPassword(args[0], args[1]))
{
return("False");
}
int id = int.Parse(args[2]);
if (!ArgsHelper.NoteIsExist(id))
{
return("ae");
}
if (ArgsHelper.IsAne(args[0], args[1], id))
{
return("ane");
}
int day = int.Parse(args[3]);
int month = int.Parse(args[4]);
int year = int.Parse(args[5]);
DateTime newCreated;
try { newCreated = new DateTime(int.Parse(args[5]), int.Parse(args[4]), int.Parse(args[3])); }
catch { return("ae"); }
Note note = DBContext.Notes.Where(x => x.Id == id).First();
Note dNote = new Note(note.User, DBContext.Collections.Where(x => x.Id == 1).First(), note.Name, note.Text, new DateTime(year, month, day), DateTime.Now);
DBContext.Notes.Add(dNote);
return(dNote.Id.ToString());
}
private string ChangeNoteName(string[] args)
{
if (!ArgsHelper.CheckArgs(args, 4, 2))
{
return("ae");
}
int id = int.Parse(args[2]);
if (!ArgsHelper.CheckLoginPassword(args[0], args[1]) || !ArgsHelper.NoteIsExist(id))
{
return("False");
}
if (ArgsHelper.IsAne(args[0], args[1], id))
{
return("ane");
}
Note current = DBContext.Notes.Where(x => x.Id == id).First();
current.Name = args[3];
current.LastChanged = DateTime.Now;
return("True");
}
private string RemovePoint(string[] args)
{
if (!ArgsHelper.CheckArgs(args, 3, 2))
{
return("ae");
}
if (!ArgsHelper.CheckLoginPassword(args[0], args[1]))
{
return("False");
}
int pointId = int.Parse(args[2]);
int noteId = DBContext.Missions
.Where(x => x.ContextId ==
DBContext.Points
.Where(y => y.Id == pointId)
.First()
.ParagraphId)
.First()
.Action
.NoteId;
if (ArgsHelper.IsAne(args[0], args[1], noteId))
{
return("ane");
}
DBContext.Points.Where(x => x.Id == pointId).First().Paragraph.Count--;
DBContext.Points.Remove(DBContext.Points.Where(x => x.Id == pointId).First());
return("True");
}
private string AddPointToParagraphMission(string[] args)
{
if (!ArgsHelper.CheckArgs(args, 3, 2))
{
return("ae");
}
int id = int.Parse(args[2]);
if (!ArgsHelper.CheckLoginPassword(args[0], args[1]) || ArgsHelper.IsAne(args[0], args[1], DBContext.Missions.Where(x => x.Id == id).First().Action.NoteId))
{
return("False");
}
string text = "";
if (args.Length >= 4)
{
text = args[3];
}
Mission mission = DBContext.Missions.Where(x => x.Id == id).First();
Point point = null;
if (DBContext.Points.Count != 0)
{
point = new Point(mission.ContextId, text, false);
}
else
{
point = new Point(1, mission.ContextId, text, false);
}
DBContext.Points.Add(point);
((Collection)mission.Context).Count++;
return(point.Id.ToString());
}
private string InsertTextToNote(string[] args)
{
if (!ArgsHelper.CheckArgs(args, 5, 2, 3))
{
return("ae");
}
int id = int.Parse(args[2]);
int count = int.Parse(args[3]);
if (!ArgsHelper.CheckLoginPassword(args[0], args[1]))
{
return("False");
}
if (ArgsHelper.IsAne(args[0], args[1], id))
{
return("ane");
}
if (!ArgsHelper.NoteIsExist(id))
{
return("False");
}
Note note = DBContext.Notes
.Where(x => x.Id == id).First();
if (note.Text.Length < count)
{
return("ae");
}
note.Text = note.Text.Substring(0, note.Text.Length - count) + args[4];
note.LastChanged = DateTime.Now;
return("True");
}
private string CheckLoginPassword(string[] args)
{
if (ArgsHelper.CheckArgs(args, 2))
{
return(ArgsHelper.CheckLoginPassword(args[0], args[1]).ToString());
}
return("ae");
}
private string CreateNewNote(string[] args)
{
if (!ArgsHelper.CheckArgs(args, 2))
{
return("ae");
}
if (!ArgsHelper.CheckLoginPassword(args[0], args[1]))
{
return("False");
}
string name = "";
if (args.Length >= 3)
{
name = args[2];
}
string text = "";
if (args.Length >= 4)
{
text = args[3];
}
int day = 0, month = 0, year = 0;
bool hasCreated = false;
if (args.Length >= 7)
{
if (ArgsHelper.CheckArgs(new string[] { args[4], args[5], args[6] }, 3, 0, 1, 2))
{
hasCreated = true;
day = int.Parse(args[4]);
month = int.Parse(args[5]);
year = int.Parse(args[6]);
}
}
DateTime created = DateTime.Now, lastChanged = created;
if (hasCreated)
{
try
{
created = new DateTime(year, month, day);
}
catch (ArgumentOutOfRangeException) { }
}
Note note = new Note(DBContext.Users.Where(x => x.Login == args[0]).First(),
DBContext.Collections.Where(x => x.Id == 1).First(),
name, text, created, lastChanged);
DBContext.Notes.Add(note);
return(note.Id.ToString());
}
private string DuplicateParagraphMission(string[] args)
{
if (!ArgsHelper.CheckArgs(args, 6, 2, 3, 4, 5))
{
return("ae");
}
if (!ArgsHelper.CheckLoginPassword(args[0], args[1]))
{
return("False");
}
int id = int.Parse(args[2]);
Mission mission = DBContext.Missions.Where(x => x.Id == id).First();
if (!ArgsHelper.NoteIsExist(mission.Action.NoteId))
{
return("ae");
}
if (ArgsHelper.IsAne(args[0], args[1], mission.Action.NoteId))
{
return("ane");
}
int day = int.Parse(args[3]);
int month = int.Parse(args[4]);
int year = int.Parse(args[5]);
DateTime newCreated;
try { newCreated = new DateTime(int.Parse(args[5]), int.Parse(args[4]), int.Parse(args[3])); }
catch { return("ae"); }
Note note = new Note(DBContext.Users.Where(x => x.Login == args[0] && x.Password == args[1]).First(),
DBContext.Collections.Where(x => x.Id == 1).First(),
mission.Action.Note.Name,
mission.Action.Note.Text,
newCreated,
DateTime.Now);
DBContext.Notes.Add(note);
Database.Context.Action action = new Database.Context.Action(note, DateTime.MinValue, DateTime.MaxValue);
DBContext.Actions.Add(action);
Collection collection = new Collection();
collection.Count = ((Collection)mission.Context).Count;
DBContext.Collections.Add(collection);
Mission dMission = new Mission(action, false, collection);
DBContext.Missions.Add(dMission);
List <Point> points = DBContext.Points.Where(x => x.ParagraphId == mission.ContextId).ToList();
string result = note.Id.ToString() + "|" + action.Id.ToString() + "|" + dMission.Id.ToString() + "|" + collection.Id.ToString();
foreach (Point point in points)
{
Point dPoint = new Point(dMission.ContextId, point.Name, point.IsChecked);
DBContext.Points.Add(dPoint);
result += "|" + dPoint.Id.ToString();
}
return(result);
}
private string CreateNewParagraphMission(string[] args)
{
if (!ArgsHelper.CheckArgs(args, 2))
{
return("ae");
}
if (!ArgsHelper.CheckLoginPassword(args[0], args[1]))
{
return("False");
}
string name = "";
if (args.Length >= 3)
{
name = args[2];
}
string text = "";
if (args.Length >= 4)
{
text = args[3];
}
DateTime end = DateTime.MaxValue;
DateTime created = DateTime.Now;
if (ArgsHelper.CheckArgs(args.Skip(4).ToArray(), 3, 0, 1, 2))
{
try { created = new DateTime(int.Parse(args[4]), int.Parse(args[5]), int.Parse(args[6])); }
catch (ArgumentOutOfRangeException) { }
}
Note note = new Note(DBContext.Users.Where(x => x.Login == args[0] && x.Password == args[1]).First(),
DBContext.Collections.Where(x => x.Id == 1).First(), name, text, created, DateTime.Now);
DBContext.Notes.Add(note);
Database.Context.Action action = new Database.Context.Action(note, DateTime.MinValue, DateTime.MaxValue);
DBContext.Actions.Add(action);
Collection collection = new Collection();
DBContext.Collections.Add(collection);
Mission mission = new Mission(action, false, collection);
DBContext.Missions.Add(mission);
return(note.Id.ToString() + "|" + action.Id.ToString() + "|" + mission.Id.ToString() + "|" + collection.Id.ToString());
}
private string ChangePointText(string[] args)
{
if (!ArgsHelper.CheckArgs(args, 4, 2))
{
return("ae");
}
int id = int.Parse(args[2]);
if (!ArgsHelper.CheckLoginPassword(args[0], args[1]) || ArgsHelper.IsAne(args[0], args[1],
DBContext.Missions.Where(x => x.ContextId ==
DBContext.Points.Where(y => y.Id == id).First().ParagraphId).First().Action.NoteId))
{
return("False");
}
DBContext.Points.Where(x => x.Id == id).First().Name = args[3];
return("True");
}
private string RegisterNewUser(string[] args)
{
if (!ArgsHelper.CheckArgs(args, 3))
{
return("ae");
}
if (DBContext.Users
.Where(x => x.Login == args[0])
.Count() >= 1)
{
return("uc");
}
User user = new User(args[2], args[0], args[1], DateTime.Now);
DBContext.Users.Add(user);
return("True");
}
private string GetDay(string[] args)
{
if (!ArgsHelper.CheckArgs(args, 5, 2, 3, 4))
{
return("ae");
}
try
{
DateTime t = new DateTime(int.Parse(args[4]), int.Parse(args[3]), int.Parse(args[2]));
}
catch { return("ae"); }
if (!ArgsHelper.CheckLoginPassword(args[0], args[1]))
{
return("False");
}
string splitter = "\b<sgd>\b";
string result = splitter;
List <Note> notes = DBContext.Notes.Where(x => x.User.Login == args[0] &&
x.User.Password == args[1] &&
x.Created.Day.ToString() == args[2] &&
x.Created.Month.ToString() == args[3] &&
x.Created.Year.ToString() == args[4])
.ToList();
foreach (Note note in notes)
{
if (DBContext.Actions.Where(x => x.NoteId == note.Id).Count() != 0)
{
result += DBContext.Missions.Where(x => x.ActionId ==
DBContext.Actions.Where(y => y.NoteId == note.Id)
.First().Id).First().ToString() + splitter;
}
else
{
result += note.ToString() + splitter;
}
}
return(result);
}
private string SetCheckedPoint(string[] args)
{
if (!ArgsHelper.CheckArgs(args, 4, 2) || !bool.TryParse(args[3], out bool val))
{
return("ae");
}
int id = int.Parse(args[2]);
if (!ArgsHelper.CheckLoginPassword(args[0], args[1]) || ArgsHelper.IsAne(args[0], args[1],
DBContext.Missions
.Where(y => y.ContextId == DBContext.Points
.Where(x => x.Id == id)
.First().ParagraphId)
.First().Action.NoteId))
{
return("False");
}
DBContext.Points.Where(x => x.Id == id).First().IsChecked = val;
return("True");
}
private string RemoveNoteCascade(string[] args)
{
if (!ArgsHelper.CheckArgs(args, 3, 2))
{
return("ae");
}
if (!ArgsHelper.CheckLoginPassword(args[0], args[1]))
{
return("False");
}
int id = int.Parse(args[2]);
if (ArgsHelper.IsAne(args[0], args[1], id))
{
return("ane");
}
if (DBContext.Actions.Where(x => x.NoteId == id).Count() != 0)
{
Mission mission = DBContext.Missions
.Where(x => x.Id ==
DBContext.Actions
.Where(y => y.NoteId == id)
.First().Id)
.First();
DBContext.Actions.Remove(mission.Action);
List <Point> points = DBContext.Points.Where(x => x.Paragraph.Id == mission.ContextId).ToList();
foreach (Point point in points)
{
DBContext.Points.Remove(point);
}
DBContext.Collections.Remove((Collection)mission.Context);
DBContext.Missions.Remove(mission);
}
DBContext.Notes.Remove(DBContext.Notes.Where(x => x.Id == id).First());
return("True");
}