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