示例#1
0
        private void deleteLesson_Click(object sender, EventArgs e)
        {
            cSQL cS = new cSQL();
            List <Tuple <string, string, SqlDbType, int> > sParameters = new List <Tuple <string, string, SqlDbType, int> >();

            try
            {
                int             selectedrowindex = dataGridView1.SelectedCells[0].RowIndex;
                DataGridViewRow selectedRow      = dataGridView1.Rows[selectedrowindex];
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("iID", selectedRow.Cells[0].Value.ToString(), SqlDbType.Int, -1));
                if (cS.CallProcedure("DELETE_LESSON", sParameters))
                {
                    LoadDataset();
                }
            }
            catch (Exception ee)
            {
                MessageBox.Show(ee.Message);
            }
            finally
            {
                cS = null;
                sParameters.Clear();
                sParameters = null;
            }
        }
示例#2
0
        public void LoadDataset()
        {
            cSQL cS = new cSQL();

            try
            {
                dataGridView1.DataSource = cS.CallProcedure("GET_LESSON", null, false, true);
            }
            catch (Exception ee)
            {
                MessageBox.Show(ee.Message);
            }
            finally
            {
                cS = null;
            }
        }
示例#3
0
        public void LoadLesson()
        {
            cSQL      cS = new cSQL();
            DataTable dt = new DataTable();

            try
            {
                dt = cS.CallProcedure("GET_LESSON_ONLY_CODE", null, false, true);
                foreach (DataRow row in dt.Rows)
                {
                    comboBox1.Items.Add(row[0].ToString());
                }
            }
            catch (Exception ee)
            {
                MessageBox.Show(ee.Message);
            }
            finally
            {
                cS = null;
            }
        }
