public override void Create()
{
var lecturesPlan = new LecturesPlan();
Console.Clear();
Console.WriteLine("Enter Lectures_plan properties:");
Console.WriteLine("Group id:");
lecturesPlan.group_id = Int32.Parse(Console.ReadLine());
Console.WriteLine("Subject id:");
lecturesPlan.subject_id = Int32.Parse(Console.ReadLine());
Console.WriteLine("Teacher id:");
lecturesPlan.teacher_id = Int32.Parse(Console.ReadLine());
try
{
context.lectures_plan.Add(lecturesPlan);
context.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Console.ReadLine();
}
}
public override void Create()
{
string sqlInsert = "Insert into lectures_plan(group_id, subject_id, teacher_id) VALUES(@group_id, @subject_id, @teacher_id)";
var lecturesPlan = new LecturesPlan();
Console.Clear();
Console.WriteLine("Enter Lectures_plan properties:");
Console.WriteLine("Group id:");
lecturesPlan.group_id = Int32.Parse(Console.ReadLine());
Console.WriteLine("Subject id:");
lecturesPlan.subject_id = Int32.Parse(Console.ReadLine());
Console.WriteLine("Teacher id:");
lecturesPlan.teacher_id = Int32.Parse(Console.ReadLine());
sqlConnection.Open();
using var cmd = new NpgsqlCommand(sqlInsert, sqlConnection);
cmd.Parameters.AddWithValue("group_id", lecturesPlan.group_id);
cmd.Parameters.AddWithValue("subject_id", lecturesPlan.subject_id);
cmd.Parameters.AddWithValue("teacher_id", lecturesPlan.teacher_id);
cmd.Prepare();
try
{
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Console.ReadLine();
}
finally
{
sqlConnection.Close();
}
}
