static void Main(string[] args) { string connStr = "Data Source=DESKTOP-KHVC2BC;Initial Catalog=PZ_K;Integrated Security=True"; UserDAL dal = new UserDAL(connStr); UserDTO currentUser = null; SecurityDTO security = null; char menuItem; char menuUpdateItem; //dal.PutImageBinaryInDb(@"G:\Project Kyrs\Kyrsova_PZ\Images\1.jpg", 4); while (true) { ShowMenuItems(); menuItem = char.Parse(Console.ReadLine()); switch (menuItem) { case 'l': foreach (UserDTO cUser in dal.GetAllUsers()) { Console.WriteLine(cUser.GetInfo()); } break; case 'f': Console.Write("Enter Id : "); int iD; Int32.TryParse(Console.ReadLine(), out iD); currentUser = dal.GetUserById(iD); Console.WriteLine(currentUser.GetInfo()); break; case 'u': Console.Write("Enter Id : "); int id; Int32.TryParse(Console.ReadLine(), out id); currentUser = dal.GetUserById(id); if (currentUser != null) { Console.WriteLine(currentUser.GetInfo()); ShowMenuUpdateItems(); while (true) { menuUpdateItem = Console.ReadLine()[0]; switch (menuUpdateItem) { case '1': Console.Write("Enter FirstName : "); currentUser.FirstName = Console.ReadLine(); break; case '2': Console.Write("Enter LastName : "); currentUser.LastName = Console.ReadLine(); break; case '3': Console.Write("Enter Gender : "); currentUser.Gender = Console.ReadLine(); break; case '4': Console.Write("Enter Address : "); currentUser.Address = Console.ReadLine(); break; case '5': Console.Write("Enter Mail : "); currentUser.Mail = Console.ReadLine(); break; case '6': Console.Write("Enter Tel : "); currentUser.Tel = Console.ReadLine(); break; case '7': Console.Write("Enter BankCard : "); currentUser.BankCard = Console.ReadLine(); break; case '8': Console.Write("Path to images : "); string path = Console.ReadLine(); if (dal.PutImageBinaryInDb(path, id) == false) { Console.WriteLine("File not found"); } break; case '9': Console.Write("Securuty Info : "); security = new SecurityDTO(); Console.Write("Password :"******"KeyWord :"); security.KeyWord = Console.ReadLine(); security.IsTemporary = false; security.UserId = currentUser.Id; dal.SetPasswordForUser(security); break; } Console.WriteLine("For save and exit press e "); menuUpdateItem = Console.ReadLine()[0]; if (menuUpdateItem == 'e') { dal.UpdateUser(currentUser); break; } } } else { Console.WriteLine("User not found"); } break; case 'e': return; } Console.WriteLine("Pres any key to continue"); Console.ReadKey(); } //UserDTO m = new UserDTO //{ // Name = "Petro Inkognito", // Mail = "*****@*****.**", // Gender = "Male", // Address= "LVIv" //}; //dal.CreateUser(m); //m = manager.AddMovie(m); }