//izmena i brisanje aranzmana
public static void ObrisiAranzmanPoSifri(int sifra)
{
TuristickaAgencijaEntities dbEntitet = new TuristickaAgencijaEntities();
try
{
Aranzman aranzman = (from a in dbEntitet.Aranzmen where a.AranzmanID == sifra select a).Single();
aranzman.Aktivan = 0;
dbEntitet.SaveChanges();
}
catch (Exception)
{
}
}
public static void DodajAranzman(int hotelID, int uslugaID, int terminID, int cena, int raspolozivost)
{
using (TuristickaAgencijaEntities dbEntitet = new TuristickaAgencijaEntities())
{
int sifra = (from a in dbEntitet.Aranzmen
select a.AranzmanID).Max();
Aranzman aranzman = new Aranzman {
AranzmanID = sifra + 1, HotelID = hotelID, UslugaID = uslugaID, TerminID = terminID, Cena = cena, Raspolozivost = raspolozivost, Aktivan = 1
};
try
{
dbEntitet.Aranzmen.Add(aranzman);
dbEntitet.SaveChanges();
}
catch (Exception e) { }
}
}
public static void IzmeniAranzman(Aranzman aranzman)
{
using (TuristickaAgencijaEntities dbEntitet = new TuristickaAgencijaEntities())
{
Aranzman izmena = (from a in dbEntitet.Aranzmen
where a.AranzmanID == aranzman.AranzmanID
select a).Single();
izmena.Cena = aranzman.Cena;
izmena.Raspolozivost = aranzman.Raspolozivost;
try
{
dbEntitet.SaveChanges();
}
catch (Exception)
{
}
}
}
