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