public void Execute(NapraviVrstuGoriva request)
{
if (request == null)
{
throw new NullReferenceException("Gorivo");
}
if (Context.VrsteGoriva.Any(g => g.Naziv == request.VrstaGoriva))
{
throw new EntityAlreadyExists("Gorivo");
}
var gorivo = new Gorivo
{
Naziv = request.VrstaGoriva,
DateCreated = DateTime.Now
};
try
{
Context.VrsteGoriva.Add(gorivo);
Context.SaveChanges();
}
catch (Exception)
{
throw new EntryPointNotFoundException();
}
}
public SusMotor(Gorivo gorivo, int prosecnaPotrosnja, int snagaKW, int snagaKS, int zapremina)
{
VrstaGoriva = gorivo;
ProsecnaPotrosnja = prosecnaPotrosnja;
SnagaKW = snagaKW;
SnagaKS = snagaKS;
Zapremina = zapremina;
}
public string IspisiAutomobil()
{
return("Automobil je marke: " + Marka.ToString() + Environment.NewLine +
"Model: " + Model.ToString() + Environment.NewLine +
"Godiste: " + God_proizvodnje.ToString() + Environment.NewLine +
"Pogon: " + Pogon.ToString() + Environment.NewLine +
"Menjac: " + Menjac.ToString() + Environment.NewLine +
"Karoserija: " + Karoserija.ToString() + Environment.NewLine +
"Gorivo: " + Gorivo.ToString() + Environment.NewLine +
"Broj vrata: " + Broj_vrata.ToString());
}
private void btnSacuvaj_Click(object sender, RoutedEventArgs e)
{
if (cmbGorivo.SelectedValue == null)
{
tbPoruka.Text = "Morate izabrati vrstu goriva.";
return;
}
if (cmbVlasnik.SelectedValue == null)
{
tbPoruka.Text = "Morate izabrati vlasnika vozila.";
return;
}
if (cmbTipVozila.SelectedValue == null)
{
tbPoruka.Text = "Morate izabrati tip vozila.";
return;
}
if (cmbMarka.SelectedValue == null)
{
tbPoruka.Text = "Morate izabrati marku i model.";
return;
}
tbPoruka.Text = "";
Vozilo novoVozilo = new Vozilo();
try
{
novoVozilo.BrojMotora = txtBrojMotora.Text;
if (!String.IsNullOrEmpty(txtSnagaMotora.Text))
{
novoVozilo.SnagaMotora = Convert.ToInt32(txtSnagaMotora.Text);
}
if (!String.IsNullOrEmpty(txtGodinaProizvodnje.Text))
{
novoVozilo.GodinaProizvodnje = Convert.ToInt32(txtGodinaProizvodnje.Text);
}
if (!String.IsNullOrEmpty(txtZapreminaMotora.Text))
{
novoVozilo.ZapreminaMotora = Convert.ToInt32(txtZapreminaMotora.Text);
}
novoVozilo.RegistarskaOznaka = txtRegOznaka.Text;
novoVozilo.BrojSasije = txtBrojSasije.Text;
novoVozilo.TipVozila = TipVozila.UcitajTipVozila(Convert.ToInt32(cmbTipVozila.SelectedValue));
novoVozilo.VrstaGoriva = Gorivo.UcitajGorivo(Convert.ToInt32(cmbGorivo.SelectedValue));
novoVozilo.Vlasnik = Vlasnik.UcitajVlasnika(Convert.ToInt32(cmbVlasnik.SelectedValue));
novoVozilo.Model = Model.UcitajModel(Convert.ToInt32(cmbMarka.SelectedValue));
}
catch (Exception)
{
tbPoruka.Text = "Niste uneli ispravne vrednosti.";
return;
}
if (String.IsNullOrEmpty(txtID.Text) != true)
{
Vozilo staroVozilo = Vozilo.UcitajVozilo(Convert.ToInt32(txtID.Text));
staroVozilo.Azuriraj(novoVozilo);
}
else
{
if (novoVozilo.PostojiDuplikat())
{
tbPoruka.Text = "Ovo vozilo već postoji u bazi. Ne možete sačuvati duplikat.";
return;
}
novoVozilo.Sacuvaj();
}
UcitajListuVozila();
}
private void btnEdit_Click(object sender, EventArgs e)
{
string dateString, model, full_name, objekt_begin, object_end;
string[] vid = new string[4];
String[] kolichestvo_text = new String[4];
string[] merna_edinitsa = new string[4];
decimal begin_km, end_km, km_tovaritelnitsa, km, gorivo;
String begin_Km, end_Km, km_Tovaritelnitsa, Km, Gorivo;
decimal[] kolichestvo_sum = new decimal[4];
int nomer_paten_list, nomer_tovaritelnitsa, hours_worked;
bool[] hasError = new bool[4];
CultureInfo culture = new CultureInfo("bg-BG");
string connectionString = null;
SqlConnection conn;
connectionString = "Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=Transport;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
conn = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "UPDATE Отчет SET Дата=@Data, МПС=@MPS, Начало_км=@Begin_km, Край_км=@End_km, Км_товарителница=@Km_tovaritelnitsa, Отработени_часове=@Hours_worked, Шофьор=@Shofior, Обект_начало=@Object_begin, Обект_край=@Object_end, Материал_1=@Material_1, Материал_2=@Material_2, Материал_3=@Material_3, Материал_4=@Material_4, Количество_текст_1=@Kolichestvo_text_1, Количество_текст_2=@Kolichestvo_text_2, Количество_текст_3=@Kolichestvo_text_3, Количество_текст_4=@Kolichestvo_text_4, Количество_сума_1=@Kolichestvo_suma_1, Количество_сума_2=@Kolichestvo_suma_2, Количество_сума_3=@Kolichestvo_suma_3, Количество_сума_4=@Kolichestvo_suma_4, Мерна_единица_1=@Merna_edinitsa_1, Мерна_единица_2=@Merna_edinitsa_2, Мерна_единица_3=@Merna_edinitsa_3, Мерна_единица_4=@Merna_edinitsa_4, Км=@Km, Гориво=@Gorivo WHERE (Номер_пътен_лист=@Number_paten_list AND Номер_товарителница=@Number_tovaritelnitsa)";
dateString = dtpDateFrom.Value.ToShortDateString();
DateTime date = DateTime.Parse(dateString, culture);
model = cmbMPS.Text;
begin_Km = txtBegin.Text;
begin_Km = begin_Km.Replace(",", ".");
begin_km = decimal.Parse(begin_Km, new CultureInfo("en-US"));
end_Km = txtEnd.Text;
end_Km = end_Km.Replace(",", ".");
end_km = decimal.Parse(end_Km, new CultureInfo("en-US"));
km_Tovaritelnitsa = txtKmTovaritelnitsa.Text;
km_Tovaritelnitsa = km_Tovaritelnitsa.Replace(",", ".");
km_tovaritelnitsa = decimal.Parse(km_Tovaritelnitsa, new CultureInfo("en-US"));
hours_worked = int.Parse(txtHoursWorked.Text);
full_name = cmbDriver.Text;
nomer_paten_list = int.Parse(txtNumber_p_list.Text);
nomer_tovaritelnitsa = int.Parse(txtNumber_tovar.Text);
objekt_begin = cmbObjectBegin.Text;
object_end = cmbObjectEnd.Text;
vid[0] = cmbMaterial1.Text;
vid[1] = cmbMaterial2.Text;
vid[2] = cmbMaterial3.Text;
vid[3] = cmbMaterial4.Text;
kolichestvo_text[0] = txtKolichestvo1.Text;
kolichestvo_text[0] = kolichestvo_text[0].Replace(",", ".");
kolichestvo_text[1] = txtKolichestvo2.Text;
kolichestvo_text[1] = kolichestvo_text[1].Replace(",", ".");
kolichestvo_text[2] = txtKolichestvo3.Text;
kolichestvo_text[2] = kolichestvo_text[2].Replace(",", ".");
kolichestvo_text[3] = txtKolichestvo4.Text;
kolichestvo_text[3] = kolichestvo_text[3].Replace(",", ".");
Expression[] expr = new Expression[4];
for (int i = 0; i < 4; i++)
{
if (kolichestvo_text[i] == "")
{
kolichestvo_sum[i] = 0;
kolichestvo_text[i] = "0";
expr[i] = new Expression(kolichestvo_text[i]);
hasError[i] = expr[i].HasErrors();
}
else
{
expr[i] = new Expression(kolichestvo_text[i]);
hasError[i] = expr[i].HasErrors();
if (hasError[i] == true)
{
MessageBox.Show("Въведеният израз е НЕВАЛИДЕН!");
kolichestvo_sum[i] = 0;
}
else
{
kolichestvo_sum[i] = Convert.ToDecimal(expr[i].Evaluate());
}
}
}
merna_edinitsa[0] = cmbMerna_edinitsa1.Text;
merna_edinitsa[1] = cmbMerna_edinitsa2.Text;
merna_edinitsa[2] = cmbMerna_edinitsa3.Text;
merna_edinitsa[3] = cmbMerna_edinitsa4.Text;
km = end_km - begin_km;
Gorivo = txtGorivo.Text;
Gorivo = Gorivo.Replace(",", ".");
gorivo = decimal.Parse(Gorivo, new CultureInfo("en-US"));
cmd.Parameters.AddWithValue("@Data", date);
cmd.Parameters.AddWithValue("@MPS", model);
cmd.Parameters.AddWithValue("@Begin_km", begin_km);
cmd.Parameters.AddWithValue("@End_km", end_km);
cmd.Parameters.AddWithValue("@Km_tovaritelnitsa", km_tovaritelnitsa);
cmd.Parameters.AddWithValue("@Hours_worked", hours_worked);
cmd.Parameters.AddWithValue("@Shofior", full_name);
cmd.Parameters.AddWithValue("@Number_paten_list", nomer_paten_list);
cmd.Parameters.AddWithValue("@Number_tovaritelnitsa", nomer_tovaritelnitsa);
cmd.Parameters.AddWithValue("@Object_begin", objekt_begin);
cmd.Parameters.AddWithValue("@Object_end", object_end);
cmd.Parameters.AddWithValue("@Material_1", vid[0]);
cmd.Parameters.AddWithValue("@Material_2", vid[1]);
cmd.Parameters.AddWithValue("@Material_3", vid[2]);
cmd.Parameters.AddWithValue("@Material_4", vid[3]);
cmd.Parameters.AddWithValue("@Kolichestvo_text_1", kolichestvo_text[0]);
cmd.Parameters.AddWithValue("@Kolichestvo_text_2", kolichestvo_text[1]);
cmd.Parameters.AddWithValue("@Kolichestvo_text_3", kolichestvo_text[2]);
cmd.Parameters.AddWithValue("@Kolichestvo_text_4", kolichestvo_text[3]);
cmd.Parameters.AddWithValue("@Kolichestvo_suma_1", kolichestvo_sum[0]);
cmd.Parameters.AddWithValue("@Kolichestvo_suma_2", kolichestvo_sum[1]);
cmd.Parameters.AddWithValue("@Kolichestvo_suma_3", kolichestvo_sum[2]);
cmd.Parameters.AddWithValue("@Kolichestvo_suma_4", kolichestvo_sum[3]);
cmd.Parameters.AddWithValue("@Merna_edinitsa_1", merna_edinitsa[0]);
cmd.Parameters.AddWithValue("@Merna_edinitsa_2", merna_edinitsa[1]);
cmd.Parameters.AddWithValue("@Merna_edinitsa_3", merna_edinitsa[2]);
cmd.Parameters.AddWithValue("@Merna_edinitsa_4", merna_edinitsa[3]);
cmd.Parameters.AddWithValue("@Km", km);
cmd.Parameters.AddWithValue("@Gorivo", gorivo);
try
{
conn.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("Данните са обновени успешно!!!");
cmbMPS.SelectedIndex = -1;
txtBegin.Text = null;
txtEnd.Text = null;
txtKmTovaritelnitsa.Text = null;
txtHoursWorked.Text = null;
cmbDriver.SelectedIndex = -1;
txtNumber_p_list.Text = null;
txtNumber_tovar.Text = null;
cmbObjectBegin.SelectedIndex = -1;
cmbObjectEnd.SelectedIndex = -1;
cmbMaterial1.SelectedIndex = -1;
cmbMaterial2.SelectedIndex = -1;
cmbMaterial3.SelectedIndex = -1;
cmbMaterial4.SelectedIndex = -1;
txtKolichestvo1.Text = null;
txtKolichestvo2.Text = null;
txtKolichestvo3.Text = null;
txtKolichestvo4.Text = null;
cmbMerna_edinitsa1.SelectedIndex = -1;
cmbMerna_edinitsa2.SelectedIndex = -1;
cmbMerna_edinitsa3.SelectedIndex = -1;
cmbMerna_edinitsa4.SelectedIndex = -1;
txtGorivo.Text = null;
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show("Базата данни не се отваря, защото се опитвате да обновите несъщестуващи данни!");
}
}
private void btnAdd_Click(object sender, System.EventArgs e)
{
string dateString, reg_number, full_name, objectBegin, objectEnd;
string[] vid = new string[4];
String[] kolichestvo_text = new String[4];
string[] merna_edinitsa = new string[4];
decimal begin_km, end_km, km_tovaritelnitsa, km, gorivo;
String begin_Km, end_Km, km_Tovaritelnitsa, Km, Gorivo;
decimal[] kolichestvo_sum = new decimal[4];
int nomer_paten_list, nomer_tovaritelnitsa, hours_worked;
bool[] hasError = new bool[4];
CultureInfo culture = new CultureInfo("bg-BG");
string connectionString = null;
SqlConnection conn;
connectionString = "Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=Transport;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
conn = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "INSERT INTO Отчет values (@Data, @MPS, @Begin_km, @End_km, @Km_tovaritelnitsa, @Hours_worked, @Shofior, @Number_paten_list, @Number_tovaritelnitsa, @ObjectBegin, @ObjectEnd, @Material_1, @Material_2, @Material_3, @Material_4, @Kolichestvo_text_1, @Kolichestvo_text_2, @Kolichestvo_text_3, @Kolichestvo_text_4, @Kolichestvo_suma_1, @Kolichestvo_suma_2, @Kolichestvo_suma_3, @Kolichestvo_suma_4, @Merna_edinitsa_1, @Merna_edinitsa_2, @Merna_edinitsa_3, @Merna_edinitsa_4, @Km, @Gorivo)";
dateString = dtpDateFrom.Value.ToShortDateString();
DateTime date = DateTime.Parse(dateString, culture);
reg_number = cmbMPS.Text;
if (txtBegin.Text == "")
{
begin_km = 0;
}
else
{
begin_Km = txtBegin.Text;
begin_Km = begin_Km.Replace(",", ".");
begin_km = decimal.Parse(begin_Km, new CultureInfo("en-US"));
}
if (txtEnd.Text == "")
{
end_km = 0;
}
else
{
end_Km = txtEnd.Text;
end_Km = end_Km.Replace(",", ".");
end_km = decimal.Parse(end_Km, new CultureInfo("en-US"));
}
if (txtKmTovaritelnitsa.Text == "")
{
km_tovaritelnitsa = 0;
}
else
{
km_Tovaritelnitsa = txtKmTovaritelnitsa.Text;
km_Tovaritelnitsa = km_Tovaritelnitsa.Replace(",", ".");
km_tovaritelnitsa = decimal.Parse(km_Tovaritelnitsa, new CultureInfo("en-US"));
}
if (txtHoursWorked.Text == "")
{
hours_worked = 0;
}
else
{
hours_worked = int.Parse(txtHoursWorked.Text);
}
full_name = cmbDriver.Text;
nomer_paten_list = int.Parse(txtNumber_p_list.Text);
nomer_tovaritelnitsa = int.Parse(txtNumber_tovar.Text);
objectBegin = cmbObjectBegin.Text;
objectEnd = cmbObjectEnd.Text;
vid[0] = cmbMaterial1.Text;
vid[1] = cmbMaterial2.Text;
vid[2] = cmbMaterial3.Text;
vid[3] = cmbMaterial4.Text;
kolichestvo_text[0] = txtKolichestvo1.Text;
kolichestvo_text[1] = txtKolichestvo2.Text;
kolichestvo_text[2] = txtKolichestvo3.Text;
kolichestvo_text[3] = txtKolichestvo4.Text;
Expression[] expr = new Expression[4];
for (int i = 0; i < 4; i++)
{
if (kolichestvo_text[i] == "")
{
kolichestvo_sum[i] = 0;
kolichestvo_text[i] = "0";
expr[i] = new Expression(kolichestvo_text[i]);
hasError[i] = expr[i].HasErrors();
}
else
{
kolichestvo_text[i] = kolichestvo_text[i].Replace(",", ".");
expr[i] = new Expression(kolichestvo_text[i]);
hasError[i] = expr[i].HasErrors();
if (hasError[i] == true)
{
MessageBox.Show("Въведеният израз е НЕВАЛИДЕН!");
kolichestvo_sum[i] = 0;
}
else
{
kolichestvo_sum[i] = Convert.ToDecimal(expr[i].Evaluate());
}
}
}
merna_edinitsa[0] = cmbMerna_edinitsa1.Text;
merna_edinitsa[1] = cmbMerna_edinitsa2.Text;
merna_edinitsa[2] = cmbMerna_edinitsa3.Text;
merna_edinitsa[3] = cmbMerna_edinitsa4.Text;
km = end_km - begin_km;
if (txtGorivo.Text == "")
{
gorivo = 0;
}
else
{
Gorivo = txtGorivo.Text;
Gorivo = Gorivo.Replace(",", ".");
gorivo = decimal.Parse(Gorivo, new CultureInfo("en-US"));
}
cmd.Parameters.AddWithValue("@Data", date);
cmd.Parameters.AddWithValue("@MPS", reg_number);
cmd.Parameters.AddWithValue("@Begin_km", begin_km);
cmd.Parameters.AddWithValue("@End_km", end_km);
cmd.Parameters.AddWithValue("@Km_tovaritelnitsa", km_tovaritelnitsa);
cmd.Parameters.AddWithValue("@Hours_worked", hours_worked);
cmd.Parameters.AddWithValue("@Shofior", full_name);
cmd.Parameters.AddWithValue("@Number_paten_list", nomer_paten_list);
cmd.Parameters.AddWithValue("@Number_tovaritelnitsa", nomer_tovaritelnitsa);
cmd.Parameters.AddWithValue("@ObjectBegin", objectBegin);
cmd.Parameters.AddWithValue("@ObjectEnd", objectEnd);
cmd.Parameters.AddWithValue("@Material_1", vid[0]);
cmd.Parameters.AddWithValue("@Material_2", vid[1]);
cmd.Parameters.AddWithValue("@Material_3", vid[2]);
cmd.Parameters.AddWithValue("@Material_4", vid[3]);
cmd.Parameters.AddWithValue("@Kolichestvo_text_1", kolichestvo_text[0]);
cmd.Parameters.AddWithValue("@Kolichestvo_text_2", kolichestvo_text[1]);
cmd.Parameters.AddWithValue("@Kolichestvo_text_3", kolichestvo_text[2]);
cmd.Parameters.AddWithValue("@Kolichestvo_text_4", kolichestvo_text[3]);
cmd.Parameters.AddWithValue("@Kolichestvo_suma_1", kolichestvo_sum[0]);
cmd.Parameters.AddWithValue("@Kolichestvo_suma_2", kolichestvo_sum[1]);
cmd.Parameters.AddWithValue("@Kolichestvo_suma_3", kolichestvo_sum[2]);
cmd.Parameters.AddWithValue("@Kolichestvo_suma_4", kolichestvo_sum[3]);
cmd.Parameters.AddWithValue("@Merna_edinitsa_1", merna_edinitsa[0]);
cmd.Parameters.AddWithValue("@Merna_edinitsa_2", merna_edinitsa[1]);
cmd.Parameters.AddWithValue("@Merna_edinitsa_3", merna_edinitsa[2]);
cmd.Parameters.AddWithValue("@Merna_edinitsa_4", merna_edinitsa[3]);
cmd.Parameters.AddWithValue("@Km", km);
cmd.Parameters.AddWithValue("@Gorivo", gorivo);
try
{
conn.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("Данните са въведени успешно!!!");
cmbMPS.SelectedIndex = -1;
txtBegin.Text = null;
txtEnd.Text = null;
txtKmTovaritelnitsa.Text = null;
txtHoursWorked.Text = null;
cmbDriver.SelectedIndex = -1;
txtNumber_p_list.Text = null;
txtNumber_tovar.Text = null;
cmbObjectBegin.SelectedIndex = -1;
cmbObjectEnd.SelectedIndex = -1;
cmbMaterial1.SelectedIndex = -1;
cmbMaterial2.SelectedIndex = -1;
cmbMaterial3.SelectedIndex = -1;
cmbMaterial4.SelectedIndex = -1;
txtKolichestvo1.Text = null;
txtKolichestvo2.Text = null;
txtKolichestvo3.Text = null;
txtKolichestvo4.Text = null;
cmbMerna_edinitsa1.SelectedIndex = -1;
cmbMerna_edinitsa2.SelectedIndex = -1;
cmbMerna_edinitsa3.SelectedIndex = -1;
cmbMerna_edinitsa4.SelectedIndex = -1;
txtGorivo.Text = null;
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show("Базата данни не се отваря, защото въведените данни съществуват в нея!");
}
}
public string UpisUFajl()
{
return(Marka.ToString() + "," + Model.ToString() + "," + Kubikaza.ToString() + "," + God_proizvodnje.ToString() + "," + Pogon.ToString() + "," + Menjac.ToString() + "," + Karoserija.ToString() + "," + Gorivo.ToString() + "," + Broj_vrata.ToString() + "," + id.ToString());
}
