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;
}
