public List <StorageUnit> getStorageUnits()
{
List <StorageUnit> storageUnits = new List <StorageUnit>();
if (con.OpenConnection())
{
DbDataReader dr = con.Select("SELECT s.storageUnitId AS Id, s.storageReference AS Name, s.storageUnitCapacity AS Total, s.storedCapacity AS Stock, c.cropName AS Crop FROM StorageUnits AS s, Crops AS c WHERE s.storedCropId = c.cropId;");
//Read the data and store them in the list
while (dr.Read())
{
StorageUnit storage = new StorageUnit();
storage.Id = dr.GetInt32(0);
storage.Reference = dr.GetString(1);
storage.TotalCapacity = dr.GetInt32(2);
storage.CurrentCapacity = dr.GetInt32(3);
storage.StoredCrop = dr.GetString(4);
storageUnits.Add(storage);
}
//close Data Reader
dr.Close();
con.CloseConnection();
}
return(storageUnits);
}
private void btnAddTask_Click(object sender, EventArgs e)
{
DateTime taskDate = dtTaskDate.Value;
Employee selectedEmployee = (Employee)cmbEmployees.SelectedItem;
int employeeId = selectedEmployee.Id;
TaskType selectedTaskType = (TaskType)cmbTaskTypes.SelectedItem;
int taskTypeId = selectedTaskType.Id;
Crop selectedCrop = (Crop)cmbCrops.SelectedItem;
int cropId = selectedCrop.Id;
Field selectedField = (Field)cmbFields.SelectedItem;
int fieldId = selectedField.Id;
Vehicle selectedVehicle = (Vehicle)cmbVehicles.SelectedItem;
int vehicleId = selectedVehicle.Id;
StorageUnit selectedStorageUnit = (StorageUnit)cmbStorageUnit.SelectedItem;
int storageUnitId = selectedStorageUnit.Id;
BusinessMetaLayer create = BusinessMetaLayer.instance();
//DateTime taskDate = dtTaskDate;
int success;
success = create.setTask(taskDate, employeeId, taskTypeId, cropId, fieldId, vehicleId, storageUnitId);
if (success == 1)
{
MessageBox.Show("Task Created");
}
else
{
MessageBox.Show("A Input is Incorrect.");
}
}
