Exemple #1
0
        public async Task <IActionResult> Edit(int id, [Bind("id,imie,nazwisko,data_urodzenia,plec,miasto,liczba_dzieci")] Studenci studenci)
        {
            if (id != studenci.id)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(studenci);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!StudenciExists(studenci.id))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            return(View(studenci));
        }
Exemple #2
0
        public static void Uruchom()
        {
            Studenci.listaStudentów = Studenci.Deserializuj(Studenci.sciezkaBazyDanych);
            int i;

            do
            {
                i = Menu();
                switch (i)
                {
                case 1:
                    Fabryka.Wybor();
                    break;

                case 2:
                    WyświetlanieIModyfikacja.Wybor();
                    break;

                case 0:
                    Studenci.Serializuj(Studenci.sciezkaBazyDanych, Studenci.listaStudentów);
                    break;

                default:
                    break;
                }
            } while (i != 0);
        }
Exemple #3
0
        //
        // GET: /Admin/Students/Delete/5

        public ActionResult Delete(int id)
        {
            _logger.Info("StudenciController.Delete => HTTP GET");
            ViewBag.Current = "Students";
            Studenci student = _repo1.GetStudentByID(id);

            return(View(student));
        }
Exemple #4
0
        //
        // GET: /Admin/Students/Edit/5

        public ActionResult Edit(int id)
        {
            _logger.Info("StudenciController.Edit => HTTP GET");
            ViewBag.Current = "Students";
            Studenci student = _repo1.GetStudentByID(id);

            ViewBag.ListaGrup = _repo.GetAllGroups;
            return(View(student));
        }
Exemple #5
0
        public ActionResult DeleteConfirmed(int id)
        {
            _logger.Info("StudenciController.Delete => SUCCES = Delete Studenci| HTTP POST");
            Studenci student = (Studenci)_repo1.GetStudentByID(id);

            _repo1.DeleteStudent(student);
            _repo1.Save();
            TempData["message"] = "Usunięto Studenta!";
            TempData["status"]  = "valid";
            return(RedirectToAction("List"));
        }
Exemple #6
0
        public async Task <IActionResult> Create([Bind("id,imie,nazwisko,data_urodzenia,plec,miasto,liczba_dzieci")] Studenci studenci)
        {
            if (ModelState.IsValid)
            {
                _context.Add(studenci);
                await _context.SaveChangesAsync();

                return(RedirectToAction(nameof(Index)));
            }
            return(View(studenci));
        }
Exemple #7
0
        public async Task <IActionResult> Index(string nazwa)
        {
            List <Studenci> stud = new List <Studenci>();



            if (nazwa != null)
            {
                query = nazwa;
            }
            var conn = _context.Database.GetDbConnection();

            try {
                conn.Open();
                using (var command = conn.CreateCommand())
                {
                    command.CommandText = query;
                    DbDataReader reader = await command.ExecuteReaderAsync();

                    if (reader.HasRows)
                    {
                        while (await reader.ReadAsync())
                        {
                            var row = new Studenci {
                                id = reader.GetInt32(6), imie = reader.GetString(0), nazwisko = reader.GetString(1), data_urodzenia = reader.GetDateTime(2), miasto = reader.GetString(4), liczba_dzieci = reader.GetInt32(5)
                            };
                            stud.Add(row);
                        }
                    }
                    reader.Dispose();
                }
            }
            finally
            {
                conn.Close();
            }

            ViewData["nazwa"] = nazwa;
            return(View(stud));

            // return View(await _context.Studenci.ToListAsync());



            //return View(await _context.Studenci.ToListAsync());
        }
