private void MailSend_FormClosed(object sender, FormClosedEventArgs e)
{
this.Hide();
MeetingConsole3 frm = new MeetingConsole3();
frm.Show();
}
private void buttonMeetingInvitation_Click(object sender, EventArgs e)
{
this.Hide();
MeetingConsole3 frm = new MeetingConsole3();
frm.Show();
}
private void GetBody()
{
MeetingConsole3 frm55 = new MeetingConsole3();
con = new SqlConnection(cs.DBConn);
con.Open();
string query = "Select MeetingDate From Meeting where Meeting.MeetingId='" + meetingId22 + "' ";
cmd = new SqlCommand(query, con);
rdr = cmd.ExecuteReader();
if (rdr.Read())
{
dateTimeYears = (rdr.GetDateTime(0));
}
dateValue = dateTimeYears.ToString("yyyy-MMMM-dd");
timeValue = dateTimeYears.ToString("HH:mm");
con = new SqlConnection(cs.DBConn);
con.Open();
string query2 =
"SELECT AddressHeader.AHeaderName, CompanyAddresses.HouseNo, CompanyAddresses.RoadNo, CompanyAddresses.Area, Thanas.Thana, Districts.District, Divisions.Division,CompanyAddresses.PostOfficeId FROM Meeting INNER JOIN AddressHeader ON Meeting.AHeaderId = AddressHeader.AHeaderId INNER JOIN CompanyAddresses ON AddressHeader.AHeaderId = CompanyAddresses.AHeaderId INNER JOIN PostOffice ON CompanyAddresses.PostOfficeId = PostOffice.PostOfficeId INNER JOIN Thanas ON PostOffice.T_ID = Thanas.T_ID INNER JOIN Districts ON Thanas.D_ID = Districts.D_ID INNER JOIN Divisions ON Districts.Division_ID = Divisions.Division_ID where Meeting.MeetingId='" +
meetingId22 + "' ";
cmd = new SqlCommand(query2, con);
rdr = cmd.ExecuteReader();
if (rdr.Read())
{
addHeader = (rdr.GetString(0));
hNo = (rdr.GetString(1));
rNo = (rdr.GetString(2));
area = (rdr.GetString(3));
thana = (rdr.GetString(4));
dist = (rdr.GetString(5));
division = (rdr.GetString(6));
psId = (rdr.GetInt32(7));
}
txtBody.Text = "Notice is hereby given to you that the " + meetingTitle + " of the Company will be held on " +
dateValue + " at " + timeValue + " am in " + addHeader + ",House-" + hNo + ",Road-" + rNo +
", " + area + ", " + thana + "," + division + ":" + psId + " ";
}