public static List <Projects_class> Load()
{
List <Projects_class> proj = new List <Projects_class>();
StreamReader inFile;
Projects_class pro;
try
{
inFile = File.OpenText("project2.txt");
while (!inFile.EndOfStream)
{
pro = new Projects_class();
pro.ID = Int32.Parse(inFile.ReadLine());
pro.Project_name = inFile.ReadLine();
pro.Year = Int32.Parse(inFile.ReadLine());
pro.Category = inFile.ReadLine();
proj.Add(pro);
}
inFile.Close();
return(proj);
}
catch
{
return(proj);
}
}
//load the text file
private void project_selection_form_Load(object sender, EventArgs e)
{
proj = projectDA.Load();
MySqlConnection connection = new MySqlConnection(connec);
connection.Open();
string query1 = @"SELECT
*
FROM internal_communication_4.projects AS p1";
MySqlDataAdapter adapt = new MySqlDataAdapter(query1, connection);
adapt.Fill(table);
while (row < table.Rows.Count)
{
Projects_class su = new Projects_class();
su.Project_name = (string)table.Rows[row]["project_name"];
su.Category = (string)table.Rows[row]["project_category"];
su.Year = Convert.ToInt32(table.Rows[row]["project_year"]);
su.ID = Convert.ToInt32(table.Rows[row]["project_id"]);
project_list.Items.Add(su.Showproject());
row += 1;
}
connection.Close();
user_lbl.Text = login_form.user_name;
position_lbl.Text = login_form.user_position;
//load subjects !!!!!!!!!!!!!!!!!!!!!!
/*MySqlConnection connection = new MySqlConnection(connec);
* connection.Open();
* string query6 = "SELECT user_name, user_position FROM internal_communication_4.user AS u1 JOIN internal_communication_4.logs AS l1 ON u1.user_id = l1.user_user_id WHERE (log_current = 1)";
* MySqlCommand command = new MySqlCommand(query6, connection);
* MySqlDataReader reader;
* reader = command.ExecuteReader();
* while (reader.Read())
* {
* user_lbl.Text = reader.GetString(0);
* position_lbl.Text = reader.GetString(1);
* }
* connection.Close();
*/
try
{
MySqlConnection connection1 = new MySqlConnection(connec);
//set projects as non active
Projects_class pro = new Projects_class();
pro.Proj_active = 2;
connection1.Open();
string query7 = "UPDATE internal_communication_4.projects SET project_selection = @project_selection ";
MySqlCommand comm = connection1.CreateCommand();
comm.CommandText = query7;
comm.Parameters.AddWithValue("@project_selection", pro.Proj_active);
comm.ExecuteNonQuery();
connection1.Close();
}
catch
{ }
}
private void project_btn_Click(object sender, EventArgs e)
{
Projects_class pro = new Projects_class();
this.Close();
}
private void Next_Click(object sender, EventArgs e)
{
//reset the current project to inactive in the database and clear the subject list
Projects_class pro2 = new Projects_class();
pro2.Proj_active = 2;
MySqlConnection connection1 = new MySqlConnection(connec);
connection1.Open();
string query8 = @"UPDATE internal_communication_4.projects
SET project_selection = @project_selection
WHERE (project_id = " + proID + ")";
MySqlCommand comm1 = connection1.CreateCommand();
comm1.CommandText = query8;
comm1.Parameters.AddWithValue("@project_selection", pro2.Proj_active);
comm1.ExecuteNonQuery();
connection1.Close();
subject_listbx.Items.Clear();
//reset the subject active
try
{
MySqlConnection connection2 = new MySqlConnection(connec);
Subject_class sub = new Subject_class();
sub.Subject_select = 2;
connection2.Open();
string query10 = "UPDATE internal_communication_4.subjects SET subject_selection = @subject_selection";
MySqlCommand comm = connection2.CreateCommand();
comm.CommandText = query10;
comm.Parameters.AddWithValue("@subject_selection", sub.Subject_select);
comm.ExecuteNonQuery();
connection2.Close();
}
catch
{
MessageBox.Show("error, please repeat the process");
}
Projects_class pro = new Projects_class();
pro.Proj_active = 1;
selectedItems = new ListBox.SelectedObjectCollection(project_list);
selectedItems = project_list.SelectedItems;
int selectedIndex = project_list.SelectedIndex;
if (selectedIndex != -1)
{
for (int i = selectedItems.Count - 1; i >= 0; i--)
{
projIDii = selectedItems[i].ToString();
}
projIDiii = projIDii.Split(',');
proID = Convert.ToInt32(projIDiii[0]);
MySqlConnection connection = new MySqlConnection(connec);
connection.Open();
string query7 = @"UPDATE internal_communication_4.projects
SET project_selection = @project_selection
WHERE (project_id = " + proID + ")";
MySqlCommand comm = connection.CreateCommand();
comm.CommandText = query7;
comm.Parameters.AddWithValue("@project_selection", pro.Proj_active);
comm.ExecuteNonQuery();
connection.Close();
}
//selectedItems = new ListBox.SelectedObjectCollection(project_list);
string project = Convert.ToString(selectedItems);
if (selectedItems != null)
{
string[] projectdiv = project.Split(',');
// subj = SubjectDA.Loadsub(projectdiv[0]);
// AddSubject(subj);
try
{
//fill listbox while loading
MySqlConnection connection = new MySqlConnection(connec);
connection.Open();
string query1 = @"SELECT
subject_id,
subject_name,
Project_project_id
FROM internal_communication_4.subjects AS s1
JOIN internal_communication_4.projects AS p1
ON s1.Project_project_id = p1.project_id
WHERE (project_selection = 1)";
table.Clear();
row = 0;
MySqlDataAdapter adapt = new MySqlDataAdapter(query1, connection);
adapt.Fill(table);
while (row < table.Rows.Count)
{
Subject_class su = new Subject_class();
su.Subject_id = Convert.ToInt32(table.Rows[row]["subject_id"]);
su.Subject = (string)table.Rows[row]["subject_name"];
subject_listbx.Items.Add(su.Showsubject());
row += 1;
}
connection.Close();
selectedItems = null;
row = 0;
}
catch
{
MessageBox.Show("error, please repeat the process");
}
}
else
{
MessageBox.Show("Please select a project");
}
}