private void tile_update_Click(object sender, EventArgs e)
{
try
{
Database d = new Database();
DialogResult result = MessageBox.Show("Are you sure you want to edit program details?", "NILS", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
string resourceP2;
string resourceP3;
if (metroCheckBox1.Checked == true)
{
resourceP2 = General_methods.get_lec_no_from_lec_name(cmb_rp_2.Text);
}
else
{
resourceP2 = "None";
}
if (metroCheckBox2.Checked == true)
{
resourceP3 = General_methods.get_lec_no_from_lec_name(cmb_rp_3.Text);
}
else
{
resourceP3 = "None";
}
if (cmb_type_2.SelectedIndex != 5)
{
con.Open();
d.update("UPDATE Session_details SET scheduled_date='" + txt_date.Value.ToString("MM/dd/yyyy") + "',course_type='" + ctype + "',course_no='" + course_no.Text + "',Resource_person_1='" + General_methods.get_lec_no_from_lec_name(cmb_rp_1.Text) + "',Resource_person_2='" + resourceP2 + "',Resource_person_3='" + resourceP3 + "',venue=N'" + txt_venue.Text + "' WHERE (program_no='" + txt_progno.Text + "')");
MessageBox.Show("Details edited Succefully", "NILS", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
con.Close();
}
else
{
con.Open();
d.update("UPDATE Session_details SET scheduled_date='" + txt_date.Value.ToString("MM/dd/yyyy") + "',course_type='Workshop', course_no='None', Resource_person_1='" + General_methods.get_lec_no_from_lec_name(cmb_rp_1.Text) + "',Resource_person_2='" + resourceP2 + "', Resource_person_3='" + resourceP3 + "',venue=N'" + txt_venue.Text + "' WHERE (program_no='" + txt_progno.Text + "')");
d.update("UPDATE Short_program_details SET Program_title='" + txt_progtitle.Text + "' WHERE Code='" + txt_progno.Text + "'");
MessageBox.Show("Details edited Succefully", "NILS", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
con.Close();
}
}
else
{
}
}
catch (Exception V)
{
MessageBox.Show(V.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void SMS_recipents_Load(object sender, EventArgs e)
{
if (type == "student")
{
con.Open();
this.ControlBox = false;
richTextBox1.AppendText("Lecture Reminder");
richTextBox1.AppendText(Environment.NewLine + "batch - " + batchname);
richTextBox1.AppendText(Environment.NewLine + "module - " + module);
richTextBox1.AppendText(Environment.NewLine + "date - " + date);
richTextBox1.AppendText(Environment.NewLine + "time - " + time);
richTextBox1.AppendText(Environment.NewLine + "Conducted by - " + lecturer1 + "," + lecturer2 + "," + lecturer3);
richTextBox1.AppendText(Environment.NewLine + "Venue - " + venue);
SqlCommand cmd = new SqlCommand("SELECT stud_no,name_with_initials,mobile FROM Stud_details WHERE batch_no='" + General_methods.get_batch_no_from_batch_name(batchname) + "'", con);
SqlDataReader dr = cmd.ExecuteReader();
int c = 0;
while (dr.Read())
{
checkedListBox1.Items.Add(dr.GetValue(0) + " - " + dr.GetValue(1) + " - " + dr.GetValue(2));
checkedListBox1.SetItemChecked(c, true);
c++;
}
}
if (type == "lec")
{
con.Open();
this.ControlBox = false;
richTextBox1.AppendText("Lecture Reminder");
richTextBox1.AppendText(Environment.NewLine + "batch - " + batchname);
richTextBox1.AppendText(Environment.NewLine + "module - " + module);
richTextBox1.AppendText(Environment.NewLine + "date - " + date);
richTextBox1.AppendText(Environment.NewLine + "time - " + time);
richTextBox1.AppendText(Environment.NewLine + "Venue - " + venue);
SqlCommand cmd = new SqlCommand("SELECT Lecturer_no,F_name,L_name,mobile_no_1 FROM Lecture_details WHERE Lecturer_no='" + General_methods.get_lec_no_from_lec_name(lecturer1) + "' OR Lecturer_no='" + General_methods.get_lec_no_from_lec_name(lecturer2) + "' OR Lecturer_no='" + General_methods.get_lec_no_from_lec_name(lecturer3) + "'", con);
SqlDataReader dr = cmd.ExecuteReader();
int c = 0;
while (dr.Read())
{
checkedListBox1.Items.Add(dr.GetValue(0) + " - " + dr.GetValue(1) + " " + dr.GetValue(2) + " - " + dr.GetValue(3));
checkedListBox1.SetItemChecked(c, true);
c++;
}
}
if (type == "short_lec")
{
con.Open();
this.ControlBox = false;
richTextBox1.AppendText("Reminder for " + prg_type + " at NILS");
richTextBox1.AppendText(Environment.NewLine + "Title - " + batchname);
richTextBox1.AppendText(Environment.NewLine + "date - " + date);
richTextBox1.AppendText(Environment.NewLine + "time - " + time);
richTextBox1.AppendText(Environment.NewLine + "Conducted by - " + lecturer1 + "," + lecturer2 + "," + lecturer3);
richTextBox1.AppendText(Environment.NewLine + "Venue - " + venue);
SqlCommand cmd = new SqlCommand("SELECT Lecturer_no,F_name,L_name,mobile_no_1 FROM Lecture_details WHERE Lecturer_no='" + General_methods.get_lec_no_from_lec_name(lecturer1) + "' OR Lecturer_no='" + General_methods.get_lec_no_from_lec_name(lecturer2) + "' OR Lecturer_no='" + General_methods.get_lec_no_from_lec_name(lecturer3) + "'", con);
SqlDataReader dr = cmd.ExecuteReader();
int c = 0;
while (dr.Read())
{
checkedListBox1.Items.Add(dr.GetValue(0) + " - " + dr.GetValue(1) + " " + dr.GetValue(2) + " - " + dr.GetValue(3));
checkedListBox1.SetItemChecked(c, true);
c++;
}
}
}
private void tile_enter_Click(object sender, EventArgs e)
{
if (cmb_type.Text == "")
{
MessageBox.Show(this, "Please select course type");
}
else if (cmb_type.SelectedIndex == 5 && txt_progtitle.Text == "")
{
MessageBox.Show(this, "Please enter title for workshop");
}
else if (cmb_name.Enabled == true && cmb_name.Text == "")
{
MessageBox.Show(this, "Please select the course name");
}
else if (cmb_module.Enabled == true && cmb_module.Text == "")
{
MessageBox.Show(this, "Please select the module name");
}
else if (cmb_rperson1.Text == "")
{
MessageBox.Show(this, "Please select at least one resource person");
}
else if (cmb_rperson2.Enabled == true && cmb_rperson2.Text == "")
{
MessageBox.Show(this, "Please select second resource person");
}
else if (cmb_rperson3.Enabled == true && cmb_rperson3.Text == "")
{
MessageBox.Show(this, "Please select third resource person");
}
else if (groupBox1.Enabled == true && rbn_in.Checked == false && rbn_out.Checked == false)
{
MessageBox.Show(this, "Please select venue");
}
else if (groupBox1.Enabled = true && rbn_out.Checked == true && (txt_venue.Text == "" || txt_venue.Text == "NILS"))
{
MessageBox.Show(this, "Please enter a valid outstation venue");
}
else if (cmb_batch.Enabled == true && cmb_batch.Text == "")
{
MessageBox.Show("Please select the batch");
}
else
{
resourceP1 = General_methods.get_lec_no_from_lec_name(cmb_rperson1.Text);
if (metroCheckBox1.Checked == true)
{
resourceP2 = General_methods.get_lec_no_from_lec_name(cmb_rperson2.Text);
}
else
{
resourceP2 = "None";
}
if (metroCheckBox2.Checked == true)
{
resourceP3 = General_methods.get_lec_no_from_lec_name(cmb_rperson3.Text);
}
else
{
resourceP3 = "None";
}
Database d = new Database();
string code;
code = generate_program_no(ctype);
if (cmb_type.SelectedIndex == 0)
{
d.insert("INSERT INTO Session_details (program_no,scheduled_date,course_type,course_no,module,Resource_person_1,Resource_person_2,Resource_person_3,venue,overall_morn_rating,overall_noon_rating,Batch_no) VALUES('" + code + "','" + metroDateTime1.Value + "','" + ctype + "','" + txt_no.Text + "', '" + cmb_module.Text + "' ,'" + resourceP1 + "','" + resourceP2 + "','" + resourceP3 + "',N'" + txt_venue.Text + "','0','0','" + General_methods.get_batch_no_from_batch_name(cmb_batch.Text) + "')");
}
if (cmb_type.SelectedIndex == 1)
{
d.insert("INSERT INTO Session_details (program_no,scheduled_date,course_type,course_no,module,Resource_person_1,Resource_person_2,Resource_person_3,venue,overall_morn_rating,overall_noon_rating,Batch_no) VALUES('" + code + "','" + metroDateTime1.Value + "','" + ctype + "','" + txt_no.Text + "', '" + cmb_module.Text + "' ,'" + resourceP1 + "','" + resourceP2 + "','" + resourceP3 + "',N'" + txt_venue.Text + "','0','0','" + General_methods.get_batch_no_from_batch_name(cmb_batch.Text) + "')");
}
if (cmb_type.SelectedIndex == 2)
{
d.insert("INSERT INTO Session_details (program_no,scheduled_date,course_type,course_no,module,Resource_person_1,Resource_person_2,Resource_person_3,venue,overall_morn_rating,overall_noon_rating) VALUES('" + code + "','" + metroDateTime1.Value + "','" + ctype + "','" + txt_no.Text + "', 'no modules' ,'" + resourceP1 + "','" + resourceP2 + "','" + resourceP3 + "',N'" + txt_venue.Text + "','0','0')");
d.insert("INSERT INTO Short_program_details (Code,Program_title) VALUES ('" + code + "','" + txt_progtitle.Text + "')");
}
if (cmb_type.SelectedIndex == 3)
{
d.insert("INSERT INTO Session_details (program_no,scheduled_date,course_type,course_no,module,Resource_person_1,Resource_person_2,Resource_person_3,venue,overall_morn_rating,overall_noon_rating) VALUES('" + code + "','" + metroDateTime1.Value + "','" + ctype + "','" + txt_no.Text + "', 'no modules' ,'" + resourceP1 + "','" + resourceP2 + "','" + resourceP3 + "',N'" + txt_venue.Text + "','0','0')");
d.insert("INSERT INTO Short_program_details (Code,Program_title) VALUES ('" + code + "','" + txt_progtitle.Text + "')");
}
if (cmb_type.SelectedIndex == 4)
{
d.insert("INSERT INTO Session_details (program_no,scheduled_date,course_type,course_no,module,Resource_person_1,Resource_person_2,Resource_person_3,venue,overall_morn_rating,overall_noon_rating) VALUES('" + code + "','" + metroDateTime1.Value + "','" + ctype + "','" + txt_no.Text + "', 'no modules' ,'" + resourceP1 + "','" + resourceP2 + "','" + resourceP3 + "',N'" + txt_venue.Text + "','0','0')");
d.insert("INSERT INTO Short_program_details (Code,Program_title) VALUES ('" + code + "','" + txt_progtitle.Text + "')");
}
if (cmb_type.SelectedIndex == 5)
{
d.insert("INSERT INTO Session_details (program_no,scheduled_date,course_type,course_no,module,Resource_person_1,Resource_person_2,Resource_person_3,venue,overall_morn_rating,overall_noon_rating) VALUES('" + code + "','" + metroDateTime1.Value + "','" + ctype + "','None', 'no modules' ,'" + resourceP1 + "','" + resourceP2 + "','" + resourceP3 + "',N'" + txt_venue.Text + "','0','0')");
d.insert("INSERT INTO Short_program_details (Code,Program_title) VALUES ('" + code + "','" + txt_progtitle.Text + "')");
}
MessageBox.Show("Successfully Scheduled New Program", "", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
private void Email_recipients_Load(object sender, EventArgs e)
{
if (type == "dip_studs")
{
metroTextBox1.Text = "Lecturer Reminder- (" + batchname + ")";
richTextBox1.AppendText("Lecture Reminder");
richTextBox1.AppendText(Environment.NewLine + "batch - " + batchname);
richTextBox1.AppendText(Environment.NewLine + "module - " + module);
richTextBox1.AppendText(Environment.NewLine + "date - " + date);
richTextBox1.AppendText(Environment.NewLine + "time - " + time);
richTextBox1.AppendText(Environment.NewLine + "Conducted by - " + lecturer1 + "," + lecturer2 + "," + lecturer3);
richTextBox1.AppendText(Environment.NewLine + "Venue - " + venue);
richTextBox1.AppendText(Environment.NewLine + "Please be present");
con.Open();
SqlCommand cmd = new SqlCommand("SELECT stud_no,name_with_initials,email_R FROM Stud_details WHERE batch_no='" + General_methods.get_batch_no_from_batch_name(batchname) + "'", con);
SqlDataReader dr = cmd.ExecuteReader();
int c = 0;
while (dr.Read())
{
checkedListBox1.Items.Add(dr.GetValue(0) + " - " + dr.GetValue(1) + " - " + dr.GetValue(2));
checkedListBox1.SetItemChecked(c, true);
c++;
}
con.Close();
}
if (type == "lec")
{
con.Open();
this.ControlBox = false;
metroTextBox1.Text = "Lecturer Reminder- (" + batchname + ")";
richTextBox1.AppendText("Lecture Reminder");
richTextBox1.AppendText(Environment.NewLine + "batch - " + batchname);
richTextBox1.AppendText(Environment.NewLine + "module - " + module);
richTextBox1.AppendText(Environment.NewLine + "date - " + date);
richTextBox1.AppendText(Environment.NewLine + "time - " + time);
richTextBox1.AppendText(Environment.NewLine + "Venue - " + venue);
SqlCommand cmd = new SqlCommand("SELECT Lecturer_no,F_name,L_name,email FROM Lecture_details WHERE Lecturer_no='" + General_methods.get_lec_no_from_lec_name(lecturer1) + "' OR Lecturer_no='" + General_methods.get_lec_no_from_lec_name(lecturer2) + "' OR Lecturer_no='" + General_methods.get_lec_no_from_lec_name(lecturer3) + "'", con);
SqlDataReader dr = cmd.ExecuteReader();
int c = 0;
while (dr.Read())
{
checkedListBox1.Items.Add(dr.GetValue(0) + " - " + dr.GetValue(1) + " " + dr.GetValue(2) + " - " + dr.GetValue(3));
checkedListBox1.SetItemChecked(c, true);
c++;
}
}
if (type == "short")
{
con.Open();
this.ControlBox = false;
metroTextBox1.Text = "Lecturer Reminder- (" + batchname + ")";
richTextBox1.AppendText("Lecture Reminder");
richTextBox1.AppendText(Environment.NewLine + "Topic - " + batchname);
//richTextBox1.AppendText(Environment.NewLine + "module - " + module);
richTextBox1.AppendText(Environment.NewLine + "date - " + date);
richTextBox1.AppendText(Environment.NewLine + "time - " + time);
richTextBox1.AppendText(Environment.NewLine + "Venue - " + venue);
SqlCommand cmd = new SqlCommand("SELECT Lecturer_no,F_name,L_name,email FROM Lecture_details WHERE Lecturer_no='" + General_methods.get_lec_no_from_lec_name(lecturer1) + "' OR Lecturer_no='" + General_methods.get_lec_no_from_lec_name(lecturer2) + "' OR Lecturer_no='" + General_methods.get_lec_no_from_lec_name(lecturer3) + "'", con);
SqlDataReader dr = cmd.ExecuteReader();
int c = 0;
while (dr.Read())
{
checkedListBox1.Items.Add(dr.GetValue(0) + " - " + dr.GetValue(1) + " " + dr.GetValue(2) + " - " + dr.GetValue(3));
checkedListBox1.SetItemChecked(c, true);
c++;
}
}
}