Esempio n. 1
0
 private void Button_Click_6(object sender, RoutedEventArgs e)
 {
     using (var entity = new kadryEntities2())
     {
         myGrid.DataContext = entity.WolneEtaty().ToArray();
     }
 }
Esempio n. 2
0
 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();
         }
     }
 }
Esempio n. 3
0
 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");
         }
     }
 }
Esempio n. 4
0
        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();
                }
            }
        }
Esempio n. 5
0
 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");
         }
     }
 }
Esempio n. 6
0
 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);
     }
 }
Esempio n. 7
0
        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ę");
            }
        }
Esempio n. 8
0
 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");
         }
     }
 }
Esempio n. 9
0
 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);
     }
 }
Esempio n. 10
0
        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;
            }
        }
Esempio n. 11
0
        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);
                }
            }
        }
Esempio n. 12
0
        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;
                }
            }
        }
Esempio n. 13
0
        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;
                }
            }
        }
Esempio n. 14
0
        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");
                }
            }
        }
Esempio n. 15
0
        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");
            }
        }
Esempio n. 16
0
        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();
        }
Esempio n. 17
0
        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");
                }
            }
        }