public static DBPrepaidCards GetDataByAmount(int amount, string cableType)
{
DBPrepaidCards data = null;
MySqlConnection con = DBConnection.ConnectDatabase();
try
{
MySqlCommand cmd = new MySqlCommand("SELECT amount,pin,id FROM " + tablename + " WHERE id=(SELECT MIN(id) from " + tablename + " WHERE cableType='" + cableType + "' AND amount=" + amount + ") ", con);
MySqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
data = new DBPrepaidCards();
data.Amount = reader.GetInt32(0);
data.Pin = reader.GetString(1);
data.Id = reader.GetInt32(2);
}
reader.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
MessageBox.Show(ex.ToString());
}
finally
{
con.Close();
}
return(data);
}
public static DBPrepaidCards GetDataID(string id)
{
DBPrepaidCards data = null;
MySqlConnection con = DBConnection.ConnectDatabase();
try
{
MySqlCommand cmd = new MySqlCommand("SELECT id FROM " + tablename + " WHERE id=" + id, con);
MySqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
data = new DBPrepaidCards();
data.Id = reader.GetInt32(0);
}
reader.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
MessageBox.Show(ex.ToString());
}
finally
{
con.Close();
}
return(data);
}
public static List <DBPrepaidCards> GetData()
{
List <DBPrepaidCards> data = new List <DBPrepaidCards>();
MySqlConnection con = DBConnection.ConnectDatabase();
try
{
MySqlCommand cmd = new MySqlCommand("SELECT * FROM " + tablename, con);
MySqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
DBPrepaidCards rawData = new DBPrepaidCards();
rawData.Id = reader.GetInt32(0);
rawData.cableType = reader.GetString(1);
rawData.Amount = reader.GetInt32(2);
rawData.Pin = reader.GetString(3);
rawData.Status = reader.GetString(4);
rawData.Date_Registered = reader.GetDateTime(5);
rawData.Date_Expired = reader.GetDateTime(6);
data.Add(rawData);
}
}
reader.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
return(data);
}
