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