public void DuplicateNoteTest(string name, string text, string createdDay, string createdMonth, string createdYear, string newDay, string newMonth, string newYear) { Note note = new Note(-1, -1, name, text, new DateTime(int.Parse(createdYear), int.Parse(createdMonth), int.Parse(createdDay)), DateTime.Now, true); DateTime before = DateTime.Now; Note dNote = helper.DuplicateNote(note, new DateTime(int.Parse(newYear), int.Parse(newMonth), int.Parse(newDay))); DateTime after = DateTime.Now; Assert.AreNotEqual(note.Id, dNote.Id); ServerRealization.Database.Context.Note dbNote = DBContext.Notes.Where(x => x.Id == note.Id).First(); ServerRealization.Database.Context.Note DbDNote = DBContext.Notes.Where(x => x.Id == dNote.Id).First(); Assert.AreEqual(name, dNote.Name); Assert.AreEqual(name, DbDNote.Name); Assert.AreEqual(text, dNote.Text); Assert.AreEqual(text, DbDNote.Text); Assert.AreEqual(dbNote.UserId, DbDNote.UserId); Assert.AreEqual(newDay, dNote.Created.Day.ToString()); Assert.AreEqual(newDay, DbDNote.Created.Day.ToString()); Assert.AreEqual(newMonth, dNote.Created.Month.ToString()); Assert.AreEqual(newMonth, DbDNote.Created.Month.ToString()); Assert.AreEqual(newYear, dNote.Created.Year.ToString()); Assert.AreEqual(newYear, DbDNote.Created.Year.ToString()); Assert.IsTrue(before <= dNote.LastChanged && dNote.LastChanged <= after); Assert.IsTrue(before <= DbDNote.LastChanged && DbDNote.LastChanged <= after); }
public void CreateNoteTest(string name, string text) { Note note = new Note(-1, name, text, DateTime.Now, DateTime.Now); int id = helper.CreateNote(note); Thread.Sleep(500); ServerRealization.Database.Context.Note dbNote = DBContext.Notes.Where(x => x.Id == id).First(); Assert.AreEqual(name, dbNote.Name); Assert.AreEqual(text, dbNote.Text); }
public void InitializationTest(int id, string name, string text) { Random random = new Random(); DateTime created = DateTime.Now.AddDays(random.NextDouble() * -1); DateTime lastChanged = DateTime.Now; Note note1 = new Note(id, 0, name, text, created, lastChanged); Note note2 = new Note(0, name, text, created, lastChanged); ServerRealization.Database.Context.User user = new ServerRealization.Database.Context.User("Name", "Login", "Password", DateTime.Now); ServerRealization.Database.Context.Note dbNote = new ServerRealization.Database.Context.Note(id, user, new ServerRealization.Database.Context.Collection(), name, text, created, lastChanged); Note note3 = new Note(dbNote.ToString()); Assert.AreEqual(id, note1.Id); Assert.AreEqual(id, note3.Id); Assert.AreEqual(name, note1.Name); Assert.AreEqual(name, note2.Name); Assert.AreEqual(name, note3.Name); Assert.AreEqual(text, note1.Text); Assert.AreEqual(text, note2.Text); Assert.AreEqual(text, note3.Text); Assert.AreEqual(created, note1.Created); Assert.AreEqual(created, note2.Created); if (created > note3.Created) { Assert.IsTrue((created - note3.Created).TotalSeconds < 1); } else if (note3.Created > created) { Assert.IsTrue((note3.Created - created).TotalSeconds < 1); } Assert.AreEqual(lastChanged, note1.LastChanged); Assert.AreEqual(lastChanged, note2.LastChanged); if (lastChanged > note3.LastChanged) { Assert.IsTrue((lastChanged - note3.LastChanged).TotalSeconds < 1); } else if (note3.LastChanged > lastChanged) { Assert.IsTrue((note3.LastChanged - lastChanged).TotalSeconds < 1); } }
public void AutoTimingTest(string name, string text, string newName, string newText) { SocketSettings.SocketSettings settings = new SocketSettings.SocketSettings("192.168.0.107", 11221, 300); ServerProgram server = new ServerProgram(settings); server.Run(); server.ExecuteCommand("rnu", new string[] { "Login", "Password", "Name" }); DBHelper helper = new DBHelper(settings); DBHelper.Login = "******"; DBHelper.Password = "******"; Note note = new Note(name, text, true); Thread.Sleep(500); Assert.AreEqual(name, note.Name); Assert.AreEqual(text, note.Text); Assert.IsTrue(DBContext.Notes.Where(x => x.Id == note.Id).Count() == 1); ServerRealization.Database.Context.Note dbNote = DBContext.Notes.Where(x => x.Id == note.Id).First(); Assert.AreEqual(name, dbNote.Name); Assert.AreEqual(text, dbNote.Text); Assert.IsTrue(new TimeSpan(0, 0, 1) > (note.Created > dbNote.Created ? note.Created - dbNote.Created : dbNote.Created - note.Created)); Assert.IsTrue(new TimeSpan(0, 0, 1) > (note.LastChanged > dbNote.LastChanged ? note.LastChanged - dbNote.LastChanged : dbNote.LastChanged - note.LastChanged)); note.Name = newName; note.Text = newText; Thread.Sleep(7000); if (name != newName) { Assert.AreNotEqual(newName, dbNote.Name); } if (text != newText) { Assert.AreNotEqual(newText, dbNote.Text); } Thread.Sleep(3500); Assert.AreEqual(newName, dbNote.Name); Assert.AreEqual(newText, dbNote.Text); server.Stop(); Thread.Sleep(1000); }
public void SaveChangesTest(string name, string text, string newName, string newText) { Note note = new Note(-1, name, text, DateTime.Now, DateTime.Now); int id = helper.CreateNote(note); Thread.Sleep(500); List <KeyValuePair <string, string[]> > changes = Note.GetChanges(new Note(id, -1, newName, newText, DateTime.Now, DateTime.Now), note); Assert.IsTrue(helper.SaveChanges(changes)); Thread.Sleep(500); ServerRealization.Database.Context.Note dbNote = DBContext.Notes.Where(x => x.Id == id).First(); Assert.AreEqual(newName, dbNote.Name); Assert.AreEqual(newText, dbNote.Text); server.Stop(); Thread.Sleep(1000); }
public void InitializationTestParagraph(int id, int actionId, int noteId, string name, string text, string[] points, bool[] isCheckeds) { Random random = new Random(); DateTime created = DateTime.Now.AddDays(random.NextDouble() * -1); DateTime lastChanged = DateTime.Now; DateTime startT = new DateTime(random.Next()); DateTime endT = new DateTime(random.Next()); if (startT > endT) { DateTime t = startT; startT = endT; endT = t; } ServerRealization.Database.Context.User dbUser = new ServerRealization.Database.Context.User("Name", "Login", "Password", DateTime.Now); DBContext.Users.Add(dbUser); ServerRealization.Database.Context.Note dbNote = new ServerRealization.Database.Context.Note(noteId, dbUser, new ServerRealization.Database.Context.Collection(), name, text, created, lastChanged); DBContext.Notes.Add(dbNote); ServerRealization.Database.Context.Action dbAction = new ServerRealization.Database.Context.Action(actionId, dbNote, startT, endT); DBContext.Actions.Add(dbAction); ServerRealization.Database.Context.Collection dbParagraph = new ServerRealization.Database.Context.Collection(points.Length); DBContext.Collections.Add(dbParagraph); for (int i = 0; i < points.Length; ++i) { ServerRealization.Database.Context.Point dbPoint = new ServerRealization.Database.Context.Point(dbParagraph, points[i], isCheckeds[i]); DBContext.Points.Add(dbPoint); } ServerRealization.Database.Context.Mission dbMission = new ServerRealization.Database.Context.Mission(id, dbAction, false, dbParagraph); ParagraphMission mission = (ParagraphMission)Mission.CreateNew(dbMission.ToString()); Assert.AreEqual(id, mission.Id); Assert.AreEqual(actionId, mission.ActionId); Assert.AreEqual(noteId, mission.NoteId); Assert.AreEqual(name, mission.Name); Assert.AreEqual(text, mission.Text); Assert.AreEqual(points.Length, mission.Paragraph.Count); for (int i = 0; i < mission.Paragraph.Count; ++i) { Assert.AreEqual(points[i], mission.Paragraph.Items[i].Text); Assert.AreEqual(isCheckeds[i], mission.Paragraph.Items[i].IsChecked); } if (created > mission.Created) { Assert.IsTrue((created - mission.Created).TotalSeconds < 1); } else if (mission.Created > created) { Assert.IsTrue((mission.Created - created).TotalSeconds < 1); } if (lastChanged > mission.LastChanged) { Assert.IsTrue((lastChanged - mission.LastChanged).TotalSeconds < 1); } else if (mission.LastChanged > lastChanged) { Assert.IsTrue((mission.LastChanged - lastChanged).TotalSeconds < 1); } if (startT > mission.Start) { Assert.IsTrue((startT - mission.Start).TotalSeconds < 1); } else if (mission.Start > startT) { Assert.IsTrue((mission.Start - startT).TotalSeconds < 1); } if (endT > mission.End) { Assert.IsTrue((endT - mission.End).TotalSeconds < 1); } else if (mission.End > endT) { Assert.IsTrue((mission.End - endT).TotalSeconds < 1); } }
public void InitializationTestProgress(int id, int actionId, int noteId, string name, string text, int start, int current, int end) { Random random = new Random(); DateTime created = DateTime.Now.AddDays(random.NextDouble() * -1); DateTime lastChanged = DateTime.Now; DateTime startT = new DateTime(random.Next()); DateTime endT = new DateTime(random.Next()); if (startT > endT) { DateTime t = startT; startT = endT; endT = t; } ServerRealization.Database.Context.User dbUser = new ServerRealization.Database.Context.User("Name", "Login", "Password", DateTime.Now); ServerRealization.Database.Context.Note dbNote = new ServerRealization.Database.Context.Note(noteId, dbUser, new ServerRealization.Database.Context.Collection(), name, text, created, lastChanged); ServerRealization.Database.Context.Action dbAction = new ServerRealization.Database.Context.Action(actionId, dbNote, startT, endT); ServerRealization.Database.Context.Mission dbMission = new ServerRealization.Database.Context.Mission(id, dbAction, true, new ServerRealization.Database.Context.Progress(start, current, end)); ProgressMission mission = (ProgressMission)Mission.CreateNew(dbMission.ToString()); Assert.AreEqual(id, mission.Id); Assert.AreEqual(actionId, mission.ActionId); Assert.AreEqual(noteId, mission.NoteId); Assert.AreEqual(name, mission.Name); Assert.AreEqual(text, mission.Text); Assert.AreEqual(start, ((Progress)mission.Context).Start); Assert.AreEqual(current, mission.Context.Count); Assert.AreEqual(end, ((Progress)mission.Context).End); if (created > mission.Created) { Assert.IsTrue((created - mission.Created).TotalSeconds < 1); } else if (mission.Created > created) { Assert.IsTrue((mission.Created - created).TotalSeconds < 1); } if (lastChanged > mission.LastChanged) { Assert.IsTrue((lastChanged - mission.LastChanged).TotalSeconds < 1); } else if (mission.LastChanged > lastChanged) { Assert.IsTrue((mission.LastChanged - lastChanged).TotalSeconds < 1); } if (startT > mission.Start) { Assert.IsTrue((startT - mission.Start).TotalSeconds < 1); } else if (mission.Start > startT) { Assert.IsTrue((mission.Start - startT).TotalSeconds < 1); } if (endT > mission.End) { Assert.IsTrue((endT - mission.End).TotalSeconds < 1); } else if (mission.End > endT) { Assert.IsTrue((mission.End - endT).TotalSeconds < 1); } }
public void DuplicateParagraphMissionTest(string name, string text, string[] points, bool[] isCheckeds, string createdDay, string createdMonth, string createdYear, string newDay, string newMonth, string newYear, string expectedResult) { ParagraphMission paragraphMission = new ParagraphMission(name, text, DateTime.Parse(createdDay + "." + createdMonth + "." + createdYear), true); int[] ids = new int[] { paragraphMission.NoteId, paragraphMission.ActionId, paragraphMission.Id, paragraphMission.Paragraph.Id }; for (int i = 0; i < points.Length; ++i) { helper.AddPointToParagraphMission(paragraphMission, new Point(points[i], isCheckeds[i])); } DateTime before = DateTime.Now; ParagraphMission dParagraphMission = helper.DuplicateParagraphMission(paragraphMission, DateTime.Parse(newDay + "." + newMonth + "." + newYear)); DateTime after = DateTime.Now; int[] newIds = new int[] { dParagraphMission.NoteId, dParagraphMission.ActionId, dParagraphMission.Id, dParagraphMission.Paragraph.Id }; ServerRealization.Database.Context.Note noteDb = DBContext.Notes.Where(x => x.Id == ids[0]).First(); ServerRealization.Database.Context.Note newNoteDb = DBContext.Notes.Where(x => x.Id == newIds[0]).First(); ServerRealization.Database.Context.Action actionDb = DBContext.Actions.Where(x => x.Id == ids[1]).First(); ServerRealization.Database.Context.Action newActionDb = DBContext.Actions.Where(x => x.Id == newIds[1]).First(); ServerRealization.Database.Context.Mission missionDb = DBContext.Missions.Where(x => x.Id == ids[2]).First(); ServerRealization.Database.Context.Mission newMissionDb = DBContext.Missions.Where(x => x.Id == newIds[2]).First(); ServerRealization.Database.Context.Collection paragraphDb = DBContext.Collections.Where(x => x.Id == ids[3]).First(); ServerRealization.Database.Context.Collection newParagraphDb = DBContext.Collections.Where(x => x.Id == newIds[3]).First(); List <ServerRealization.Database.Context.Point> pointsDb = DBContext.Points.Where(x => x.ParagraphId == ids[3]).ToList(); List <ServerRealization.Database.Context.Point> newPointsDb = DBContext.Points.Where(x => x.ParagraphId == newIds[3]).ToList(); Assert.AreNotEqual(noteDb.Id, newNoteDb.Id); Assert.AreEqual(noteDb.UserId, newNoteDb.UserId); Assert.AreEqual(noteDb.Name, newNoteDb.Name); Assert.AreEqual(noteDb.Text, newNoteDb.Text); Assert.AreNotEqual(noteDb.Created, newNoteDb.Created); Assert.AreEqual(newDay, newNoteDb.Created.Day.ToString()); Assert.AreEqual(newMonth, newNoteDb.Created.Month.ToString()); Assert.AreEqual(newYear, newNoteDb.Created.Year.ToString()); Assert.IsTrue(before <= newNoteDb.LastChanged && newNoteDb.LastChanged <= after); Assert.AreNotEqual(actionDb.Id, newActionDb.Id); Assert.AreNotEqual(actionDb.NoteId, newActionDb.NoteId); Assert.AreEqual(newNoteDb.Id, newActionDb.NoteId); Assert.AreEqual(actionDb.Start, newActionDb.Start); Assert.AreEqual(actionDb.End, newActionDb.End); Assert.AreNotEqual(missionDb.Id, newMissionDb.Id); Assert.AreNotEqual(missionDb.ActionId, newMissionDb.ActionId); Assert.AreEqual(newActionDb.Id, newMissionDb.Id); Assert.AreEqual(false, newMissionDb.IsProgressType); Assert.AreNotEqual(missionDb.ContextId, newMissionDb.ContextId); Assert.AreEqual(newParagraphDb.Id, newMissionDb.ContextId); Assert.AreNotEqual(paragraphDb.Id, newParagraphDb.Id); Assert.AreEqual(paragraphDb.Count, newParagraphDb.Count); Assert.AreEqual(pointsDb.Count, newPointsDb.Count); for (int i = 0; i < pointsDb.Count; ++i) { Assert.AreNotEqual(pointsDb[i].Id, newPointsDb[i].Id); Assert.AreEqual(newParagraphDb.Id, newPointsDb[i].ParagraphId); Assert.AreEqual(pointsDb[i].Name, newPointsDb[i].Name); Assert.AreEqual(pointsDb[i].IsChecked, newPointsDb[i].IsChecked); } }
public void InitializationTest(int id, int noteId, string name, string text) { Random random = new Random(); DateTime created = DateTime.Now.AddDays(random.NextDouble() * -1); DateTime lastChanged = DateTime.Now; DateTime start = new DateTime(random.Next()); DateTime end = new DateTime(random.Next()); if (start > end) { DateTime t = start; start = end; end = t; } Action action1 = new Action(id, noteId, 0, name, text, created, lastChanged, start, end); Note note2 = new Note(noteId, 0, name, text, created, lastChanged); Action action2 = new Action(id, note2, start, end); ServerRealization.Database.Context.User user = new ServerRealization.Database.Context.User("Name", "Login", "Password", DateTime.Now); ServerRealization.Database.Context.Note dbNote = new ServerRealization.Database.Context.Note(noteId, user, new ServerRealization.Database.Context.Collection(), name, text, created, lastChanged); ServerRealization.Database.Context.Action dbAction = new ServerRealization.Database.Context.Action(id, dbNote, start, end); Action action3 = new Action(dbAction.ToString()); Assert.AreEqual(id, action1.Id); Assert.AreEqual(id, action2.Id); Assert.AreEqual(id, action3.Id); Assert.AreEqual(noteId, action1.NoteId); Assert.AreEqual(noteId, action2.NoteId); Assert.AreEqual(noteId, action3.NoteId); Assert.AreEqual(name, action1.Name); Assert.AreEqual(name, action2.Name); Assert.AreEqual(name, action3.Name); Assert.AreEqual(text, action1.Text); Assert.AreEqual(text, action2.Text); Assert.AreEqual(text, action3.Text); Assert.AreEqual(created, action1.Created); Assert.AreEqual(created, action2.Created); Assert.AreEqual(lastChanged, action1.LastChanged); Assert.AreEqual(lastChanged, action2.LastChanged); Assert.AreEqual(start, action1.Start); Assert.AreEqual(start, action2.Start); Assert.AreEqual(end, action1.End); Assert.AreEqual(end, action2.End); if (created > action3.Created) { Assert.IsTrue((created - action3.Created).TotalSeconds < 1); } else if (action3.Created > created) { Assert.IsTrue((action3.Created - created).TotalSeconds < 1); } if (lastChanged > action3.LastChanged) { Assert.IsTrue((lastChanged - action3.LastChanged).TotalSeconds < 1); } else if (action3.LastChanged > lastChanged) { Assert.IsTrue((action3.LastChanged - lastChanged).TotalSeconds < 1); } if (start > action3.Start) { Assert.IsTrue((start - action3.Start).TotalSeconds < 1); } else if (action3.Start > start) { Assert.IsTrue((action3.Start - start).TotalSeconds < 1); } if (end > action3.End) { Assert.IsTrue((end - action3.End).TotalSeconds < 1); } else if (action3.End > end) { Assert.IsTrue((action3.End - end).TotalSeconds < 1); } }