public void CreateTest()
{
CustomerDataDAL dal = new CustomerDataDAL(ConfigurationManager.ConnectionStrings["ITCDB"].ConnectionString);
var result = dal.CreateUser(new CustomerDataDTO
{
CustName = "Some Cust Name",
CustSurname = "Surname",
CustEmail = "*****@*****.**",
CustPhone = 000000000,
CustAddress = "Address",
CustPassword = Encoding.ASCII.GetBytes("1234567"),
RoleId = 1
});
Assert.IsTrue(result.CustomerDataId != 0, "somethig goes wong...");
}
public void GetAllCustomerTest()
{
CustomerDataDAL dal = new CustomerDataDAL(ConfigurationManager.ConnectionStrings["ITCDB"].ConnectionString);
var result = dal.CreateUser(new CustomerDataDTO
{
CustName = "SomeCustName",
CustSurname = "Surname",
CustEmail = "*****@*****.**",
CustPhone = 000100000,
CustAddress = "Address",
CustPassword = Encoding.ASCII.GetBytes("1234567"),
RoleId = 1
});
var categories = dal.GetAllUsers();
Assert.AreEqual(1, categories.Count(x => x.CustName == "SomeCustName"));
}
public void CustomerDataDAL()
{
System.Console.WriteLine("Welcome in Customer CRUD");
while (true)
{
System.Console.WriteLine("c - Create");
System.Console.WriteLine("r1 - read one");
System.Console.WriteLine("r2 - read all");
System.Console.WriteLine("u - update");
System.Console.WriteLine("d - delete");
System.Console.WriteLine("f - exit");
switch (System.Console.ReadLine())
{
case "c":
System.Console.WriteLine("Input Customer:");
customer = dal.CreateUser(new CustomerDataDTO
{
CustName = System.Console.ReadLine(),
CustSurname = System.Console.ReadLine(),
CustEmail = System.Console.ReadLine(),
CustPhone = Convert.ToInt32(System.Console.ReadLine()),
CustAddress = System.Console.ReadLine(),
CustPassword = Encoding.ASCII.GetBytes(System.Console.ReadLine()),
RoleId = Convert.ToInt32(System.Console.ReadLine())
});
System.Console.WriteLine("You add the: Id - " + customer.CustomerDataId + "; Name - " + customer.CustName + " " + customer.CustSurname + "; Email - " + customer.CustEmail + "; Phone - " + customer.CustPhone + "; Address - " + customer.CustAddress + "; Password - " + customer.CustPassword + "; Role Id - " + customer.RoleId);
System.Console.WriteLine("Press any key");
System.Console.WriteLine("");
System.Console.WriteLine("");
System.Console.ReadKey();
break;
case "r1":
System.Console.Write("Choose Id: ");
customer = dal.GetUserById(Convert.ToInt32(System.Console.ReadLine()));
System.Console.WriteLine("You read the: Id - " + customer.CustomerDataId + "; Name - " + customer.CustName + " " + customer.CustSurname + "; Email - " + customer.CustEmail + "; Phone - " + customer.CustPhone + "; Address - " + customer.CustAddress + "; Password - " + customer.CustPassword + "; Role Id - " + customer.RoleId);
System.Console.WriteLine("Press any key");
System.Console.WriteLine("");
System.Console.WriteLine("");
System.Console.ReadKey();
break;
case "r2":
List <CustomerDataDTO> categories = dal.GetAllUsers();
for (int i = 0; i < categories.Count; i++)
{
System.Console.WriteLine("You read the: Id - " + customer.CustomerDataId + "; Name - " + customer.CustName + " " + customer.CustSurname + "; Email - " + customer.CustEmail + "; Phone - " + customer.CustPhone + "; Address - " + customer.CustAddress + "; Password - " + customer.CustPassword + "; Role Id - " + customer.RoleId);
}
System.Console.WriteLine("Press any key");
System.Console.WriteLine("");
System.Console.WriteLine("");
System.Console.ReadKey();
break;
case "u":
System.Console.WriteLine("Update Name:");
customer = dal.UpdateUser(new CustomerDataDTO
{
CustName = System.Console.ReadLine(),
CustSurname = System.Console.ReadLine(),
CustEmail = System.Console.ReadLine(),
CustPhone = Convert.ToInt32(System.Console.ReadLine()),
CustAddress = System.Console.ReadLine(),
CustPassword = Encoding.ASCII.GetBytes(System.Console.ReadLine()),
RoleId = Convert.ToInt32(System.Console.ReadLine())
});
System.Console.WriteLine("You change the: Id - " + customer.CustomerDataId + "; Name - " + customer.CustName + " " + customer.CustSurname + "; Email - " + customer.CustEmail + "; Phone - " + customer.CustPhone + "; Address - " + customer.CustAddress + "; Password - " + customer.CustPassword + "; Role Id - " + customer.RoleId); System.Console.WriteLine("Press any key");
System.Console.WriteLine("");
System.Console.WriteLine("");
System.Console.ReadKey();
break;
case "d":
System.Console.WriteLine("Choose Id:");
dal.DeleteUser(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;
default:
return;
}
}
}
