private void button2_Click(object sender, EventArgs e)
{
// ------------------ IT WILL SHOW YOU YOUR GENERATED TIMETABLE --------------------
// Previous page hides when new/next page is requested
this.Hide();
generator ss1 = new generator();
ss1.Show();
}
private void button2_Click(object sender, EventArgs e)
{
// ------------------ CLICKING THIS BUTTON WILL LET YOU LEAVE THE PAGE --------------------
// Creating a connection with database
SqlConnection con = new SqlConnection("Data Source=DESKTOP-6FG9FQD;Initial Catalog=AutoTimeTable;Integrated Security=True");
// Opening the connection
con.Open();
// ------------------------------- 1 -----------------------------
// This query will store subject1 data in SUBJECT1 table in database
string query1 = "INSERT INTO SUBJECT1(SUBJ1, CHRS1, SUBTYPE1, S_ID1)" +
"VALUES(@sub, @chrs, @type, @usid)";
SqlCommand cmd1 = new SqlCommand(query1, con);
cmd1.Parameters.AddWithValue("@sub", sub1.Text);
cmd1.Parameters.AddWithValue("@chrs", crd1.Text);
cmd1.Parameters.AddWithValue("@type", th1.Text);
cmd1.Parameters.AddWithValue("@usid", userID.Text);
cmd1.ExecuteNonQuery();
// --------------------- Lecture slots generation for input subjects ------------------------
// Inserting the lecture in database table of TIMETABLE in sequence of after applying conditions
string s1 = "INSERT INTO TIMETABLE(T_ID, LEC1, LEC2, LEC3, LEC4, TBREAK, LEC5, LEC6, LEC7) VALUES(@t_id, @l1, @l2, @l3, @l4, @tbreak, @l5, @l6, @l7)";
SqlCommand ls1 = new SqlCommand(s1, con);
// Creating variables for break and free slots
string var = "BREAK";
string nill = "-";
// If it is lab entered in subject 1 textbox, then it is adjusted such that 3 slots are
// assigned to it of 3 hours
if (th1.Text == "Lab" || th1.Text == "lab" || th1.Text == "l")
{
ls1.Parameters.AddWithValue("@t_id", userID.Text);
ls1.Parameters.AddWithValue("@l1", sub1.Text);
ls1.Parameters.AddWithValue("@l2", sub1.Text);
ls1.Parameters.AddWithValue("@l3", sub1.Text);
}
else if (th1.Text == "Theory" || th1.Text == "theory" || th1.Text == "th")
{
// If it is theory entered in subject 1 textbox, then it is adjusted according to its contact
// hours mentioned
if (crd1.Text == "1")
{
// If the contact hour of subject is 1, then it is assigned the first lecture slot on first
// day of the week
ls1.Parameters.AddWithValue("@t_id", userID.Text);
ls1.Parameters.AddWithValue("@l1", sub1.Text);
ls1.Parameters.AddWithValue("@l2", nill);
ls1.Parameters.AddWithValue("@l3", nill);
}
else if (crd1.Text == "2")
{
// If the contact hour of subject is 2, then it is assigned the two consective lecture slots
// on first day of the week
ls1.Parameters.AddWithValue("@t_id", userID.Text);
ls1.Parameters.AddWithValue("@l1", sub1.Text);
ls1.Parameters.AddWithValue("@l2", sub1.Text);
ls1.Parameters.AddWithValue("@l3", nill);
}
else if (crd1.Text == "3")
{
// If the contact hour of subject is 3, then it is assigned the three consective lecture
// slots on first day of the week
ls1.Parameters.AddWithValue("@t_id", userID.Text);
ls1.Parameters.AddWithValue("@l1", sub1.Text);
ls1.Parameters.AddWithValue("@l2", sub1.Text);
ls1.Parameters.AddWithValue("@l3", sub1.Text);
}
}
else
{
// Incase no data is entered, the slots are left nill
ls1.Parameters.AddWithValue("@t_id", userID.Text);
ls1.Parameters.AddWithValue("@l1", nill);
ls1.Parameters.AddWithValue("@l2", nill);
ls1.Parameters.AddWithValue("@l3", nill);
}
//------------------------------------ 2 ------------------------------
// This query will store subject2 data in SUBJECT2 table in database
string query2 = "INSERT INTO SUBJECT2(SUBJ2, CHRS2, SUBTYPE2, S_ID2)" +
"VALUES(@sub, @crdhrs, @type, @usid)";
SqlCommand cmd2 = new SqlCommand(query2, con);
cmd2.Parameters.AddWithValue("@sub", sub2.Text);
cmd2.Parameters.AddWithValue("@crdhrs", crd2.Text);
cmd2.Parameters.AddWithValue("@type", th2.Text);
cmd2.Parameters.AddWithValue("@usid", userID.Text);
cmd2.ExecuteNonQuery();
// If it is lab entered in subject 2 textbox, then it is adjusted such that 3 slots are
// assigned to it of 3 hours
if (th2.Text == "Lab" || th2.Text == "lab" || th2.Text == "l")
{
ls1.Parameters.AddWithValue("@l4", nill);
ls1.Parameters.AddWithValue("@tbreak", var);
ls1.Parameters.AddWithValue("@l5", sub2.Text);
ls1.Parameters.AddWithValue("@l6", sub2.Text);
ls1.Parameters.AddWithValue("@l7", sub2.Text);
}
else if ((th2.Text == "Theory" || th2.Text == "theory" || th2.Text == "th") && (th1.Text == "Theory" || th1.Text == "theory" || th1.Text == "th") && (crd1.Text == "1" || crd1.Text == "2" || crd1.Text == "3"))
{
// If it is theory entered in subject 2 textbox, then it is adjusted according to its contact
// hours mentioned
if (crd2.Text == "1")
{
// If the contact hour of subject is 1, then it is assigned the 4th lecture slot on first day
// of the week
ls1.Parameters.AddWithValue("@l4", sub2.Text);
ls1.Parameters.AddWithValue("@tbreak", var);
ls1.Parameters.AddWithValue("@l5", nill);
ls1.Parameters.AddWithValue("@l6", nill);
ls1.Parameters.AddWithValue("@l7", nill);
}
else if (crd2.Text == "2")
{
// If the contact hour of subject is 2, then it is assigned the two consective lecture slots;
// 4th and 5th slot on first day of the week
ls1.Parameters.AddWithValue("@l4", sub2.Text);
ls1.Parameters.AddWithValue("@tbreak", var);
ls1.Parameters.AddWithValue("@l5", sub2.Text);
ls1.Parameters.AddWithValue("@l6", nill);
ls1.Parameters.AddWithValue("@l7", nill);
}
else if (crd2.Text == "3")
{
// If the contact hour of subject is 3, then it is assigned the three consective lecture slots;
// 4th, 5th and 6th slot on first day of the week
ls1.Parameters.AddWithValue("@l4", sub2.Text);
ls1.Parameters.AddWithValue("@tbreak", var);
ls1.Parameters.AddWithValue("@l5", sub2.Text);
ls1.Parameters.AddWithValue("@l6", sub2.Text);
ls1.Parameters.AddWithValue("@l7", nill);
}
}
else if ((th2.Text == "Theory" || th2.Text == "theory" || th2.Text == "th") && (th1.Text == "Lab" || th1.Text == "lab" || th1.Text == "l"))
{
// If subject 1 is a lab and subject 2 is theory then lectures are arranges in following manner
if (crd2.Text == "1")
{
// If the contact hour of subject is 1, then it is assigned one lecture slot;
// 4th slot on first day of the week
ls1.Parameters.AddWithValue("@l4", sub2.Text);
ls1.Parameters.AddWithValue("@tbreak", var);
ls1.Parameters.AddWithValue("@l5", nill);
ls1.Parameters.AddWithValue("@l6", nill);
ls1.Parameters.AddWithValue("@l7", nill);
}
else if (crd2.Text == "2")
{
// If the contact hour of subject is 2, then it is assigned the two consective lecture slots;
// 4th and 5th slot on first day of the week
ls1.Parameters.AddWithValue("@l4", sub2.Text);
ls1.Parameters.AddWithValue("@tbreak", var);
ls1.Parameters.AddWithValue("@l5", sub2.Text);
ls1.Parameters.AddWithValue("@l6", nill);
ls1.Parameters.AddWithValue("@l7", nill);
}
else if (crd2.Text == "3")
{
// If the contact hour of subject is 3, then it is assigned the three consective lecture slots;
// 4th, 5th and 6th slot on first day of the week
ls1.Parameters.AddWithValue("@l4", sub2.Text);
ls1.Parameters.AddWithValue("@tbreak", var);
ls1.Parameters.AddWithValue("@l5", sub2.Text);
ls1.Parameters.AddWithValue("@l6", sub2.Text);
ls1.Parameters.AddWithValue("@l7", nill);
}
}
else
{
// Incase no data is entered, the slots are left nill
ls1.Parameters.AddWithValue("@l4", nill);
ls1.Parameters.AddWithValue("@tbreak", var);
ls1.Parameters.AddWithValue("@l5", nill);
ls1.Parameters.AddWithValue("@l6", nill);
ls1.Parameters.AddWithValue("@l7", nill);
}
ls1.ExecuteNonQuery();
//------------------------------------ 3 ------------------------------
// This query will store subject3 data in SUBJECT3 table in database
string query3 = "INSERT INTO SUBJECT3(SUBJ3, CHRS3, SUBTYPE3, S_ID3)" +
"VALUES(@sub, @crdhrs, @type, @usid)";
SqlCommand cmd3 = new SqlCommand(query3, con);
cmd3.Parameters.AddWithValue("@sub", sub3.Text);
cmd3.Parameters.AddWithValue("@crdhrs", crd3.Text);
cmd3.Parameters.AddWithValue("@type", th3.Text);
cmd3.Parameters.AddWithValue("@usid", userID.Text);
cmd3.ExecuteNonQuery();
// Inserting the lecture in database table of TIMETABLE in sequence of after applying conditions
string s2 = "INSERT INTO TIMETABLE(T_ID, LEC1, LEC2, LEC3, LEC4, TBREAK, LEC5, LEC6, LEC7) VALUES(@t_id_2, @l1_2, @l2_2, @l3_2, @l4_2, @tbreak_2, @l5_2, @l6_2, @l7_2)";
SqlCommand ls2 = new SqlCommand(s2, con);
// If it is lab entered in subject 3 textbox, then it is adjusted such that 3 slots are
// assigned to it of 3 hours
if (th3.Text == "Lab" || th3.Text == "lab" || th3.Text == "l")
{
ls2.Parameters.AddWithValue("@t_id_2", userID.Text);
ls2.Parameters.AddWithValue("@l1_2", sub3.Text);
ls2.Parameters.AddWithValue("@l2_2", sub3.Text);
ls2.Parameters.AddWithValue("@l3_2", sub3.Text);
}
else if (th3.Text == "Theory" || th3.Text == "theory" || th3.Text == "th")
{
// If it is theory entered in subject 3 textbox, then it is adjusted according to its contact
// hours mentioned
if (crd3.Text == "1")
{
// If the contact hour of subject is 1, then it is assigned one lecture slot;
// first slot on second day of the week
ls2.Parameters.AddWithValue("@t_id_2", userID.Text);
ls2.Parameters.AddWithValue("@l1_2", sub3.Text);
ls2.Parameters.AddWithValue("@l2_2", nill);
ls2.Parameters.AddWithValue("@l3_2", nill);
}
else if (crd3.Text == "2")
{
// If the contact hour of subject is 2, then it is assigned the two consective lecture slots;
// first two slot on second day of the week
ls2.Parameters.AddWithValue("@t_id_2", userID.Text);
ls2.Parameters.AddWithValue("@l1_2", sub3.Text);
ls2.Parameters.AddWithValue("@l2_2", sub3.Text);
ls2.Parameters.AddWithValue("@l3_2", nill);
}
else if (crd3.Text == "3")
{
// If the contact hour of subject is 3, then it is assigned the three consective lecture slots;
// first three slot on second day of the week
ls2.Parameters.AddWithValue("@t_id_2", userID.Text);
ls2.Parameters.AddWithValue("@l1_2", sub3.Text);
ls2.Parameters.AddWithValue("@l2_2", sub3.Text);
ls2.Parameters.AddWithValue("@l3_2", sub3.Text);
}
}
else
{
// Incase no data is entered, the slots are left nill
ls2.Parameters.AddWithValue("@t_id_2", userID.Text);
ls2.Parameters.AddWithValue("@l1_2", nill);
ls2.Parameters.AddWithValue("@l2_2", nill);
ls2.Parameters.AddWithValue("@l3_2", nill);
}
//------------------------------------ 4 ------------------------------
// This query will store subject4 data in SUBJECT4 table in database
string query4 = "INSERT INTO SUBJECT4(SUBJ4, CHRS4, SUBTYPE4, S_ID4)" +
"VALUES(@sub, @crdhrs, @type, @usid)";
SqlCommand cmd4 = new SqlCommand(query4, con);
cmd4.Parameters.AddWithValue("@sub", sub4.Text);
cmd4.Parameters.AddWithValue("@crdhrs", crd4.Text);
cmd4.Parameters.AddWithValue("@type", th4.Text);
cmd4.Parameters.AddWithValue("@usid", userID.Text);
cmd4.ExecuteNonQuery();
// If it is lab entered in subject 4 textbox, then it is adjusted such that 3 slots are
// assigned to it of 3 hours
if (th4.Text == "Lab" || th4.Text == "lab" || th4.Text == "l")
{
ls2.Parameters.AddWithValue("@l4_2", nill);
ls2.Parameters.AddWithValue("@tbreak_2", var);
ls2.Parameters.AddWithValue("@l5_2", sub2.Text);
ls2.Parameters.AddWithValue("@l6_2", sub2.Text);
ls2.Parameters.AddWithValue("@l7_2", sub2.Text);
}
else if ((th4.Text == "Theory" || th4.Text == "theory" || th4.Text == "th") && (th3.Text == "Theory" || th3.Text == "theory" || th3.Text == "th") && (crd3.Text == "1" || crd3.Text == "2" || crd3.Text == "3"))
{
// If it is theory entered in subject 3 and 4 textbox, then it is adjusted according to its
// contact hours mentioned
if (crd4.Text == "1")
{
// If the contact hour of subject is , then it is assigned one lecture slot;
// 4th slot on second day of the week
ls2.Parameters.AddWithValue("@l4_2", sub4.Text);
ls2.Parameters.AddWithValue("@tbreak_2", var);
ls2.Parameters.AddWithValue("@l5_2", nill);
ls2.Parameters.AddWithValue("@l6_2", nill);
ls2.Parameters.AddWithValue("@l7_2", nill);
}
else if (crd4.Text == "2")
{
// If the contact hour of subject is 2, then it is assigned the two consective lecture slots;
// 4th and 5th slots on second day of the week
ls2.Parameters.AddWithValue("@l4_2", sub4.Text);
ls2.Parameters.AddWithValue("@tbreak_2", var);
ls2.Parameters.AddWithValue("@l5_2", sub4.Text);
ls2.Parameters.AddWithValue("@l6_2", nill);
ls2.Parameters.AddWithValue("@l7_2", nill);
}
else if (crd4.Text == "3")
{
// If the contact hour of subject is 3, then it is assigned the three consective lecture slots;
// 4th, 5th and 6th slots on second day of the week
ls2.Parameters.AddWithValue("@l4_2", sub4.Text);
ls2.Parameters.AddWithValue("@tbreak_2", var);
ls2.Parameters.AddWithValue("@l5_2", sub4.Text);
ls2.Parameters.AddWithValue("@l6_2", sub4.Text);
ls2.Parameters.AddWithValue("@l7_2", nill);
}
}
else if ((th4.Text == "Theory" || th4.Text == "theory" || th4.Text == "th") && (th3.Text == "Lab" || th3.Text == "lab" || th3.Text == "l"))
{
// If subject 3 is a lab and subject 4 is theory then lectures are arranges in following manner
if (crd4.Text == "1")
{
// If the contact hour of subject is , then it is assigned one lecture slot;
// 4th slot on second day of the week
ls2.Parameters.AddWithValue("@l4_2", sub4.Text);
ls2.Parameters.AddWithValue("@tbreak_2", var);
ls2.Parameters.AddWithValue("@l5_2", nill);
ls2.Parameters.AddWithValue("@l6_2", nill);
ls2.Parameters.AddWithValue("@l7_2", nill);
}
else if (crd4.Text == "2")
{
// If the contact hour of subject is 2, then it is assigned the two consective lecture slots;
// 4th and 5th slots on second day of the week
ls2.Parameters.AddWithValue("@l4_2", sub4.Text);
ls2.Parameters.AddWithValue("@tbreak_2", var);
ls2.Parameters.AddWithValue("@l5_2", sub4.Text);
ls2.Parameters.AddWithValue("@l6_2", nill);
ls2.Parameters.AddWithValue("@l7_2", nill);
}
else if (crd4.Text == "3")
{
// If the contact hour of subject is 3, then it is assigned the three consective lecture slots;
// 4th, 5th and 6th slots on second day of the week
ls2.Parameters.AddWithValue("@l4_2", sub4.Text);
ls2.Parameters.AddWithValue("@tbreak_2", var);
ls2.Parameters.AddWithValue("@l5_2", sub4.Text);
ls2.Parameters.AddWithValue("@l6_2", sub4.Text);
ls2.Parameters.AddWithValue("@l7_2", nill);
}
}
else
{
// Incase no data is entered, the slots are left nill
ls2.Parameters.AddWithValue("@l4_2", nill);
ls2.Parameters.AddWithValue("@tbreak_2", var);
ls2.Parameters.AddWithValue("@l5_2", nill);
ls2.Parameters.AddWithValue("@l6_2", nill);
ls2.Parameters.AddWithValue("@l7_2", nill);
}
ls2.ExecuteNonQuery();
//------------------------------------ 5 ------------------------------
// This query will store subject5 data in SUBJECT5 table in database
string query5 = "INSERT INTO SUBJECT5(SUBJ5, CHRS5, SUBTYPE5, S_ID5)" +
"VALUES(@sub, @crdhrs, @type, @usid)";
SqlCommand cmd5 = new SqlCommand(query5, con);
cmd5.Parameters.AddWithValue("@sub", sub5.Text);
cmd5.Parameters.AddWithValue("@crdhrs", crd5.Text);
cmd5.Parameters.AddWithValue("@type", th5.Text);
cmd5.Parameters.AddWithValue("@usid", userID.Text);
cmd5.ExecuteNonQuery();
// Inserting the lecture in database table of TIMETABLE in sequence of after applying conditions
string s3 = "INSERT INTO TIMETABLE(T_ID, LEC1, LEC2, LEC3, LEC4, TBREAK, LEC5, LEC6, LEC7) VALUES(@t_id_3, @l1_3, @l2_3, @l3_3, @l4_3, @tbreak_3, @l5_3, @l6_3, @l7_3)";
SqlCommand ls3 = new SqlCommand(s3, con);
// If it is lab entered in subject 5 textbox, then it is adjusted such that 3 slots are
// assigned to it of 3 hours
if (th5.Text == "Lab" || th5.Text == "lab" || th5.Text == "l")
{
ls3.Parameters.AddWithValue("@t_id_3", userID.Text);
ls3.Parameters.AddWithValue("@l1_3", sub5.Text);
ls3.Parameters.AddWithValue("@l2_3", sub5.Text);
ls3.Parameters.AddWithValue("@l3_3", sub5.Text);
}
else if (th5.Text == "Theory" || th5.Text == "theory" || th5.Text == "th")
{
// If it is theory entered in subject 5 textbox, then it is adjusted according to its contact
// hours mentioned
if (crd5.Text == "1")
{
// If the contact hour of subject is 1, then it is assigned one lecture slot;
// first lecture slot on third day of the week
ls3.Parameters.AddWithValue("@t_id_3", userID.Text);
ls3.Parameters.AddWithValue("@l1_3", sub5.Text);
ls3.Parameters.AddWithValue("@l2_3", nill);
ls3.Parameters.AddWithValue("@l3_3", nill);
}
else if (crd5.Text == "2")
{
// If the contact hour of subject is 2, then it is assigned the two consective lecture slots;
// first two lecture slots on third day of the week
ls3.Parameters.AddWithValue("@t_id_3", userID.Text);
ls3.Parameters.AddWithValue("@l1_3", sub5.Text);
ls3.Parameters.AddWithValue("@l2_3", sub5.Text);
ls3.Parameters.AddWithValue("@l3_3", nill);
}
else if (crd5.Text == "3")
{
// If the contact hour of subject is 3, then it is assigned the two consective lecture slots;
// first three lecture slots on third day of the week
ls3.Parameters.AddWithValue("@t_id_3", userID.Text);
ls3.Parameters.AddWithValue("@l1_3", sub5.Text);
ls3.Parameters.AddWithValue("@l2_3", sub5.Text);
ls3.Parameters.AddWithValue("@l3_3", sub5.Text);
}
}
else
{
// Incase no data is entered, the slots are left nill
ls3.Parameters.AddWithValue("@t_id_3", userID.Text);
ls3.Parameters.AddWithValue("@l1_3", nill);
ls3.Parameters.AddWithValue("@l2_3", nill);
ls3.Parameters.AddWithValue("@l3_3", nill);
}
//------------------------------------ 6 ------------------------------
// This query will store subject6 data in SUBJECT6 table in database
string query6 = "INSERT INTO SUBJECT6(SUBJ6, CHRS6, SUBTYPE6, S_ID6)" +
"VALUES(@sub, @crdhrs, @type, @usid)";
SqlCommand cmd6 = new SqlCommand(query6, con);
cmd6.Parameters.AddWithValue("@sub", sub6.Text);
cmd6.Parameters.AddWithValue("@crdhrs", crd6.Text);
cmd6.Parameters.AddWithValue("@type", th6.Text);
cmd6.Parameters.AddWithValue("@usid", userID.Text);
cmd6.ExecuteNonQuery();
// If it is lab entered in subject 6 textbox, then it is adjusted such that 3 slots are
// assigned to it of 3 hours
if (th6.Text == "Lab" || th6.Text == "lab" || th6.Text == "l")
{
ls3.Parameters.AddWithValue("@l4_3", nill);
ls3.Parameters.AddWithValue("@tbreak_3", var);
ls3.Parameters.AddWithValue("@l5_3", sub6.Text);
ls3.Parameters.AddWithValue("@l6_3", sub6.Text);
ls3.Parameters.AddWithValue("@l7_3", sub6.Text);
}
else if ((th6.Text == "Theory" || th6.Text == "theory" || th6.Text == "th") && (th5.Text == "Theory" || th5.Text == "theory" || th5.Text == "th") && (crd5.Text == "1" || crd5.Text == "2" || crd5.Text == "3"))
{
// If it is theory entered in subject 6 textbox, then it is adjusted according to its contact
// hours mentioned
if (crd6.Text == "1")
{
// If the contact hour of subject is 1, then it is assigned one lecture slot;
// 4th lecture slot on third day of the week
ls3.Parameters.AddWithValue("@l4_3", sub6.Text);
ls3.Parameters.AddWithValue("@tbreak_3", var);
ls3.Parameters.AddWithValue("@l5_3", nill);
ls3.Parameters.AddWithValue("@l6_3", nill);
ls3.Parameters.AddWithValue("@l7_3", nill);
}
else if (crd6.Text == "2")
{
// If the contact hour of subject is 2, then it is assigned the two consective lecture slots;
// 4th and 5th lecture slot on third day of the week
ls3.Parameters.AddWithValue("@l4_3", sub6.Text);
ls3.Parameters.AddWithValue("@tbreak_3", var);
ls3.Parameters.AddWithValue("@l5_3", sub6.Text);
ls3.Parameters.AddWithValue("@l6_3", nill);
ls3.Parameters.AddWithValue("@l7_3", nill);
}
else if (crd6.Text == "3")
{
// If the contact hour of subject is 3, then it is assigned the three consective lecture slots;
// 4th, 5th and 6th lecture slot on third day of the week
ls3.Parameters.AddWithValue("@l4_3", sub6.Text);
ls3.Parameters.AddWithValue("@tbreak_3", var);
ls3.Parameters.AddWithValue("@l5_3", sub6.Text);
ls3.Parameters.AddWithValue("@l6_3", sub6.Text);
ls3.Parameters.AddWithValue("@l7_3", nill);
}
}
else if ((th6.Text == "Theory" || th6.Text == "theory" || th6.Text == "th") && (th5.Text == "Lab" || th5.Text == "lab" || th5.Text == "l"))
{
// If subject 5 is a lab and subject 6 is theory then lectures are arranges in following manner
if (crd6.Text == "1")
{
// If the contact hour of subject is 1, then it is assigned one lecture slot;
// 4th lecture slot on third day of the week
ls3.Parameters.AddWithValue("@l4_2", sub6.Text);
ls3.Parameters.AddWithValue("@tbreak_2", var);
ls3.Parameters.AddWithValue("@l5_2", nill);
ls3.Parameters.AddWithValue("@l6_2", nill);
ls3.Parameters.AddWithValue("@l7_2", nill);
}
else if (crd6.Text == "2")
{
// If the contact hour of subject is 2, then it is assigned the two consective lecture slots;
// 4th and 5th lecture slot on third day of the week
ls3.Parameters.AddWithValue("@l4_3", sub6.Text);
ls3.Parameters.AddWithValue("@tbreak_3", var);
ls3.Parameters.AddWithValue("@l5_3", sub6.Text);
ls3.Parameters.AddWithValue("@l6_3", nill);
ls3.Parameters.AddWithValue("@l7_3", nill);
}
else if (crd6.Text == "3")
{
// If the contact hour of subject is 3, then it is assigned the three consective lecture slots;
// 4th, 5th and 6th lecture slot on third day of the week
ls3.Parameters.AddWithValue("@l4_3", sub6.Text);
ls3.Parameters.AddWithValue("@tbreak_3", var);
ls3.Parameters.AddWithValue("@l5_3", sub6.Text);
ls3.Parameters.AddWithValue("@l6_3", sub6.Text);
ls3.Parameters.AddWithValue("@l7_3", nill);
}
}
else
{
// Incase no data is entered, the slots are left nill
ls3.Parameters.AddWithValue("@l4_3", nill);
ls3.Parameters.AddWithValue("@tbreak_3", var);
ls3.Parameters.AddWithValue("@l5_3", nill);
ls3.Parameters.AddWithValue("@l6_3", nill);
ls3.Parameters.AddWithValue("@l7_3", nill);
}
ls3.ExecuteNonQuery();
//------------------------------------ 7 ------------------------------
// This query will store subject7 data in SUBJECT7 table in database
string query7 = "INSERT INTO SUBJECT7(SUBJ7, CHRS7, SUBTYPE7, S_ID7)" +
"VALUES(@sub, @crdhrs, @type, @usid)";
SqlCommand cmd7 = new SqlCommand(query7, con);
cmd7.Parameters.AddWithValue("@sub", sub7.Text);
cmd7.Parameters.AddWithValue("@crdhrs", crd7.Text);
cmd7.Parameters.AddWithValue("@type", th7.Text);
cmd7.Parameters.AddWithValue("@usid", userID.Text);
cmd7.ExecuteNonQuery();
// Inserting the lecture in database table of TIMETABLE in sequence of after applying conditions
string s4 = "INSERT INTO TIMETABLE(T_ID, LEC1, LEC2, LEC3, LEC4, TBREAK, LEC5, LEC6, LEC7) VALUES(@t_id_4, @l1_4, @l2_4, @l3_4, @l4_4, @tbreak_4, @l5_4, @l6_4, @l7_4)";
SqlCommand ls4 = new SqlCommand(s4, con);
// If it is lab entered in subject 7 textbox, then it is adjusted such that 3 slots are
// assigned to it of 3 hours
if (th7.Text == "Lab" || th7.Text == "lab" || th7.Text == "l")
{
ls4.Parameters.AddWithValue("@t_id_4", userID.Text);
ls4.Parameters.AddWithValue("@l1_4", sub7.Text);
ls4.Parameters.AddWithValue("@l2_4", sub7.Text);
ls4.Parameters.AddWithValue("@l3_4", sub7.Text);
}
else if (th7.Text == "Theory" || th7.Text == "theory" || th7.Text == "th")
{
// If it is theory entered in subject 7 textbox, then it is adjusted according to its contact
// hours mentioned
if (crd7.Text == "1")
{
// If the contact hour of subject is 1, then it is assigned one lecture slot;
// first lecture slot on fourth day of the week
ls4.Parameters.AddWithValue("@t_id_4", userID.Text);
ls4.Parameters.AddWithValue("@l1_4", sub7.Text);
ls4.Parameters.AddWithValue("@l2_4", nill);
ls4.Parameters.AddWithValue("@l3_4", nill);
}
else if (crd7.Text == "2")
{
// If the contact hour of subject is 2, then it is assigned the two consective lecture slots;
// first two lecture slot on fourth day of the week
ls4.Parameters.AddWithValue("@t_id_4", userID.Text);
ls4.Parameters.AddWithValue("@l1_4", sub7.Text);
ls4.Parameters.AddWithValue("@l2_4", sub7.Text);
ls4.Parameters.AddWithValue("@l3_4", nill);
}
else if (crd7.Text == "3")
{
// If the contact hour of subject is 3, then it is assigned the three consective lecture slots;
// first three lecture slot on fourth day of the week
ls4.Parameters.AddWithValue("@t_id_4", userID.Text);
ls4.Parameters.AddWithValue("@l1_4", sub7.Text);
ls4.Parameters.AddWithValue("@l2_4", sub7.Text);
ls4.Parameters.AddWithValue("@l3_4", sub7.Text);
}
}
else
{
// Incase no data is entered, the slots are left nill
ls4.Parameters.AddWithValue("@t_id_4", userID.Text);
ls4.Parameters.AddWithValue("@l1_4", nill);
ls4.Parameters.AddWithValue("@l2_4", nill);
ls4.Parameters.AddWithValue("@l3_4", nill);
}
//------------------------------------ 8 -----------------------------
// This query will store subject8 data in SUBJECT8 table in database
string query8 = "INSERT INTO SUBJECT8(SUBJ8, CHRS8, SUBTYPE8, S_ID8)" +
"VALUES(@sub, @crdhrs, @type, @usid)";
SqlCommand cmd8 = new SqlCommand(query8, con);
cmd8.Parameters.AddWithValue("@sub", sub8.Text);
cmd8.Parameters.AddWithValue("@crdhrs", crd8.Text);
cmd8.Parameters.AddWithValue("@type", th8.Text);
cmd8.Parameters.AddWithValue("@usid", userID.Text);
cmd8.ExecuteNonQuery();
// If it is lab entered in subject 8 textbox, then it is adjusted such that 3 slots are
// assigned to it of 3 hours
if (th8.Text == "Lab" || th8.Text == "lab" || th8.Text == "l")
{
ls4.Parameters.AddWithValue("@l4_4", nill);
ls4.Parameters.AddWithValue("@tbreak_4", var);
ls4.Parameters.AddWithValue("@l5_4", sub8.Text);
ls4.Parameters.AddWithValue("@l6_4", sub8.Text);
ls4.Parameters.AddWithValue("@l7_4", sub8.Text);
}
else if ((th8.Text == "Theory" || th8.Text == "theory" || th8.Text == "th") && (th7.Text == "Theory" || th7.Text == "theory" || th7.Text == "th") && (crd7.Text == "1" || crd7.Text == "2" || crd7.Text == "3"))
{
// If it is theory entered in subject 8 textbox, then it is adjusted according to its contact
// hours mentioned
if (crd8.Text == "1")
{
// If the contact hour of subject is 1, then it is assigned one lecture slot;
// 4th lecture slot on fourth day of the week
ls4.Parameters.AddWithValue("@l4_4", sub8.Text);
ls4.Parameters.AddWithValue("@tbreak_4", var);
ls4.Parameters.AddWithValue("@l5_4", nill);
ls4.Parameters.AddWithValue("@l6_4", nill);
ls4.Parameters.AddWithValue("@l7_4", nill);
}
else if (crd8.Text == "2")
{
// If the contact hour of subject is 2, then it is assigned two consective lecture slots;
// 4th and 5th lecture slots on fourth day of the week
ls4.Parameters.AddWithValue("@l4_4", sub8.Text);
ls4.Parameters.AddWithValue("@tbreak_4", var);
ls4.Parameters.AddWithValue("@l5_4", sub8.Text);
ls4.Parameters.AddWithValue("@l6_4", nill);
ls4.Parameters.AddWithValue("@l7_4", nill);
}
else if (crd8.Text == "3")
{
// If the contact hour of subject is 3, then it is assigned three consective lecture slots;
// 4th, 5th and 6th lecture slots on fourth day of the week
ls4.Parameters.AddWithValue("@l4_4", sub8.Text);
ls4.Parameters.AddWithValue("@tbreak_4", var);
ls4.Parameters.AddWithValue("@l5_4", sub8.Text);
ls4.Parameters.AddWithValue("@l6_4", sub8.Text);
ls4.Parameters.AddWithValue("@l7_4", nill);
}
}
else if ((th8.Text == "Theory" || th8.Text == "theory" || th8.Text == "th") && (th7.Text == "Lab" || th7.Text == "lab" || th7.Text == "l"))
{
// If subject 7 is a lab and subject 8 is theory then lectures are arranges in following manner
if (crd8.Text == "1")
{
// If the contact hour of subject is 1, then it is assigned one lecture slot;
// 4th lecture slots on fourth day of the week
ls4.Parameters.AddWithValue("@l4_4", sub8.Text);
ls4.Parameters.AddWithValue("@tbreak_4", var);
ls4.Parameters.AddWithValue("@l5_4", nill);
ls4.Parameters.AddWithValue("@l6_4", nill);
ls4.Parameters.AddWithValue("@l7_4", nill);
}
else if (crd8.Text == "2")
{
// If the contact hour of subject is 2, then it is assigned two consective lecture slots;
// 4th and 5th lecture slots on fourth day of the week
ls4.Parameters.AddWithValue("@l4_4", sub8.Text);
ls4.Parameters.AddWithValue("@tbreak_4", var);
ls4.Parameters.AddWithValue("@l5_4", sub8.Text);
ls4.Parameters.AddWithValue("@l6_4", nill);
ls4.Parameters.AddWithValue("@l7_4", nill);
}
else if (crd8.Text == "3")
{
// If the contact hour of subject is 3, then it is assigned three consective lecture slots;
// 4th, 5th and 6th lecture slots on fourth day of the week
ls4.Parameters.AddWithValue("@l4_4", sub8.Text);
ls4.Parameters.AddWithValue("@tbreak_4", var);
ls4.Parameters.AddWithValue("@l5_4", sub8.Text);
ls4.Parameters.AddWithValue("@l6_4", sub8.Text);
ls4.Parameters.AddWithValue("@l7_4", nill);
}
}
else
{
// Incase no data is entered, the slots are left nill
ls4.Parameters.AddWithValue("@l4_4", nill);
ls4.Parameters.AddWithValue("@tbreak_4", var);
ls4.Parameters.AddWithValue("@l5_4", nill);
ls4.Parameters.AddWithValue("@l6_4", nill);
ls4.Parameters.AddWithValue("@l7_4", nill);
}
ls4.ExecuteNonQuery();
// After storing data in respective tables in database, the message is displayed
// The message informs user that data is stored in database
MessageBox.Show("Data stored in database!");
// The page subjectData hides when Done button is pressed and next generator page appears
this.Hide();
generator ss1 = new generator();
ss1.Show();
}
