private void btn_Delete_Click(object sender, EventArgs e)
{
Engine engine = FormToEngine();
CarArr carArr = new CarArr();
carArr.Fill();
if (engine.Id == 0)
{
}
else
{
if (carArr.DoesExist(engine))
{
MessageBox.Show("You can not delete this engine, it is connected" +
" to 1 or more cars", "Can not delete engine",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (MessageBox.Show("Are you sure you want to delete this" +
" Engine? ", "Warning", MessageBoxButtons.YesNo,
MessageBoxIcon.Warning) == DialogResult.Yes)
{
engine.Delete();
ClearForm();
EngineArrToForm(null);
}
}
}
}
private void btn_Save_Click(object sender, EventArgs e)
{
if (CheckForm())
{
Car car = FormToCar();
if (car.Id == 0)
{
if (car.Insert())
{
MessageBox.Show("Data saved successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearForm();
CarArr carArr = new CarArr();
carArr.Fill();
car = carArr.GetCarWithMaxId();
CarArrToForm(car);
}
}
else
{
if (car.Update())
{
MessageBox.Show("Data updated successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearForm();
CarArr carArr = new CarArr();
carArr.Fill();
car = carArr.GetCarWithMaxId();
CarArrToForm(car);
}
}
}
}
private void btn_Delete_Click(object sender, EventArgs e)
{
Company company = FormToCompany();
CarArr carArr = new CarArr();
carArr.Fill();
if (company.Id == 0)
{
}
else
{
if (carArr.DoesExist(company))
{
MessageBox.Show("You can not delete this company, it is connected" +
" to 1 or more cars", "Can not delete company",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (MessageBox.Show("Are you sure you want to delete this" +
" Company? ", "Warning", MessageBoxButtons.YesNo,
MessageBoxIcon.Warning) == DialogResult.Yes)
{
company.Delete();
ClearForm();
CompanyArrToForm(null);
}
}
}
}
private void cmb_Category_SelectedIndexChanged(object sender, EventArgs e)
{
CarArr carArr = new CarArr();
carArr.Fill();
carArr = carArr.Filter(0, cmb_Category.SelectedItem as Category, cmb_Company.SelectedItem as Company);
cmb_Model.DataSource = carArr;
cmb_Model.DisplayMember = "Model";
cmb_Model.SelectedIndex = -1;
}
public void CarArrToForm(Car car)
{
CarArr carArr = new CarArr();
carArr.Fill();
carArr.Sort();
listbox_Product.ValueMember = "Id";
listbox_Product.DisplayMember = "FullModel";
listbox_Product.DataSource = carArr;
if (car != null)
{
listbox_Product.SelectedValue = car.Id;
}
}
public void ModelToForm(Car curProduct)
{
CarArr carArr = new CarArr();
carArr.Fill();
carArr.Sort();
cmb_Model.DataSource = carArr;
cmb_Model.ValueMember = "Id";
cmb_Model.DisplayMember = "Model";
if (curProduct != null)
{
cmb_Model.SelectedValue = curProduct.Id;
}
}
public void ModelToForm(Car curCar)
{
CarArr carArr = new CarArr();
carArr.Fill();
carArr.Sort();
cmb_Model.DataSource = carArr;
cmb_Model.ValueMember = "Id";
cmb_Model.DisplayMember = "Model";
if (curCar != null)
{
cmb_Model.SelectedValue = curCar.Id;
}
else
{
cmb_Model.SelectedIndex = -1;
}
}
public CarArr GetCars()
{
int id = 0;
//אם המשתמש רשם ערך בשדה המזהה
if (txt_Id.Text != "")
{
id = int.Parse(txt_Id.Text);
}
//מייצרים אוסף של כלל הלקוחות
CarArr carArr = new CarArr();
carArr.Fill();
carArr.Sort();
//מסננים את אוסף הלקוחות לפי שדות הסינון שרשם המשתמש
carArr = carArr.Filter(id, cmb_Category.SelectedItem as Category, (cmb_Company.SelectedItem as Company));
return(carArr);
}
