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);
}
public void CarRentToChart(DateTime dt)
{
RadioButton(true);
chart1.Palette = ChartColorPalette.SeaGreen;
chart1.ChartAreas[0].AxisX.LabelStyle.Interval = 1;
chart1.Titles.Clear();
chart1.Titles.Add("Distribution");
SortedDictionary <string, int> dictionary = new SortedDictionary <string, int>();
OrderRentArr orderArr = new OrderRentArr();
orderArr.Fill();
ProductArr productArr = orderArr.GetProductArr();
CarArr carArr = productArr.GetCarArr();
foreach (Car car in carArr)
{
Count = orderArr.Filter(car, dt).Count;
if (Count > 0)
{
dictionary.Add(car.Category + "" + car.Model, Count);
}
}
Series series = new Series("Products", productArr.Count);
series.ChartType = SeriesChartType.Column;
series.Label = "[#PERCENT{P0}]";
series.Points.DataBindXY(dictionary.Keys, dictionary.Values);
chart1.Series.Clear();
chart1.Series.Add(series);
}
public void ProductArrToForm(CarArr productArr)
{
cmb_Category.DataSource = productArr;
// cmb_Model.ValueMember = "Id";
cmb_Category.DisplayMember = "Category ";
}
