public void FindTopic() { TopicDal a = new TopicDal(connectionString); var gl = a.Find("Title"); Assert.IsTrue(gl.Count == 0 || gl[0].ID != -1); }
public void DeleteTopic() { TopicDal a = new TopicDal(connectionString); var res = a.Delete(3); Assert.IsTrue(res != -1); }
public void GetSortTopic() { TopicDal a = new TopicDal(connectionString); var gl = a.GetSort(); Assert.IsTrue(gl.Count >= 2 && String.Compare(gl[0].Title, gl[1].Title) < 0); }
public void GetAllTopic() { TopicDal a = new TopicDal(connectionString); var gl = a.GetAll(); Assert.IsTrue(gl.Count == 0 || gl[0].ID != -1); }
public UserManager(UserDTO user) { currentUser = user; userDal = new UserDal(user.Email); topicDal = new TopicDal(user.Email); commentDal = new CommentDal(user.Email); }
public void AddTopic() { TopicDal a = new TopicDal(connectionString); TopicDTO top = new TopicDTO(); top.ID = -1; top.Title = "Title"; top.Text = "text"; top.CommentID = 99999999; var res = a.Add(top); Assert.IsTrue(res.ID == -1); }
public void AddTopic() { UserDTO user = new UserDTO(); user.Email = connectionString; user.Login = login; user.Password = login; user.IDUser = -1; UserManager um = new AdminManager(user); TopicDal a = new TopicDal(connectionString); TopicDTO top = new TopicDTO(); top.ID = -1; top.Title = "Title"; top.Text = "text"; top.CommentID = 99999999; var res = um.AddTopic("Topic", "Text", "Comm"); Assert.IsTrue(res); }
public static void Main(string[] args) { Console.OutputEncoding = System.Text.Encoding.Default; //string connStr = ConfigurationManager.ConnectionStrings["ManagerNews"].ConnectionString; string connectionString = "Data Source=localhost;Initial Catalog=ManagerNews;Integrated Security=True"; topicDal = new TopicDal(connectionString); userDal = new UserDal(connectionString); commentDal = new CommentDal(connectionString); uint isLogIn = LogIn(); while (isLogIn != 0) { //Console.Clear(); Console.WriteLine("\n\n What do you want to DO?"); Console.WriteLine("\ntype 'l' to get List of entities"); Console.WriteLine("type 's' to Sort entity"); Console.WriteLine("type 'f' to Find entity"); if (isLogIn == 2) { Console.WriteLine("type 'a' to Add entity"); Console.WriteLine("type 'r' to Remove entity"); } //... Console.WriteLine("type 'o' to logOut"); Console.WriteLine("type 'q' to Quit"); try { char c = char.Parse(Console.ReadLine()); switch (c) { case 'l': //show list of entities { Console.WriteLine("\nList of all entity:"); PrintAll(); } break; case 's': // { Console.WriteLine("\nSorted by Title:"); PrintSorted(); } break; case 'a': //create new entity { Console.WriteLine("Add:"); AddUser(); } break; case 'r': //remove entity { Console.WriteLine("If you are the Owner or Administrator you can delete the user.\nEnter ID:"); if (isLogIn == 2) { int id = int.Parse(Console.ReadLine()); topicDal.Delete(id); } else { throw new Exception("Not permission"); } } break; case 'f': { Console.WriteLine("Please, enter a word or letters or a price: "); // find by Title string ttl = Console.ReadLine().ToString(); Find(ttl); } break; case 'o': { isLogIn = LogIn(); } break; case 'q': return; } } catch (Exception e) { Console.WriteLine(e.Message); } } }