public static DBPrepaidCable GetDataByCode(string code) { DBPrepaidCable data = null; MySqlConnection con = DBConnection.ConnectDatabase(); try { MySqlCommand cmd = new MySqlCommand("SELECT * FROM " + tablename + " WHERE code ='" + code + "'", con); MySqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { reader.Read(); data = new DBPrepaidCable(); data.Id = reader.GetInt32(0); data.Code = reader.GetString(1); data.Description = reader.GetString(2); data.Gateway = reader.GetString(3); } reader.Close(); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { con.Close(); } return(data); }
public static List <DBPrepaidCable> GetData() { List <DBPrepaidCable> data = new List <DBPrepaidCable>(); MySqlConnection con = DBConnection.ConnectDatabase(); try { MySqlCommand cmd = new MySqlCommand("SELECT * FROM " + tablename, con); MySqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { DBPrepaidCable rawData = new DBPrepaidCable(); rawData.Id = reader.GetInt32(0); rawData.Code = reader.GetString(1); rawData.Description = reader.GetString(2); rawData.Gateway = reader.GetString(3); data.Add(rawData); } } reader.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { con.Close(); } return(data); }