public static List <string> getFertiliserList() { Fertiliser fertiliser = new Fertiliser(); List <string> flist = new List <string>(); MySqlDataReader rdr = null; try { string tableName = "fertiliser"; string query = "SELECT * FROM " + tableName; MySqlCommand cmd = new MySqlCommand(query, MysqlDbc.Instance.getConn()); rdr = cmd.ExecuteReader(); while (rdr.Read()) { fertiliser.Name = rdr.GetString("name"); flist.Add(fertiliser.Name); } } catch (MySqlException ex) { Console.WriteLine("Error: {0}", ex.ToString()); } finally { if (rdr != null) { rdr.Close(); } } return(flist); }
private void addFertiliser() { Fertiliser f1 = new Fertiliser(); f1.Name = textBox1.Text; f1.Quantity_kg = Convert.ToInt32(textBox2.Text); f1.Remark = textBox3.Text; InsertSQL add = new InsertSQL(); int addrecord = add.addNewFertiliser(f1); MessageBox.Show("Seccuess!!"); this.Close(); }
private void updateFertiliser() { Fertiliser f1 = new Fertiliser(); f1.Id = f11.Id; f1.Name = textBox1.Text; f1.Quantity_kg = Convert.ToInt32(textBox2.Text); f1.Remark = textBox3.Text; UpdateSQL add = new UpdateSQL(); int editrecord = add.updateFertiliser(f1); MessageBox.Show("Seccuess!!"); this.Close(); }
public Fertiliser GetFertiliserFromID(int itemId) { Fertiliser fer = new Fertiliser(); MySqlDataReader rdr = null; try { string tableName = "fertiliser"; string query = "SELECT * FROM " + tableName + " WHERE id = " + itemId; MySqlCommand cmd = new MySqlCommand(query, MysqlDbc.Instance.getConn()); rdr = cmd.ExecuteReader(); while (rdr.Read()) { fer.Id = itemId; fer.Name = rdr.GetString("descriptionst_name"); fer.Quantity_kg = rdr.GetInt32("area"); fer.Remark = rdr.GetString("utilize_area"); } } catch (MySqlException ex) { Console.WriteLine("Error: {0}", ex.ToString()); } finally { if (rdr != null) { rdr.Close(); } } return(fer); }