Exemple #1
0
        public ActionResult Create(Plyta collection)
        {
            if (ModelState.IsValid)
            {
                using (SqlConnection sqlConn = new SqlConnection(StringsqlConn))
                {
                    sqlConn.Open();

                    string     query    = "INSERT INTO plyta VALUES(@Tytul, @Autor, @Gatunek,@Zdjecie1, @Zdjecie2, @Cena,@Ilosc,@Opis,@DataWydania);";
                    SqlCommand sqlQuery = new SqlCommand(query, sqlConn);
                    sqlQuery.Parameters.AddWithValue("@Tytul", collection.Tytul);
                    sqlQuery.Parameters.AddWithValue("@Autor", collection.Autor);
                    sqlQuery.Parameters.AddWithValue("@Gatunek", collection.Gatunek);
                    sqlQuery.Parameters.AddWithValue("@Zdjecie1", collection.Zdjecie1);
                    sqlQuery.Parameters.AddWithValue("@Zdjecie2", collection.Zdjecie2);
                    sqlQuery.Parameters.AddWithValue("@Cena", collection.Cena);
                    sqlQuery.Parameters.AddWithValue("@Ilosc", collection.Ilosc);
                    sqlQuery.Parameters.AddWithValue("@Opis", collection.Opis);
                    sqlQuery.Parameters.AddWithValue("@DataWydania", collection.DataWydania);
                    sqlQuery.ExecuteNonQuery();
                }
                return(RedirectToAction(nameof(Index)));
            }
            else
            {
                return(View());
            }
        }
Exemple #2
0
        public ActionResult Create(FormCollection collection)
        {
            var us = db.Registrations.Where(c => c.Email == User.Identity.Name).FirstOrDefault();

            try
            {
                if (us.Role == "Admin")
                {
                    Plyta plyta = new Plyta();

                    plyta.Nazwa            = Convert.ToString(collection["Nazwa"]);
                    plyta.Cena             = Int32.Parse(Convert.ToString(collection["Cena"]));
                    plyta.Marka            = Convert.ToString(collection["Marka"]);
                    plyta.Opis             = Convert.ToString(collection["Opis"]);
                    plyta.Chipset          = Convert.ToString(collection["Chipset"]);
                    plyta.Gniazdo          = Convert.ToString(collection["Gniazdo"]);
                    plyta.GniazdoRAM       = Convert.ToString(collection["GniazdoRAM"]);
                    plyta.CzestotliwoscRAM = Convert.ToString(collection["CzestotliwoscRAM"]);
                    plyta.PanelTylni       = Convert.ToString(collection["PanelTylni"]);
                    plyta.Standard         = Convert.ToString(collection["Standard"]);
                    plyta.Stan             = Convert.ToString(collection["Stan"]);

                    plyta.Sprzedany = Boolean.Parse(collection["Sprzedany"]);
                    plyta.Kategoria = "Plyty";

                    db.Plyty.Add(plyta);
                    db.SaveChanges();
                }
                return(RedirectToAction("Plyty"));
            }
            catch
            {
                return(View());
            }
        }
Exemple #3
0
 public ActionResult Edit(int id, Plyta collection)
 {
     if (ModelState.IsValid)
     {
         using (SqlConnection sqlConn = new SqlConnection(StringsqlConn))
         {
             sqlConn.Open();
             string     query    = "update plyta set tytul=@Tytul, autor=@Autor,gatunek=@Gatunek,zdjecie1=@Zdjecie1,zdjecie2=@Zdjecie2,cena=@Cena,ilosc=@Ilosc,opis=@Opis,data_wydania=@DataWydania where id_plyta=@ID;";
             SqlCommand sqlQuery = new SqlCommand(query, sqlConn);
             sqlQuery.Parameters.AddWithValue("@ID", id);
             sqlQuery.Parameters.AddWithValue("@Tytul", collection.Tytul);
             sqlQuery.Parameters.AddWithValue("@Autor", collection.Autor);
             sqlQuery.Parameters.AddWithValue("@Gatunek", collection.Gatunek);
             sqlQuery.Parameters.AddWithValue("@Zdjecie1", collection.Zdjecie1);
             sqlQuery.Parameters.AddWithValue("@Zdjecie2", collection.Zdjecie2);
             sqlQuery.Parameters.AddWithValue("@Cena", collection.Cena);
             sqlQuery.Parameters.AddWithValue("@Ilosc", collection.Ilosc);
             sqlQuery.Parameters.AddWithValue("@Opis", collection.Opis);
             sqlQuery.Parameters.AddWithValue("@DataWydania", collection.DataWydania);
             sqlQuery.ExecuteNonQuery();
         }
         return(RedirectToAction(nameof(Index)));
     }
     else
     {
         return(View());
     }
 }
