private void MainForm_Load(object sender, EventArgs e)
{
try
{
// show makes
comboBoxMake.DataSource = DBMgr.getTable("Make");
comboBoxMake.DisplayMember = "Name";
comboBoxMake.ValueMember = "MakeId";
// show models
comboBoxModel.DataSource = DBMgr.getTable("VehicleModel");
comboBoxModel.DisplayMember = "Name";
comboBoxModel.ValueMember = "ModelId";
// show vehicle types
comboBoxVehicleType.DataSource = DBMgr.getTable("VehicleType");
comboBoxVehicleType.DisplayMember = "Name";
comboBoxVehicleType.ValueMember = "Name";
// list of vehicle id
comboBoxVehicles.DataSource = DBMgr.getTable("Vehicle");
comboBoxVehicles.DisplayMember = "VehicleId";
comboBoxVehicles.ValueMember = "VehicleId";
}
catch (Exception ex)
{
MessageBox.Show("Error reading data base", ex.Message);
}
}
private void buttonVehicles_Click(object sender, EventArgs e)
{
// show vehicles in data grid
try
{
dataGridView1.DataSource = DBMgr.getTable("Vehicle");
}
catch (Exception ex)
{
MessageBox.Show("Error reading data base", ex.Message);
}
}
private void buttonDelete_Click(object sender, EventArgs e)
{
if (comboBoxVehicles.SelectedValue != null)
{
// read vehicle
int vehicleid = (int)comboBoxVehicles.SelectedValue;
DBMgr.deleteVehicle(vehicleid);
// list of vehicle id
comboBoxVehicles.DataSource = DBMgr.getTable("Vehicle");
comboBoxVehicles.DisplayMember = "VehicleId";
comboBoxVehicles.ValueMember = "VehicleId";
clearControls();
}
}
private void buttonUpdate_Click(object sender, EventArgs e)
{
// update a vehicle
try
{
// get make id
string make = comboBoxMake.Text.Trim();
if (make.Length == 0)
{
MessageBox.Show("Please Enter/select a Make");
return;
}
int makeid = DBMgr.getNameId(make, "Make", "MakeId", null);
// get model
string model = comboBoxModel.Text.Trim();
if (model.Length == 0)
{
MessageBox.Show("Please Enter/select a Mudel");
return;
}
// get vehicle type
string vehicleType = comboBoxVehicleType.Text.Trim();
if (vehicleType.Length == 0)
{
MessageBox.Show("Please Enter a Vehicle Type");
return;
}
int vehicleTypeId = DBMgr.getNameId(vehicleType, "VehicleType", "VehicleTypeId", null);
// make model
VehicleModel vm = new VehicleModel();
vm.Name = model;
// engine size
int engineSize = 0;
if (!int.TryParse(textBoxEngineSize.Text, out engineSize))
{
MessageBox.Show("Please Enter a proper Engine Size");
return;
}
// number of doors
vm.EngineSize = engineSize;
int numberOfDoors = 0;
if (!int.TryParse(textBoxNumberOfDoors.Text, out numberOfDoors))
{
MessageBox.Show("Please Enter a proper Number of Doors");
return;
}
vm.NumberOfDoors = numberOfDoors;
// get colour
vm.Colour = comboBoxColor.Text.Trim();
if (vm.Colour.Length == 0)
{
MessageBox.Show("Please Enter a proper vehicle Colour");
return;
}
// assign vehicle id
vm.VehicleTypeId = vehicleTypeId;
// get model id
int vehicleModelId = DBMgr.getNameId(model, "VehicleModel", "ModelId", vm);
vm.ModelId = vehicleModelId;
// update vehicle model
DBMgr.updateModel(vm);
// get vehicle
Vehicle v = new Vehicle();
v.VehicleId = int.Parse(comboBoxVehicles.Text);
v.ModelId = vm.ModelId;
v.MakeId = makeid;
// get year
int year = 0;
if (!int.TryParse(comboBoxYear.Text, out year))
{
MessageBox.Show("Please Enter a proper year");
return;
}
v.Year = year;
// get yprice
double price = 0;
if (!double.TryParse(textBoxPrice.Text, out price))
{
MessageBox.Show("Please Enter a proper price");
return;
}
v.Price = price;
// get cost
double cost = 0;
if (!double.TryParse(textBoxCost.Text, out cost))
{
MessageBox.Show("Please Enter a proper cost");
return;
}
v.Cost = cost;
// get sold date
v.SoldDate = dateTimePickerSoldDate.Value;
// get sold
v.Sold = checkBoxSoldDate.Checked;
// updae vehicle
DBMgr.updateVehicle(v);
// update makes
comboBoxMake.DataSource = DBMgr.getTable("Make");
comboBoxMake.DisplayMember = "Name";
comboBoxMake.ValueMember = "MakeId";
// update models
comboBoxModel.DataSource = DBMgr.getTable("VehicleModel");
comboBoxModel.DisplayMember = "Name";
comboBoxModel.ValueMember = "ModelId";
// update vehicle types
comboBoxVehicleType.DataSource = DBMgr.getTable("VehicleType");
comboBoxVehicleType.DisplayMember = "Name";
comboBoxVehicleType.ValueMember = "Name";
// show this vehicle id
comboBoxVehicles.Text = v.VehicleId.ToString();
show_vehicle();
}
catch (Exception ex)
{
MessageBox.Show("Error reading data base", ex.Message);
}
}
