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);
}
}
private void show_vehicle()
{
if (comboBoxVehicles.SelectedValue != null)
{
// read vehicle
int vehicleid = (int)comboBoxVehicles.SelectedValue;
Vehicle v = DBMgr.getVehicleById(vehicleid);
string make = DBMgr.getMakeById(v.MakeId);
VehicleModel model = DBMgr.getModelById(v.ModelId);
// update combo's
int index = -1;
int i = 0;
foreach (DataRowView x in comboBoxModel.Items)
{
string name = x.Row["Name"].ToString();
if (name == model.Name)
{
index = i;
break;
}
i++;
}
if (index >= 0)
{
comboBoxModel.SelectedIndex = index;
}
i = 0;
index = -1;
foreach (DataRowView x in comboBoxMake.Items)
{
string name = x.Row["Name"].ToString();
if (name == make)
{
index = i;
break;
}
i++;
}
if (index >= 0)
{
comboBoxMake.SelectedIndex = index;
}
// update details
if (v != null)
{
comboBoxYear.Text = v.Year.ToString();
textBoxPrice.Text = v.Price.ToString();
textBoxCost.Text = v.Cost.ToString();
dateTimePickerSoldDate.Value = v.SoldDate;
checkBoxSoldDate.Checked = v.Sold;
}
}
}