public static List <DBOutbox> GetUnsentMessagesByRecipeint(string sender) { List <DBOutbox> data = new List <DBOutbox>(); MySqlConnection con = DBConnection.ConnectDatabase(); try { MySqlCommand cmd = new MySqlCommand("SELECT * FROM " + tablename + " WHERE recipient='"+ sender + "' AND status='Unsuccessful'", con); MySqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { DBOutbox rawData = new DBOutbox(); rawData.ID = reader.GetInt32(0); string sdate = reader.GetString(1).ToString(); DateTime dddate = DateTime.Parse(sdate); rawData.Date = dddate; rawData.Recipient = reader.GetString(2); rawData.Message = reader.GetString(3); rawData.Sent = reader.GetString(4); data.Add(rawData); } } reader.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { con.Close(); } return(data); }
public List <DBOutbox> GetData() { List <DBOutbox> data = new List <DBOutbox>(); MySqlConnection con = DBConnection.ConnectDatabase(); try { MySqlCommand cmd = new MySqlCommand("SELECT * FROM " + tablename, con); MySqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { DBOutbox rawData = new DBOutbox(); rawData.ID = reader.GetInt32(0); string sdate = reader.GetString(1).ToString(); DateTime dddate = DateTime.Parse(sdate); rawData.Date = dddate; rawData.Recipient = reader.GetString(2); rawData.Message = reader.GetString(3); rawData.Sent = reader.GetString(4); data.Add(rawData); } } reader.Close(); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { con.Close(); } return(data); }
public DBOutbox GetDataId(int id) { DBOutbox data = null; MySqlConnection con = DBConnection.ConnectDatabase(); try { MySqlCommand cmd = new MySqlCommand("SELECT * FROM " + tablename + " WHERE id=" + id, con); MySqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { reader.Read(); data = new DBOutbox(); data.ID = reader.GetInt32(0); data.Date = reader.GetDateTime(1); data.Recipient = reader.GetString(2); data.Message = reader.GetString(3); data.Sent = reader.GetString(4); } reader.Close(); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { con.Close(); } return(data); }
public static DBOutbox GetDataMessage(string message, string status) { DBOutbox data = null; MySqlConnection con = DBConnection.ConnectDatabase(); try { MySqlCommand cmd = new MySqlCommand("SELECT * FROM " + tablename + " WHERE message LIKE '%" + message + "%' AND status='" + status + "'", con); MySqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { reader.Read(); data = new DBOutbox(); data.ID = reader.GetInt32(0); data.Date = DateTime.Parse(reader.GetDateTime(1).ToString()); data.Recipient = reader.GetString(2); data.Message = reader.GetString(3); data.Sent = reader.GetString(4); } reader.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { con.Close(); } return(data); }