Exemple #8
0
        public ActionResult Edit(Studenci student)
        {
            _logger.Info("StudenciController.Edit => Entering| HTTP POST");
            if (ModelState.IsValid)
            {
                _repo1.EditStudent(student);
                _repo1.Save();
                _logger.Info("StudenciController.Edit => SUCCES = Edit Studenci| HTTP POST");
                TempData["message"] = "Zauktalizowano studenta!";
                TempData["status"]  = "valid";
                return(RedirectToAction("List"));
            }
            _logger.Info("StudenciController.Edit => FAILED = Edit Studenci| HTTP POST");

            ViewBag.ListaGrup   = _repo.GetAllGroups;
            TempData["message"] = "Nie udało się uaktualnić studenta! Taki student istnieje!";
            TempData["status"]  = "invalid";
            ViewBag.Current     = "Students";
            return(View(student));
        }
        public override bool IsUserInRole(string username, string rolename)
        {
            Prowadzacy user    = repository.GetProwadzacyByName(username);
            Studenci   student = null;

            if (user == null)
            {
                student = repository.GetStudentByName(username);
            }

            if (!repository.ProwadzacyExists(user))
            {
                return(false);
            }
            if (student != null && !repository.StudentExists(student))
            {
                return(false);
            }

            return(user.admin);
        }
Exemple #10
0
        public static void Wybor()
        {
            int i;

            do
            {
                i = Menu();
                switch (i)
                {
                case 1:
                    Studenci.DodajStudentaDziennego();
                    break;

                case 2:
                    Studenci.DodajStudentaZaocznego();
                    break;

                default:
                    break;
                }
            } while (i != 0);
        }
