public void initiate_sending()
{
String query = "";
String send_date = "";
String send_time = "";
do
{
try
{
send_date = gm.toDateString(DateTime.Now.ToString("yyyy-MM-dd"), "yyyy-MM-dd");
query = "SELECT tbid FROM rssys.tb_hdr WHERE send_date = '" + send_date + "' ORDER BY send_date DESC";
date_to_send = db.QueryBySQLCode(query);
if (date_to_send.Rows.Count > 0)
{
for (int i = 0; i < date_to_send.Rows.Count; i++)
{
send_text_blast(date_to_send.Rows[i]["tbid"].ToString());
}
}
else
{
Thread.Sleep(10000);
}
}
catch (Exception ex)
{
}
} while (true);
}
public void initiate_sending()
{
String query = "";
String send_date = "";
String send_time = "";
do
{
try
{
send_date = gm.toDateString(DateTime.Now.ToString("yyyy-MM-dd"), "yyyy-MM-dd");
query = "SELECT tb_emailid,message,file_path,sender_email,sender_pass FROM rssys.tb_emailhdr WHERE send_date <= '" + db.get_systemdate("yyyy-MM-dd") + "' AND time_sent <= '" + DateTime.Now.ToString("hh:mm tt") + "'ORDER BY send_date DESC";
date_to_send = db.QueryBySQLCode(query);
if (date_to_send.Rows.Count > 0)
{
for (int i = 0; i < date_to_send.Rows.Count; i++)
{
send_email_blast(date_to_send.Rows[i]["tb_emailid"].ToString(), date_to_send.Rows[i]["message"].ToString(), date_to_send.Rows[i]["file_path"].ToString(), date_to_send.Rows[i]["sender_email"].ToString(), date_to_send.Rows[i]["sender_pass"].ToString());
lbl_status.Invoke(new Action(() =>
{
lbl_status.Text = "IDLE";
}));
}
}
else
{
Thread.Sleep(3000);
}
}
catch (Exception ex)
{
}
} while (true);
}
