/// <summary>
/// Method to add a new car with all the details.
/// </summary>
public void AddNewCar()
{
var type = comboBoxCarType.Text;
var typeId = context.CarTypes.Where(x => x.Type == type).Select(x => x.TypeId).Distinct();
var make = comboBoxCarMake.Text;
var makeId = context.CarMakes.Where(x => x.Make == make).Select(x => x.MakeId).Distinct();
Car newCar = new Car()
{
TypeId = typeId.First(),
MakeId = makeId.First(),
Color = textBoxCarColor.Text,
Model = textBoxCarModel.Text,
Year = Int32.Parse(textBoxCarYear.Text),
Price = Decimal.Parse(textBoxCarPrice.Text),
};
try
{
context.Cars.Add(newCar);
context.SaveChanges();
MessageBox.Show("Car added successfully");
}
catch (Exception ex)
{
MessageBox.Show("Cannot add car to database" + ex.InnerException.InnerException.Message + "\n Make " + makeId.First());
return;
}
}
public void AddNewCar()
{
context = new CarRentalManagementEntities();
var type = comboBoxCarType.Text;
var typeId = context.CarTypes.Where(x => x.Type == type).Select(x => x.TypeId);
var make = comboBoxCarType.Text;
var makeId = context.CarMakes.Where(x => x.Make == make).Select(x => x.MakeId);
Car newCar = new Car()
{
TypeId = typeId.FirstOrDefault(),
MakeId = makeId.FirstOrDefault(),
Color = textBoxCarColor.Text,
Model = textBoxCarModel.Text,
Year = Int32.Parse(textBoxCarYear.Text),
Price = Decimal.Parse(textBoxCarPrice.Text),
};
try
{
context.Cars.Add(newCar);
context.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show("Cannot add car to database" + ex.InnerException.InnerException.Message);
return;
}
}
public void AddNewCar()
{
context = new CarRentalManagementEntities();
Car newCar = new Car()
{
Color = textBoxCarColor.Text,
Model = textBoxCarModel.Text,
Year = Int32.Parse(textBoxCarYear.Text),
Price = Int32.Parse(textBoxCarPrice.Text),
};
try
{
context.Cars.Add(newCar);
context.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show("Cannot add car to databse" + ex.InnerException.InnerException.Message);
return;
}
}
/// <summary>
/// Method to add new type in car types.
/// </summary>
public void AddNewType()
{
CarRentalManagementEntities entities = new CarRentalManagementEntities();
CarType carType = new CarType()
{
Type = textBoxCarType.Text
};
try
{
entities.CarTypes.Add(carType);
entities.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show("Cannot add Car Type to database" + ex.InnerException.InnerException.Message);
return;
}
this.DialogResult = DialogResult.OK;
entities.Dispose();
Close();
}
private void ButtonAddCarMake_Click(object sender, EventArgs e)
{
CarRentalManagementEntities entities = new CarRentalManagementEntities();
CarMake carMake = new CarMake()
{
Make = textBoxAddCarMake.Text
};
try
{
entities.CarMakes.Add(carMake);
entities.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show("Cannot add Car Make to database" + ex.InnerException.InnerException.Message);
return;
}
this.DialogResult = DialogResult.OK;
entities.Dispose();
Close();
}