public void AddStudent(University student)
{
try
{
connection.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = connection;
cmd.CommandText = "INSERT INTO student (studentName,studentLastName,studentCours) " +
"VALUES(@studentName,@studentLastname,@studentCours)";
cmd.Prepare();
cmd.Parameters.AddWithValue("@studentName", student.getName());
cmd.Parameters.AddWithValue("@studentLastName", student.getLastName());
cmd.Parameters.AddWithValue("@studentCours", student.getCours());
cmd.ExecuteNonQuery();
}
finally
{
if (connection != null)
{
connection.Close();
}
}
}
public static void AddStudent(DBConnection con)
{
Console.WriteLine();
Console.WriteLine("----------------------------");
string name = "";
string lastName = "";
int cours = 0;
bool b1;
bool b2;
Console.WriteLine("Enter name:");
name = Console.ReadLine();
if (b1 = string.IsNullOrWhiteSpace(name))
{
Console.WriteLine("Please enter students name!");
b1 = false;
}
else
{
b1 = true;
}
if (b1 == true)
{
Console.WriteLine("Enter last name:");
lastName = Console.ReadLine();
if (b2 = string.IsNullOrWhiteSpace(lastName))
{
Console.WriteLine("Please enter students last name!");
b2 = false;
}
else
{
b2 = true;
}
if (b2 == true)
{
Console.WriteLine("Enter Cours:");
string coursString = Console.ReadLine();
try
{
cours = Convert.ToInt32(coursString);
University student = new University(name, lastName, cours);
con.AddStudent(student);
Console.WriteLine("----------------------------");
Console.WriteLine();
}
catch (Exception)
{
Console.WriteLine("Please enter student cours with numbers");
AddStudent(con);
return;
}
}
else
{
AddStudent(con);
return;
}
}
else
{
AddStudent(con);
return;
}
}