示例#4
0
        private void button_export_Click(object sender, EventArgs e)
        {
            cSQL      cS = new cSQL();
            DataTable dt = new DataTable();
            List <Tuple <string, string, SqlDbType, int> > sParameters = new List <Tuple <string, string, SqlDbType, int> >();

            try
            {
                List <string> Columns = new List <string>();
                if (!this.isEnglish)
                {
                    Columns.Add("ID : ");
                    Columns.Add("Dersin Adı : ");
                    Columns.Add("Kodu : ");
                    Columns.Add("Yarıyıl : ");
                    Columns.Add("Teori(saat / hafta : ");
                    Columns.Add("Uygulama/Lab(saat / hafta) : ");
                    Columns.Add("Yerel Kredi : ");
                    Columns.Add("AKTS : ");
                    Columns.Add("Ön-Koşul(lar) : ");
                    Columns.Add("Dersin Dili : ");
                    Columns.Add("Dersin Türü : ");
                    Columns.Add("Dersin Düzeyi : ");
                    Columns.Add("Dersin Koordinatörü : ");
                    Columns.Add("Öğretim Eleman(lar)ı : ");
                    Columns.Add("Yardımcı(ları) : ");
                    Columns.Add("Dersin Amacı : ");
                    Columns.Add("Öğrenme Çıktıları : ");
                    Columns.Add("Ders Tanımı : ");
                    Columns.Add("Dersin Kategorisi : ");
                    Columns.Add("1. Hafta Konusu : ");
                    Columns.Add("1. Hafta Ön Hazırlık : ");
                    Columns.Add("2. Hafta Konusu : ");
                    Columns.Add("2. Hafta Ön Hazırlık : ");
                    Columns.Add("3. Hafta Konusu : ");
                    Columns.Add("3. Hafta Ön Hazırlık : ");
                    Columns.Add("4. Hafta Konusu : ");
                    Columns.Add("4. Hafta Ön Hazırlık : ");
                    Columns.Add("5. Hafta Konusu : ");
                    Columns.Add("5. Hafta Ön Hazırlık : ");
                    Columns.Add("6. Hafta Konusu : ");
                    Columns.Add("6. Hafta Ön Hazırlık : ");
                    Columns.Add("7. Hafta Konusu : ");
                    Columns.Add("7. Hafta Ön Hazırlık : ");
                    Columns.Add("8. Hafta Konusu : ");
                    Columns.Add("8. Hafta Ön Hazırlık : ");
                    Columns.Add("9. Hafta Konusu : ");
                    Columns.Add("9. Hafta Ön Hazırlık : ");
                    Columns.Add("10. Hafta Konusu : ");
                    Columns.Add("10. Hafta Ön Hazırlık : ");
                    Columns.Add("11. Hafta Konusu : ");
                    Columns.Add("11. Hafta Ön Hazırlık : ");
                    Columns.Add("12. Hafta Konusu : ");
                    Columns.Add("12. Hafta Ön Hazırlık : ");
                    Columns.Add("13. Hafta Konusu : ");
                    Columns.Add("13. Hafta Ön Hazırlık : ");
                    Columns.Add("14. Hafta Konusu : ");
                    Columns.Add("14. Hafta Ön Hazırlık : ");
                    Columns.Add("15. Hafta Konusu : ");
                    Columns.Add("15. Hafta Ön Hazırlık : ");
                    Columns.Add("16. Hafta Konusu : ");
                    Columns.Add("16. Hafta Ön Hazırlık : ");
                    Columns.Add("Dersin Kitabı : ");
                    Columns.Add("Önerilen Okumalar/Materyaller : ");
                    Columns.Add("Katılım Sayısı : ");
                    Columns.Add("Katılım Katkı Payı : ");
                    Columns.Add("Laboratuvar / Uygulama Sayısı : ");
                    Columns.Add("Laboratuvar / Uygulama Katkı Payı : ");
                    Columns.Add("Arazi Çalışması Sayısı : ");
                    Columns.Add("Arazi Çalışması Katkı Payı : ");
                    Columns.Add("Küçük Sınav / Stüdyo Kritiği Sayısı : ");
                    Columns.Add("Küçük Sınav / Stüdyo Kritiği Katkı Payı : ");
                    Columns.Add("Ödev Sayısı : ");
                    Columns.Add("Ödev Katkı Payı : ");
                    Columns.Add("Sunum / Jüri Önünde Sunum Sayısı : ");
                    Columns.Add("Sunum / Jüri Önünde Sunum Katkı Payı : ");
                    Columns.Add("Proje Sayısı : ");
                    Columns.Add("Proje Katkı Payı : ");
                    Columns.Add("Seminer/Çalıştay Sayısı : ");
                    Columns.Add("Seminer/Çalıştay Katkı Payı : ");
                    Columns.Add("Sözlü Sınav Sayısı : ");
                    Columns.Add("Sözlü Sınav Katkı Payı : ");
                    Columns.Add("Ara Sınav Sayısı : ");
                    Columns.Add("Ara Sınav Katkı Payı : ");
                    Columns.Add("Final Sınavı Sayısı : ");
                    Columns.Add("Final Sınavı Katkı Payı : ");
                    Columns.Add("Teorik Ders Sayısı : ");
                    Columns.Add("Teorik Ders Süre(saat) : ");
                    Columns.Add("Teorik Ders İş Yükü(saat) : ");
                    Columns.Add("Laboratuvar / Uygulama Ders Sayısı : ");
                    Columns.Add("Laboratuvar / Uygulama Ders Süre(saat) : ");
                    Columns.Add("Laboratuvar / Uygulama Ders İş Yükü(saat) : ");
                    Columns.Add("Sınıf Dışı Ders Sayısı : ");
                    Columns.Add("Sınıf Dışı Ders Süre(saat) : ");
                    Columns.Add("Sınıf Dışı Ders İş Yükü(saat) : ");
                    Columns.Add("Arazi Çalışması Sayısı : ");
                    Columns.Add("Arazi Çalışması Süre(saat) : ");
                    Columns.Add("Arazi Çalışması İş Yükü(saat) : ");
                    Columns.Add("Küçük Sınav / Stüdyo Kritiği Sayısı : ");
                    Columns.Add("Küçük Sınav / Stüdyo Kritiği Süre(saat) : ");
                    Columns.Add("Küçük Sınav / Stüdyo Kritiği İş Yükü(saat) : ");
                    Columns.Add("Ödev Sayısı : ");
                    Columns.Add("Ödev Süre(saat) : ");
                    Columns.Add("Ödev İş Yükü(saat) : ");
                    Columns.Add("Sunum / Jüri Önünde Sunum Sayısı : ");
                    Columns.Add("Sunum / Jüri Önünde Sunum Süre(saat) : ");
                    Columns.Add("Sunum / Jüri Önünde Sunum İş Yükü(saat) : ");
                    Columns.Add("Proje Sayısı : ");
                    Columns.Add("Proje Süre(saat) : ");
                    Columns.Add("Proje İş Yükü(saat) : ");
                    Columns.Add("Seminer/Çalıştay Sayısı : ");
                    Columns.Add("Seminer/Çalıştay Süre(saat) : ");
                    Columns.Add("Seminer/Çalıştay İş Yükü(saat) : ");
                    Columns.Add("Sözlü Sınav Sayısı : ");
                    Columns.Add("Sözlü Sınav Süre(saat) : ");
                    Columns.Add("Sözlü Sınav İş Yükü(saat) : ");
                    Columns.Add("Ara Sınavlar Sayısı : ");
                    Columns.Add("Ara Sınavlar Süre(saat) : ");
                    Columns.Add("Ara Sınavlar İş Yükü(saat) : ");
                    Columns.Add("Final Sınavı Sayısı : ");
                    Columns.Add("Final Sınavı Süre(saat) : ");
                    Columns.Add("Final Sınavı İş Yükü(saat) : ");
                    Columns.Add("1 - Program Yeterlilikleri / Çıktıları : ");
                    Columns.Add("1- Katkı Düzeyi : ");
                    Columns.Add("2 - Program Yeterlilikleri / Çıktıları : ");
                    Columns.Add("2- Katkı Düzeyi : ");
                    Columns.Add("3 - Program Yeterlilikleri / Çıktıları : ");
                    Columns.Add("3- Katkı Düzeyi : ");
                    Columns.Add("4 - Program Yeterlilikleri / Çıktıları : ");
                    Columns.Add("4- Katkı Düzeyi : ");
                    Columns.Add("5 - Program Yeterlilikleri / Çıktıları : ");
                    Columns.Add("5- Katkı Düzeyi : ");
                    Columns.Add("6 - Program Yeterlilikleri / Çıktıları : ");
                    Columns.Add("6- Katkı Düzeyi : ");
                    Columns.Add("7 - Program Yeterlilikleri / Çıktıları : ");
                    Columns.Add("7- Katkı Düzeyi : ");
                    Columns.Add("8 - Program Yeterlilikleri / Çıktıları : ");
                    Columns.Add("8- Katkı Düzeyi : ");
                    Columns.Add("9 - Program Yeterlilikleri / Çıktıları : ");
                    Columns.Add("9- Katkı Düzeyi : ");
                    Columns.Add("10 - Program Yeterlilikleri / Çıktıları : ");
                    Columns.Add("10- Katkı Düzeyi : ");
                    Columns.Add("11 - Program Yeterlilikleri / Çıktıları : ");
                    Columns.Add("11- Katkı Düzeyi : ");
                    Columns.Add("12 - Program Yeterlilikleri / Çıktıları : ");
                    Columns.Add("12- Katkı Düzeyi : ");
                    Columns.Add("13 - Program Yeterlilikleri / Çıktıları : ");
                    Columns.Add("13- Katkı Düzeyi : ");
                }
                else
                {
                    Columns.Add("ID : ");
                    Columns.Add("Course Name : ");
                    Columns.Add("Code : ");
                    Columns.Add("Semester : ");
                    Columns.Add("Theory(hour / week) : ");
                    Columns.Add("Application/Lab(hour / week) : ");
                    Columns.Add("Local Credits : ");
                    Columns.Add("ECTS : ");
                    Columns.Add("Prerequisites : ");
                    Columns.Add("Course Language : ");
                    Columns.Add("Course Type : ");
                    Columns.Add("Course Level : ");
                    Columns.Add("Course Coordinator : ");
                    Columns.Add("Course Lecturer(s) : ");
                    Columns.Add("Assistant(s) : ");
                    Columns.Add("Course Objectives : ");
                    Columns.Add("Learning Outcomes : ");
                    Columns.Add("Course Description : ");
                    Columns.Add("Course Category : ");
                    Columns.Add("1. Week Subjects : ");
                    Columns.Add("1. Week Ön Related Preparation : ");
                    Columns.Add("2. Week Subjects : ");
                    Columns.Add("2. Week Ön Related Preparation : ");
                    Columns.Add("3. Week Subjects : ");
                    Columns.Add("3. Week Ön Related Preparation : ");
                    Columns.Add("4. Week Subjects : ");
                    Columns.Add("4. Week Ön Related Preparation : ");
                    Columns.Add("5. Week Subjects : ");
                    Columns.Add("5. Week Ön Related Preparation : ");
                    Columns.Add("6. Week Subjects : ");
                    Columns.Add("6. Week Ön Related Preparation : ");
                    Columns.Add("7. Week Subjects : ");
                    Columns.Add("7. Week Ön Related Preparation : ");
                    Columns.Add("8. Week Subjects : ");
                    Columns.Add("8. Week Ön Related Preparation : ");
                    Columns.Add("9. Week Subjects : ");
                    Columns.Add("9. Week Ön Related Preparation : ");
                    Columns.Add("10. Week Subjects : ");
                    Columns.Add("10. Week Ön Related Preparation : ");
                    Columns.Add("11. Week Subjects : ");
                    Columns.Add("11. Week Ön Related Preparation : ");
                    Columns.Add("12. Week Subjects : ");
                    Columns.Add("12. Week Ön Related Preparation : ");
                    Columns.Add("13. Week Subjects : ");
                    Columns.Add("13. Week Ön Related Preparation : ");
                    Columns.Add("14. Week Subjects : ");
                    Columns.Add("14. Week Ön Related Preparation : ");
                    Columns.Add("15. Week Subjects : ");
                    Columns.Add("15. Week Ön Related Preparation : ");
                    Columns.Add("16. Week Subjects : ");
                    Columns.Add("16. Week Ön Related Preparation : ");
                    Columns.Add("Course Notes/Textbooks : ");
                    Columns.Add("Suggested Readings/Materials : ");
                    Columns.Add("Participation Number : ");
                    Columns.Add("Participation Weigthing : ");
                    Columns.Add("Laboratory / Application Number : ");
                    Columns.Add("Laboratory / Application Weigthing : ");
                    Columns.Add("Field Work Number : ");
                    Columns.Add("Field Work Weigthing : ");
                    Columns.Add("Quizzes / Studio Critiques Number : ");
                    Columns.Add("Quizzes / Studio Critiques Weigthing : ");
                    Columns.Add("Homework / Assignments Number : ");
                    Columns.Add("Homework / Assignments Weigthing : ");
                    Columns.Add("Presentation / Jury Number : ");
                    Columns.Add("Presentation / Jury Weigthing : ");
                    Columns.Add("Project Number : ");
                    Columns.Add("Project Weigthing : ");
                    Columns.Add("Seminar / Workshop Number : ");
                    Columns.Add("Seminar / Workshop Weigthing : ");
                    Columns.Add("Oral Exams Number : ");
                    Columns.Add("Oral Exams Weigthing : ");
                    Columns.Add("Midterm Number : ");
                    Columns.Add("Midterm Weigthing : ");
                    Columns.Add("Final Exam Number : ");
                    Columns.Add("Final Exam Weigthing : ");
                    Columns.Add("Theoretical Course Number : ");
                    Columns.Add("Theoretical Course Duration (Hours) : ");
                    Columns.Add("Theoretical Course Workload : ");
                    Columns.Add("Laboratory / Application Number : ");
                    Columns.Add("Laboratory / Application (Hours) : ");
                    Columns.Add("Laboratory / Application Workload : ");
                    Columns.Add("Study Hours Out of Class Number : ");
                    Columns.Add("Study Hours Out of Class Duration (Hours) : ");
                    Columns.Add("Study Hours Out of Class Workload : ");
                    Columns.Add("Field Work Number : ");
                    Columns.Add("Field Work Duration (Hours) : ");
                    Columns.Add("Field Work Workload : ");
                    Columns.Add("Quizzes / Studio Critiques Number : ");
                    Columns.Add("Quizzes / Studio Critiques Duration (Hours) : ");
                    Columns.Add("Quizzes / Studio Critiques Workload : ");
                    Columns.Add("Homework / Assignments Number : ");
                    Columns.Add("Homework / Assignments Duration (Hours) : ");
                    Columns.Add("Homework / Assignments Workload : ");
                    Columns.Add("Presentation / Jury Number : ");
                    Columns.Add("Presentation / Jury Duration (Hours) : ");
                    Columns.Add("Presentation / Jury Workload : ");
                    Columns.Add("Project Number : ");
                    Columns.Add("Project Duration (Hours) : ");
                    Columns.Add("Project Workload : ");
                    Columns.Add("Seminar / Workshop Number : ");
                    Columns.Add("Seminar / Workshop Duration (Hours) : ");
                    Columns.Add("Seminar / Workshop Workload : ");
                    Columns.Add("Oral Exam Number : ");
                    Columns.Add("Oral Exam Duration (Hours) : ");
                    Columns.Add("Oral Exam Workload : ");
                    Columns.Add("Midterms Number : ");
                    Columns.Add("Midterms Duration (Hours) : ");
                    Columns.Add("Midterms Workload : ");
                    Columns.Add("Final Exam Number : ");
                    Columns.Add("Final Exam Duration (Hours) : ");
                    Columns.Add("Final Exam Workload : ");
                    Columns.Add("1 - Program Competencies/Outcomes : ");
                    Columns.Add("1 - Contribution Level : ");
                    Columns.Add("2 - Program Competencies/Outcomes : ");
                    Columns.Add("2 - Contribution Level : ");
                    Columns.Add("3 - Program Competencies/Outcomes : ");
                    Columns.Add("3 - Contribution Level : ");
                    Columns.Add("4 - Program Competencies/Outcomes : ");
                    Columns.Add("4- Contribution Level : ");
                    Columns.Add("5 - Program Competencies/Outcomes : ");
                    Columns.Add("5 - Contribution Level : ");
                    Columns.Add("6 - Program Competencies/Outcomes : ");
                    Columns.Add("6- Contribution Level : ");
                    Columns.Add("7 - Program Competencies/Outcomes : ");
                    Columns.Add("7 - Contribution Level : ");
                    Columns.Add("8 - Program Competencies/Outcomes : ");
                    Columns.Add("8 - Contribution Level : ");
                    Columns.Add("9 - Program Competencies/Outcomes : ");
                    Columns.Add("9 - Contribution Level : ");
                    Columns.Add("10 - Program Competencies/Outcomes : ");
                    Columns.Add("10 - Contribution Level : ");
                    Columns.Add("11 - Program Competencies/Outcomes : ");
                    Columns.Add("11 - Contribution Level : ");
                    Columns.Add("12 - Program Competencies/Outcomes : ");
                    Columns.Add("12 - Contribution Level : ");
                    Columns.Add("13 - Program Competencies/Outcomes : ");
                    Columns.Add("13 - Contribution Level : ");
                }


                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Code", comboBox1.SelectedItem.ToString(), SqlDbType.VarChar, -1));
                dt = cS.CallProcedure("GET_LESSON_WITH_CODE", sParameters, false, true);
                string html = "<table>";
                for (int j = 0; j < dt.Columns.Count; j++)
                {
                    html += "<tr>";
                    html += "<td>" + Columns.ElementAt(j) + dt.Rows[0][j].ToString() + "</td>";
                    html += "</tr>";
                }
                html += "</table>";
                string path = Directory.GetCurrentDirectory() + "/test.html";
                File.WriteAllText(path, html);
                System.Diagnostics.Process.Start(path);
            }
            catch (Exception ee)
            {
                MessageBox.Show(ee.Message);
            }
            finally
            {
                cS = null;
            };
        }
