private void dealerFireBt_Click(object sender, RoutedEventArgs e)
{
bool ok = true;
myCon.Open();
Utilizator delDealer = new Utilizator();
try
{
delDealer = dealers.ElementAt(dealrLB.SelectedIndex);
}catch (Exception ex)
{
Console.WriteLine(ex.Message);
new MessageBoxPoni("Dealer not selected").Show();
myCon.Close();
return;
}
dealrLB.Items.Clear();
SqlCommand cmd = new SqlCommand();
try
{
cmd = new SqlCommand("DELETE FROM [Dealer] WHERE Email= @email", myCon);
cmd.Parameters.AddWithValue("email", delDealer.email);
cmd.ExecuteNonQuery();
cmd = new SqlCommand("DELETE FROM [user] WHERE Email= @email", myCon);
cmd.Parameters.AddWithValue("email", delDealer.email);
cmd.ExecuteNonQuery();
ok = true;
}
catch (Exception ex)
{
new MessageBoxPoni("Error").Show();
ok = false;
Console.WriteLine(ex.Message);
myCon.Close();
return;
}
myCon.Close();
dealers.Clear();
dealers = ReadDealers();
foreach (Utilizator utilizator in dealers)
{
dealrLB.Items.Add(utilizator.nume + " " + utilizator.prenume);
}
if (ok)
{
new MessageBoxPoni("Dealer Fired").Show();
}
}
private void addDealerBt_Click(object sender, RoutedEventArgs e)
{
try
{
Utilizator test = null;
SignUp signUp = new SignUp(test);
signUp.ShowDialog();
test = signUp.getUtil();
signUp.Close();
if (test != null)
{
dealers.Add(test);
dealrLB.Items.Add(test.nume + ' ' + test.prenume);
new MessageBoxPoni("Dealer Aded").Show();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return;
}
}
public ChangePass(Utilizator utilizator)
{
InitializeComponent();
this.utilizator = utilizator;
}
public UserMenu(Utilizator utilizator)
{
InitializeComponent();
this.utilizator = utilizator;
emailTextBlock.Text = utilizator.email;
myCon.Open();
if (this.utilizator.isAdmin == 1)
{
infoDealearItem.Visibility = Visibility.Visible;
addCars_Item.Visibility = Visibility.Visible;
StatisticsItem.Visibility = Visibility.Visible;
List <Utilizator> utilizatori = new List <Utilizator>();
DataSet dataset = new DataSet();
SqlDataAdapter dataAdapter = new SqlDataAdapter("SELECT * FROM [Admin]", myCon);
dataAdapter.Fill(dataset, "[Admin]");
foreach (DataRow dr in dataset.Tables["[Admin]"].Rows)
{
String firstName = dr.ItemArray.GetValue(1).ToString();
String lastName = dr.ItemArray.GetValue(2).ToString();
int admin = Convert.ToInt32(dr.ItemArray.GetValue(3).ToString());
String emailRead = dr.ItemArray.GetValue(4).ToString();
String passRead = dr.ItemArray.GetValue(5).ToString();
utilizatori.Add(new Utilizator(emailRead, passRead, admin, lastName, firstName));
}
foreach (Utilizator utilizator1 in utilizatori)
{
if (utilizator1.email == utilizator.email)
{
utilizator.nume = utilizator1.nume;
utilizator.prenume = utilizator1.prenume;
}
}
}
else
{
List <Utilizator> utilizatori = new List <Utilizator>();
DataSet dataset = new DataSet();
SqlDataAdapter dataAdapter = new SqlDataAdapter("SELECT * FROM [Dealer]", myCon);
dataAdapter.Fill(dataset, "[Dealer]");
foreach (DataRow dr in dataset.Tables["[Dealer]"].Rows)
{
String firstName = dr.ItemArray.GetValue(1).ToString();
String lastName = dr.ItemArray.GetValue(2).ToString();
int admin = Convert.ToInt32(dr.ItemArray.GetValue(3).ToString());
int sales = Convert.ToInt32(dr.ItemArray.GetValue(4).ToString());
String emailRead = dr.ItemArray.GetValue(5).ToString();
String passRead = dr.ItemArray.GetValue(6).ToString();
utilizatori.Add(new Utilizator(emailRead, passRead, admin, lastName, firstName, sales));
}
foreach (Utilizator utilizator1 in utilizatori)
{
if (utilizator1.email == utilizator.email)
{
utilizator.nume = utilizator1.nume;
utilizator.prenume = utilizator1.prenume;
utilizator.salesNumber = utilizator1.salesNumber;
}
}
}
myCon.Close();
}
public ProductPrezentation(Utilizator utilizator, Masini masina)
{
InitializeComponent();
myCon.ConnectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=D:\ii-proj\Developer-s-Work\WpfApp1\WpfApp1\PCDB.mdf;Integrated Security=True";
this.utilizator = utilizator;
this.masina = masina;
emailTextBlock.Text = utilizator.email;
var products = GetProducts();
myCon.Open();
DataSet dataset = new DataSet();
SqlDataAdapter dataAdapter = new SqlDataAdapter("SELECT * FROM [SpecificationCar]", myCon);
dataAdapter.Fill(dataset, "[SpecificationCar]");
foreach (DataRow dr in dataset.Tables["[SpecificationCar]"].Rows)
{
int carId = Convert.ToInt32(dr.ItemArray.GetValue(1).ToString());
if (carId == masina.carId)
{
masina.color = dr.ItemArray.GetValue(2).ToString();
masina.Co2E = Convert.ToInt32(dr.ItemArray.GetValue(3).ToString());
masina.ParkingSpot = dr.ItemArray.GetValue(4).ToString();
masina.Consumption = Convert.ToDouble(dr.ItemArray.GetValue(5).ToString());
masina.Traction = dr.ItemArray.GetValue(6).ToString();
masina.CilindricalCap = Convert.ToDouble(dr.ItemArray.GetValue(7).ToString());
String[] feat = dr.ItemArray.GetValue(8).ToString().Split('@');
List <String> f = new List <string>();
for (int i = 0; i < feat.Length; i++)
{
f.Add(feat[i]);
}
brand.Text = brand.Text + ": " + masina.make;
model.Text = model.Text + ": " + masina.model;
culoare.Text = culoare.Text + ": " + masina.color;
combustibil.Text = combustibil.Text + ": " + masina.FuelType;
caiputere.Text = caiputere.Text + ": " + masina.HorsePower.ToString();
tractiune.Text = tractiune.Text + ": " + masina.Traction;
capcilindrica.Text = capcilindrica.Text + ": " + masina.CilindricalCap.ToString();
locparcare.Text = locparcare.Text + ": " + masina.ParkingSpot;
pret.Text = "$" + masina.carPrice.ToString();
f.RemoveAt(f.Count - 1);
features.Items.Clear();
foreach (String feature in f)
{
features.Items.Add(feature);
}
}
}
products.RemoveAt(products.Count - 1);
if (products.Count > 0)
{
PhotosList.ItemsSource = products;
}
try
{
var uriSource = new Uri(@"/WpfApp1;component/" + products.ElementAt(0).Image, UriKind.Relative);
BigImg.Source = new BitmapImage(uriSource);
BigImg.Width = 400;
BigImg.Height = 400;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
myCon.Close();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (emailTB.Text == "" || PassP.Password == "" || SallaryTB.Text == "" || FirstNameTB.Text == "" || LastNameTB.Text == "")
{
new MessageBoxPoni("All Blocks must be completed").Show();
return;
}
try
{
int emailok = 1, firstletterfn = 1, firstletterln = 1, lnok = 1, fnok = 1, salaryok = 1;
string[] emailstr = emailTB.Text.Split(new char[] { '@', '.' }, StringSplitOptions.RemoveEmptyEntries);
if (!(emailstr[1] == "gmail" && emailstr[1] == "yahoo") && !(emailstr[2] == "com"))
{
emailok = 0;
//new MessageBoxPoni("Wrong email format!").Show();
}
string firstname = FirstNameTB.Text;
string lastname = LastNameTB.Text;
if (firstname[0] >= 'A' && firstname[0] <= 'Z')
{
for (int i = 1; i < firstname.Length; i++)
{
if (!(firstname[i] >= 'a' && firstname[i] <= 'z'))
{
fnok = 0;
}
}
}
else
{
firstletterfn = 0;
}
if (lastname[0] >= 'A' && lastname[0] <= 'Z')
{
for (int i = 1; i < lastname.Length; i++)
{
if (!(lastname[i] >= 'a' && lastname[i] <= 'z'))
{
lnok = 0;
}
}
}
else
{
firstletterln = 0;
}
string s = SallaryTB.Text;
if (s[0] == '0')// Daca salariul incepe cu cifra 0
{
salaryok = 0;
}
for (int i = 0; i < s.Length; i++)
{
if (!(s[i] >= '1' && s[i] <= '9'))
{
salaryok = 0;
}
}
if (emailok == 1 && firstletterfn == 1 && firstletterln == 1 && lnok == 1 && fnok == 1 && salaryok == 1)
{
myCon.Open();
cmd = new SqlCommand("INSERT INTO [user] (Email,[Password],Salary) VALUES (@Email,@Password,@Salary) ", myCon);
cmd.Parameters.AddWithValue("@Email", emailTB.Text);
cmd.Parameters.AddWithValue("@Password", PassP.Password);
cmd.Parameters.AddWithValue("@Salary", SallaryTB.Text);
cmd.ExecuteNonQuery();
cmd = new SqlCommand("INSERT INTO [Dealer] (FirstName,LastName,Email,[Password]) VALUES (@FirstName,@LastName,@email,@Password) ", myCon);
cmd.Parameters.AddWithValue("@FirstName", FirstNameTB.Text);
cmd.Parameters.AddWithValue("@LastName", LastNameTB.Text);
cmd.Parameters.AddWithValue("@Email", emailTB.Text);
cmd.Parameters.AddWithValue("@Password", PassP.Password);
cmd.ExecuteNonQuery();
double salary = Convert.ToDouble(SallaryTB.Text);
utilizator = new Utilizator(emailTB.Text, PassP.Password, 0, salary);
utilizator.nume = LastNameTB.Text;
utilizator.prenume = FirstNameTB.Text;
utilizator.salesNumber = 0;
}
else
{
new MessageBoxPoni("Email,FirstName,LastName or Salary fields might have a wrong format!").Show();
emailTB.Text = ""; PassP.Password = ""; FirstNameTB.Text = ""; LastNameTB.Text = ""; SallaryTB.Text = "";
}
}
catch (IndexOutOfRangeException ex)
{
new MessageBoxPoni("Wrong email format! Hint: Use [email protected] \n or [email protected]").Show();
Console.WriteLine(ex.Message);
emailTB.Text = ""; PassP.Password = ""; FirstNameTB.Text = ""; LastNameTB.Text = ""; SallaryTB.Text = "";
myCon.Close();
return;
}
catch (SqlException ex)
{
new MessageBoxPoni("No connection to the database!").Show();
Console.WriteLine(ex.Message);
myCon.Close();
emailTB.Text = ""; PassP.Password = ""; FirstNameTB.Text = ""; LastNameTB.Text = ""; SallaryTB.Text = "";
return;
}
myCon.Close();
this.Hide();
}
public SignUp(Utilizator utilizator)
{
InitializeComponent();
this.utilizator = utilizator;
}
