public int addNewPesticide(Pesticide pesticide) { MySqlCommand sqlComm = new MySqlCommand("INSERT INTO" + " pesticide(name, quantity_kg, remark)" + " VALUES" + " (@name, @quantity_kg, @remark)", MysqlDbc.Instance.getConn()); sqlComm.Parameters.Add("@name", MySqlDbType.Text).Value = pesticide.Name; sqlComm.Parameters.Add("@quantity_kg", MySqlDbType.UInt32).Value = pesticide.Quantity_kg; sqlComm.Parameters.Add("@remark", MySqlDbType.Text).Value = pesticide.Remark; return(sqlComm.ExecuteNonQuery()); }
public int updatePesticide(Pesticide pesticide) { string query = "UPDATE" + " pesticide SET name=@name, quantity_kg=@quantity_kg, remark=@remark " + "WHERE id = " + pesticide.Id; MySqlCommand sqlComm = new MySqlCommand(query, MysqlDbc.Instance.getConn()); sqlComm.Parameters.Add("@name", MySqlDbType.Text).Value = pesticide.Name; sqlComm.Parameters.Add("@quantity_kg", MySqlDbType.UInt32).Value = pesticide.Quantity_kg; sqlComm.Parameters.Add("@remark", MySqlDbType.Text).Value = pesticide.Remark; return(sqlComm.ExecuteNonQuery()); }
public List <Pesticide> GetPesticideList() //string employee_id { List <Pesticide> pesticideLists = new List <Pesticide>(); MySqlDataReader rdr = null; try { string stm = "SELECT * FROM pesticide"; MySqlCommand cmd = new MySqlCommand(stm, MysqlDbc.Instance.getConn()); rdr = cmd.ExecuteReader(); while (rdr.Read()) { Pesticide sj1 = new Pesticide(); sj1.Id = rdr.GetInt32("id");; sj1.Name = rdr.GetString("name"); sj1.Quantity_kg = rdr.GetInt32("quantity_kg"); sj1.Remark = rdr.GetString("remark"); pesticideLists.Add(sj1); } } catch (MySqlException ex) { Console.WriteLine("Error: {0}", ex.ToString()); } finally { if (rdr != null) { rdr.Close(); } } return(pesticideLists); }