示例#5
0
        private void button_import_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(textBox1.Text) ||
                string.IsNullOrEmpty(textBox2.Text) ||
                string.IsNullOrEmpty(textBox3.Text))
            {
                return;
            }

            cSQL cS = new cSQL();
            List <Tuple <string, string, SqlDbType, int> > sParameters = new List <Tuple <string, string, SqlDbType, int> >();

            try
            {
                Uri           url  = new Uri(textBox1.Text);
                HTML          html = new HTML(url);
                List <string> data = html.GetData();

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("sLessonName", textBox2.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Code", textBox3.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Semester", data[0], SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Theory", data[1], SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Application", data[2], SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Credits", data[3], SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("ECTS", data[4], SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Prerequisites", data[5], SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Language", data[6], SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Type", data[7], SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Level", data[8], SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Coordinator", data[9], SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Lecturer", "-", SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Assistant", "-", SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Objectives", "-", SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Outcomes", "-", SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Description", "-", SqlDbType.VarChar, -1));

                if (this.isEnglish)
                {
                    DialogResult dialog = new DialogResult();
                    dialog = MessageBox.Show("Do you approve course enrollment?", "CONFIRMATION", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                    if (dialog == DialogResult.Yes)
                    {
                        if (cS.CallProcedure("ADD_LESSON_FROM_HTML", sParameters, true) == 1)
                        {
                            MessageBox.Show("Course registration successfully created", "SUCCES", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                        else
                        {
                            MessageBox.Show("Error encountered while creating lecture record", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                    }
                }

                else
                {
                    DialogResult dialog = new DialogResult();
                    dialog = MessageBox.Show("Ders kaydını onaylıyor musunuz ?", "ONAY", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                    if (dialog == DialogResult.Yes)
                    {
                        if (cS.CallProcedure("ADD_LESSON_FROM_HTML", sParameters, true) == 1)
                        {
                            MessageBox.Show("Ders kaydı başarıyla oluşturuldu", "BAŞARILI", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                        else
                        {
                            MessageBox.Show("Ders kaydı oluştururken hata ile karşılaşıldı", "HATA", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                    }
                }
            }
            catch (Exception ee)
            {
                MessageBox.Show(ee.Message);
            }
            finally
            {
                cS = null;
                sParameters.Clear();
                sParameters = null;
            }
        }
示例#6
0
        public void FieldBox(int iID)
        {
            cSQL      cS = new cSQL();
            DataTable dt = new DataTable();
            List <Tuple <string, string, SqlDbType, int> > sParameters = new List <Tuple <string, string, SqlDbType, int> >();

            try
            {
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("iID", iID.ToString(), SqlDbType.Int, -1));
                dt = cS.CallProcedure("GET_LESSON_FOR_UPDATE", sParameters, false, true);

                textBox1.Text     = dt.Rows[0]["sLessonName"].ToString();
                textBox7.Text     = dt.Rows[0]["Code"].ToString();
                textBox5.Text     = dt.Rows[0]["Semester"].ToString();
                textBox6.Text     = dt.Rows[0]["Theory"].ToString();
                textBox4.Text     = dt.Rows[0]["Application"].ToString();
                textBox2.Text     = dt.Rows[0]["Credits"].ToString();
                textBox3.Text     = dt.Rows[0]["ECTS"].ToString();
                textBox9.Text     = dt.Rows[0]["Prerequisites"].ToString();
                textBox8.Text     = dt.Rows[0]["Language"].ToString();
                textBox10.Text    = dt.Rows[0]["Type"].ToString();
                textBox12.Text    = dt.Rows[0]["Level"].ToString();
                textBox11.Text    = dt.Rows[0]["Coordinator"].ToString();
                textBox13.Text    = dt.Rows[0]["Lecturer"].ToString();
                textBox14.Text    = dt.Rows[0]["Assistant"].ToString();
                richTextBox1.Text = dt.Rows[0]["Objectives"].ToString();
                richTextBox2.Text = dt.Rows[0]["Outcomes"].ToString();
                richTextBox3.Text = dt.Rows[0]["Description"].ToString();
                string temp = string.Empty;

                temp = dt.Rows[0]["CoreCoursesChecked"].ToString();
                if (string.Equals(temp, CoreCourses.Text))
                {
                    checkBox1.Checked = true;
                }
                if (string.Equals(temp, MajorAreaCourses.Text))
                {
                    checkBox2.Checked = true;
                }
                if (string.Equals(temp, SupportiveCourses.Text))
                {
                    checkBox3.Checked = true;
                }
                if (string.Equals(temp, MediaandManagementSkillsCourses.Text))
                {
                    checkBox4.Checked = true;
                }
                if (string.Equals(temp, TransferableSkillCourses.Text))
                {
                    checkBox5.Checked = true;
                }

                textBox15.Text = dt.Rows[0]["week_1_Related"].ToString();
                textBox31.Text = dt.Rows[0]["week_1_Subjects"].ToString();
                textBox19.Text = dt.Rows[0]["week_2_Subjects"].ToString();
                textBox32.Text = dt.Rows[0]["week_2_Related"].ToString();
                textBox17.Text = dt.Rows[0]["week_3_Subjects"].ToString();
                textBox33.Text = dt.Rows[0]["week_3_Related"].ToString();
                textBox16.Text = dt.Rows[0]["week_4_Subjects"].ToString();
                textBox34.Text = dt.Rows[0]["week_4_Related"].ToString();
                textBox20.Text = dt.Rows[0]["week_5_Subjects"].ToString();
                textBox35.Text = dt.Rows[0]["week_5_Related"].ToString();
                textBox21.Text = dt.Rows[0]["week_6_Subjects"].ToString();
                textBox36.Text = dt.Rows[0]["week_6_Related"].ToString();
                textBox24.Text = dt.Rows[0]["week_7_Subjects"].ToString();
                textBox37.Text = dt.Rows[0]["week_7_Related"].ToString();
                textBox25.Text = dt.Rows[0]["week_8_Subjects"].ToString();
                textBox38.Text = dt.Rows[0]["week_8_Related"].ToString();
                textBox22.Text = dt.Rows[0]["week_9_Subjects"].ToString();
                textBox39.Text = dt.Rows[0]["week_9_Related"].ToString();
                textBox18.Text = dt.Rows[0]["week_10_Subjects"].ToString();
                textBox40.Text = dt.Rows[0]["week_10_Related"].ToString();
                textBox23.Text = dt.Rows[0]["week_11_Subjects"].ToString();
                textBox41.Text = dt.Rows[0]["week_11_Related"].ToString();
                textBox26.Text = dt.Rows[0]["week_12_Subjects"].ToString();
                textBox42.Text = dt.Rows[0]["week_12_Related"].ToString();
                textBox27.Text = dt.Rows[0]["week_13_Subjects"].ToString();
                textBox43.Text = dt.Rows[0]["week_13_Related"].ToString();
                textBox30.Text = dt.Rows[0]["week_14_Subjects"].ToString();
                textBox44.Text = dt.Rows[0]["week_14_Related"].ToString();
                textBox28.Text = dt.Rows[0]["week_15_Subjects"].ToString();
                textBox45.Text = dt.Rows[0]["week_15_Related"].ToString();
                textBox29.Text = dt.Rows[0]["week_16_Subjects"].ToString();
                textBox46.Text = dt.Rows[0]["week_16_Related"].ToString();

                richTextBox6.Text = dt.Rows[0]["Textbooks"].ToString();
                richTextBox5.Text = dt.Rows[0]["Materials"].ToString();

                textBox78.Text = dt.Rows[0]["Participation_Number"].ToString();
                textBox62.Text = dt.Rows[0]["Participation_Weight"].ToString();
                textBox74.Text = dt.Rows[0]["Laboratory_Applicationxtbooks_Number"].ToString();
                textBox61.Text = dt.Rows[0]["Laboratory_Applicationxtbooks_Weight"].ToString();
                textBox76.Text = dt.Rows[0]["FieldWork_Number"].ToString();
                textBox60.Text = dt.Rows[0]["FieldWork_Weight"].ToString();
                textBox77.Text = dt.Rows[0]["Quizzes_StudioCritiques_Number"].ToString();
                textBox59.Text = dt.Rows[0]["Quizzes_StudioCritiques_Weight"].ToString();
                textBox73.Text = dt.Rows[0]["Homework_Assignments_Number"].ToString();
                textBox58.Text = dt.Rows[0]["Homework_Assignments_Weight"].ToString();
                textBox72.Text = dt.Rows[0]["Presentation_Jury_Number"].ToString();
                textBox57.Text = dt.Rows[0]["Presentation_Jury_Weight"].ToString();
                textBox69.Text = dt.Rows[0]["Project_Number"].ToString();
                textBox56.Text = dt.Rows[0]["Project_Weight"].ToString();
                textBox68.Text = dt.Rows[0]["Seminar_Workshop_Number"].ToString();
                textBox55.Text = dt.Rows[0]["Seminar_Workshop_Weight"].ToString();
                textBox71.Text = dt.Rows[0]["OralExams_Number"].ToString();
                textBox54.Text = dt.Rows[0]["OralExams_Weight"].ToString();
                textBox75.Text = dt.Rows[0]["Midterm_Number"].ToString();
                textBox53.Text = dt.Rows[0]["Midterm_Weight"].ToString();
                textBox70.Text = dt.Rows[0]["FinalExam_Number"].ToString();
                textBox52.Text = dt.Rows[0]["FinalExam_Weight"].ToString();

                textBox90.Text  = dt.Rows[0]["TheoreticalCourseHours_Num"].ToString();
                textBox79.Text  = dt.Rows[0]["TheoreticalCourseHours_Duration"].ToString();
                textBox93.Text  = dt.Rows[0]["TheoreticalCourseHours_Workload"].ToString();
                textBox86.Text  = dt.Rows[0]["Laboratory_Application_Hours_Number"].ToString();
                textBox67.Text  = dt.Rows[0]["Laboratory_Application_Hour_Duration"].ToString();
                textBox94.Text  = dt.Rows[0]["Laboratory_Application_Hours_Workload"].ToString();
                textBox88.Text  = dt.Rows[0]["Study_Hours_Out_of_Class_Number"].ToString();
                textBox66.Text  = dt.Rows[0]["Study_Hours_Out_of_Class_Duration"].ToString();
                textBox95.Text  = dt.Rows[0]["Study_Hours_Out_of_Class_Workload"].ToString();
                textBox89.Text  = dt.Rows[0]["Field_Work_Number"].ToString();
                textBox65.Text  = dt.Rows[0]["Field_Work_Duration"].ToString();
                textBox96.Text  = dt.Rows[0]["Field_Work_Workload"].ToString();
                textBox85.Text  = dt.Rows[0]["Quizzes_Studio_Critiques_Number"].ToString();
                textBox64.Text  = dt.Rows[0]["Quizzes_Studio_Critiques_Duration"].ToString();
                textBox97.Text  = dt.Rows[0]["Quizzes_Studio_Critiques_Workload"].ToString();
                textBox84.Text  = dt.Rows[0]["Homework_Assignmentss_Number"].ToString();
                textBox63.Text  = dt.Rows[0]["Homework_Assignmentss_Duration"].ToString();
                textBox98.Text  = dt.Rows[0]["Homework_Assignmentss_Workload"].ToString();
                textBox81.Text  = dt.Rows[0]["Presentation_Juryy_Number"].ToString();
                textBox51.Text  = dt.Rows[0]["Presentation_Juryy_Duration"].ToString();
                textBox99.Text  = dt.Rows[0]["Presentation_Juryy_Workload"].ToString();
                textBox80.Text  = dt.Rows[0]["Projectt_Number"].ToString();
                textBox50.Text  = dt.Rows[0]["Projectt_Duration"].ToString();
                textBox100.Text = dt.Rows[0]["Projectt_Workload"].ToString();
                textBox83.Text  = dt.Rows[0]["Seminar_Workshopp_Number"].ToString();
                textBox49.Text  = dt.Rows[0]["Seminar_Workshopp_Duration"].ToString();
                textBox101.Text = dt.Rows[0]["Seminar_Workshopp_Workload"].ToString();
                textBox87.Text  = dt.Rows[0]["Oral_Exam_Number"].ToString();
                textBox48.Text  = dt.Rows[0]["Oral_Exam_Duration"].ToString();
                textBox102.Text = dt.Rows[0]["Oral_Exam_Workload"].ToString();
                textBox82.Text  = dt.Rows[0]["Midtermss_Number"].ToString();
                textBox47.Text  = dt.Rows[0]["Midtermss_Duration"].ToString();
                textBox103.Text = dt.Rows[0]["Midtermss_Workload"].ToString();
                textBox91.Text  = dt.Rows[0]["Final_Exam_Number"].ToString();
                textBox92.Text  = dt.Rows[0]["Final_Exam_Duration"].ToString();
                textBox104.Text = dt.Rows[0]["Final_Exam_Workload"].ToString();


                textBox105.Text       = dt.Rows[0]["Outcomes_1_Text"].ToString();
                numericUpDown1.Value  = Convert.ToInt32(dt.Rows[0]["Outcomes_1_Value"]);
                textBox106.Text       = dt.Rows[0]["Outcomes_2_Text"].ToString();
                numericUpDown2.Value  = Convert.ToInt32(dt.Rows[0]["Outcomes_2_Value"]);
                textBox107.Text       = dt.Rows[0]["Outcomes_3_Text"].ToString();
                numericUpDown3.Value  = Convert.ToInt32(dt.Rows[0]["Outcomes_3_Value"]);
                textBox108.Text       = dt.Rows[0]["Outcomes_4_Text"].ToString();
                numericUpDown4.Value  = Convert.ToInt32(dt.Rows[0]["Outcomes_4_Value"]);
                textBox109.Text       = dt.Rows[0]["Outcomes_5_Text"].ToString();
                numericUpDown5.Value  = Convert.ToInt32(dt.Rows[0]["Outcomes_5_Value"]);
                textBox110.Text       = dt.Rows[0]["Outcomes_6_Text"].ToString();
                numericUpDown6.Value  = Convert.ToInt32(dt.Rows[0]["Outcomes_6_Value"]);
                textBox111.Text       = dt.Rows[0]["Outcomes_7_Text"].ToString();
                numericUpDown7.Value  = Convert.ToInt32(dt.Rows[0]["Outcomes_7_Value"]);
                textBox112.Text       = dt.Rows[0]["Outcomes_8_Text"].ToString();
                numericUpDown8.Value  = Convert.ToInt32(dt.Rows[0]["Outcomes_8_Value"]);
                textBox113.Text       = dt.Rows[0]["Outcomes_9_Text"].ToString();
                numericUpDown9.Value  = Convert.ToInt32(dt.Rows[0]["Outcomes_9_Value"]);
                textBox114.Text       = dt.Rows[0]["Outcomes_10_Text"].ToString();
                numericUpDown10.Value = Convert.ToInt32(dt.Rows[0]["Outcomes_10_Value"]);
                textBox115.Text       = dt.Rows[0]["Outcomes_11_Text"].ToString();
                numericUpDown11.Value = Convert.ToInt32(dt.Rows[0]["Outcomes_11_Value"]);
                textBox116.Text       = dt.Rows[0]["Outcomes_12_Text"].ToString();
                numericUpDown12.Value = Convert.ToInt32(dt.Rows[0]["Outcomes_12_Value"]);
                textBox117.Text       = dt.Rows[0]["Outcomes_13_Text"].ToString();
                numericUpDown13.Value = Convert.ToInt32(dt.Rows[0]["Outcomes_13_Value"]);
            }
            catch (Exception ee)
            {
                MessageBox.Show(ee.Message);
            }
            finally
            {
                cS = null;
                dt.Dispose();
                sParameters.Clear();
                sParameters = null;
            }
        }
示例#7
0
        private void buttun_save_Click(object sender, EventArgs e)
        {
            cSQL cS = new cSQL();
            List <Tuple <string, string, SqlDbType, int> > sParameters = new List <Tuple <string, string, SqlDbType, int> >();

            try
            {
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("sLessonName", textBox1.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Code", textBox7.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Semester", textBox5.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Theory", textBox6.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Application", textBox4.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Credits", textBox2.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("ECTS", textBox3.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Prerequisites", textBox9.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Language", textBox8.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Type", textBox10.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Level", textBox12.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Coordinator", textBox11.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Lecturer", textBox13.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Assistant", textBox14.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Objectives", richTextBox1.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Outcomes", richTextBox2.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Description", richTextBox3.Text.ToString(), SqlDbType.VarChar, -1));

                string temp = string.Empty;
                if (checkBox1.Checked)
                {
                    temp = CoreCourses.Text;
                }

                if (checkBox2.Checked)
                {
                    temp = MajorAreaCourses.Text;
                }

                if (checkBox3.Checked)
                {
                    temp = SupportiveCourses.Text;
                }

                if (checkBox4.Checked)
                {
                    temp = MediaandManagementSkillsCourses.Text;
                }

                if (checkBox5.Checked)
                {
                    temp = TransferableSkillCourses.Text;
                }

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("CoreCoursesChecked", temp, SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_1_Subjects", textBox15.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_1_Related", textBox31.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_2_Subjects", textBox19.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_2_Related", textBox32.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_3_Subjects", textBox17.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_3_Related", textBox33.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_4_Subjects", textBox16.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_4_Related", textBox34.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_5_Subjects", textBox20.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_5_Related", textBox35.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_6_Subjects", textBox21.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_6_Related", textBox36.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_7_Subjects", textBox24.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_7_Related", textBox37.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_8_Subjects", textBox25.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_8_Related", textBox38.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_9_Subjects", textBox22.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_9_Related", textBox39.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_10_Subjects", textBox18.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_10_Related", textBox40.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_11_Subjects", textBox23.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_11_Related", textBox41.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_12_Subjects", textBox26.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_12_Related", textBox42.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_13_Subjects", textBox27.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_13_Related", textBox43.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_14_Subjects", textBox30.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_14_Related", textBox44.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_15_Subjects", textBox28.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_15_Related", textBox45.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_16_Subjects", textBox29.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("week_16_Related", textBox46.Text.ToString(), SqlDbType.VarChar, -1));



                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Textbooks", richTextBox6.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Materials", richTextBox5.Text.ToString(), SqlDbType.VarChar, -1));


                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Participation_Number", textBox78.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Participation_Weight", textBox62.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Laboratory_Applicationxtbooks_Number", textBox74.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Laboratory_Applicationxtbooks_Weight", textBox61.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("FieldWork_Number", textBox76.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("FieldWork_Weight", textBox60.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Quizzes_StudioCritiques_Number", textBox77.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Quizzes_StudioCritiques_Weight", textBox59.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Homework_Assignments_Number", textBox73.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Homework_Assignments_Weight", textBox58.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Presentation_Jury_Number", textBox72.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Presentation_Jury_Weight", textBox57.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Project_Number", textBox69.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Project_Weight", textBox56.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Seminar_Workshop_Number", textBox68.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Seminar_Workshop_Weight", textBox55.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("OralExams_Number", textBox71.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("OralExams_Weight", textBox54.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Midterm_Number", textBox75.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Midterm_Weight", textBox53.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("FinalExam_Number", textBox70.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("FinalExam_Weight", textBox52.Text.ToString(), SqlDbType.VarChar, -1));


                sParameters.Add(new Tuple <string, string, SqlDbType, int>("TheoreticalCourseHours_Num", textBox90.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("TheoreticalCourseHours_Duration", textBox79.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("TheoreticalCourseHours_Workload", textBox93.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Laboratory_Application_Hours_Number", textBox86.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Laboratory_Application_Hour_Duration", textBox67.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Laboratory_Application_Hours_Workload", textBox94.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Study_Hours_Out_of_Class_Number", textBox88.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Study_Hours_Out_of_Class_Duration", textBox66.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Study_Hours_Out_of_Class_Workload", textBox95.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Field_Work_Number", textBox89.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Field_Work_Duration", textBox65.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Field_Work_Workload", textBox96.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Quizzes_Studio_Critiques_Number", textBox85.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Quizzes_Studio_Critiques_Duration", textBox64.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Quizzes_Studio_Critiques_Workload", textBox97.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Homework_Assignmentss_Number", textBox84.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Homework_Assignmentss_Duration", textBox63.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Homework_Assignmentss_Workload", textBox98.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Presentation_Juryy_Number", textBox81.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Presentation_Juryy_Duration", textBox51.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Presentation_Juryy_Workload", textBox99.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Projectt_Number", textBox80.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Projectt_Duration", textBox50.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Projectt_Workload", textBox100.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Seminar_Workshopp_Number", textBox83.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Seminar_Workshopp_Duration", textBox49.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Seminar_Workshopp_Workload", textBox101.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Oral_Exam_Number", textBox87.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Oral_Exam_Duration", textBox48.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Oral_Exam_Workload", textBox102.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Midtermss_Number", textBox82.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Midtermss_Duration", textBox47.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Midtermss_Workload", textBox103.Text.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Final_Exam_Number", textBox91.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Final_Exam_Duration", textBox92.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Final_Exam_Workload", textBox104.Text.ToString(), SqlDbType.VarChar, -1));


                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Outcomes_1_Text", textBox105.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Outcomes_1_Value", numericUpDown11.Value.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Outcomes_2_Text", textBox106.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Outcomes_2_Value", numericUpDown2.Value.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Outcomes_3_Text", textBox107.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Outcomes_3_Value", numericUpDown3.Value.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Outcomes_4_Text", textBox108.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Outcomes_4_Value", numericUpDown4.Value.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Outcomes_5_Text", textBox109.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Outcomes_5_Value", numericUpDown5.Value.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Outcomes_6_Text", textBox110.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Outcomes_6_Value", numericUpDown6.Value.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Outcomes_7_Text", textBox111.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Outcomes_7_Value", numericUpDown7.Value.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Outcomes_8_Text", textBox112.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Outcomes_8_Value", numericUpDown8.Value.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Outcomes_9_Text", textBox113.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Outcomes_9_Value", numericUpDown9.Value.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Outcomes_10_Text", textBox114.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Outcomes_10_Value", numericUpDown10.Value.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Outcomes_11_Text", textBox115.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Outcomes_11_Value", numericUpDown11.Value.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Outcomes_12_Text", textBox116.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Outcomes_12_Value", numericUpDown12.Value.ToString(), SqlDbType.VarChar, -1));

                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Outcomes_13_Text", textBox117.Text.ToString(), SqlDbType.VarChar, -1));
                sParameters.Add(new Tuple <string, string, SqlDbType, int>("Outcomes_13_Value", numericUpDown13.Value.ToString(), SqlDbType.VarChar, -1));


                if (this.isEnglish)
                {
                    DialogResult dialog = new DialogResult();
                    dialog = MessageBox.Show("Do you approve course enrollment?", "CONFIRMATION", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                    if (dialog == DialogResult.Yes)
                    {
                        if (this.isUpdate)
                        {
                            sParameters.Add(new Tuple <string, string, SqlDbType, int>("iID", this.iID.ToString(), SqlDbType.Int, -1));
                            if (cS.CallProcedure("UPDATE LESSON", sParameters, true) == 1)
                            {
                                MessageBox.Show("Course registration successfully updated", "SUCCES", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            }
                            else
                            {
                                MessageBox.Show("Error encountered while updating lecture record", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            }
                        }
                        else
                        {
                            if (cS.CallProcedure("ADD_LESSON", sParameters, true) == 1)
                            {
                                MessageBox.Show("Course registration successfully created", "SUCCES", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            }
                            else
                            {
                                MessageBox.Show("Error encountered while creating lecture record", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            }
                        }
                    }
                }

                else
                {
                    DialogResult dialog = new DialogResult();
                    dialog = MessageBox.Show("Ders kaydını onaylıyor musunuz ?", "ONAY", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                    if (dialog == DialogResult.Yes)
                    {
                        if (this.isUpdate)
                        {
                            sParameters.Add(new Tuple <string, string, SqlDbType, int>("iID", this.iID.ToString(), SqlDbType.Int, -1));
                            if (cS.CallProcedure("UPDATE_LESSON", sParameters, true) == 1)
                            {
                                MessageBox.Show("Ders kaydı başarıyla güncellendi", "BAŞARILI", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            }
                            else
                            {
                                MessageBox.Show("Ders kaydı güncellenirken hata ile karşılaşıldı", "HATA", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            }
                        }
                        else
                        {
                            if (cS.CallProcedure("ADD_LESSON", sParameters, true) == 1)
                            {
                                MessageBox.Show("Ders kaydı başarıyla oluşturuldu", "BAŞARILI", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            }
                            else
                            {
                                MessageBox.Show("Ders kaydı oluştururken hata ile karşılaşıldı", "HATA", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            }
                        }
                    }
                }
            }
            catch (Exception ee)
            {
                MessageBox.Show(ee.Message);
            }
            finally
            {
                cS = null;
                sParameters.Clear();
                sParameters = null;
            }
        }