private void nav_menu_Click(object sender, RoutedEventArgs e) { Optiuni form = new Optiuni(); form.Show(); this.Hide(); }
public Automobile(string sir) { int i = 0; string[] date = sir.Split(','); foreach (var cuvant in date) { if (i == 0) { Marca = cuvant; } if (i == 1) { Culoare = cuvant; } if (i == 2) { Pret = Convert.ToInt64(cuvant); } if (i == 3) { int v = Convert.ToInt32(cuvant); ClasaBuget bug = (ClasaBuget)v; BugetClass = bug; } if (i >= 4) { Opt = Opt | (Optiuni)Convert.ToInt32(cuvant); } i++; } }
private void guna2CircleButton6_Click(object sender, EventArgs e) { bunifuCustomLabel6.Text = ""; guna2TextBox7.Text = Regex.Replace(guna2TextBox7.Text, @"\s", ""); guna2TextBox8.Text = Regex.Replace(guna2TextBox8.Text, @"\s", ""); int k = 0; if (guna2TextBox7.Text != "" && guna2TextBox8.Text != "") { ArrayList masina = adminAutomobile.GetAutomobile(); foreach (Automobile s in masina) { s.Marca = Regex.Replace(s.Marca, @"\s", ""); s.Model = Regex.Replace(s.Model, @"\s", ""); if (s.Marca.Equals(guna2TextBox7.Text) && s.Model.Equals(guna2TextBox8.Text)) { bunifuCustomLabel6.Text = s.afisareconsola(); op = s.Opt; guna2TextBox11.ReadOnly = false; guna2TextBox12.ReadOnly = false; guna2TextBox13.ReadOnly = false; k = 1; } else if (k == 0) { bunifuCustomLabel6.Text = "Inregistrare inexistenta"; } } } else { bunifuCustomLabel6.Text = "Completati toate campurile!"; } }
public Masina(string _NumeVanzator, string _NumeCumparator, string _Tip, string _AnFabricare, string _DataTranzactie, string _Pret, Optiuni _obtiune, Culori _culoare) { NumeVanzator = _NumeVanzator; NumeCumparator = _NumeCumparator; Tip = _Tip; AnFabricare = _AnFabricare; DataTranzactie = _DataTranzactie; Pret = _Pret; ProgramOptiuni = _obtiune; ProgramCulori = _culoare; IdUltimaMasina++; IdMasina = IdUltimaMasina; }
private void inapoi_Click(object sender, RoutedEventArgs e) { if (parametru == 0) { Optiuni form = new Optiuni(); form.Show(); } else if (parametru == 1) { Meniu form = new Meniu(); form.Show(); } this.Hide(); }
private void btn_addcar_Click(object sender, EventArgs e) { var context = new Parc_AutoDataContext(); float pret1 = 0; bool parsepret1 = float.TryParse(textBox_Pret_addmasina.Text.ToString(), out pret1); string sup = comboBox_Supplier.SelectedItem.ToString(); var supplier = from db in context.Suppliers where db.Company_Name.Equals(sup) select db.ID_Suppliers; float pret = 0; bool parsepret = float.TryParse(textBox_Pret_addmasina.Text.ToString(), out pret); int fabricatie = 0; bool parseOK = Int32.TryParse(comboBox_An_fabricatie.SelectedItem.ToString(), out fabricatie); if (comboBox_Marca.SelectedIndex > -1 && textBox_VIN.Text.ToString() != null && comboBox_Model.SelectedIndex > -1 && comboBox_An_fabricatie.SelectedIndex > -1 && parsepret1 != false) { MessageBox.Show("Campuri Complete !"); } else { this.Close(); MessageBox.Show("Campuri Incomplete !", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } var masina = new Masini { ID_Suppliers = supplier.First(), Marca = comboBox_Marca.SelectedItem.ToString(), Model = comboBox_Model.SelectedItem.ToString(), VIN = textBox_VIN.Text.ToString(), An_Fabricatie = fabricatie, Pret_Vanzare = pret }; if (parsepret == true) { context.Masinis.InsertOnSubmit(masina); } context.SubmitChanges(); var masina_id = from db in context.Masinis where db.VIN.Equals(masina.VIN) select db.ID_Masina; string faruri; if (comboBox_faruri.SelectedIndex > -1) { faruri = comboBox_faruri.SelectedItem.ToString(); } else { faruri = null; } string clima; if (comboBox_climatizare.SelectedIndex > -1) { clima = comboBox_climatizare.SelectedItem.ToString(); } else { clima = null; } string Tapiterie1; if (comboBox_tapiterie.SelectedIndex > -1) { Tapiterie1 = comboBox_tapiterie.SelectedItem.ToString(); } else { Tapiterie1 = null; } string cul; if (comboBox_culoare.SelectedIndex > -1) { cul = comboBox_culoare.SelectedItem.ToString(); } else { cul = null; } Optiuni op_car = null; op_car = new Optiuni { ID_Masina = masina_id.First(), Climatizare = clima, Faruri = faruri, Tapiterie = Tapiterie1, Faruri_ceata = checkBox_faruri_ceata.Checked, Culoare = cul, Tractiune4x4 = checkBox_4x4.Checked, Avariat = checkBox_avarie.Checked, Comenzi_volan = checkBox_volan_multifunctional.Checked, Cruise_control = checkBox_adaptive_cruise.Checked, Navigatie = checkBox_navigatie.Checked, Scaune_incalzite = checkBox_scaune_incalzite.Checked, Senzori_parcare = checkBox_senzori_parcare.Checked }; context.Optiunis.InsertOnSubmit(op_car); context.SubmitChanges(); // MessageBox.Show(masina_id.First().ToString()); // Dgv = all; this.DialogResult = DialogResult.OK; this.Close(); }
private void guna2CircleButton5_Click(object sender, EventArgs e) { bunifuCustomLabel5.Text = ""; if (opt == 1) { ArrayList masina = adminAutomobile.GetAutomobile(); string marc = guna2TextBox6.Text; marc = Regex.Replace(marc, @"\s", ""); int k = 0; foreach (Automobile s in masina) { s.Marca = Regex.Replace(s.Marca, @"\s", ""); if (s.Marca == marc) { bunifuCustomLabel5.Text = bunifuCustomLabel5.Text + s.afisareconsola() + "\n"; k = 1; } } if (k == 0) { bunifuCustomLabel5.Text = "Nu sunt optiuni disponibile!"; } } if (opt == 2) { ArrayList masina = adminAutomobile.GetAutomobile(); string mod = guna2TextBox6.Text; mod = Regex.Replace(mod, @"\s", ""); int k = 0; foreach (Automobile s in masina) { s.Model = Regex.Replace(s.Model, @"\s", ""); if (s.Model == mod) { bunifuCustomLabel5.Text = bunifuCustomLabel5.Text + s.afisareconsola() + "\n"; k = 1; } } if (k == 0) { bunifuCustomLabel5.Text = "Nu sunt optiuni disponibile!"; } } if (opt == 3) { ArrayList masina = adminAutomobile.GetAutomobile(); string cul = guna2TextBox6.Text; cul = Regex.Replace(cul, @"\s", ""); int k = 0; foreach (Automobile s in masina) { s.Culoare = Regex.Replace(s.Culoare, @"\s", ""); if (s.Culoare == cul) { bunifuCustomLabel5.Text = bunifuCustomLabel5.Text + s.afisareconsola() + "\n"; k = 1; } } if (k == 0) { bunifuCustomLabel5.Text = "Nu sunt optiuni disponibile!"; } } if (opt == 4) { ArrayList masina = adminAutomobile.GetAutomobile(); string pret = guna2TextBox6.Text; pret = Regex.Replace(pret, @"\s", ""); int pr = Convert.ToInt32(pret); int k = 0; foreach (Automobile s in masina) { if (s.Pret <= pr) { bunifuCustomLabel5.Text = bunifuCustomLabel5.Text + s.afisareconsola() + "\n"; k = 1; } } if (k == 0) { bunifuCustomLabel5.Text = "Nu sunt optiuni disponibile!"; } } if (opt == 5) { ArrayList masina = adminAutomobile.GetAutomobile(); string buget = guna2TextBox6.Text; buget = Regex.Replace(buget, @"\s", ""); ClasaBuget bg = (ClasaBuget)Convert.ToInt32(buget); int k = 0; foreach (Automobile s in masina) { if (s.BugetClass == bg) { bunifuCustomLabel5.Text = bunifuCustomLabel5.Text + s.afisareconsola() + "\n"; op = s.Opt; k = 1; } } if (k == 0) { bunifuCustomLabel5.Text = "Nu sunt optiuni disponibile!"; } } guna2TextBox6.Text = ""; }
public bool UpdateUserOption(Optiuni _optiune) { using (var context = new AdmitereLicentaContext()) { using (var transaction = context.Database.BeginTransaction()) { try { context.Optiunis.Add(_optiune); context.Entry(_optiune).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); transaction.Commit(); return true; } catch(Exception ex) { transaction.Rollback(); return false; } } } }
public string AddUserOption(string specializare, int prioritate, string isTaxa) { using (var context = new AdmitereLicentaContext()) { using (var transaction = context.Database.BeginTransaction()) { try { var q = (from c in context.Specializaris where c.Nume_specializare == specializare select c.ID_Specializare).FirstOrDefault(); if ( q == 0) { return "NoSpecialization"; } var query = context.Optiunis; foreach (var temp in query) { if (temp.ID_Specializare == q) { return "SpecializationExist"; } } var query2 = this.GetUserOptionOrderedByPriority(); bool flag = false; foreach(var temp in query2) { if (temp.Prioritate == prioritate) { flag = true; ; } if (flag==true) { temp.Prioritate++; this.UpdateUserOption(temp); } } //var query = context.Specializaris.Where(n => n.Nume_specializare == specializare).First(); currentUser = 4; var cand = this.GetCurrentUser(); var spec = context.Specializaris.Where(n => n.Nume_specializare == specializare).FirstOrDefault(); var option = new Optiuni(); option.ID_Candidat = 4; option.Prioritate = prioritate; option.Doreste_Taxa = isTaxa; option.ID_Specializare = q; option.Candidati = cand; option.Specializari = spec; context.Optiunis.Add(option); context.Entry(option).State = System.Data.Entity.EntityState.Added; context.SaveChanges(); transaction.Commit(); return "TransactionCorect"; } catch (Exception ex) { transaction.Rollback(); return "TransactionFailed ad"; } } } }