internal void StergePoza(int idPreparat, Fotografie pozaDeSters) { RestaurantEntities1 context = new RestaurantEntities1(); context.StergePoza(pozaDeSters.id_foto, idPreparat); context.SaveChanges(); }
protected override Fotografie select(Fotografie fotografie) { Database db = new Database(); db.Connect(); OracleCommand cmd = db.CreateCommand(SELECT); cmd.Parameters.Add("fotoId", fotografie.FotoId); List <Fotografie> vystup = new List <Fotografie>(); OracleDataReader readshit = db.Select(cmd); while (readshit.Read()) { Fotografie tmp = new Fotografie(); tmp.FotoId = readshit.GetInt32(0); tmp.Nazev = readshit.GetString(1); tmp.Datum = readshit.GetDateTime(2); tmp.Popis = readshit.GetValue(3) == DBNull.Value ? null : readshit.GetString(3); tmp.AlbumId = readshit.GetInt32(4); tmp.Visible = readshit.GetInt32(5); vystup.Add(tmp); } Fotografie wtf = null; if (vystup.Count == 1) { wtf = vystup[0]; } readshit.Close(); db.Close(); return(wtf); }
protected override List <Fotografie> select_alb(int albumId) { Database db = new Database(); db.Connect(); OracleCommand cmd = db.CreateCommand(SELECT_ALB); cmd.Parameters.Add("albumId", albumId); List <Fotografie> vystup = new List <Fotografie>(); OracleDataReader readshit = db.Select(cmd); while (readshit.Read()) { Fotografie tmp = new Fotografie(); tmp.FotoId = readshit.GetInt32(0); tmp.Nazev = readshit.GetString(1); tmp.Datum = readshit.GetDateTime(2); tmp.Popis = readshit.GetValue(3) == DBNull.Value ? null : readshit.GetString(3); tmp.AlbumId = readshit.GetInt32(4); tmp.Visible = readshit.GetInt32(5); vystup.Add(tmp); } db.Close(); readshit.Close(); return(vystup); }
protected override void delete(Fotografie fotografie) { Database db = new Database(); db.Connect(); OracleCommand cmd = db.CreateCommand(DELETE); cmd.Parameters.Add("fotoId", fotografie.FotoId); db.ExecuteNonQuery(cmd); db.Close(); }
protected override void update(Fotografie fotografie) { Database db = new Database(); db.Connect(); OracleCommand cmd = db.CreateCommand(UPDATE); cmd.Parameters.Add("nazev", fotografie.Nazev); cmd.Parameters.Add("popis", fotografie.Popis); cmd.Parameters.Add("albumId", fotografie.AlbumId); cmd.Parameters.Add("visible", fotografie.Visible); db.ExecuteNonQuery(cmd); db.Close(); }
protected override void insert(Fotografie fotografie) { Database db = new Database(); db.Connect(); OracleCommand cmd = db.CreateCommand(INSERT); DateTime now = DateTime.Today; cmd.Parameters.Add("nazev", fotografie.Nazev); cmd.Parameters.Add("datum", now); cmd.Parameters.Add("popis", fotografie.Popis); cmd.Parameters.Add("albumId", fotografie.AlbumId); db.ExecuteNonQuery(cmd); db.Close(); }
public ActionResult Upload(IEnumerable <HttpPostedFileBase> files, Hotel hotel, int stravovani) { HotelDao hd = new HotelDao(); StatDao sd = new StatDao(); Stat s = sd.FindStat(hotel.destinace.stat.jmeno); if (s == null) { sd.Create(hotel.destinace.stat); } else { hotel.destinace.stat = s; } DestinaceDao dd = new DestinaceDao(); Destinace d = dd.FindDestinace(hotel.destinace.nazev); if (d == null) { dd.Create(hotel.destinace); } else { hotel.destinace = d; } ZpusobStravovani st = new ZpusobStravovaniDao().GetById(stravovani); hotel.stravovani = st; hd.Create(hotel); FotografieDao fd = new FotografieDao(); foreach (var file in files) { if (file != null && file.ContentLength > 0) { Fotografie f = new Fotografie(); Stream str = file.InputStream; Image image = Image.FromStream(file.InputStream); Image smallImage = ImageHelper.ScaleImage(Image.FromStream(str), 300, 200); Bitmap b = new Bitmap(image); Bitmap sb = new Bitmap(smallImage); Guid guid = Guid.NewGuid(); string imageName = guid.ToString() + ".png"; b.Save(Server.MapPath("~/Images/hotely/" + imageName), ImageFormat.Jpeg); sb.Save(Server.MapPath("~/Images/hotely/nahled/" + imageName), ImageFormat.Jpeg); smallImage.Dispose(); b.Dispose(); f.fotografie = "~/Images/hotely/" + imageName; f.nahled = "~/Images/hotely/nahled/" + imageName; f.hotel = hotel; f.popisek = hotel.nazev; fd.Create(f); } TempData["x"] = "Hotel úspěšně přidán"; } IList <Uzivatel> odberatele = new UzivatelDao().GetUsersWithNews(); foreach (Uzivatel u in odberatele) { MailClient.sendMail(u.login, "Nový hotel", "V naši nabídce se objevil nový hotel: " + hotel.nazev + " nacházející se v " + hotel.destinace.stat.jmeno + " - " + hotel.destinace.nazev + " více na www.eurotravel.cz"); } return(RedirectToAction("Index", "Zajezdy")); }
public ActionResult UpdateInDB(IEnumerable <HttpPostedFileBase> files, Hotel hotel, int stravovani) { HotelDao hd = new HotelDao(); StatDao sd = new StatDao(); Stat s = sd.FindStat(hotel.destinace.stat.jmeno); if (s == null) { sd.Create(hotel.destinace.stat); } else { hotel.destinace.stat = s; } DestinaceDao dd = new DestinaceDao(); Destinace d = dd.FindDestinace(hotel.destinace.nazev); if (d == null) { dd.Create(hotel.destinace); } else { hotel.destinace = d; } ZpusobStravovani st = new ZpusobStravovaniDao().GetById(stravovani); hotel.stravovani = st; FotografieDao fd = new FotografieDao(); hotel.fotky = fd.GetPhotosByHotelId(hotel.Id); hd.Update(hotel); foreach (var file in files) { if (file != null && file.ContentLength > 0) { Fotografie f = new Fotografie(); Stream str = file.InputStream; Image image = Image.FromStream(file.InputStream); Image smallImage = ImageHelper.ScaleImage(Image.FromStream(str), 300, 200); Bitmap b = new Bitmap(image); Bitmap sb = new Bitmap(smallImage); Guid guid = Guid.NewGuid(); string imageName = guid.ToString() + ".png"; b.Save(Server.MapPath("~/Images/hotely/" + imageName), ImageFormat.Jpeg); sb.Save(Server.MapPath("~/Images/hotely/nahled/" + imageName), ImageFormat.Jpeg); smallImage.Dispose(); b.Dispose(); f.fotografie = "~/Images/hotely/" + imageName; f.nahled = "~/Images/hotely/nahled/" + imageName; f.hotel = hotel; f.popisek = hotel.nazev; fd.Create(f); } } return(RedirectToAction("Index", "Zajezdy")); }
protected abstract Fotografie select(Fotografie fotografie);
protected abstract void update(Fotografie fotografie);
protected abstract void insert(Fotografie fotografie);
public static Fotografie Select(Fotografie fotografie) { return(chmpff.select(fotografie)); }
public static void Delete(Fotografie fotografie) { chmpff.delete(fotografie); }
public static void Update(Fotografie fotografie) { chmpff.update(fotografie); }
public static void Insert(Fotografie fotografie) { chmpff.insert(fotografie); }
protected abstract void delete(Fotografie fotografie);
public InformatiiPreparat(Preparat preparat, Categorie categorie, Fotografie fotografie) { this.Preparat = preparat; this.Categorie = categorie; this.Fotografie = fotografie; }