private void btnCreateMemo_Click(object sender, EventArgs e)
{
if (tblSelectedList.Rows.Count != 0)
{
thisArr = new string[tblSelectedList.Rows.Count];
for (int i = 0; i < tblSelectedList.Rows.Count; i++)
{
thisArr[i] = tblSelectedList.Rows[i].Cells[1].Value.ToString();
}
foreach (string i in thisArr)
{
string _id = csm.countSQL("select id from offensesnpenalty where concat(sec_code,' ',subsec_name) = '" + i + "'", "id");
string _Section = csm.countSQL("select concat('SECTION ',sec_num, ' ',sec_name) as penalty from offensesnpenalty where concat(sec_code,' ',subsec_name) = '" + i + "'", "penalty");
string _paragraph = csm.countSQL("select concat('Paragraph ', sec_code,' ',description ) as penalty from offensesnpenalty where concat(sec_code,' ',subsec_name) = '" + i + "'", "penalty");
dgv.Rows.Add(_id, _Section, _paragraph);
using (NarrativeMemoForm nmf = new NarrativeMemoForm(user_id))
{
nmf.addtoPenalty(_id, memono);
}
}
this.Dispose();
}
else
{
MessageBox.Show("Select a section paragraph!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void btnNotice_Click(object sender, EventArgs e)
{
using (NarrativeMemoForm nmf = new NarrativeMemoForm(user_id))
{
this.Dispose();
nmf.ShowDialog();
}
}
private void forNoticetoExplain()
{
using (NarrativeMemoForm nmf = new NarrativeMemoForm(empid))
{
MySqlDataReader _reader = csm.sqlCommand("Select *,YEAR(nte.date_reported)as _year, Day(nte.date_reported)as _day, Month(nte.date_reported)as _mon, date_format(date_created, '%m/%d/%Y')as'datecreated' from noticetoexplain nte inner join record r on nte.memo_no = r.memo_no where nte.memo_no = '" + tblDraft.CurrentRow.Cells[0].Value.ToString() + "'").ExecuteReader();
while (_reader.Read())
{
nmf.lblGenRecNo.Text = _reader.GetString("memo_no");
nmf.txtDateNow.Text = _reader.GetString("datecreated");
nmf.dtReported.Value = new DateTime(int.Parse(_reader.GetString("_year")), int.Parse(_reader.GetString("_mon")), int.Parse(_reader.GetString("_day")));
nmf.txtSubject.Text = _reader.GetString("title");
nmf.txtFinding.Text = _reader.GetString("findings");
nmf.txtMngComm.Text = _reader.GetString("commentary");
nmf.ShowDialog();
}
csm.closeSql();
}
}
private void printPreview(string memono)
{
using (NarrativeMemoForm nmf = new NarrativeMemoForm(empid))
{
MySqlDataReader _reader = csm.sqlCommand("Select *,YEAR(nte.date_reported)as _year, Day(nte.date_reported)as _day, Month(nte.date_reported)as _mon, date_format(date_created, '%m/%d/%Y')as'datecreated' from noticetoexplain nte inner join record r on nte.memo_no = r.memo_no where nte.memo_no = '" + memono + "'").ExecuteReader();
while (_reader.Read())
{
nmf.lblGenRecNo.Text = _reader.GetString("memo_no");
nmf.txtDateNow.Text = _reader.GetString("datecreated");
nmf.retrieveEmployee(_reader.GetString("empid_to"));
nmf.dtReported.Value = new DateTime(int.Parse(_reader.GetString("_year")), int.Parse(_reader.GetString("_mon")), int.Parse(_reader.GetString("_day")));
nmf.txtSubject.Text = _reader.GetString("title");
nmf.txtFinding.Text = _reader.GetString("findings");
nmf.txtMngComm.Text = _reader.GetString("commentary");
nmf.printPreview();
}
}
}
