public void CreateTest()
{
DateTime date = new DateTime(2000, 7, 1);
PersonDAL dal = new PersonDAL(ConfigurationManager.ConnectionStrings["IMDB"].ConnectionString);
var result = dal.CreatePerson(new PersonDTO
{
FirstName = "Ivan",
LastName = "Husak",
Birthday = date,
RoleId = 13
});
Assert.IsTrue(result.PersonId != 0, "returned ID should be more than zero");
}
public void PersonDALMenu()
{
while (true)
{
System.Console.WriteLine("Welcome in Role");
System.Console.WriteLine("c - Create");
System.Console.WriteLine("r - read one");
System.Console.WriteLine("rall - read all");
System.Console.WriteLine("u - update");
System.Console.WriteLine("d - delete");
System.Console.WriteLine("else - exit");
string a = System.Console.ReadLine();
switch (a)
{
case "c":
System.Console.WriteLine("Input Person :");
person = dal.CreatePerson(new PersonDTO {
FirstName = System.Console.ReadLine()
});
System.Console.WriteLine("You add the: Id - " + person.PersonId + " Name - " + person.FirstName);
System.Console.WriteLine("Press any key");
System.Console.WriteLine("");
System.Console.WriteLine("");
System.Console.ReadKey();
break;
case "r":
System.Console.Write("Choose Id: ");
person = dal.GetPersonById(System.Convert.ToInt32(System.Console.ReadLine()));
System.Console.WriteLine("You read the: Id - " + person.PersonId + " Name - " + person.FirstName);
System.Console.WriteLine("Press any key");
System.Console.WriteLine("");
System.Console.WriteLine("");
System.Console.ReadKey();
break;
case "rall":
List <PersonDTO> categories = dal.GetAllPerson();
for (int i = 0; i < person.Count; i++)
{
System.Console.WriteLine("Id - " + person[i].RoleId + " Name - " + person[i].FirstName);
}
System.Console.WriteLine("Press any key");
System.Console.WriteLine("");
System.Console.WriteLine("");
System.Console.ReadKey();
break;
case "u":
System.Console.WriteLine("Update Name:");
person = dal.UpdatePerson(new PersonDTO {
FirstName = System.Console.ReadLine()
});
System.Console.WriteLine("You add the: Id - " + person.PersonId + " Name - " + person.FirstName);
System.Console.WriteLine("Press any key");
System.Console.WriteLine("");
System.Console.WriteLine("");
System.Console.ReadKey();
break;
case "d":
System.Console.WriteLine("Choose Id:");
dal.DeletePerson(System.Convert.ToInt32(System.Console.ReadLine()));
System.Console.WriteLine("Delete successful");
System.Console.WriteLine("Press any key");
System.Console.WriteLine("");
System.Console.WriteLine("");
System.Console.ReadKey();
break;
case "else":
break;
}
}
}