/// <summary>
/// insert given data to a selected table
/// </summary>
private void InsertData()
{
string table = TablesComboBox.SelectedItem.ToString();
if (CheckID(InsertIDBox))
{
ValueError.Clear();
switch (table)
{
case "Students":
int stdid = Convert.ToInt32(InsertIDBox.Text.ToString());
string stdname = InsertNameBox.Text.ToString();
Data.AddItem(stdid, stdname);
break;
case "Courses":
int courseid = Convert.ToInt32(InsertIDBox.Text.ToString());
string coursename = InsertNameBox.Text.ToString();
string coursedesc = InsertCourseDescBox.Text.ToString();
int courseinst = Convert.ToInt32(InsertCourseInstBox.Text.ToString());
Data.AddItem(courseid, coursename, coursedesc, courseinst);
break;
case "Instructors":
int instid = Convert.ToInt32(InsertIDBox.Text.ToString());
string instname = InsertNameBox.Text.ToString();
Data.AddItem(instid, instname);
break;
case "Enrollments":
int courseEnroll = Convert.ToInt32(InsertIDBox.Text.ToString());
int stdEnroll = Convert.ToInt32(InsertNameBox.Text.ToString());
Data.AddItem(courseEnroll, stdEnroll);
break;
}
}
}