private void Button_Click_6(object sender, RoutedEventArgs e)
{
using (var entity = new kadryEntities2())
{
myGrid.DataContext = entity.WolneEtaty().ToArray();
}
}
public Usun(String log, String pwd)
{
InitializeComponent();
this.a = log;
this.b = pwd;
using (var entity = new kadryEntities2())
{
var user = entity.AppUsers.Where(x => x.login == a && x.password == b && (x.Role == "m" || x.Role == "a")).FirstOrDefault();
if (user != null)
{
var tab = entity.TABELE.ToArray();
List <String> tabele = new List <string>();
for (int i = 0; i < tab.Length; i++)
{
tabele.Add(tab[i].TABLE_NAME.ToString());
}
boxTabel.ItemsSource = tabele;
}
else
{
MessageBox.Show("Nie masz uprawnień do usuwania rekordów");
this.Close();
}
}
}
private void Button_Click_7(object sender, RoutedEventArgs e)
{
using (var entity = new kadryEntities2())
{
var user = entity.AppUsers.Where(x => x.login == login && x.password == haslo && (x.Role == "m" || x.Role == "a")).FirstOrDefault();
if (user != null)
{
try
{
String input = Microsoft.VisualBasic.Interaction.InputBox("Podaj wartość",
"Podaj datę która cię interesuje",
"RRRR-mm-dd",
-1, -1);
myGrid.DataContext = entity.rozmowyPerDzien(Convert.ToDateTime(input)).ToArray();
}
catch (Exception)
{
MessageBox.Show("Podano nieprawidłową wartość");
}
}
else
{
MessageBox.Show("Nie masz uprawnień do tenj funkcji");
}
}
}
public Dodaj(String log, String has)
{
InitializeComponent();
this.log = log;
this.has = has;
using (var entity = new kadryEntities2())
{
var user = entity.AppUsers.Where(x => x.login == log && x.password == has && (x.Role == "m" || x.Role == "a")).FirstOrDefault();
if (user != null)
{
this.role = user.Role;
this.Show();
var tab = entity.TABELE.ToArray();
List <String> tabele = new List <string>();
for (int i = 0; i < tab.Length; i++)
{
tabele.Add(tab[i].TABLE_NAME.ToString());
}
box.ItemsSource = tabele;
}
else
{
new Dodaj_podanie();
this.Close();
}
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
using (var entity = new kadryEntities2())
{
DateTime data = DateTime.Today;
try
{
var podanie = new Podania
{
idPo = entity.Podania.Max(u => u.idPo + 1),
idO = Convert.ToInt32(idOferty.Text),
dataZlozPo = data,
imiePo = Imie.Text,
nazwiskoPo = Nazwisko.Text,
miasto = Miasto.Text,
adres = adres.Text,
wyksztalceniePo = Wyksztalcenie.Text,
dataUrPo = DataUr.SelectedDate
};
entity.Podania.Add(podanie);
}
catch (Exception)
{
MessageBox.Show("Podano błędne dane");
}
}
}
private List <String> getColTitels()
{
using (var entity = new kadryEntities2())
{
List <String> count = entity.Database.SqlQuery <String>("SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '" + box.SelectedItem.ToString() + "' AND TABLE_SCHEMA = 'dbo' AND COLUMN_NAME != 'idR'").ToList();;
return(count);
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
using (var entity = new kadryEntities2())
{
switch (boxTabel.SelectedItem.ToString())
{
case "Dzialy":
entity.DelDzial(Convert.ToInt32(id.Text));
break;
case "Stanowiska":
entity.StanDel(Convert.ToInt32(id.Text));
break;
case "Oferty":
entity.OfertyDel(Convert.ToInt32(id.Text));
break;
case "Podania":
entity.PodaniaDel(Convert.ToInt32(id.Text));
break;
case "Rozmowy":
entity.RozmowyDel(Convert.ToInt32(id.Text));
break;
case "stan_dzial":
entity.StanDzialDel(Convert.ToInt32(id.Text), Convert.ToInt32(id2.Text));
break;
case "AppUsers":
entity.AppUsDel(Convert.ToInt32(id.Text));
break;
default:
entity.PracowDel(Convert.ToInt32(id.Text));
break;
}
entity.SaveChanges();
grid.UpdateLayout();
MessageBox.Show("usuwanie powiodło się");
}
}
private void Button_Click_5(object sender, RoutedEventArgs e)
{
using (var entity = new kadryEntities2())
{
var user = entity.AppUsers.Where(x => x.login == login && x.password == haslo && (x.Role == "m" || x.Role == "a")).FirstOrDefault();
if (user != null)
{
myGrid.DataContext = entity.kierownicy().ToArray();
}
else
{
MessageBox.Show("Nie masz uprawnień do tenj funkcji");
}
}
}
private List <String> getColTitels(int i)
{
using (var entity = new kadryEntities2())
{
List <String> count;
if (i == 1)
{
count = entity.Database.SqlQuery <String>("SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Dzialy' AND TABLE_SCHEMA = 'dbo' AND COLUMN_NAME != 'idR'").ToList();;
}
else
{
count = entity.Database.SqlQuery <String>("SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Stanowiska' AND TABLE_SCHEMA = 'dbo' AND COLUMN_NAME != 'idR'").ToList();;
}
return(count);
}
}
public MainWindow(String uid, String password)
{
InitializeComponent();
this.login = uid;
this.haslo = password;
using (var entity = new kadryEntities2())
{
var tab = entity.TABELE.ToArray();
List <String> tabele = new List <string>();
for (int i = 0; i < tab.Length; i++)
{
tabele.Add(tab[i].TABLE_NAME.ToString());
}
box.ItemsSource = tabele;
var tab2 = entity.Oferty.ToArray();
myGrid.DataContext = tab2;
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
using (var entity = new kadryEntities2())
{
var user = entity.AppUsers.Where(x => x.login == login.Text && x.password == haslo.Password).FirstOrDefault();
if (user != null)
{
MainWindow app = new MainWindow(login.Text, haslo.Password);
app.Show();
this.Close();
}
else
{
MessageBox.Show("Wprowadzono błędne dane logowania", "Błąd logowania", MessageBoxButton.OK);
}
}
}
private void ComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
using (var entity = new kadryEntities2())
{
var user = entity.AppUsers.Where(x => x.login == login && x.password == haslo && (x.Role == "m" || x.Role == "a")).FirstOrDefault();
switch (box.SelectedItem.ToString())
{
case "Dzialy":
var tab1 = entity.Dzialy.ToArray();
myGrid.DataContext = tab1;
break;
case "Stanowiska":
var tab3 = entity.Stanowiska.ToArray();
myGrid.DataContext = tab3;
break;
case "Oferty":
var tab2 = entity.Oferty.ToArray();
myGrid.DataContext = tab2;
break;
case "Podania":
if (user != null)
{
var tab4 = entity.Podania.ToArray();
myGrid.DataContext = tab4;
}
else
{
MessageBox.Show("Nie posiadasz uprawnień do tej operacji");
}
break;
case "Rozmowy":
var tab6 = entity.Rozmowy.ToArray();
myGrid.DataContext = tab6;
break;
case "stan_dzial":
var tab5 = entity.stan_dzial.ToArray();
myGrid.DataContext = tab5;
break;
case "AppUsers":
if (user != null)
{
var tab8 = entity.AppUsers.ToArray();
myGrid.DataContext = tab8;
}
else
{
MessageBox.Show("Nie posiadasz uprawnień do tej operacji");
}
break;
default:
if (user != null)
{
var tab7 = entity.Pracownicy.ToArray();
myGrid.DataContext = tab7;
}
else
{
MessageBox.Show("Nie posiadasz uprawnień do tej operacji");
}
break;
}
}
}
private void ComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
Stos.Children.Clear();
List <UIElement> pola = new List <UIElement>();
List <Label> texty = new List <Label>();
var lista = getColTitels();
using (var entity = new kadryEntities2())
{
switch (box.SelectedItem.ToString())
{
case "Dzialy":
var tab1 = entity.Dzialy;
for (int i = 0; i < numberOfReps(tab1.ToString(), "AS") - 1; i++)
{
texty.Add(new Label()
{
Height = 25,
Width = 100,
Name = "Text" + i,
Visibility = Visibility.Visible,
HorizontalAlignment = HorizontalAlignment.Left,
Content = lista[i]
});
pola.Add(new TextBox
{
Height = 22,
Width = 100,
Name = "TextBox" + i,
Visibility = Visibility.Visible,
HorizontalAlignment = HorizontalAlignment.Left,
});
if (i > 0)
{
this.Stos.Children.Add(texty[i]);
this.Stos.Children.Add(pola[i]);
}
}
break;
case "AppUsers":
var tab8 = entity.Dzialy;
for (int i = 0; i < numberOfReps(tab8.ToString(), "AS") - 1; i++)
{
texty.Add(new Label()
{
Height = 25,
Width = 100,
Name = "Text" + i,
Visibility = Visibility.Visible,
HorizontalAlignment = HorizontalAlignment.Left,
Content = lista[i]
});
pola.Add(new TextBox
{
Height = 22,
Width = 100,
Name = "TextBox" + i,
Visibility = Visibility.Visible,
HorizontalAlignment = HorizontalAlignment.Left,
});
if (i > 0)
{
this.Stos.Children.Add(texty[i]);
this.Stos.Children.Add(pola[i]);
}
}
break;
case "Stanowiska":
var tab3 = entity.Stanowiska;
for (int i = 0; i < lista.Count; i++)
{
texty.Add(new Label()
{
Height = 25,
Width = 100,
Name = "Text" + i,
Visibility = Visibility.Visible,
HorizontalAlignment = HorizontalAlignment.Left,
Content = lista[i]
});
pola.Add(new TextBox
{
Height = 22,
Width = 100,
Name = "TextBox" + i,
Visibility = Visibility.Visible,
HorizontalAlignment = HorizontalAlignment.Left,
});
if (i > 0)
{
this.Stos.Children.Add(texty[i]);
this.Stos.Children.Add(pola[i]);
}
}
break;
case "Oferty":
var tab2 = entity.Oferty;
for (int i = 0; i < lista.Count; i++)
{
texty.Add(new Label()
{
Height = 25,
Width = 100,
Name = "Text" + i,
Visibility = Visibility.Visible,
HorizontalAlignment = HorizontalAlignment.Left,
Content = lista[i]
});
pola.Add(new TextBox
{
Height = 22,
Width = 100,
Name = "TextBox" + i,
Visibility = Visibility.Visible,
HorizontalAlignment = HorizontalAlignment.Left,
});
if (i > 0)
{
this.Stos.Children.Add(texty[i]);
this.Stos.Children.Add(pola[i]);
}
}
break;
case "Podania":
var tab4 = entity.Podania;
//Console.WriteLine((numberOfReps(tab4.ToString(), "AS") - 1));
for (int i = 0; i < lista.Count; i++)
{
texty.Add(new Label()
{
Height = 25,
Width = 100,
Name = "Text" + i,
Visibility = Visibility.Visible,
HorizontalAlignment = HorizontalAlignment.Left,
Content = lista[i]
});
pola.Add(new TextBox
{
Height = 22,
Width = 100,
Name = "TextBox" + i,
Visibility = Visibility.Visible,
HorizontalAlignment = HorizontalAlignment.Left,
});
if (lista[i].Equals("dataUrPo"))
{
pola[i] = new DatePicker
{
Width = 120,
Height = 25,
HorizontalAlignment = HorizontalAlignment.Left
};
}
if (lista[i].Equals("dataZlozPo"))
{
pola[i] = new DatePicker
{
Width = 120,
Height = 25,
HorizontalAlignment = HorizontalAlignment.Left
};
}
if (i > 0)
{
this.Stos.Children.Add(texty[i]);
this.Stos.Children.Add(pola[i]);
}
}
this.Stos.Children.Add(new ScrollBar
{
Height = Stos.Height,
Width = 10,
HorizontalAlignment = HorizontalAlignment.Right,
Visibility = Visibility.Visible
});
break;
case "Rozmowy":
var tab6 = entity.Rozmowy;
for (int i = 0; i < lista.Count; i++)
{
texty.Add(new Label()
{
Height = 25,
Width = 100,
Name = "Text" + i,
Visibility = Visibility.Visible,
HorizontalAlignment = HorizontalAlignment.Left,
Content = lista[i]
});
pola.Add(new TextBox
{
Height = 22,
Width = 100,
Name = "TextBox" + i,
Visibility = Visibility.Visible,
HorizontalAlignment = HorizontalAlignment.Left,
});
this.Stos.Children.Add(texty[i]);
this.Stos.Children.Add(pola[i]);
}
break;
case "stan_dzial":
var tab5 = entity.stan_dzial;
for (int i = 0; i < lista.Count; i++)
{
texty.Add(new Label()
{
Height = 25,
Width = 100,
Name = "Text" + i,
Visibility = Visibility.Visible,
HorizontalAlignment = HorizontalAlignment.Left,
Content = lista[i]
});
pola.Add(new TextBox
{
Height = 22,
Width = 100,
Name = "TextBox" + i,
Visibility = Visibility.Visible,
HorizontalAlignment = HorizontalAlignment.Left,
});
this.Stos.Children.Add(texty[i]);
this.Stos.Children.Add(pola[i]);
}
break;
default:
var tab7 = entity.Pracownicy;
lista.Add("idDziału");
lista.Add("idStanowiska");
List <String> lista1 = entity.Database.SqlQuery <String>("SELECT nazwaD FROM Dzialy").ToList();
List <String> lista2 = entity.Database.SqlQuery <String>("SELECT nazwa FROM Stanowiska").ToList();
for (int i = 0; i < lista.Count; i++)
{
texty.Add(new Label()
{
Height = 25,
Width = 100,
Name = "Text" + i,
Visibility = Visibility.Visible,
HorizontalAlignment = HorizontalAlignment.Left,
Content = lista[i]
});
pola.Add(new TextBox
{
Height = 22,
Width = 100,
Name = "TextBox" + i,
Visibility = Visibility.Visible,
HorizontalAlignment = HorizontalAlignment.Left,
});
if (i == lista.Count - 2)
{
pola[i] = null;
pola[i] = new ComboBox
{
ItemsSource = lista1
};
}
if (i == lista.Count - 1)
{
pola[i] = null;
pola[i] = new ComboBox
{
ItemsSource = lista2
};
}
if (i > 0)
{
this.Stos.Children.Add(texty[i]);
this.Stos.Children.Add(pola[i]);
}
}
break;
}
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
using (var entity = new kadryEntities2())
{
if (box.SelectedIndex != -1)
{
var user = entity.AppUsers.Where(x => x.login == login && x.password == haslo && (x.Role == "m" || x.Role == "a")).FirstOrDefault();
if (user != null)
{
try
{
switch (box.SelectedItem.ToString())
{
case "Dzialy":
var zmienna = (Dzialy[])myGrid.DataContext;
for (int i = 0; i < zmienna.Count(); i++)
{
if (user != null)
{
entity.ModDzialy(zmienna[i].idD, zmienna[i].nazwaD, zmienna[i].miastoD, zmienna[i].adresD);
}
else
{
MessageBox.Show("Nie posiadasz uprawnień do tej operacji");
break;
}
}
entity.SaveChanges();
break;
case "Stanowiska":
var zmienna1 = (Stanowiska[])myGrid.DataContext;
for (int i = 0; i < zmienna1.Count(); i++)
{
if (user != null)
{
entity.ModStano(zmienna1[i].idS, zmienna1[i].nazwa);
}
else
{
MessageBox.Show("Nie posiadasz uprawnień do tej operacji");
break;
}
}
entity.SaveChanges();
break;
case "Oferty":
var zmienna2 = (Oferty[])myGrid.DataContext;
for (int i = 0; i < zmienna2.Count(); i++)
{
if (user != null)
{
entity.ModOferty(zmienna2[i].idO, zmienna2[i].dataWystaw);
}
else
{
MessageBox.Show("Nie posiadasz uprawnień do tej operacji");
break;
}
}
entity.SaveChanges();
break;
case "Podania":
var zmienna3 = (Podania[])myGrid.DataContext;
for (int i = 0; i < zmienna3.Count(); i++)
{
if (user != null)
{
entity.ModPodania(zmienna3[i].idPo, zmienna3[i].idR, zmienna3[i].idO, zmienna3[i].imiePo, zmienna3[i].nazwiskoPo, zmienna3[i].miasto, zmienna3[i].adres, zmienna3[i].dataUrPo, zmienna3[i].wyksztalceniePo, zmienna3[i].dataZlozPo);
}
else
{
MessageBox.Show("Nie posiadasz uprawnień do tej operacji");
break;
}
}
entity.SaveChanges();
break;
case "Rozmowy":
var zmienna4 = (Rozmowy[])myGrid.DataContext;
for (int i = 0; i < zmienna4.Count(); i++)
{
if (user != null)
{
entity.ModRozmowy(zmienna4[i].idR, zmienna4[i].idP, zmienna4[i].idPo, zmienna4[i].dataRozmowy);
}
else
{
MessageBox.Show("Nie posiadasz uprawnień do tej operacji");
break;
}
}
entity.SaveChanges();
break;
case "AppUsers":
var zmienna5 = (AppUsers[])myGrid.DataContext;
for (int i = 0; i < zmienna5.Count(); i++)
{
if (user != null)
{
entity.ModAppUsers(zmienna5[i].uId, zmienna5[i].login, zmienna5[i].password, zmienna5[i].Role);
}
else
{
MessageBox.Show("Nie posiadasz uprawnień do tej operacji");
break;
}
}
entity.SaveChanges();
break;
case "Pracownicy":
var zmienna6 = (Pracownicy[])myGrid.DataContext;
for (int i = 0; i < zmienna6.Count(); i++)
{
if (user != null)
{
entity.ModPracownicy(zmienna6[i].idP, zmienna6[i].imieP, zmienna6[i].nazwiskoP, zmienna6[i].miastoP, zmienna6[i].adresP, zmienna6[i].nrTelP, zmienna6[i].placaP);
}
else
{
MessageBox.Show("Nie posiadasz uprawnień do tej operacji");
break;
}
}
entity.SaveChanges();
break;
default:
MessageBox.Show("Błąd modyfikacji");
break;
}
myGrid.UpdateLayout();
}
catch (Exception)
{
MessageBox.Show("Wystąpił błąd w podanych wartościach");
}
}
else
{
MessageBox.Show("Nie posiadasz uprawnień do tej operacji");
}
}
else
{
MessageBox.Show("Wybierz tabele");
}
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (box.SelectedIndex != -1)
{
//DateTime dateOnly1,dateOnly2;
using (var entity = new kadryEntities2())
{
int id;
List <String> dane = new List <string>();
Pracownicy prac = null;
switch (box.SelectedItem.ToString())
{
case "Dzialy":
try {
id = entity.Dzialy.Max(u => u.idD);
}
catch (Exception)
{
id = 0;
}
if (id == null)
{
id = 0;
}
for (int i = 1; i < Stos.Children.Count; i += 2)
{
dane.Add(Stos.Children[i].ToString().Substring(Stos.Children[i].ToString().IndexOf(":") + 2, Stos.Children[i].ToString().Length - Stos.Children[i].ToString().IndexOf(":") - 2));
}
var user = new Dzialy {
idD = (id + 1)
};
user.nazwaD = dane[0];
user.miastoD = dane[1];
user.adresD = dane[2];
entity.Dzialy.Add(user);
break;
case "Stanowiska":
try
{
id = entity.Stanowiska.Max(u => u.idS);
}
catch (Exception)
{
id = 0;
}
if (id == null)
{
id = 0;
}
for (int i = 1; i < Stos.Children.Count; i += 2)
{
dane.Add(Stos.Children[i].ToString().Substring(Stos.Children[i].ToString().IndexOf(":") + 2, Stos.Children[i].ToString().Length - Stos.Children[i].ToString().IndexOf(":") - 2));
}
var user2 = new Stanowiska {
idS = (id + 1)
};
user2.nazwa = dane[0];
entity.Stanowiska.Add(user2);
break;
case "Oferty":
try
{
id = entity.Oferty.Max(u => u.idO);
}
catch (Exception)
{
id = 0;
}
for (int i = 1; i < Stos.Children.Count; i += 2)
{
dane.Add(Stos.Children[i].ToString().Substring(Stos.Children[i].ToString().IndexOf(":") + 2, Stos.Children[i].ToString().Length - Stos.Children[i].ToString().IndexOf(":") - 2));
}
var user3 = new Oferty {
idO = (id + 1)
};
try
{
System.Console.WriteLine("");
System.Console.WriteLine(dane[0] + dane[1]);
System.Console.WriteLine("");
System.Console.WriteLine(dane[2]);
System.Console.WriteLine("");
user3.idS = Convert.ToInt32(dane[0]);
user3.idD = Convert.ToInt32(dane[1]);
user3.dataWystaw = Convert.ToDateTime(dane[2]);
entity.Oferty.Add(user3);
}
catch (Exception)
{
MessageBox.Show("Wprowadzono błędne dane");
}
break;
case "AppUsers":
id = entity.AppUsers.Max(u => u.uId);
for (int i = 1; i < Stos.Children.Count; i += 2)
{
dane.Add(Stos.Children[i].ToString().Substring(Stos.Children[i].ToString().IndexOf(":") + 2, Stos.Children[i].ToString().Length - Stos.Children[i].ToString().IndexOf(":") - 2));
}
var user9 = new AppUsers {
uId = (id + 1)
};
try
{
user9.login = dane[0];
user9.password = dane[1];
user9.Role = dane[2];
entity.AppUsers.Add(user9);
}
catch (Exception)
{
MessageBox.Show("Wprowadzono błędne dane");
}
break;
case "Podania":
try
{
id = entity.Podania.Max(u => u.idPo);
}
catch (Exception)
{
id = 0;
}
for (int i = 1; i < Stos.Children.Count; i += 2)
{
dane.Add(Stos.Children[i].ToString().Substring(Stos.Children[i].ToString().IndexOf(":") + 2, Stos.Children[i].ToString().Length - Stos.Children[i].ToString().IndexOf(":") - 2));
}
var user4 = new Podania {
idPo = (id + 1)
};
try
{
user4.idO = Convert.ToInt32(dane[0]);
user4.imiePo = dane[1];
user4.nazwiskoPo = dane[2];
user4.miasto = dane[3];
user4.adres = dane[4];
user4.dataUrPo = Convert.ToDateTime(dane[5]);
user4.wyksztalceniePo = dane[6];
user4.dataZlozPo = Convert.ToDateTime(dane[7]);
entity.Podania.Add(user4);
}
catch (Exception)
{
MessageBox.Show("Wprowadzono błędne dane");
}
break;
case "Rozmowy":
try
{
id = entity.Rozmowy.Max(u => u.idR);
}catch (Exception)
{
id = 0;
}
for (int i = 1; i < Stos.Children.Count; i += 2)
{
dane.Add(Stos.Children[i].ToString().Substring(Stos.Children[i].ToString().IndexOf(":") + 2, Stos.Children[i].ToString().Length - Stos.Children[i].ToString().IndexOf(":") - 2));
}
Console.WriteLine(dane[0] + dane[1] + dane[2]);
var user5 = new Rozmowy {
idR = (id + 1)
};
try {
Console.WriteLine(dane[0] + dane[1] + dane[2]);
user5.idP = Convert.ToInt32(dane[0]);
user5.idPo = Convert.ToInt32(dane[1]);
user5.dataRozmowy = Convert.ToDateTime(dane[2]);
entity.Rozmowy.Add(user5);
}
catch (Exception)
{
MessageBox.Show("Wprowadzono błędne dane");
}
break;
case "stan_dzial":
id = entity.stan_dzial.Max(u => u.idD);
for (int i = 1; i < Stos.Children.Count; i += 2)
{
dane.Add(Stos.Children[i].ToString().Substring(Stos.Children[i].ToString().IndexOf(":") + 2, Stos.Children[i].ToString().Length - Stos.Children[i].ToString().IndexOf(":") - 2));
}
try {
var user6 = new stan_dzial();
user6.idS = Convert.ToInt32(dane[0]);
user6.idD = Convert.ToInt32(dane[1]);
entity.stan_dzial.Add(user6);
}
catch (Exception)
{
MessageBox.Show("Wprowadzono błędne dane");
}
break;
default:
try {
id = entity.Pracownicy.Max(u => u.idP);
}
catch (Exception)
{
id = 0;
}
for (int i = 1; i < Stos.Children.Count; i += 2)
{
dane.Add(Stos.Children[i].ToString().Substring(Stos.Children[i].ToString().IndexOf(":") + 2, Stos.Children[i].ToString().Length - Stos.Children[i].ToString().IndexOf(":") - 2));
}
var user7 = new Pracownicy {
idP = (id + 1)
};
try
{
user7.imieP = dane[0].ToString();
user7.nazwiskoP = dane[1].ToString();
user7.miastoP = dane[2].ToString();
user7.adresP = dane[3].ToString();
user7.nrTelP = dane[4];
user7.placaP = Convert.ToDouble(dane[5]);
entity.Pracownicy.Add(user7);
prac = user7;
}
catch (Exception)
{
MessageBox.Show("Wprowadzono błędne dane");
}
break;
}
try
{
entity.SaveChanges();
if (box.SelectedItem.ToString().Equals("Pracownicy"))
{
entity.AddPracMore(Convert.ToInt32(dane[6]), Convert.ToInt32(prac.idP), Convert.ToInt32(dane[7]));
}
MessageBox.Show("Dodawanie powiodło się");
}
catch (EntitySqlException)
{
MessageBox.Show("Wystąpił błąd zapisu");
}
}
}
else
{
MessageBox.Show("Wybierz tebele");
}
}
private void ComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
using (var entity = new kadryEntities2())
{
switch (boxTabel.SelectedItem.ToString())
{
case "Dzialy":
var tab1 = entity.Dzialy.ToArray();
grid.DataContext = tab1;
break;
case "Stanowiska":
var tab3 = entity.Stanowiska.ToArray();
grid.DataContext = tab3;
break;
case "Oferty":
var tab2 = entity.Oferty.ToArray();
grid.DataContext = tab2;
break;
case "Podania":
var tab4 = entity.Podania.ToArray();
grid.DataContext = tab4;
break;
case "Rozmowy":
var tab6 = entity.Rozmowy.ToArray();
grid.DataContext = tab6;
break;
case "stan_dzial":
var tab5 = entity.stan_dzial.ToArray();
grid.DataContext = tab5;
break;
case "AppUsers":
var tab8 = entity.AppUsers.ToArray();
grid.DataContext = tab8;
break;
default:
var tab7 = entity.Pracownicy.ToArray();
grid.DataContext = tab7;
break;
}
}
grid.UpdateLayout();
}
private void Button_Click_3(object sender, RoutedEventArgs e)
{
using (var entity = new kadryEntities2())
{
if (box.SelectedIndex != -1)
{
var user = entity.AppUsers.Where(x => x.login == login && x.password == haslo && (x.Role == "m" || x.Role == "a")).FirstOrDefault();
switch (box.SelectedItem.ToString())
{
case "Dzialy":
myGrid.DataContext = entity.Dzialy.ToArray();
break;
case "Stanowiska":
if (user != null)
{
myGrid.DataContext = entity.Stanowiska.ToArray();
}
break;
case "Oferty":
myGrid.DataContext = entity.Oferty.ToArray();
break;
case "AppUsers":
if (user != null)
{
myGrid.DataContext = entity.AppUsers.ToArray();
}
break;
case "Podania":
if (user != null)
{
myGrid.DataContext = entity.Podania.ToArray();
}
break;
case "Rozmowy":
myGrid.DataContext = entity.Rozmowy.ToArray();
break;
case "stan_dzial":
if (user != null)
{
myGrid.DataContext = entity.stan_dzial.ToArray();
}
break;
default:
if (user != null)
{
myGrid.DataContext = entity.Pracownicy.ToArray();
}
break;
}
}
else
{
MessageBox.Show("Wybierz tabele");
}
}
}