private void Add_btn_Click(object sender, EventArgs e) { //msgbox.show("Click Yes to Add ", "Confirm", CustomMessageBox.MessageBoxButtons.YesNo, CustomMessageBox.MessageBoxIcon.Information); //var result = msgbox.ReturnValue; //if (result == "Yes") //{ try { if (Session_combobox.Text != "-Select-") { int flag = 0; foreach (DataGridViewRow dr in Course_Select_dgv.Rows) { bool checkboxselect = Convert.ToBoolean(dr.Cells["checkBoxColumn"].Value); if (checkboxselect) { flag = 1; SQLiteCommand comm = new SQLiteCommand("Insert into Timetable(Date,Session,Exam_Code,Course,Semester,Branch)Values(" + "@Date,@Session,@Exam_Code,@Course,@Semester,@Branch)", con.ActiveCon()); comm.Parameters.AddWithValue("@Date", DateTimePicker.Text); comm.Parameters.AddWithValue("@Session", Session_combobox.SelectedItem.ToString()); comm.Parameters.AddWithValue("@Exam_Code", dr.Cells["Sub_Code"].Value); comm.Parameters.AddWithValue("@Course", dr.Cells["Course"].Value); comm.Parameters.AddWithValue("@Semester", dr.Cells["Semester"].Value); comm.Parameters.AddWithValue("@Branch", dr.Cells["Branch"].Value); comm.ExecuteNonQuery(); } } if (flag == 1) { con.CloseCon(); Undo_backup_function(flag); //Session_combobox.SelectedIndex = 0; Examcode_box.Clear(); CourseFill(); TimetableFill(); //msgbox.show("Data Inserted ", "Success", CustomMessageBox.MessageBoxButtons.OK, CustomMessageBox.MessageBoxIcon.Information); } else { msgbox.show("No Course Selected ", "Error", CustomMessageBox.MessageBoxButtons.OK, CustomMessageBox.MessageBoxIcon.Error); } } else { msgbox.show("Select Session ", "Error", CustomMessageBox.MessageBoxButtons.OK, CustomMessageBox.MessageBoxIcon.Error); } } catch (Exception ex) { msgbox.show(ex.ToString(), "Exception Error", CustomMessageBox.MessageBoxButtons.OK, CustomMessageBox.MessageBoxIcon.Error); //Session_combobox.SelectedIndex = 0; //Course_Select_dgv.Update(); //Course_Select_dgv.Refresh(); //Timetableview_dgv.Update(); //Timetableview_dgv.Refresh(); CourseFill(); TimetableFill(); } //} }
//void AddHeaderchckbox() //{ // //Locate Header Cell to place checkbox in correct position // Point HeaderCellLocation = this.Course_Select_dgv.GetCellDisplayRectangle(0, -1, true).Location; // //place headercheckbox to the location // headerchkbox.Location = new Point(HeaderCellLocation.X + 8, HeaderCellLocation.Y + 13); // headerchkbox.BackColor = Color.RoyalBlue; // headerchkbox.Size = new Size(18, 18); // //add checkbox into dgv // Course_Select_dgv.Controls.Add(headerchkbox); //} //private void Headerchckbox_Mouseclick(object sender, MouseEventArgs e) //{ // Headerchckboxclick((CheckBox)sender); //} ////headerchckbox click event //private void Headerchckboxclick(CheckBox Hcheckbox) //{ // foreach (DataGridViewRow row in Course_Select_dgv.Rows) // ((DataGridViewCheckBoxCell)row.Cells["checkBoxColumn"]).Value = Hcheckbox.Checked; // Course_Select_dgv.RefreshEdit(); //} private void Clear_btn_Click(object sender, EventArgs e) { Session_combobox.SelectedIndex = 0; DateTimePicker.Value = DateTime.Now; Branch_combobox.SelectedIndex = 0; Semester_combobox.SelectedIndex = 0; Examcode_box.ResetText(); //Datepick_box.ResetText(); //Datewise_radio.Checked = false; //Branchwise_radio.Checked = false; }
private void Clear_btn_Click(object sender, EventArgs e) { try { Session_combobox.SelectedIndex = 0; DateTimePicker.Value = DateTime.Now; Branch_combobox.SelectedIndex = 0; Semester_combobox.SelectedIndex = 0; Examcode_box.ResetText(); //Datepick_box.ResetText(); //Datewise_radio.Checked = false; //Branchwise_radio.Checked = false; } catch (Exception) { MessageBox.Show("Try Again", "Clear_btn_Click", MessageBoxButtons.OK, MessageBoxIcon.Error); } }