public IActionResult EditExamTitle(Examtitle et)
{
SystemContext context = HttpContext.RequestServices.GetService(typeof(Exam_Management_System.Models.SystemContext)) as SystemContext;
using (MySqlConnection conn = context.GetConnection())
{
conn.Open();
string sql = $"Update examtitle set examtitle_name='{et.Name}' where id={et.Id}";
using (MySqlCommand command = new MySqlCommand(sql, conn))
{
command.ExecuteNonQuery();
conn.Close();
}
}
return(Redirect("/examtitle/index"));
}
public IActionResult AddExamTitle(Examtitle examtitle)
{
SystemContext context = HttpContext.RequestServices.GetService(typeof(Exam_Management_System.Models.SystemContext)) as SystemContext;
using (MySqlConnection conn = context.GetConnection())
{
conn.Open();
string sql = $"Insert Into examtitle (examtitle_name) Values ('{examtitle.Name}')";
using (MySqlCommand command = new MySqlCommand(sql, conn))
{
command.ExecuteNonQuery();
conn.Close();
}
}
return(Redirect("/examtitle/Index"));
}