Exemple #4
0
        public ActionResult Edit(int id, FormCollection collection)
        {
            var us = db.Registrations.Where(c => c.Email == User.Identity.Name).FirstOrDefault();

            try
            {
                if (us.Role == "Admin")
                {
                    Plyta plyta = db.Plyty.Find(id);

                    plyta.Nazwa            = Convert.ToString(collection["Nazwa"]);
                    plyta.Cena             = Int32.Parse(Convert.ToString(collection["Cena"]));
                    plyta.Marka            = Convert.ToString(collection["Marka"]);
                    plyta.Opis             = Convert.ToString(collection["Opis"]);
                    plyta.Chipset          = Convert.ToString(collection["Chipset"]);
                    plyta.Gniazdo          = Convert.ToString(collection["Gniazdo"]);
                    plyta.GniazdoRAM       = Convert.ToString(collection["GniazdoRAM"]);
                    plyta.CzestotliwoscRAM = Convert.ToString(collection["CzestotliwoscRAM"]);
                    plyta.PanelTylni       = Convert.ToString(collection["PanelTylni"]);
                    plyta.Standard         = Convert.ToString(collection["Standard"]);
                    plyta.Stan             = Convert.ToString(collection["Stan"]);

                    db.Entry((Plyta)plyta).State = EntityState.Modified;
                    db.SaveChanges();
                }
                return(RedirectToAction("Plyty"));
            }
            catch
            {
                return(View());
            }
        }
    static void Main(string[] args)
    {
        // Ask the user for the relevant data
        Console.WriteLine("iveskite plytos ilgi - ");
        int ilgis = int.Parse(Console.ReadLine());

        Console.WriteLine("iveskite plytos auksti - ");
        int aukstis = int.Parse(Console.ReadLine());

        // Now we're in a position to create the object
        Plyta p1 = new Plyta(ilgis, aukstis);

        // And we can read the value back from the property
        Console.WriteLine(p1.Ilgis);
    }
        public async Task <IActionResult> AddOrEdit([Bind("PlytaId,Kod,Ilosc")] Plyta plyta)
        {
            if (ModelState.IsValid)
            {
                if (plyta.PlytaId == 0)
                {
                    _context.Add(plyta);
                }

                else
                {
                    _context.Update(plyta);
                }
                await _context.SaveChangesAsync();

                return(RedirectToAction(nameof(Index)));
            }
            return(View(plyta));
        }
Exemple #7
0
        // GET: Plyta/Edit/5
        public ActionResult Edit(int id)
        {
            var us = db.Registrations.Where(c => c.Email == User.Identity.Name).FirstOrDefault();

            try
            {
                if (us.Role == "Admin")
                {
                    Plyta plyta = db.Plyty.Where(c => c.PlytaId == id).FirstOrDefault();
                    if (plyta != null)
                    {
                        return(View("~/Views/Plyta/Edit.cshtml", db.Plyty.Where(c => c.PlytaId == id).FirstOrDefault())); //return edit view
                    }
                }
                return(RedirectToAction("Plyty"));
            }
            catch
            {
                return(RedirectToAction("Pytyly"));
            }
        }
Exemple #8
0
        // GET: Plyta/Delete/5
        public ActionResult Delete(int id)
        {
            var us = db.Registrations.Where(c => c.Email == User.Identity.Name).FirstOrDefault();

            try
            {
                if (us.Role == "Admin")
                {
                    Plyta plyta = db.Plyty.Find(id);
                    if (plyta != null)
                    {
                        return(View(plyta));
                    }
                }
                return(RedirectToAction("Plyty"));
            }
            catch
            {
                return(RedirectToAction("Plyty"));
            }
        }