private void Btn_Remove_Click(object sender, EventArgs e)
{
if (dgv_show.RowCount > 0)
{
int rownumber = dgv_show.SelectedCells[0].RowIndex;
string reportname = dgv_show.Rows[rownumber].Cells[0].Value.ToString();
string reportType = dgv_show.Rows[rownumber].Cells[1].Value.ToString();
string minutes = dgv_show.Rows[rownumber].Cells[2].Value.ToString();
string hours = dgv_show.Rows[rownumber].Cells[3].Value.ToString();
string day = dgv_show.Rows[rownumber].Cells[4].Value.ToString();
string date = dgv_show.Rows[rownumber].Cells[5].Value.ToString();
string month = dgv_show.Rows[rownumber].Cells[6].Value.ToString();
StringBuilder sql = new StringBuilder();
sql.Append("delete from t_report_schedule where ");
sql.Append("reportname = '" + reportname + "' and ");
sql.Append("reporttype = '" + reportType + "' and ");
sql.Append("Minutes = '" + minutes + "' and ");
sql.Append("hours = '" + hours + "' and ");
sql.Append("day = '" + day + "' and ");
sql.Append("date = '" + date + "' and ");
sql.Append("month = '" + month + "'");
sqlCON connect = new sqlCON();
connect.sqlExecuteNonQuery(sql.ToString(), true);
dtScheduleSendMail = new DataTable();
StringBuilder sql2 = new StringBuilder();
sql2.Append("select reportname, reporttype,Minutes ,hours, day, date, month,isBodyHTML, subject,attach, comments from t_report_schedule where 1=1 ");
sqlCON tf = new sqlCON();
tf.sqlDataAdapterFillDatatable(sql2.ToString(), ref dtScheduleSendMail);
dgv_show.DataSource = dtScheduleSendMail;
dgv_show.Refresh();
}
}
private bool InsertSendMailtoRecord(ScheduleReportItems schedule, string attachFile)
{
StringBuilder sqlinsert = new StringBuilder();
sqlinsert.Append("insert into t_email_record ");
sqlinsert.Append(@"(reportname,reporttype,Minutes,hours,day,date,month,subject,attach,inputdate) values ('");
sqlinsert.Append(schedule.ReportName + "' , '" + schedule.ReportType + "' , '" + schedule.Minutes + "' , '" + schedule.Hours + "', '" + "" + "' , '" + "" + "', '");
sqlinsert.Append("" + "' , '" + schedule.Subject + "' , '" + attachFile + "' , '" + DateTime.Now + "' )");
sqlCON insert = new sqlCON();
insert.sqlExecuteNonQuery(sqlinsert.ToString(), false);
return(true);
}
