// insert professor values into db
public static void InsertProfessor(SqlConnection conn, Professors newProfessor)
{
var _insert = "INSERT INTO Professors (Name, Title)" +
" VALUES (@Name, @Title)";
var cmd = new SqlCommand(_insert, conn);
cmd.Parameters.AddWithValue("Name", newProfessor.NewProfessorName);
cmd.Parameters.AddWithValue("Title", newProfessor.NewProfessorTitle);
cmd.ExecuteScalar();
}
// display all professors that are in db
public static List <Professors> GetAllProfessors(SqlConnection conn)
{
var _select = "SELECT [ID], [Name], [Title] FROM Professors";
var query = new SqlCommand(_select, conn);
var reader = query.ExecuteReader();
var _rv = new List <Professors>();
// parse results
while (reader.Read())
{
var _newProfessor = new Professors(reader);
Console.WriteLine($"Professor's Name: {_newProfessor.NewProfessorName}, Professor's Title: {_newProfessor.NewProfessorTitle}");
}
reader.Close();
return(_rv);
}
// read for professor info
public static Professors CreateProfessor()
{
Console.WriteLine("What is the Professor's name?");
var professorNameFromInput = Console.ReadLine();
Console.WriteLine("What is the Professor's title?");
var professorTitleFromInput = Console.ReadLine();
// store input values for professors
var newProfessor = new Professors
{
NewProfessorName = professorNameFromInput,
NewProfessorTitle = professorTitleFromInput
};
return(newProfessor);
}