public ActionResult SubjectAdd(SubjectAdder model)
{
string Username = Session["username"] as string;
if (Username == null)
{
return(Redirect("../Log/index"));
}
string subAdd = "INSERT INTO subjects_dictionary(Subject) VALUES ('" + model.NewSubject + "');";
DBConnection dbconnection = new DBConnection();
dbconnection.ExecuteQuery(subAdd);
string lecturerquery = "SELECT Login AS lecturer FROM lecturers";
string subjectQuery = "SELECT Subject FROM subjects_dictionary";
string classesQuery = "SELECT ClassNR FROM classes";
string hoursQuery = "SELECT CONVERT(hours_dictionary.Hour, char) as hour FROM hours_dictionary";
List <string> lecturersList = new List <string>();
List <string> hoursList = new List <string>();
List <string> subjectList = new List <string>();
List <string> classesList = new List <string>();
dbconnection.ConnectionToList(lecturerquery, lecturersList);
dbconnection.ConnectionToList(hoursQuery, hoursList);
dbconnection.ConnectionToList(subjectQuery, subjectList);
dbconnection.ConnectionToList(classesQuery, classesList);
ViewData["lecturers"] = lecturersList;
ViewData["hours"] = hoursList;
ViewData["subjects_dictionary"] = subjectList;
ViewData["classes"] = classesList;
return(View("AdminPanel"));
}
private void Button1_Click(object sender, EventArgs e)
{
this.Hide();
var subjectAdder = new SubjectAdder();
var subjectForm = new AddSubjectForm(subjectAdder);
if (subjectForm.ShowDialog() == DialogResult.OK)
{
DisplayList();
}
this.Show();
}
