Beispiel #1
0
 public static void GetAll(ORM ado)
 {
     Console.WriteLine();
     foreach (var p in ado.GetAllPeople())
     {
         Console.WriteLine("{0}\t{1}\t{2}\t{3}\t{4}\t{5}", p.Id, p.FirstName, p.LastName, p.Age, p.PhoneNumber, p.Email);
     }
 }
Beispiel #2
0
        public static void Update(ORM orm)
        {
            bool checkUpdate = true;

            while (checkUpdate == true)
            {
                Console.Write("\nEnter the id you want to update: ");
                int id = Convert.ToInt32(Console.ReadLine());
                if (id == 0)
                {
                    checkUpdate = false;
                }
                var people = orm.GetAllPeople().Where(x => x.Id == id).FirstOrDefault();

                Console.WriteLine("\nChoose the column you want to change:\n" + "1.FirstName\n" + "2.LastName\n" + "3.Age\n" + "4.PhoneNumber\n" + "5.Email\n" + "<-Back\n");
                Console.Write(">>");
                string choiceUpdate = Console.ReadLine();
                try
                {
                    switch (choiceUpdate)
                    {
                    case "FirstName":
                        Console.Write("\nUpdate FirstName: ");
                        string fn = Console.ReadLine();

                        orm.Update(new People
                        {
                            Id          = people.Id,
                            FirstName   = fn,
                            LastName    = people.LastName,
                            Age         = people.Age,
                            PhoneNumber = people.PhoneNumber,
                            Email       = people.Email
                        });
                        break;

                    case "LastName":
                        Console.Write("\nUpdate LastName: ");
                        string ln = Console.ReadLine();

                        orm.Update(new People
                        {
                            Id          = people.Id,
                            FirstName   = people.FirstName,
                            LastName    = ln,
                            Age         = people.Age,
                            PhoneNumber = people.PhoneNumber,
                            Email       = people.Email
                        });
                        break;

                    case "Age":
                        Console.Write("\nUpdate Age: ");
                        int age = Convert.ToInt32(Console.ReadLine());

                        orm.Update(new People
                        {
                            Id          = people.Id,
                            FirstName   = people.FirstName,
                            LastName    = people.LastName,
                            Age         = age,
                            PhoneNumber = people.PhoneNumber,
                            Email       = people.Email
                        });
                        break;

                    case "PhoneNumber":
                        Console.Write("\nUpdate PhoneNumber: ");
                        string pn = Console.ReadLine();

                        orm.Update(new People
                        {
                            Id          = people.Id,
                            FirstName   = people.FirstName,
                            LastName    = people.LastName,
                            Age         = people.Age,
                            PhoneNumber = pn,
                            Email       = people.Email
                        });
                        break;

                    case "Email":
                        Console.Write("\nUpdate Email: ");
                        string em = Console.ReadLine();

                        orm.Update(new People
                        {
                            Id          = people.Id,
                            FirstName   = people.FirstName,
                            LastName    = people.LastName,
                            Age         = people.Age,
                            PhoneNumber = people.PhoneNumber,
                            Email       = em
                        });
                        break;

                    case "Back":
                        checkUpdate = false;
                        break;
                    }
                }
                catch (Exception e)
                {
                    Console.WriteLine(e.Message);
                }
            }
        }