public void AutoRemovingPointTest(string[] points, int id) { ParagraphMission mission = new ParagraphMission("name", "text", DateTime.Now, true); ServerRealization.Database.Context.Mission dbMission = DBContext.Missions.Where(x => x.Id == mission.Id).First(); int dbId = -1; for (int i = 0; i < points.Length; ++i) { mission.Paragraph.AddPoint(new Point(points[i], true)); if (id == i) { dbId = mission.Paragraph.Items.Last().Id; } } Assert.AreEqual(1, DBContext.Points.Where(x => x.Id == dbId).Count()); Assert.AreEqual(points.Length, mission.Paragraph.Count); Assert.AreEqual(points.Length, DBContext.Collections.Where(x => x.Id == mission.Paragraph.Id).First().Count); mission.Paragraph.RemovePoint(dbId); Assert.AreEqual(0, DBContext.Points.Where(x => x.Id == dbId).Count()); Assert.AreEqual(points.Length - 1, mission.Paragraph.Count); Assert.AreEqual(points.Length - 1, DBContext.Collections.Where(x => x.Id == mission.Paragraph.Id).First().Count); }
public void AutoTimingTest(string name, string text, int day, int month, int year, string[] points, bool[] isCheckeds, string newName, string newText, string[] newPoints, bool[] newIsCheckeds) { ParagraphMission mission = new ParagraphMission(name, text, new DateTime(year, month, day), true); for (int i = 0; i < points.Length; ++i) { mission.Paragraph.AddPoint(new Point(points[i], isCheckeds[i], true)); } ServerRealization.Database.Context.Mission dbMission = DBContext.Missions.Where(x => x.Id == mission.Id).First(); Assert.AreEqual(mission.Name, dbMission.Action.Note.Name); Assert.AreEqual(mission.Text, dbMission.Action.Note.Text); Assert.AreEqual(mission.Created, dbMission.Action.Note.Created); List <Point> paragraph = mission.Paragraph.Items; List <ServerRealization.Database.Context.Point> dbParagraph = DBContext.Points .Where(y => y.ParagraphId == DBContext.Collections .Where(x => x.Id == mission.Paragraph.Id) .First().Id) .ToList(); for (int i = 0; i < points.Length; ++i) { Point point = paragraph[i]; ServerRealization.Database.Context.Point dbPoint = dbParagraph.Where(x => x.Id == point.Id).First(); Assert.AreEqual(point.Text, dbPoint.Name); Assert.AreEqual(point.IsChecked, dbPoint.IsChecked); } mission.Name = newName; mission.Text = newText; for (int i = 0; i < points.Length; ++i) { mission.Paragraph.Items[i].Text = newPoints[i]; mission.Paragraph.Items[i].IsChecked = newIsCheckeds[i]; } Thread.Sleep(11000); dbMission = DBContext.Missions.Where(x => x.Id == mission.Id).First(); Assert.AreEqual(mission.Name, dbMission.Action.Note.Name); Assert.AreEqual(mission.Text, dbMission.Action.Note.Text); Assert.AreEqual(mission.Created, dbMission.Action.Note.Created); paragraph = mission.Paragraph.Items; dbParagraph = DBContext.Points .Where(y => y.ParagraphId == DBContext.Collections .Where(x => x.Id == mission.Paragraph.Id) .First().Id) .ToList(); for (int i = 0; i < points.Length; ++i) { Point point = paragraph[i]; ServerRealization.Database.Context.Point dbPoint = dbParagraph.Where(x => x.Id == point.Id).First(); Assert.AreEqual(point.Text, dbPoint.Name); Assert.AreEqual(point.IsChecked, dbPoint.IsChecked); } }
public void AutoCreatingTest(string name, string text, int day, int month, int year) { ParagraphMission mission = new ParagraphMission(name, text, new DateTime(year, month, day)); Assert.IsTrue(mission.Id < 1); mission = new ParagraphMission(name, text, new DateTime(year, month, day), true); Thread.Sleep(500); Assert.IsTrue(mission.Id > 0); Assert.IsTrue(DBContext.Missions.Where(x => x.Id == mission.Id).Count() == 1); ServerRealization.Database.Context.Mission dbMission = DBContext.Missions.Where(x => x.Id == mission.Id).First(); Assert.AreEqual(mission.ActionId, dbMission.ActionId); Assert.AreEqual(mission.NoteId, dbMission.Action.NoteId); Assert.AreEqual(mission.Paragraph.Id, dbMission.ContextId); Assert.AreEqual(mission.Name, dbMission.Action.Note.Name); Assert.AreEqual(mission.Text, dbMission.Action.Note.Text); Assert.AreEqual(mission.Created, dbMission.Action.Note.Created); }
public void CreateNewParagraphMissionTest(string name, string text, int day, int month, int year) { ParagraphMission paragraphMission = new ParagraphMission(name, text, new DateTime(year, month, day)); int[] ids = helper.CreateParagraphMission(paragraphMission); Thread.Sleep(500); Assert.IsTrue(ids.Length == 4); Assert.IsTrue(DBContext.Notes.Where(x => x.Id == ids[0]).Count() == 1); Assert.IsTrue(DBContext.Actions.Where(x => x.Id == ids[1]).Count() == 1); Assert.IsTrue(DBContext.Missions.Where(x => x.Id == ids[2]).Count() == 1); Assert.IsTrue(DBContext.Collections.Where(x => x.Id == ids[3]).Count() == 1); ServerRealization.Database.Context.Mission mission = DBContext.Missions.Where(x => x.Id == ids[2]).First(); Assert.AreEqual(mission.Action.NoteId, ids[0]); Assert.AreEqual(mission.Action.Id, ids[1]); Assert.AreEqual(mission.ContextId, ids[3]); Assert.AreEqual(name, mission.Action.Note.Name); Assert.AreEqual(text, mission.Action.Note.Text); Assert.AreEqual(new DateTime(year, month, day), mission.Action.Note.Created); }
public void AutoAddingPointTest(string[] points) { ParagraphMission mission = new ParagraphMission("name", "text", DateTime.Now, true); Thread.Sleep(500); ServerRealization.Database.Context.Mission dbMission = DBContext.Missions.Where(x => x.Id == mission.Id).First(); for (int i = 0; i < points.Length; ++i) { mission.Paragraph.AddPoint(new Point(points[i], true)); Thread.Sleep(500); Assert.AreEqual(i + 1, mission.Paragraph.Count); Assert.AreEqual(i + 1, ((ServerRealization.Database.Context.Collection)dbMission.Context).Count); Point point = mission.Paragraph.Items.Last(); Assert.IsTrue(point.Id > 0); Assert.AreEqual(points[i], point.Text); Assert.AreEqual(false, point.IsChecked); ServerRealization.Database.Context.Point dbPoint = DBContext.Points.Where(x => x.Id == point.Id).First(); Assert.AreEqual(points[i], dbPoint.Name); Assert.AreEqual(false, dbPoint.IsChecked); } }
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 SetIntervalTimingTest(int mls) { ParagraphMission mission = new ParagraphMission("", "", DateTime.Now, true); ServerRealization.Database.Context.Mission dbMission = DBContext.Missions.Where(x => x.Id == mission.Id).First(); mission.SetIntervalTiming(mls); DateTime start = DateTime.Now; mission.Name = "test"; while (mission.Name != dbMission.Action.Note.Name) { Thread.Sleep(100); } DateTime end = DateTime.Now; Assert.IsTrue(mls > (int)(end - start).TotalMilliseconds - 150); Assert.IsTrue(mls < (int)(end - start).TotalMilliseconds + 150); mission = new ParagraphMission("", "", DateTime.Now, true); mission.SetIntervalTiming(mls); dbMission = DBContext.Missions.Where(x => x.Id == mission.Id).First(); start = DateTime.Now; mission.Text = "test"; while (mission.Text != dbMission.Action.Note.Text) { Thread.Sleep(100); } end = DateTime.Now; Assert.IsTrue(mls > (int)(end - start).TotalMilliseconds - 150); Assert.IsTrue(mls < (int)(end - start).TotalMilliseconds + 150); mission = new ParagraphMission("", "", DateTime.Now, true); mission.SetIntervalTiming(mls); dbMission = DBContext.Missions.Where(x => x.Id == mission.Id).First(); Point point = new Point("", true); mission.Paragraph.AddPoint(point); ServerRealization.Database.Context.Point dbPoint = DBContext.Points.Where(x => x.Id == point.Id).First(); start = DateTime.Now; point.Text = "test"; while (point.Text != dbPoint.Name) { Thread.Sleep(100); } end = DateTime.Now; Assert.IsTrue(mls > (int)(end - start).TotalMilliseconds - 150); Assert.IsTrue(mls < (int)(end - start).TotalMilliseconds + 150); mission = new ParagraphMission("", "", DateTime.Now, true); mission.SetIntervalTiming(mls); dbMission = DBContext.Missions.Where(x => x.Id == mission.Id).First(); point = new Point("", true); mission.Paragraph.AddPoint(point); dbPoint = DBContext.Points.Where(x => x.Id == point.Id).First(); start = DateTime.Now; point.IsChecked = true; while (point.IsChecked != dbPoint.IsChecked) { Thread.Sleep(100); } end = DateTime.Now; Assert.IsTrue(mls > (int)(end - start).TotalMilliseconds - 150); Assert.IsTrue(mls < (int)(end - start).TotalMilliseconds + 150); }