private void cmd_save_Click(object sender, EventArgs e)
{
if (isadd == true)
{
//add new record
DBPrepaidCards prep = new DBPrepaidCards(txtCable.Text, Int32.Parse(txtAmount.Text), txtPin.Text, "Pending", dateTimePicker_DateReg.Value, dateTimePicker_Expire.Value);
prep.Add();
}
else
{
//edit record
int id = Int32.Parse(dataGridView_PrepaidCards.CurrentRow.Cells[0].Value.ToString());
DBPrepaidCards rec = DBPrepaidCards.GetDataID(id);
rec.Amount = Int32.Parse(txtAmount.Text);
rec.CableType = txtCable.Text;
rec.Date_Expired = dateTimePicker_Expire.Value;
rec.Date_Registered = dateTimePicker_DateReg.Value;
rec.Pin = txtPin.Text;
rec.Update();
}
display();
}
private void cmd_delete_Click(object sender, EventArgs e)
{
int id = Int32.Parse(dataGridView_PrepaidCards.CurrentRow.Cells[0].Value.ToString());
DBPrepaidCards rec = DBPrepaidCards.GetDataID(id);
rec.Delete();
display();
}
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);
}
public void display()
{
try
{
BindingSource bindingsource = new BindingSource();
List <DBPrepaidCards> rec = DBPrepaidCards.GetData();
foreach (DBPrepaidCards data in rec)
{
bindingsource.Add(data);
}
this.dataGridView_PrepaidCards.Refresh();
this.dataGridView_PrepaidCards.DataSource = bindingsource;
}
catch (Exception ex)
{
ex.ToString();
}
}
public static DBPrepaidCards GetDataID(int id)
{
DBPrepaidCards 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 DBPrepaidCards();
data.Id = reader.GetInt32(0);
data.CableType = reader.GetString(1);
data.Amount = reader.GetInt32(2);
data.Pin = reader.GetString(3);
data.Status = reader.GetString(4);
data.Date_Registered = reader.GetDateTime(5);
data.Date_Expired = reader.GetDateTime(6);
}
reader.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
MessageBox.Show(ex.ToString());
}
finally
{
con.Close();
}
return(data);
}
public static DBPrepaidCards GetDataByAmount(int amount, string cableType)
{
DBPrepaidCards data = null;
MySqlConnection con = DBConnection.ConnectDatabase();
try
{
MySqlCommand cmd = new MySqlCommand("SELECT amount,pin,id,cableType 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);
data.CableType = reader.GetString(3);
}
reader.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
MessageBox.Show(ex.ToString());
}
finally
{
con.Close();
}
return(data);
}
