public void JustInfo() { string CekDate = DateTime.Now.ToString("yyyy-MM-dd 15:00"); string hari = DateTime.Now.ToString("dd-MM-yyyy"); DateTime time = DateTime.Now; string format = time.ToString("d"); string cs = @"server=localhost;userid=root; password="******";database=telegram-tamansari"; MySqlConnection conn = null; MySqlConnection conn2 = null; MySqlDataReader rdr = null; MySqlDataReader rdr2 = null; conn = new MySqlConnection(cs); conn2 = new MySqlConnection(cs); conn.Open(); string stm = " SELECT id,first_name FROM user "; MySqlCommand cmd = new MySqlCommand(stm, conn); cmd.Parameters.AddWithValue("@waktu", format); rdr = cmd.ExecuteReader(); while (rdr.Read()) { string id_telegram = rdr[0].ToString(); string firstname = rdr[1].ToString(); try { string sql = " SELECT * FROM alert WHERE userid!=@id and DATE_FORMAT(created_at,'%d/%m/%Y')=@waktu"; MySqlCommand cmd2 = new MySqlCommand(sql, conn2); conn2.Open(); cmd2.Parameters.AddWithValue("@id", id_telegram); cmd2.Parameters.AddWithValue("@waktu", format); rdr2 = cmd2.ExecuteReader(); if (rdr2.HasRows) { } else { string messageToSend = "Bapak / Ibu " + firstname.ToUpper() + " Yth , Sekedar mengingatkan u "; string TOKEN = Token(); InsertAlert(id_telegram, messageToSend); Pesan pesan = new Pesan(); pesan.pm(TOKEN, id_telegram, messageToSend); } conn2.Close(); } catch (Exception error) { conn.Close(); Log log = new Log(); log.CreateLog("error-alert", error.StackTrace, error.Message, null); SendMail mail = new SendMail(); mail.SendEmailKeIT("Error alert", error.Message); } } rdr2.Dispose(); rdr.Dispose(); conn.Close(); conn2.Close(); }
public void Alert() { string CekDate = DateTime.Now.ToString("yyyy-MM-dd 15:00"); string hari = DateTime.Now.ToString("dd-MM-yyyy"); DateTime time = DateTime.Now; string format = DateTime.Now.ToString("dd/MM/yyyy"); string cs = @"server=localhost;userid=root; password="******";database=telegram-tamansari"; MySqlConnection conn = null; MySqlConnection conn2 = null; MySqlDataReader rdr = null; conn = new MySqlConnection(cs); conn2 = new MySqlConnection(cs); conn.Open(); string stm = " SELECT id,first_name FROM user WHERE id NOT IN " + "( " + " SELECT userid FROM laporan " + " WHERE DATE_FORMAT(created_at,'%d/%m/%Y')='" + format + "'" + " ) and id!='206390585' ORDER BY first_name ASC"; MySqlCommand cmd = new MySqlCommand(stm, conn); //cmd.Parameters.AddWithValue("@waktu", format); rdr = cmd.ExecuteReader(); while (rdr.Read()) { string id_telegram = rdr[0].ToString(); string firstname = rdr[1].ToString(); try { #region off //string sql = " SELECT * FROM alert WHERE userid=@id and DATE_FORMAT(created_at,'%d/%m/%Y')=@waktu"; //MySqlCommand cmd2 = new MySqlCommand(sql, conn2); //conn2.Open(); //cmd2.Parameters.AddWithValue("@id", id_telegram); //cmd2.Parameters.AddWithValue("@waktu", format); //rdr2 = cmd2.ExecuteReader(); //if (rdr2.HasRows) //{ // string messageToSend = "Bapak / Ibu " + firstname.ToUpper() + " Anda Belum Melaporkan Pekerjaan Dinas Harian " + hari +" Mohon Untuk Segera Mengirimkan Laporan tks"; // string TOKEN = Token(); // InsertAlert(id_telegram, messageToSend); // Pesan pesan = new Pesan(); // pesan.pm(TOKEN, id_telegram, messageToSend); //} //else //{ // string messageToSend = "Bapak / Ibu " + firstname.ToUpper() + " Anda Belum Melaporkan Pekerjaan Dinas Harian " + hari + " Mohon Untuk Segera Mengirimkan Laporan tks"; // string TOKEN = Token(); // InsertAlert(id_telegram, messageToSend); // Pesan pesan = new Pesan(); // pesan.pm(TOKEN, id_telegram, messageToSend); //} #endregion Log log = new Log(); log.CreateLog("alert", id_telegram, firstname + "| " + stm, null); string messageToSend = "Bapak / Ibu " + firstname.ToUpper() + ", \nAnda Belum Melaporkan Pekerjaan Dinas Harian " + hari + " Mohon Untuk Segera Mengirimkan Laporan \nTerima kasih"; string TOKEN = Token(); InsertAlert(id_telegram, messageToSend); Pesan pesan = new Pesan(); pesan.pm(TOKEN, id_telegram, messageToSend); conn2.Close(); } catch (Exception error) { conn.Close(); Log log = new Log(); log.CreateLog("error-alert", error.StackTrace, error.Message, null); SendMail mail = new SendMail(); mail.SendEmailKeIT("Error alert", error.Message); } } //rdr2.Dispose(); rdr.Dispose(); conn.Close(); // conn2.Close(); }