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); }