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";
}
}
}
}
