예제 #1
0
        public static void InsertProfessor(SqlConnection conn, Professors newProfessor)
        {
            var _insert = "INSERT INTO Professors (Title, Name) " + "VALUES (@Title, @Name)";
            var command = new SqlCommand(_insert, conn);

            command.Parameters.AddWithValue("Title", newProfessor.Title);
            command.Parameters.AddWithValue("Name", newProfessor.Name);
            command.ExecuteScalar();
        }
예제 #2
0
        public static Professors CreateProfessor()
        {
            Console.WriteLine("What is your title? (Ex: Dr. , Mr. , Mrs. etc.)");
            var professorTitle = Console.ReadLine();

            Console.WriteLine("What is your first and last name?");
            var professorFullName = Console.ReadLine();

            var newProfessor = new Professors
            {
                Title = professorTitle,
                Name  = professorFullName,
            };

            return(newProfessor);
        }