public static List <string> getHarvestingJobList() { HarvestingJob harvesting = new HarvestingJob(); List <string> flist = new List <string>(); MySqlDataReader rdr = null; try { string tableName = "harvestingjob"; string query = "SELECT * FROM " + tableName; MySqlCommand cmd = new MySqlCommand(query, MysqlDbc.Instance.getConn()); rdr = cmd.ExecuteReader(); while (rdr.Read()) { harvesting.Description = rdr.GetString("description"); flist.Add(harvesting.Description); } } catch (MySqlException ex) { Console.WriteLine("Error: {0}", ex.ToString()); } finally { if (rdr != null) { rdr.Close(); } } return(flist); }
private void addHarvestingJob() { HarvestingJob hj = new HarvestingJob(); hj.Description = textBox1.Text; hj.SowingJob_id = Convert.ToInt32(cbSoj.Text); string idStr = cbFarm.Text.Split('.')[0]; hj.Farm_id = int.Parse(idStr); string idStr1 = cbCrop.Text.Split('.')[0]; hj.Crop_id = int.Parse(idStr1); string idStr2 = cbVehicle.Text.Split('.')[0]; hj.Vehicle_id = int.Parse(idStr2); hj.Est_quantity = int.Parse(numericUpDown1.Text); hj.Harvested_quantity = int.Parse(numericUpDown2.Text); string idStr3 = cbEmployee.Text.Split('.')[0]; hj.Employee_id = int.Parse(idStr3); hj.Date_start = Convert.ToDateTime(dtpStart1.Value); hj.Date_end = Convert.ToDateTime(dtpEnd.Value); InsertSQL hdl = new InsertSQL(); hdl.addNewHarvestingJob(hj); MessageBox.Show("Success!!"); this.Close(); }
public HarvestingJob GetHarvestingJobFromID(int itemId) { HarvestingJob hj = new HarvestingJob(); MySqlDataReader rdr = null; try { string tableName = "harvestingJob"; string query = "SELECT * FROM " + tableName + " WHERE id = " + itemId; MySqlCommand cmd = new MySqlCommand(query, MysqlDbc.Instance.getConn()); rdr = cmd.ExecuteReader(); while (rdr.Read()) { hj.Id = itemId; hj.Description = rdr.GetString("description"); hj.SowingJob_id = rdr.GetInt32("sowingJob_id"); hj.Farm_id = rdr.GetInt32("farm_id"); hj.Crop_id = rdr.GetInt32("crop_id"); hj.Vehicle_id = rdr.GetInt32("vehicle_id"); hj.Est_quantity = rdr.GetInt32("est_quantity"); hj.Harvested_quantity = rdr.GetInt32("harvested_quantity"); hj.Employee_id = rdr.GetInt32("employee_id"); hj.Date_start = rdr.GetDateTime("date_start"); hj.Date_end = rdr.GetDateTime("date_end"); } } catch (MySqlException ex) { Console.WriteLine("Error: {0}", ex.ToString()); } finally { if (rdr != null) { rdr.Close(); } } return(hj); }