internal void DeleteAutomobil(UCUpdateAutomobil uCUpdateAutomobil)
{
try
{
if ((Automobil)uCUpdateAutomobil.ComboBox.SelectedItem == null)
{
System.Windows.Forms.MessageBox.Show("Niste izabrali automobil");
return;
}
Automobil a = (Automobil)uCUpdateAutomobil.ComboBox.SelectedItem;
a.WhereCondition = "BrojSasije=";
a.WhereValue = $"'{a.BrojSasije}'";
/*try
* {
* Communication.Communication.Instance.DeleteAutomobil(a);
* System.Windows.Forms.MessageBox.Show("Automobil je uspesno obrisan");
* ResetForm(uCUpdateAutomobil);
* }
* catch (Exception)
* {
*
* System.Windows.Forms.MessageBox.Show("Automobil ne moze biti obrisan jer postoji rentiranje u kome ucestvuje");
* }*/
Communication.Communication.Instance.DeleteAutomobil(a);
System.Windows.Forms.MessageBox.Show("Automobil je uspesno obrisan");
ResetForm(uCUpdateAutomobil);
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
}
internal void SearchAutomobilBrSasije(UCUpdateAutomobil uCUpdateAutomobil)
{
Automobil a = new Automobil
{
BrojSasije = uCUpdateAutomobil.TxtBrojSasije.Text,
WhereCondition = "a.BrojSasije=",
WhereValue = uCUpdateAutomobil.TxtBrojSasije.Text,
};
try
{
if (Communication.Communication.Instance.SearchAutomobilBrSasije(a))
{
System.Windows.Forms.MessageBox.Show("Nema automobila sa zadatim brojem sasije");
}
else
{
uCUpdateAutomobil.ComboBox.DataSource = Communication.Communication.Instance.SearchAutomobil(a);
System.Windows.Forms.MessageBox.Show("Postoji automobil sa zadatim brojem sasije");
}
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
}
internal void SearchAutomobilRegistracija(UCUpdateAutomobil uCUpdateAutomobil)
{
Automobil a = new Automobil
{
Registracija = uCUpdateAutomobil.TxtRegistracija.Text,
WhereCondition = "a.Registracija=",
WhereValue = uCUpdateAutomobil.TxtRegistracija.Text,
};
try
{
if (Communication.Communication.Instance.SearchAutomobilRegistracija(a))
{
System.Windows.Forms.MessageBox.Show("Nema automobila sa zadatom registracijom");
}
else
{
uCUpdateAutomobil.ComboBox.DataSource = Communication.Communication.Instance.SearchAutomobil(a);
System.Windows.Forms.MessageBox.Show("Postoji automobil sa zadatom registracijom");
}
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
}
internal void UpdateModel(UCUpdateAutomobil uCUpdateAutomobil)
{
try
{
uCUpdateAutomobil.CbModel.DataSource = Communication.Communication.Instance.GetAllModel((Marka)uCUpdateAutomobil.CbMarka.SelectedItem);
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
}
internal void ResetForm(UCUpdateAutomobil uCUpdateAutomobil)
{
uCUpdateAutomobil.TxtBrojSasije.Text = "";
uCUpdateAutomobil.TxtRegistracija.Text = "";
uCUpdateAutomobil.TxtCenaUpdate.Text = "";
uCUpdateAutomobil.TxtRegistracijaUpdate.Text = "";
uCUpdateAutomobil.CbModel.DataSource = null;
uCUpdateAutomobil.ComboBox.DataSource = null;
uCUpdateAutomobil.LblMarka.Text = "";
uCUpdateAutomobil.LblModel.Text = "";
uCUpdateAutomobil.LblCenaPoDanu.Text = "";
uCUpdateAutomobil.LblRegistracija.Text = "";
uCUpdateAutomobil.LblGodiste.Text = "";
InitUCUpdateAutomobil(uCUpdateAutomobil);
}
internal void InitUCUpdateAutomobil(UCUpdateAutomobil uCUpdateAutomobil)
{
try
{
List <int> godista = new List <int>();
for (int i = 1980; i < 2021; i++)
{
godista.Add(i);
}
//ucAddAutomobil.CbGodiste.DataSource = Communication.Communication.Instance.GetAllMarka();
uCUpdateAutomobil.CbMarka.DataSource = Communication.Communication.Instance.GetAllMarka();
uCUpdateAutomobil.CbGodiste.DataSource = godista;
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
}
internal void UpdateFill(UCUpdateAutomobil uCUpdateAutomobil)
{
try
{
Automobil a = (Automobil)uCUpdateAutomobil.ComboBox.SelectedItem;
uCUpdateAutomobil.TxtCenaUpdate.Text = a.CenaPoDanu.ToString();
uCUpdateAutomobil.TxtRegistracijaUpdate.Text = a.Registracija;
uCUpdateAutomobil.CbMarka.SelectedIndex = uCUpdateAutomobil.CbMarka.FindStringExact(a.Model.Marka.ToString());
uCUpdateAutomobil.CbModel.DataSource = Communication.Communication.Instance.GetAllModel(a.Marka);
//System.Windows.Forms.MessageBox.Show($"{a.Model.Naziv} {a.Model.Verzija}");
uCUpdateAutomobil.CbGodiste.SelectedIndex = uCUpdateAutomobil.CbGodiste.FindStringExact(a.GodinaProizvodnje.ToString());
uCUpdateAutomobil.CbModel.SelectedIndex = uCUpdateAutomobil.CbModel.FindStringExact($"{a.Model.Naziv} {a.Model.Verzija}");
//uCUpdateAutomobil.CbMarka.Text = a.Model.Marka.ToString();
//uCUpdateAutomobil.CbModel.Text = a.Model.ToString();
uCUpdateAutomobil.BrojSasije = a.BrojSasije;
System.Windows.Forms.MessageBox.Show("Ucitani su podaci o automobilu");
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
}
internal void UpdateAutomobil(UCUpdateAutomobil uCUpdateAutomobil)
{
if (uCUpdateAutomobil.ComboBox.SelectedItem == null)
{
System.Windows.Forms.MessageBox.Show("Niste izabrali automobil koji zelite da izmenite");
return;
}
if (!UserControlHelpers.ComboBoxValidation(uCUpdateAutomobil.CbMarka, uCUpdateAutomobil.LblMarka)
| !UserControlHelpers.ComboBoxValidation(uCUpdateAutomobil.CbModel, uCUpdateAutomobil.LblModel)
| !UserControlHelpers.RegistrationValidation(uCUpdateAutomobil.TxtRegistracijaUpdate, uCUpdateAutomobil.LblRegistracija)
)
{
return;
}
try
{
string k = CommaConversion(uCUpdateAutomobil.TxtCenaUpdate.Text);
Model model = (Model)uCUpdateAutomobil.CbModel.SelectedItem;
Automobil a = new Automobil
{
/*BrojSasije=uCUpdateAutomobil.BrojSasije,
* Registracija=uCUpdateAutomobil.TxtRegistracijaUpdate.Text,
* CenaPoDanu=double.Parse(uCUpdateAutomobil.TxtCenaUpdate.Text),
* GodinaProizvodnje=(int)uCUpdateAutomobil.CbGodiste.SelectedItem,
* Model=(Model)uCUpdateAutomobil.CbModel.SelectedItem*/
WhereCondition = "BrojSasije=",
WhereValue = $"'{uCUpdateAutomobil.BrojSasije}'",
UpdateText = $"Registracija='{uCUpdateAutomobil.TxtRegistracijaUpdate.Text}',GodinaProizvodnje={(int)uCUpdateAutomobil.CbGodiste.SelectedItem},CenaPoDanu={k},ModelID={model.Id}"
};
Communication.Communication.Instance.UpdateAutomobil(a);
System.Windows.Forms.MessageBox.Show("Automobil uspesno sacuvan");
ResetForm(uCUpdateAutomobil);
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
}
