public List <ScheduleReportItems> GetScheduleReportCommon(string ReportName)
{
List <ScheduleReportItems> list = new List <ScheduleReportItems>();
DataTable dt = new DataTable();
StringBuilder sql = new StringBuilder();
sql.Append("select reportname, reporttype, Minutes,hours, day, date, month,isBodyHTML,subject, attach, comments from t_report_schedule where 1=1 and reportname = '" + ReportName + "' ");
sqlCON tf = new sqlCON();
tf.sqlDataAdapterFillDatatable(sql.ToString(), ref dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
ScheduleReportItems item = new ScheduleReportItems();
item.ReportName = dt.Rows[i]["reportname"].ToString();
item.ReportType = dt.Rows[i]["reporttype"].ToString();
item.Minutes = dt.Rows[i]["Minutes"].ToString();
item.Hours = dt.Rows[i]["hours"].ToString();
item.Day = dt.Rows[i]["day"].ToString();
item.Date = dt.Rows[i]["date"].ToString();
item.Month = dt.Rows[i]["month"].ToString();
item.IsBodyHTML = bool.Parse(dt.Rows[i]["isBodyHTML"].ToString());
item.Subject = dt.Rows[i]["subject"].ToString();
item.AttachedFolder = dt.Rows[i]["attach"].ToString();
item.Contents = dt.Rows[i]["comments"].ToString();
list.Add(item);
}
dt = null;
return(list);
}
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);
}
private List <ScheduleReportItems> Listreport(DataTable dt)
{
List <ScheduleReportItems> list = new List <ScheduleReportItems>();
for (int i = 0; i < dt.Rows.Count; i++)
{
ScheduleReportItems item = new ScheduleReportItems();
item.ReportName = dt.Rows[i]["reportname"].ToString();
item.ReportType = dt.Rows[i]["reporttype"].ToString();
item.Minutes = dt.Rows[i]["Minutes"].ToString();
item.Hours = dt.Rows[i]["hours"].ToString();
item.Day = dt.Rows[i]["day"].ToString();
item.Date = dt.Rows[i]["date"].ToString();
item.Month = dt.Rows[i]["month"].ToString();
item.IsBodyHTML = bool.Parse(dt.Rows[i]["isBodyHTML"].ToString());
item.Subject = dt.Rows[i]["subject"].ToString();
item.AttachedFolder = dt.Rows[i]["attach"].ToString();
item.Contents = dt.Rows[i]["comments"].ToString();
list.Add(item);
}
return(list);
}
private bool CheckIsSentMailComplete(ScheduleReportItems scheduleReport)
{
if (scheduleReport.ReportType == "Daily")
{
DataTable dtRecord = new DataTable();
StringBuilder sql = new StringBuilder();
sql.Append("select reportname,reporttype,Minutes,hours,day,date,month,subject,attach,inputdate from t_email_record where ");
sql.Append("reportname = '" + scheduleReport.ReportName + "' and ");
sql.Append("reporttype = '" + scheduleReport.ReportType + "' and ");
sql.Append("Minutes = '" + scheduleReport.Minutes + "' and ");
sql.Append("hours = '" + scheduleReport.Hours + "' and ");
sql.Append("inputdate > '" + DateTime.Now.Date + "'");
sqlCON tf = new sqlCON();
tf.sqlDataAdapterFillDatatable(sql.ToString(), ref dtRecord);
if (dtRecord.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
else if (scheduleReport.ReportType == "Weekly")
{
DataTable dtRecord = new DataTable();
StringBuilder sql = new StringBuilder();
sql.Append("select reportname,reporttype,hours,day,date,month,subject,attach,inputdate from t_email_record where ");
sql.Append("reportname = '" + scheduleReport.ReportName + "' and ");
sql.Append("reporttype = '" + scheduleReport.ReportType + "' and ");
sql.Append("day = '" + scheduleReport.Day + "' and ");
sql.Append("hours = '" + scheduleReport.Hours + "' and ");
sql.Append("Minutes = '" + scheduleReport.Minutes + "' and ");
sql.Append("inputdate > '" + DateTime.Now.Date + "'");
sqlCON tf = new sqlCON();
tf.sqlDataAdapterFillDatatable(sql.ToString(), ref dtRecord);
if (dtRecord.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
else if (scheduleReport.ReportType == "Monthly")
{
DataTable dtRecord = new DataTable();
StringBuilder sql = new StringBuilder();
sql.Append("select reportname,reporttype,hours,day,date,month,subject,attach,inputdate from t_email_record where ");
sql.Append("reportname = '" + scheduleReport.ReportName + "' and ");
sql.Append("reporttype = '" + scheduleReport.ReportType + "' and ");
sql.Append("date = '" + scheduleReport.Date + "' and ");
sql.Append("hours = '" + scheduleReport.Hours + "' and ");
sql.Append("Minutes = '" + scheduleReport.Minutes + "' and ");
sql.Append("inputdate > '" + DateTime.Now.Date + "'");
sqlCON tf = new sqlCON();
tf.sqlDataAdapterFillDatatable(sql.ToString(), ref dtRecord);
if (dtRecord.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
else if (scheduleReport.ReportType == "Yearly")
{
DataTable dtRecord = new DataTable();
StringBuilder sql = new StringBuilder();
sql.Append("select reportname,reporttype,hours,day,date,month,subject,attach,inputdate from t_email_record where ");
sql.Append("reportname = '" + scheduleReport.ReportName + "' and ");
sql.Append("reporttype = '" + scheduleReport.ReportType + "' and ");
sql.Append("month = '" + scheduleReport.Month + "' and ");
sql.Append("date = '" + scheduleReport.Date + "' and ");
sql.Append("hours = '" + scheduleReport.Hours + "' and ");
sql.Append("Minutes = '" + scheduleReport.Minutes + "' and ");
sql.Append("inputdate > '" + DateTime.Now.Date + "'");
sqlCON tf = new sqlCON();
tf.sqlDataAdapterFillDatatable(sql.ToString(), ref dtRecord);
if (dtRecord.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
return(false);
}