Exemple #11
0
 public ActionResult Add(Studenci student)
 {
     _logger.Info("StudenciController.Add => Entering | HTTP POST");
     if (!_repo1.StudentExists(student) && !_repo1.IndeksExists(student))
     {
         if (ModelState.IsValid)
         {
             student.haslo = FormsAuthentication.HashPasswordForStoringInConfigFile(student.haslo.Trim(), "md5");
             _repo1.AddStudent(student);
             _repo1.Save();
             _logger.Info("StudenciController.Add => SUCCES = Add Studenci| HTTP POST");
             TempData["message"] = "Pomyślnie dodano nowego studenta!";
             TempData["status"]  = "valid";
             return(RedirectToAction("List"));
         }
     }
     _logger.Info("StudenciController.Add => FAILED = Add Studenci | HTTP POST");
     TempData["message"] = "Nie udało się dodać studenta! Taki student istnieje!";
     TempData["status"]  = "invalid";
     ViewBag.Current     = "Students";
     ViewBag.ListaGrup   = _repo.GetAllGroups;
     return(View(student));
 }
        private void InsertStudentsToGroups(string filepath, string filename, string groupname)
        {
            string fullpath = Server.MapPath("/excelfolder/") + filename;

            string constr = string.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 12.0 Xml;HDR=YES;""", fullpath);

            var Econ = new OleDbConnection(constr);

            string query = string.Format("Select * from [{0}]", "Studenci$");

            OleDbCommand Ecom = new OleDbCommand(query, Econ);

            Econ.Open();



            DataSet ds = new DataSet();

            OleDbDataAdapter oda = new OleDbDataAdapter(query, Econ);

            Econ.Close();

            oda.Fill(ds);

            if (db.Grupy.Where(s => s.nazwa == groupname).Count() == 0)
            {
                Grupy gr = new Grupy();
                gr.nazwa = groupname;
                db.Grupy.Add(gr);
                db.SaveChanges();
            }

            int group_id = db.Grupy.Where(s => s.nazwa == groupname).ToList().ElementAt(0).id;

            DataTable dt = ds.Tables[0];

            foreach (DataRow x in dt.Rows)
            {
                if (x.ItemArray.Length == 3)
                {
                    Studenci st = new Studenci();
                    st.indeks   = Int32.Parse(x.ItemArray.ElementAt(0).ToString());
                    st.imie     = x.ItemArray.ElementAt(1).ToString();
                    st.nazwisko = x.ItemArray.ElementAt(2).ToString();
                    if (db.Studenci.Where(s => s.indeks == st.indeks).Count() == 0)
                    {
                        db.Studenci.Add(st);
                        db.SaveChanges();
                    }

                    if (db.StudenciGrupy.Where(s => (s.id_studenta == st.indeks) && (s.id_grupy == group_id)).Count() == 0)
                    {
                        StudenciGrupy sg = new StudenciGrupy();
                        sg.id_grupy    = group_id;
                        sg.id_studenta = st.indeks;
                        db.StudenciGrupy.Add(sg);
                        db.SaveChanges();
                    }
                }
                if (x.ItemArray.Length == 4)
                {
                    Studenci st = new Studenci();
                    st.indeks   = Int32.Parse(x.ItemArray.ElementAt(0).ToString());
                    st.imie     = x.ItemArray.ElementAt(1).ToString();
                    st.nazwisko = x.ItemArray.ElementAt(2).ToString();
                    st.mail     = x.ItemArray.ElementAt(3).ToString();
                    if (db.Studenci.Where(s => s.indeks == st.indeks).Count() == 0)
                    {
                        db.Studenci.Add(st);
                        db.SaveChanges();
                    }
                    if (db.StudenciGrupy.Where(s => (s.id_studenta == st.indeks) && (s.id_grupy == group_id)).Count() == 0)
                    {
                        StudenciGrupy sg = new StudenciGrupy();
                        sg.id_grupy    = group_id;
                        sg.id_studenta = st.indeks;
                        db.StudenciGrupy.Add(sg);
                        db.SaveChanges();
                    }
                }
            }
        }
Exemple #13
0
 public List <WidokStudenta> PobierzWybranychStudentow(sbyte idGrupy)
 {
     return(Studenci.Where(a => a.Grupa.Id_grupa == idGrupy).ToList());
 }
Exemple #14
0
 public void DeleteStudent(Studenci student)
 {
     entities.Studenci.Remove(student);
 }
Exemple #15
0
 public void EditStudent(Studenci student)
 {
     entities.Entry(student).State = EntityState.Modified;
 }
Exemple #16
0
 public void AddStudent(Studenci student)
 {
     entities.Studenci.Add(student);
 }
Exemple #17
0
 public bool IndeksExists(Studenci student)
 {
     return(entities.Studenci.Any(m => m.nr_indeksu == student.nr_indeksu));
 }
Exemple #18
0
 public bool StudentExists(Studenci student)
 {
     return(entities.Studenci.Any(m => m.login == student.login));
 }
Exemple #19
0
 public List <WidokStudenta> PobierzWybranychStudentowRok(int rok)
 {
     return(Studenci.Where(a => a.Grupa.Rok == rok).ToList());
 }
Exemple #20
0
        public static void Wybor()
        {
            Delegat d = new Delegat(Studenci.Wyświetl);

            d += Studenci.PytanieOZapisywanie;
            int i;

            do
            {
                i = Menu();
                switch (i)
                {
                case 1:
                    Studenci.Wyświetl(Studenci.listaStudentów);
                    Console.ReadKey();
                    break;

                case 2:
                    List <Student> lista = Studenci.WyszukajStudentówDziennych();
                    d(lista);
                    break;

                case 3:
                    List <Student> lista2 = Studenci.WyszukajStudentówZaocznych();
                    d(lista2);
                    break;

                case 4:
                    int ind = Studenci.ZnajdźStudenta();
                    if (ind >= 0)
                    {
                        Studenci.listaStudentów[ind].WyświetlPełneInformacje();
                    }

                    Console.ReadKey();
                    break;

                case 5:
                    int numer = Studenci.ZnajdźStudenta();
                    if (numer >= 0)
                    {
                        Modyfikacja.Wybor(numer);
                    }

                    break;

                case 6:
                    Studenci.listaStudentów.Sort();
                    d(Studenci.listaStudentów);
                    break;

                case 7:
                    Studenci.listaStudentów.Sort(new Student.PoWydziale());
                    d(Studenci.listaStudentów);
                    break;

                case 8:
                    Studenci.listaStudentów.Sort(new Student.PoKierunku());
                    d(Studenci.listaStudentów);
                    break;

                case 9:
                    Studenci.listaStudentów.Sort(new Student.PoŚredniej());
                    d(Studenci.listaStudentów);
                    break;

                case 10:
                    Studenci.Wyświetl(Studenci.Wczytywanie());
                    Console.ReadKey();
                    break;

                default:
                    break;
                }
            } while (i != 0);
        }