public static void SetCurriculum(Curriculum curr)
{
SqlConnection sConn = new SqlConnection(Globals.connString);
DataSet Data = new DataSet();
SqlDataAdapter da;
SqlCommandBuilder cmdBuilder;
//Set the connection string of the SqlConnection object to connect
//to the SQL Server database in which you created the sample
//table.
try { sConn.Open(); }
catch (Exception ex) { throw ex; }
//Initialize the SqlDataAdapter object by specifying a Select command
//that retrieves data from the sample table.
da = new SqlDataAdapter("SELECT * FROM Curriculum WHERE semester_id=" + curr.Semester, sConn);
//Initialize the SqlCommandBuilder object to automatically generate and initialize
//the UpdateCommand, InsertCommand, and DeleteCommand properties of the SqlDataAdapter.
cmdBuilder = new SqlCommandBuilder(da);
//Populate the DataSet by running the Fill method of the SqlDataAdapter.
da.Fill(Data, "DATA");
Data.Tables["DATA"].Rows[0]["Courses"] = "";
foreach (Course crs in curr.Courses)
{
Data.Tables["DATA"].Rows[0]["Courses"] += crs.Name + ",";
}
da.Update(Data, "DATA");
//Close the database connection.
sConn.Close();
}
public CreateCurri(List <Course> l_c)
{
InitializeComponent();
String[] arr = new String[8];
sm = new Curriculum [8];
for (int i = 0; i < 8; i++)
{
sm[i] = new Curriculum();
sm[i].Courses = new List <Course>();
string[] words = SqlWorker.GetCurriculumString(i + 1).Split(',');
foreach (string word in words)
{
if (word == "")
{
continue;
}
Course temp = l_c.Find(crs => crs.Name == word);
sm[i].Courses.Add(temp);
}
}
foreach (Course cur in this.sm[0].Courses)
{
if (cur == null)
{
continue;
}
this.semester_list_box.Items.Add(cur);
}
foreach (Course cur in l_c)
{
Boolean flag = true;
for (int i = 0; i < 8; i++)
{
if (sm[i].Courses != null)
{
foreach (Course c in sm[i].Courses)
{
if (cur.Name == c.Name)
{
flag = false;
}
}
}
}
if (flag)
{
this.courses_list_box.Items.Add(cur);
}
}
this.add_btn.Enabled = false;
this.rem_btn.Enabled = false;
this.rem_btn.BackColor = Color.Gray;
this.add_btn.BackColor = Color.Gray;
}
private void Show_Curri_btn_Click(object sender, EventArgs e)
{
List <Curriculum> l_c = new List <Curriculum>();
for (int i = 1; i < 9; i++)
{
Curriculum cur = new Curriculum(i);
l_c.Add(cur);
}
Form form = new CurriculumsList(l_c);
form.Show();
}
