private void onClick_UpdateAllParallel_Btn()
{
string finalString = "";
if (comboBoxID.Text != "")
{
finalString = "%" + comboBoxID.Text + "%";
}
string query = "Select * from sessions s where s.s_group_id Like @id ";
SqlCommand sqlcomm = new SqlCommand(query, sqlcon);
sqlcomm.Parameters.AddWithValue("@id", finalString);
sqlcon.Open();
SqlDataReader reader = sqlcomm.ExecuteReader(); //DataReader to update parallel all sessions
//List<int> list = (from IDataRecord r in reader
// select (int)r["sort_order"]
// ).ToList();
//foreach (int s in list)
//{
// Console.WriteLine("Data: " + s);
//}
if (reader.HasRows)
{
while (reader.Read())
{
//Console.WriteLine("Is parallel: " + reader.GetString(15) + " IsConsecutive : " + reader.GetString(10));
string isParallel = reader.GetString(15);
string isConsecutive = reader.GetString(10);
int parallel_with = reader.GetInt32(16);
int consecutive = reader.GetInt32(17);
if ((isParallel.Equals("false")) && (!(parallel_with.Equals(-1))))
{
Console.WriteLine("Record ID: " + reader.GetInt32(0) + " Parallel With: " + parallel_with);
ParallelMethods pm = new ParallelMethods();
//Console.WriteLine("Find Session data : "+pm.getSessionData(106));
pm.NewUpdateParallelAll(reader.GetInt32(0), parallel_with, pm.getSessionData(parallel_with), reader.GetString(1));
}
}
//if (reader2.GetString(16) .Equals( false))//select sessions without already set parallel sessions
//{
// if (reader2.GetString(10).Equals(false))// select sessions without already set consecutive sessions
// {
// }
//}//x == false end
}
else
{
reader.Close();
}
sqlcon.Close();
}
private void InsertDatatoSevenDays()
{
string finalString = "";
if (comboBoxID.Text != "")
{
finalString = "%" + comboBoxID.Text + "%";
}
SqlConnection sqlcon2 = new SqlConnection(@"Server=tcp:timetableserver2020.database.windows.net,1433;Initial Catalog=TimetableDB;Persist Security Info=False;User ID=demo;Password=myAzure1;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;");
string query2 = "Select * from sessions s where s.s_group_id Like @id ";
sqlcon2.Open();
SqlCommand sqlcomm2 = new SqlCommand(query2, sqlcon2);
sqlcomm2.Parameters.AddWithValue("@id", finalString);
SqlDataReader reader2 = sqlcomm2.ExecuteReader(); //DataReader for inserting to monday,tuesday tables
int MondayStartTime = 830;
int TuesdayStartTime = 830;
int WednesdayStartTime = 830;
int ThursdayStartTime = 830;
int FridayStartTime = 830;
if (reader2.HasRows)
{
while (reader2.Read())
{
if ((remainingTimeMonday >= reader2.GetInt32(3)))
{ //Monday fill
int s_id = reader2.GetInt32(0);
string s_data = reader2.GetString(1);
int s_duration = reader2.GetInt32(3);
GroupTimetableUpdateCells gtuc = new GroupTimetableUpdateCells();
Console.WriteLine(" Monday start Time: " + MondayStartTime);
//Console.WriteLine("Session data: " + reader2.GetString(1));
//Console.WriteLine("Monday Start time: " + MondayStartTime + " start :" + start + " end: " + end + "\n");
int start = 0;
int end = 0;
if (reader2.GetString(15).Equals("false") && reader2.GetString(10).Equals("false")) //isParallel
{
if (!(reader2.GetInt32(17).Equals(-1))) //Consecutive != -1
{
//Find consecutive session and put
ParallelMethods pm = new ParallelMethods();
string s_data_consecutive = pm.getSessionData(reader2.GetInt32(17));
//Console.WriteLine("s_data_consecutive to be added: " + s_data_consecutive);
int c2 = 1;
while (c2 <= s_duration)//add the same session twice to get better view
{
//Console.WriteLine("s_data : " + reader2.GetString(1)+" Mondaystart:" + MondayStartTime);
MondayStartTime += 100;
gtuc.InsertCellsMonday(s_data, MondayStartTime, "Monday", start, end, s_id);
c2 += 1;
}
int c3 = 1;
while (c3 <= s_duration)//add the same session twice to get better view
{
MondayStartTime += 100;
gtuc.InsertCellsMonday(s_data_consecutive, MondayStartTime, "Monday", start, end, s_id);
c3 += 1;
}
remainingTimeMonday -= (2 * s_duration);//decrement remaining time available to add new sessions
}
else //Consecutive == -1
{
int c1 = 1;
while (c1 <= s_duration)//add the same session twice to get better view
{
start = MondayStartTime;
end = start + 100;
MondayStartTime += 100;
gtuc.InsertCellsMonday(s_data, MondayStartTime, "Monday", start, end, s_id);
c1 += 1;
}
remainingTimeMonday -= s_duration;//decrement remaining time available to add new sessions
}
}
}
else if ((remainingTimeTuesday >= reader2.GetInt32(3)))
{ //Tuesday fill
int s_id = reader2.GetInt32(0);
string s_data = reader2.GetString(1);
int s_duration = reader2.GetInt32(3);
GroupTimetableUpdateCells gtuc = new GroupTimetableUpdateCells();
Console.WriteLine(" Tuesday start Time: " + TuesdayStartTime);
//Console.WriteLine("Session data: " + reader2.GetString(1));
//Console.WriteLine("Monday Start time: " + MondayStartTime + " start :" + start + " end: " + end + "\n");
int start = 0;
int end = 0;
Console.WriteLine("remaining time to be added: " + remainingTimeTuesday);
if (reader2.GetString(15).Equals("false") && reader2.GetString(10).Equals("false")) //isParallel
{
if (!(reader2.GetInt32(17).Equals(-1))) //Consecutive != -1
{
//Find consecutive session and put
ParallelMethods pm = new ParallelMethods();
string s_data_consecutive = pm.getSessionData(reader2.GetInt32(17));
//Console.WriteLine("s_data_consecutive to be added: " + s_data_consecutive);
int c2 = 1;
while (c2 <= s_duration)//add the same session twice to get better view
{
//Console.WriteLine("s_data : " + reader2.GetString(1)+" Mondaystart:" + MondayStartTime);
TuesdayStartTime += 100;
gtuc.InsertCellsTuesday(s_data, TuesdayStartTime, "Tuesday", start, end, s_id);
c2 += 1;
}
int c3 = 1;
while (c3 <= s_duration)//add the same session twice to get better view
{
TuesdayStartTime += 100;
gtuc.InsertCellsTuesday(s_data_consecutive, TuesdayStartTime, "Tuesday", start, end, s_id);
c3 += 1;
}
remainingTimeTuesday -= (2 * s_duration);//decrement remaining time available to add new sessions
}
else //Consecutive == -1
{
int c1 = 1;
while (c1 <= s_duration)//add the same session twice to get better view
{
start = TuesdayStartTime;
end = start + 100;
TuesdayStartTime += 100;
gtuc.InsertCellsTuesday(s_data, TuesdayStartTime, "Tuesday", start, end, s_id);
c1 += 1;
}
remainingTimeTuesday -= s_duration;//decrement remaining time available to add new sessions
}
}
}
else if ((remainingTimeWednesday >= reader2.GetInt32(3)))
{ //Monday fill
int s_id = reader2.GetInt32(0);
string s_data = reader2.GetString(1);
int s_duration = reader2.GetInt32(3);
GroupTimetableUpdateCells gtuc = new GroupTimetableUpdateCells();
Console.WriteLine(" Wednesday start Time: " + WednesdayStartTime);
//Console.WriteLine("Session data: " + reader2.GetString(1));
//Console.WriteLine("Monday Start time: " + MondayStartTime + " start :" + start + " end: " + end + "\n");
int start = 0;
int end = 0;
if (reader2.GetString(15).Equals("false") && reader2.GetString(10).Equals("false")) //isParallel
{
if (!(reader2.GetInt32(17).Equals(-1))) //Consecutive != -1
{
//Find consecutive session and put
ParallelMethods pm = new ParallelMethods();
string s_data_consecutive = pm.getSessionData(reader2.GetInt32(17));
//Console.WriteLine("s_data_consecutive to be added: " + s_data_consecutive);
int c2 = 1;
while (c2 <= s_duration)//add the same session twice to get better view
{
//Console.WriteLine("s_data : " + reader2.GetString(1)+" Mondaystart:" + MondayStartTime);
WednesdayStartTime += 100;
gtuc.InsertCellsWednesday(s_data, WednesdayStartTime, "Wednesday", start, end, s_id);
c2 += 1;
}
int c3 = 1;
while (c3 <= s_duration)//add the same session twice to get better view
{
WednesdayStartTime += 100;
gtuc.InsertCellsWednesday(s_data_consecutive, WednesdayStartTime, "Wednesday", start, end, s_id);
c3 += 1;
}
remainingTimeWednesday -= (2 * s_duration);//decrement remaining time available to add new sessions
}
else //Consecutive == -1
{
int c1 = 1;
while (c1 <= s_duration)//add the same session twice to get better view
{
start = WednesdayStartTime;
end = start + 100;
WednesdayStartTime += 100;
gtuc.InsertCellsWednesday(s_data, WednesdayStartTime, "Wednesday", start, end, s_id);
c1 += 1;
}
remainingTimeWednesday -= s_duration;//decrement remaining time available to add new sessions
}
}
}
else if ((remainingTimeThursday >= reader2.GetInt32(3)))
{ //Monday fill
int s_id = reader2.GetInt32(0);
string s_data = reader2.GetString(1);
int s_duration = reader2.GetInt32(3);
GroupTimetableUpdateCells gtuc = new GroupTimetableUpdateCells();
Console.WriteLine(" Thursday start Time: " + ThursdayStartTime);
//Console.WriteLine("Session data: " + reader2.GetString(1));
//Console.WriteLine("Monday Start time: " + MondayStartTime + " start :" + start + " end: " + end + "\n");
int start = 0;
int end = 0;
if (reader2.GetString(15).Equals("false") && reader2.GetString(10).Equals("false")) //isParallel
{
if (!(reader2.GetInt32(17).Equals(-1))) //Consecutive != -1
{
//Find consecutive session and put
ParallelMethods pm = new ParallelMethods();
string s_data_consecutive = pm.getSessionData(reader2.GetInt32(17));
//Console.WriteLine("s_data_consecutive to be added: " + s_data_consecutive);
int c2 = 1;
while (c2 <= s_duration)//add the same session twice to get better view
{
//Console.WriteLine("s_data : " + reader2.GetString(1)+" Mondaystart:" + MondayStartTime);
ThursdayStartTime += 100;
gtuc.InsertCellsWednesday(s_data, ThursdayStartTime, "Thursday", start, end, s_id);
c2 += 1;
}
int c3 = 1;
while (c3 <= s_duration)//add the same session twice to get better view
{
ThursdayStartTime += 100;
gtuc.InsertCellsThursday(s_data_consecutive, ThursdayStartTime, "Thursday", start, end, s_id);
c3 += 1;
}
remainingTimeThursday -= (2 * s_duration);//decrement remaining time available to add new sessions
}
else //Consecutive == -1
{
int c1 = 1;
while (c1 <= s_duration)//add the same session twice to get better view
{
start = ThursdayStartTime;
end = start + 100;
ThursdayStartTime += 100;
gtuc.InsertCellsThursday(s_data, ThursdayStartTime, "Thursday", start, end, s_id);
c1 += 1;
}
remainingTimeThursday -= s_duration;//decrement remaining time available to add new sessions
}
}
}
else if ((remainingTimeFriday >= reader2.GetInt32(3)))
{ //Monday fill
int s_id = reader2.GetInt32(0);
string s_data = reader2.GetString(1);
int s_duration = reader2.GetInt32(3);
GroupTimetableUpdateCells gtuc = new GroupTimetableUpdateCells();
Console.WriteLine(" Friday start Time: " + FridayStartTime);
//Console.WriteLine("Session data: " + reader2.GetString(1));
//Console.WriteLine("Monday Start time: " + MondayStartTime + " start :" + start + " end: " + end + "\n");
int start = 0;
int end = 0;
if (reader2.GetString(15).Equals("false") && reader2.GetString(10).Equals("false")) //isParallel
{
if (!(reader2.GetInt32(17).Equals(-1))) //Consecutive != -1
{
//Find consecutive session and put
ParallelMethods pm = new ParallelMethods();
string s_data_consecutive = pm.getSessionData(reader2.GetInt32(17));
//Console.WriteLine("s_data_consecutive to be added: " + s_data_consecutive);
int c2 = 1;
while (c2 <= s_duration)//add the same session twice to get better view
{
//Console.WriteLine("s_data : " + reader2.GetString(1)+" Mondaystart:" + MondayStartTime);
FridayStartTime += 100;
gtuc.InsertCellsFriday(s_data, FridayStartTime, "Friday", start, end, s_id);
c2 += 1;
}
int c3 = 1;
while (c3 <= s_duration)//add the same session twice to get better view
{
FridayStartTime += 100;
gtuc.InsertCellsFriday(s_data_consecutive, FridayStartTime, "Friday", start, end, s_id);
c3 += 1;
}
remainingTimeFriday -= (2 * s_duration);//decrement remaining time available to add new sessions
}
else //Consecutive == -1
{
int c1 = 1;
while (c1 <= s_duration)//add the same session twice to get better view
{
start = FridayStartTime;
end = start + 100;
FridayStartTime += 100;
gtuc.InsertCellsFriday(s_data, FridayStartTime, "Friday", start, end, s_id);
c1 += 1;
}
remainingTimeFriday -= s_duration;//decrement remaining time available to add new sessions
}
}
}
//else if (remainingTimeTuesday >= reader2.GetInt32(3))
//{//Tuesday fill
// int s_id = reader2.GetInt32(0);
// string s_data = reader2.GetString(1);
// int s_duration = reader2.GetInt32(3);
// GroupTimetableUpdateCells gtuc = new GroupTimetableUpdateCells();
// int count = 1;
// int start = 0;
// int end = 0;
// while (count <= s_duration)//add the same session twice to get better view
// {
// start = TuesdayStartTime;
// end = start + 100;
// TuesdayStartTime += 100;//increment duration of time slot
// //Console.WriteLine("Tuesday Start time: " + TuesdayStartTime + " start :" + start + " end: " + end);
// //haha
// if (reader2.GetString(15).Equals("false")) //isParallel {
// {
// if (reader2.GetString(10).Equals("false"))//isConsecutive
// {
// //Add session to table
// gtuc.InsertCellsTuesday(s_data, TuesdayStartTime, "Tuesday", start, end, s_id);
// }
// else
// {
// //Find consecutive session and put
// ParallelMethods pm = new ParallelMethods();
// string s_data_consecutive = pm.getSessionData(reader2.GetInt32(17));
// gtuc.InsertCellsTuesday(s_data_consecutive, TuesdayStartTime, "Tuesday", start, end, s_id);
// }
// }
// //haha
// count += 1;
// }
// remainingTimeTuesday -= s_duration; //decrement remaining time available to add new sessions
//}
//else if (remainingTimeWednesday >= reader2.GetInt32(3))
//{//wednesday fill
// int s_id = reader2.GetInt32(0);
// string s_data = reader2.GetString(1);
// int s_duration = reader2.GetInt32(3);
// GroupTimetableUpdateCells gtuc = new GroupTimetableUpdateCells();
// int count = 1;
// while (count <= s_duration)//add the same session twice to get better view
// {
// WednesdayStartTime += 100;//increment duration of time slot
// gtuc.InsertCellsWednesday(s_data, WednesdayStartTime);
// count += 1;
// }
// remainingTimeWednesday -= s_duration; //decrement remaining time available to add new sessions
//}
//else if (remainingTimeThursday >= reader2.GetInt32(3))
//{//Thursday fill
// int s_id = reader2.GetInt32(0);
// string s_data = reader2.GetString(1);
// int s_duration = reader2.GetInt32(3);
// GroupTimetableUpdateCells gtuc = new GroupTimetableUpdateCells();
// int count = 1;
// while (count <= s_duration)//add the same session twice to get better view
// {
// ThursdayStartTime += 100;//increment duration of time slot
// gtuc.InsertCellsThursday(s_data, ThursdayStartTime);
// count += 1;
// }
// remainingTimeThursday -= s_duration; //decrement remaining time available to add new sessions
//}
//else if (remainingTimeFriday >= reader2.GetInt32(3))
//{//Friday fill
// int s_id = reader2.GetInt32(0);
// string s_data = reader2.GetString(1);
// int s_duration = reader2.GetInt32(3);
// GroupTimetableUpdateCells gtuc = new GroupTimetableUpdateCells();
// int count = 1;
// while (count <= s_duration)//add the same session twice to get better view
// {
// FridayStartTime += 100;//increment duration of time slot
// gtuc.InsertCellsFriday(s_data, FridayStartTime);
// count += 1;
// }
// remainingTimeFriday -= s_duration; //decrement remaining time available to add new sessions
//}
else
{
MessageBox.Show("Can't map following Data all Days full : \n" +
"Remaining TimeMonday :" + remainingTimeMonday + "hours\n" +
"Remaining TimeTuesday :" + remainingTimeTuesday + "hours\n" +
"Remaining TimeWednesday :" + remainingTimeWednesday + "hours\n" +
"Remaining TimeThursday :" + remainingTimeThursday + "hours\n" +
"Remaining TimeFriday :" + remainingTimeFriday + "hours\n" +
"" + reader2.GetInt32(0) + " " + reader2.GetString(1) + " " + reader2.GetInt32(2) + " " + reader2.GetInt32(3) + " \n");
break;
}
}
}
else
{
reader2.Close();
}
sqlcon2.Close();
displayFullTimetable();
remainingTimeMonday = 7; //reset time durations
remainingTimeTuesday = 7; //reset time durations
remainingTimeWednesday = 5;
remainingTimeThursday = 5;
remainingTimeFriday = 5;
}