public void update()
{
SowingJob s1 = new SowingJob();
s1.Id = sowj.Id;
s1.Description = tbDescription.Text;
string idStr = cbCrop.Text.Split('.')[0];
s1.Crop_id = int.Parse(idStr);
s1.Quantity_prop = int.Parse(nUDQty.Text);
string idStr1 = cbFarm.Text.Split('.')[0];
s1.Farm_id = int.Parse(idStr1);
s1.Used_area = textBox1.Text;
string idStr2 = cbVehicle.Text.Split('.')[0];
s1.Vehicle_id = int.Parse(idStr2);
string idStr3 = cbEmployee.Text.Split('.')[0];
s1.Employee_id = int.Parse(idStr3);
s1.Date_start = this.dtpDate.Value;
s1.Date_end = this.dtpDateEnd.Value;
UpdateSQL add = new UpdateSQL();
int addrecord = add.UpdateSowingJob(s1);
MessageBox.Show("Success!!");
this.Close();
}
public void add()
{
//checkAsignJobandAdd();
SowingJob s1 = new SowingJob();
s1.Description = tbDescription.Text;
string idStr = cbCrop.Text.Split('.')[0];
s1.Crop_id = int.Parse(idStr);
s1.Quantity_prop = Int32.Parse(nUDQty.Text);
string idStr1 = cbFarm.Text.Split('.')[0];
s1.Farm_id = int.Parse(idStr1);
s1.Used_area = textBox1.Text;
string idStr2 = cbVehicle.Text.Split('.')[0];
s1.Vehicle_id = int.Parse(idStr2);
string idStr3 = cbEmployee.Text.Split('.')[0];
s1.Employee_id = int.Parse(idStr3);
s1.Date_start = this.dtpDate.Value;
s1.Date_end = this.dtpDateEnd.Value;
//s1.Employee_id = Int32.Parse(cbEmployee.Text);
InsertSQL add = new InsertSQL();
int addrecord = add.addNewSowingJob(s1);
MessageBox.Show("Success!!");
this.Close();
}
public static List <string> getSowingJobList()
{
SowingJob sowing = new SowingJob();
List <string> flist = new List <string>();
MySqlDataReader rdr = null;
try
{
string tableName = "sowingjob";
string query = "SELECT * FROM " + tableName;
MySqlCommand cmd = new MySqlCommand(query, MysqlDbc.Instance.getConn());
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
sowing.Description = rdr.GetString("description");
flist.Add(sowing.Description);
}
}
catch (MySqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
}
finally
{
if (rdr != null)
{
rdr.Close();
}
}
return(flist);
}
private void FormStoringJob_Load(object sender, EventArgs e)
{
InsertSQL StoringJob = new InsertSQL();
if (state == "Edit")
{
textBox1.Text = sj1.Description;
cbHarvest.Text = sj1.Harvest_id.ToString();
cbCrop.Text = sj1.Crop_id.ToString();
cbBox.Text = sj1.Box_id.ToString();
textBox5.Text = sj1.Quantity.ToString();
cbVehicle.Text = sj1.Vehicle_id.ToString();
cbEmployee.Text = sj1.Employee_id.ToString();
dtpStart.Value = sj1.Date_start;
dtpEnd.Value = sj1.Date_end;
TestSQL ts = new TestSQL();
cropLists = ts.GetCropList();
employeeList = ts.GetEmployeeList();
vehicleList = ts.GetVehicleList();
boxList = ts.GetBoxList();
harvestLists = ts.GetHarvestingJobList();
SowingJob sj11 = new SowingJob();
foreach (HarvestingJob harvest in harvestLists)
{
string showText = harvest.Id + ". " + harvest.Description;
cbCrop.Items.Add(showText);
}
foreach (Box box in boxList)
{
string showText = box.Id + ". " + box.Name;
cbCrop.Items.Add(showText);
}
foreach (Crop crop1 in cropLists)
{
string showText = crop1.Id + ". " + crop1.Name;
cbCrop.Items.Add(showText);
}
foreach (Vehicle vehicle in vehicleList)
{
string showText = vehicle.Id + ". " + vehicle.Name;
cbVehicle.Items.Add(showText);
}
foreach (Employee employee in employeeList)
{
if (employee.Admin == false)
{
string showText = employee.Id + ". " + employee.Username;
cbEmployee.Items.Add(showText);
}
}
}
}
public SowingJob GetSowingJobFromID(int itemId)
{
SowingJob sj1 = new SowingJob();
MySqlDataReader rdr = null;
try
{
string tableName = "sowingjob";
string query = "SELECT * FROM " + tableName + " WHERE id = " + itemId;
MySqlCommand cmd = new MySqlCommand(query, MysqlDbc.Instance.getConn());
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
sj1.Id = itemId;
sj1.Description = rdr.GetString("description");
sj1.Crop_id = rdr.GetInt32("crop_id");
sj1.Quantity_prop = rdr.GetInt32("quantity_prop");
sj1.Farm_id = rdr.GetInt32("farm_id");
sj1.Used_area = rdr.GetString("used_area");
sj1.Vehicle_id = rdr.GetInt32("vehicle_id");
sj1.Employee_id = rdr.GetInt32("employee_id");
sj1.Date_start = rdr.GetDateTime("date_start");
sj1.Date_end = rdr.GetDateTime("date_end");
//sj1.Time_start = rdr.GetDateTime("time_start");
//sj1.Time_end = rdr.GetDateTime("time_end");
}
}
catch (MySqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
}
finally
{
if (rdr != null)
{
rdr.Close();
}
}
return(sj1);
}
private void FormPesticideJob_Load(object sender, EventArgs e)
{
InsertSQL pesticideJob = new InsertSQL();
if (state == "Edit")
{
textBox1.Text = pjj11.Description;
cbPesticide.Text = pjj11.Pesticide_id.ToString();
textBox3.Text = pjj11.Quantity_kg.ToString();
cbSoj.Text = pjj11.SowingJob_id.ToString();
cbFarm.Text = pjj11.Farm_id.ToString();
cbCrop.Text = pjj11.Crop_id.ToString();
cbVehicle.Text = pjj11.Vehicle_id.ToString();
cbEmployee.Text = pjj11.Employee_id.ToString();
dtpStart.Value = pjj11.Date_start;
dtpEnd.Value = pjj11.Date_end;
TestSQL ts = new TestSQL();
cropLists = ts.GetCropList();
employeeList = ts.GetEmployeeList();
farmLists = ts.GetFarmList();
vehicleList = ts.GetVehicleList();
pesticideList = ts.GetPesticideList();
sowingLists = ts.GetSowingJobList();
employeeList = ts.GetEmployeeList();
SowingJob sj11 = new SowingJob();
foreach (SowingJob sow in sowingLists)
{
cbSoj.Items.Add(sow.Id);
}
foreach (Crop crop1 in cropLists)
{
string showText = crop1.Id + ". " + crop1.Name;
cbCrop.Items.Add(showText);
}
foreach (Pesticide pest in pesticideList)
{
string showText = pest.Id + ". " + pest.Name;
cbVehicle.Items.Add(showText);
}
foreach (Vehicle vehicle in vehicleList)
{
string showText = vehicle.Id + ". " + vehicle.Name;
cbVehicle.Items.Add(showText);
}
foreach (Employee employee in employeeList)
{
if (employee.Admin == false)
{
string showText = employee.Id + ". " + employee.Username;
cbEmployee.Items.Add(showText);
}
}
foreach (Farm farm in farmLists)
{
string showText = farm.Id + ". " + farm.Description;
cbFarm.Items.Add(showText);
}
}
}
private void FormSowingJob_Load(object sender, EventArgs e)
{
InsertSQL sowing = new InsertSQL();
if (state == "Edit")
{
tbDescription.Text = sowj.Description;
cbCrop.Text = sowj.Crop_id.ToString();
nUDQty.Text = sowj.Quantity_prop.ToString();
cbFarm.Text = sowj.Farm_id.ToString();
textBox1.Text = sowj.Used_area.ToString();
cbVehicle.Text = sowj.Vehicle_id.ToString();
cbEmployee.Text = sowj.Employee_id.ToString();
dtpDate.Value = sowj.Date_start;
dtpDateEnd.Value = sowj.Date_end;
}
// when form loads, get all fields data from mysql
// then store to a bunch of list<class>
// then all combo boxes gets data from the list<class>
// mysql :
// 1. get crop list from crop table
// 2. get farm list from farm table
// 3. get vehicle list from vehicle table
// 4. get employee list from employee table
// combo box
// 5. load crop list to combo box
// 6. load farm list to combo box
// 7. load vehicle list to combo box
// 8. load employee list to combo box
// 1.
TestSQL ts = new TestSQL();
cropLists = ts.GetCropList();
employeeList = ts.GetEmployeeList();
farmLists = ts.GetFarmList();
vehicleList = ts.GetVehicleList();
SowingJob sj11 = new SowingJob();
// // 5.
foreach (Crop crop in cropLists)
{
string showText = crop.Id + ". " + crop.Name;
cbCrop.Items.Add(showText);
}
foreach (Vehicle vehicle in vehicleList)
{
string showText = vehicle.Id + ". " + vehicle.Name;
cbVehicle.Items.Add(showText);
}
foreach (Employee employee in employeeList)
{
if (employee.Admin == false)
{
string showText = employee.Id + ". " + employee.Username;
cbEmployee.Items.Add(showText);
}
}
foreach (Farm farm in farmLists)
{
string showText = farm.Id + ". " + farm.Description;
cbFarm.Items.Add(showText);
}
}
private void FormHarvestingJob_Load(object sender, EventArgs e)
{
InsertSQL crop = new InsertSQL();
if (state == "Edit")
{
textBox1.Text = hj11.Description;
cbSoj.Text = hj11.SowingJob_id.ToString();
cbFarm.Text = hj11.Farm_id.ToString();
cbCrop.Text = hj11.Crop_id.ToString();
cbVehicle.Text = hj11.Vehicle_id.ToString();
numericUpDown1.Text = hj11.Est_quantity.ToString();
numericUpDown2.Text = hj11.Harvested_quantity.ToString();
cbEmployee.Text = hj11.Employee_id.ToString();
dtpStart1.Text = hj11.Date_start.ToString();
dtpEnd.Text = hj11.Date_end.ToString();
TestSQL ts = new TestSQL();
cropLists = ts.GetCropList();
employeeList = ts.GetEmployeeList();
farmLists = ts.GetFarmList();
vehicleList = ts.GetVehicleList();
sowingLists = ts.GetSowingJobList();
SowingJob sj11 = new SowingJob();
foreach (SowingJob sow in sowingLists)
{
cbSoj.Items.Add(sow.Id);
}
foreach (Crop crop1 in cropLists)
{
string showText = crop1.Id + ". " + crop1.Name;
cbCrop.Items.Add(showText);
}
foreach (Vehicle vehicle in vehicleList)
{
string showText = vehicle.Id + ". " + vehicle.Name;
cbVehicle.Items.Add(showText);
}
foreach (Employee employee in employeeList)
{
if (employee.Admin == false)
{
string showText = employee.Id + ". " + employee.Username;
cbEmployee.Items.Add(showText);
}
}
foreach (Farm farm in farmLists)
{
string showText = farm.Id + ". " + farm.Description;
cbFarm.Items.Add(showText);
//cbFarm.Items.Add(farm.Id);
//cbFarm.Items.Add(farm.Description);
}
}
}
