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