public void ThenVerifyTheDBBusinessPartnerStausV(string nic) { Console.WriteLine("********************************************"); DBTestData ChangeStatus = new DBTestData(); ChangeStatus.ChangedStatusBusinessPartner(nic); Console.WriteLine(""); }
public void ThenVerifyTheDBUpdatedDataOfUpdatedBusinesPartnerV(string nic) { Console.WriteLine("********************************************"); DBTestData updatedData = new DBTestData(); updatedData.UpdatedCustomerData(nic); Console.WriteLine(""); }
public void ThenVerifyTheDBForNewlyAddedNoteOfBusinessPartnerV(string nic) { Console.WriteLine("********************************************"); DBTestData Note = new DBTestData(); Note.NoteMaintenance(nic); Console.WriteLine("********************************************"); Console.WriteLine(""); }
public void ThenSavedDBDataIsDsiplayed(string nic) { Console.WriteLine("********************************************"); //dynamic data = table.CreateDynamicInstance(); DBTestData dbData = new DBTestData(); dbData.NewCreatedCustomerData(nic); Console.WriteLine(""); }
private void Listener() { while (true) { IPEndPoint ep = null; byte[] mas = client_2.Receive(ref ep); using (MemoryStream ms = new MemoryStream()) { BinaryFormatter bf = new BinaryFormatter(); ms.Write(mas, 0, mas.Length); ms.Seek(0, SeekOrigin.Begin); InfoLibClientSendClass info = (InfoLibClientSendClass)bf.Deserialize(ms); if (info.MSG == "CONNECT") { var user = repoUser.FirstOrDefault(t => t.Login == info.Login && t.Password == info.Password); Info inf = new Info(); if (user == null) { inf.MSG = "CONNECTED_FALSE"; inf.Data = null; inf.DBTestData = null; inf.DBUserData = null; inf.remoteEP = remoteEP; SenderData(inf); } else { inf.MSG = "CONNECTED_TRUE"; inf.Data = null; inf.DBTestData = null; inf.DBUserData = new DBUserData() { Id = user.Id, FName = user.FName, LName = user.LName, GroupId = user.GroupId }; inf.remoteEP = remoteEP; SenderData(inf); } } else if (info.MSG == "LOAD_TESTS") { var user = repoUser.FirstOrDefault(t => t.Login == info.Login); if (user == null) { return; } var groupP = repoGroup.FindById(user.GroupId); if (groupP == null) { return; } var bs = from g in repoGroup.GetAllData() join gt in repoGroupTest.GetAllData() on g.Id equals gt.GroupId join t in repoTest.GetAllData() on gt.TestId equals t.Id where g.Id == groupP.Id select new { GroupName = g.Name, Author = t.Author, Title = t.Title, NumOfQuestions = t.NumOfQuestions, Time = t.Time }; Info inf = new Info(); inf.MSG = "LOAD_TESTS_TRUE"; inf.remoteEP = remoteEP; inf.DBUserData = new DBUserData() { FName = groupP.Name }; inf.Data = null; inf.DBTestData = new List <DBTestData>(); foreach (var t in bs) { var test = repoTest.FirstOrDefault(m => m.Author == t.Author && m.Title == t.Title); DBTestData data = new DBTestData() { Author = t.Author, Filename = test.Filename, Id = test.Id, NumOfQuestions = t.NumOfQuestions, Title = t.Title, Time = t.Time }; inf.DBTestData.Add(data); } SenderData(inf); } else if (info.MSG == "PASS_TEST") { var selectedTest = repoTest.FindById(info.TestId); XmlSerializer formatter = new XmlSerializer(typeof(Data)); Data data = new Data(); using (FileStream fs = new FileStream($@"UploadedFiles\{selectedTest.Filename}", FileMode.Open)) { data = (Data)formatter.Deserialize(fs); } Info d = new Info(); d.MSG = "RETURN_TEST"; d.Data = new Data(); d.Data = data; d.remoteEP = remoteEP; d.DBTestData = new List <DBTestData>(); d.DBTestData.Add(new DBTestData() { Id = selectedTest.Id, Author = selectedTest.Author, Filename = selectedTest.Filename, NumOfQuestions = selectedTest.NumOfQuestions, Title = selectedTest.Title, Time = selectedTest.Time }); SenderData(d); } else if (info.MSG == "TEST_PASSED_DATA") { var gr = repoGrade.FirstOrDefault(t => t.UserId == info.UserId && t.TestId == info.TestId); if (gr != null) { if (info.UserId.HasValue) { gr.UserId = info.UserId.Value; } if (info.TestId.HasValue) { gr.TestId = info.TestId.Value; } if (info.TestMark.HasValue) { gr.Mark = info.TestMark.Value; } repoGrade.Update(gr); } else { Grade grade = new Grade(); if (info.UserId.HasValue) { grade.UserId = info.UserId.Value; } if (info.TestId.HasValue) { grade.TestId = info.TestId.Value; } if (info.TestMark.HasValue) { grade.Mark = info.TestMark.Value; } repoGrade.Add(grade); } } } } }