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); }
}
