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