private void Izmeni_Click(object sender, RoutedEventArgs e)
{
Salon kopija = (Salon)IzabraniSalon.Clone();
var salonProzor = new IzmenaSalona(kopija, IzmenaSalona.Operacija.IZMENA);
salonProzor.ShowDialog();
}
public IHttpActionResult PostSalon(Salon salon)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Salon.Add(salon);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (SalonExists(salon.SalonID))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = salon.SalonID }, salon));
}
public bool RegistrarActualizarSalon(ISalonDTO salonDTO)
{
bool resultado = false;
using (ExperisDBEntities experisDBEntities = new ExperisDBEntities())
{
using (var transacion = experisDBEntities.Database.BeginTransaction())
{
try
{
Salon salon = new Salon();
if (salonDTO.IdSalon > 0)
{
salon = experisDBEntities.Salon.Find(salonDTO.IdSalon);
salon = salonDTO.MapearSalon <Salon>(salon);
}
else
{
salon = salonDTO.MapearSalon <Salon>();
experisDBEntities.Salon.Add(salon);
}
experisDBEntities.SaveChanges();
transacion.Commit();
resultado = true;
}
catch (Exception e)
{
transacion.Rollback();
throw new Exception(e.Message);
}
}
}
return(resultado);
}
public void cargar()
{
try {
Grado objGrado = new Grado();
OperacionGrado objOperGrado = new OperacionGrado(ConfigurationManager.ConnectionStrings["estigioacademicoConnectionString"].ConnectionString);
clsFunciones.enlazarCombo(objOperGrado.ConsultarGrado(objGrado), ddlGrado);
Salon objSalon = new Salon();
OperacionSalon objOperSalon = new OperacionSalon(ConfigurationManager.ConnectionStrings["estigioacademicoConnectionString"].ConnectionString);
clsFunciones.salon = objOperSalon.ConsultarSalon(objSalon);
string accion = Page.RouteData.Values["Accion"].ToString();
if (accion.Equals("Edita"))
{
Matricula objMatricula = new Matricula();
OperacionMatricula objOperMatricula = new OperacionMatricula(ConfigurationManager.ConnectionStrings["estigioacademicoConnectionString"].ConnectionString);
clsFunciones.enlazarCombo(clsFunciones.salon, ddlSalon);
string id = clsEncriptar.Desencriptar(Page.RouteData.Values["Id"].ToString());
objMatricula.id = int.Parse(id);
GridView tbl_Matricula = new GridView();
tbl_Matricula.DataSource = objOperMatricula.ConsultarMatricula(objMatricula);
tbl_Matricula.DataBind();
ddlSalon.SelectedValue = tbl_Matricula.Rows[0].Cells[2].Text;
txtEstudiante.Text = tbl_Matricula.Rows[0].Cells[5].Text;
txtNombres.Text = HttpUtility.HtmlDecode(tbl_Matricula.Rows[0].Cells[6].Text);
txtApellidos.Text = HttpUtility.HtmlDecode(tbl_Matricula.Rows[0].Cells[7].Text);
this.seleccionar_Grado(ddlGrado, ddlSalon);
}
}catch (Exception) {}
}
public SalonProzor(Salon salon, TipKorisnika tip)
{
InitializeComponent();
this.s = salon;
this.t = tip;
tbNaziv.DataContext = salon;
tbAdresa.DataContext = salon;
tbTelefon.DataContext = salon;
tbEmail.DataContext = salon;
tbSajt.DataContext = salon;
tbPIB.DataContext = salon;
tbMaticni.DataContext = salon;
tbZiroRacun.DataContext = salon;
if (t == TipKorisnika.Administrator)
{
tbcIspis.Visibility = Visibility.Hidden;
}
else
{
tbNaziv.Visibility = Visibility.Hidden;
tbAdresa.Visibility = Visibility.Hidden;
tbTelefon.Visibility = Visibility.Hidden;
tbEmail.Visibility = Visibility.Hidden;
tbSajt.Visibility = Visibility.Hidden;
tbPIB.Visibility = Visibility.Hidden;
tbMaticni.Visibility = Visibility.Hidden;
tbZiroRacun.Visibility = Visibility.Hidden;
btnPotvrdi.ToolTip = "Zatvori";
btnOdustani.Visibility = Visibility.Hidden;
tbcIspis.Text = IspisPodataka();
}
}
public async Task <IActionResult> Edit(int id, [Bind("Id,SalonSeats,SalonName")] Salon salon)
{
if (id != salon.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(salon);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SalonExists(salon.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(salon));
}
public int GetCommandNbr([PexAssumeUnderTest] Salon target, int id)
{
int result = target.GetCommandNbr(id);
return(result);
// TODO: add assertions to method SalonTest.GetCommandNbr(Salon, Int32)
}
private void cmdRead_Click(object sender, EventArgs e)
{
try
{
ISession s = DataLayer.GetSession();
// Ucitavaju se podaci o zaposlenom sa specificiranim id-em
Zaposleni zaposleni = s.Load <Zaposleni>(35);
Servis servis = s.Load <Servis>(1);
Kupac kupac = s.Load <Kupac>(3);
Vozilo vozilo = s.Load <Vozilo>(3);
Salon salon = s.Load <Salon>(1);
NezavisniEkonomista nEkonomista = s.Load <NezavisniEkonomista>(1);
Specijalnost specijalnost = s.Load <Specijalnost>(1);
MessageBox.Show(specijalnost.specijalnost);
MessageBox.Show(nEkonomista.ime);
MessageBox.Show(salon.grad);
MessageBox.Show(kupac.ime);
MessageBox.Show(vozilo.modelVozila);
MessageBox.Show(servis.salon.grad);
MessageBox.Show((zaposleni.plata).ToString());
s.Close();
}
catch (Exception ec)
{
MessageBox.Show(ec.Message);
}
}
public int GetClientNbr([PexAssumeUnderTest] Salon target)
{
int result = target.GetClientNbr();
return(result);
// TODO: add assertions to method SalonTest.GetClientNbr(Salon)
}
public string GetCommand([PexAssumeUnderTest] Salon target, int id)
{
string result = target.GetCommand(id);
return(result);
// TODO: add assertions to method SalonTest.GetCommand(Salon, Int32)
}
public string SalonGetir(int ID)
{
int salonID = Database.Session.Get <Seans>(ID).SalonID;
Salon Salons = Database.Session.Query <Salon>().SingleOrDefault(x => x.ID.Equals(salonID));
return($"{Salons.ID}x{Salons.SalonAdi}");
}
/// <summary>
/// Selecciona entre la lista de grupos el salon que tiene mas puntos en la base de datos para el salon
/// </summary>
/// <param name="empalme"></param>
/// <param name="s"></param>
private void AsignacionMejorEleccion(ListaVariables empalme, Salon s)
{
Variable gOtrosSemestres = null, gAux = null, g = null;
//Obtiene los gupos validos
ListaVariables validos = empalme.Validos();
//Obtiene los grupos que estaban
ListaVariables otrosSemestres = new ListaVariables(validos.AsignacionOtrosSemestres(s.Cve_espacio));
otrosSemestres.SetSalones(salones);
validos.SetSalones(salones);
otrosSemestres = otrosSemestres.OrdenarMejorPuntuacion(s);
ListaVariables aux = validos.OrdenarMejorPuntuacion(s);
gAux = aux.Count != 0 ? (aux as IList <Variable>)[0] : null;
gOtrosSemestres = otrosSemestres.Count != 0 ? (otrosSemestres as IList <Variable>)[0] : null;
if (gAux != null && gOtrosSemestres != null)
{
g = gAux.Puntos > gOtrosSemestres.Puntos ? gAux : gOtrosSemestres;
}
else if (gAux != null && gOtrosSemestres == null)
{
g = gAux;
}
else
{
g = gOtrosSemestres;
}
QuitaSalon(empalme, g);
}
public RacunIzgled(Racun racun, Salon salon)
{
InitializeComponent();
lbIme.Content = salon.Naziv;
lbAdresa.Content = salon.Adresa;
lbPIB.Content = salon.PIB;
lbTelefon.Content = salon.Telefon;
lbPdv.Content = racun.UkupnaCena * 0.02;
lbOsnovica.Content = (racun.UkupnaCena + (racun.UkupnaCena * 0.02));
lUkupnaCena.Content = racun.UkupnaCena;
lbDate.Content = racun.DatumProdaje;
foreach (var n in Projekat.Instance.spn)
{
if (n.RacunId == racun.Id)
{
var nam = Namestaj.GetById(n.NamestajId);
listBox.Items.Add($"{nam.Naziv}");
listBox.Items.Add($"{n.Kolicina} x {nam.Cena} {n.Kolicina*nam.Cena}");
}
}
foreach (var n in Projekat.Instance.spdu)
{
if (n.RacunId == racun.Id)
{
var nam = DodatnaUsluga.GetById(n.DUId);
listBox.Items.Add($"{nam.Naziv} {nam.Cena}");
}
}
}
public Entitet GetByID(int id)
{
Salon s = new Salon();
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString)) {
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM Salon WHERE Id=@Id";
cmd.Parameters.AddWithValue("Id", id);
DataSet dataSet = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = cmd;
adapter.Fill(dataSet, "Salon");
foreach (DataRow row in dataSet.Tables["Salon"].Rows)
{
s.ID = int.Parse(row["ID"].ToString());
s.Naziv = row["Naziv"].ToString();
s.Mail = row["Mail"].ToString();
s.MatBr = row["MatBr"].ToString();
s.Obrisan = Boolean.Parse(row["Obrisan"].ToString());
s.PIB = row["PIB"].ToString();
s.Sajt = row["Sajt"].ToString();
s.Telefon = row["Telefon"].ToString();
s.ZiroRacun = row["ZiroRacun"].ToString();
s.Adresa = row["Adresa"].ToString();
}
}
return(s);
}
public IChannel GetPlayer([PexAssumeUnderTest] Salon target, int id)
{
IChannel result = target.GetPlayer(id);
return(result);
// TODO: add assertions to method SalonTest.GetPlayer(Salon, Int32)
}
public string Create(SalonViewModel model) //yeni bir tane film tur ekleme yapar
{
try
{
SinemaOtomasyonuEntities db = new SinemaOtomasyonuEntities();
Salon ft = null;
if (model.SalonIDNumber > 0)
{
ft = db.Salon.FirstOrDefault(f => f.SalonID == model.SalonIDNumber);
}
else
{
ft = new Salon();
}
ft.SalonAd = model.SalonAdNumber;
ft.SalonKapasite = model.SalonKapasiteNumber;
ft.SalonSiraSayisi = model.SalonSiraSayisiNumber;
ft.SeansID = model.SeansIDNumber;
if (model.SalonIDNumber == 0)
{
db.Salon.Add(ft);
}
db.SaveChanges();
return("1");
}
catch
{
return("-1");
}
}
public bool PlayGame([PexAssumeUnderTest] Salon target)
{
bool result = target.PlayGame();
return(result);
// TODO: add assertions to method SalonTest.PlayGame(Salon)
}
public SalonView(Salon s)
{
idSalon = s.idSalon;
grad = s.grad;
adresa = s.adresa;
stepenOpremljenosti = s.stepenOpremljenosti;
}
public AdministracijaNamestajaViewModel(Salon s)
{
salon = s;
database = new DatabaseAccess();
magacin = new ObservableCollection <Namestaj>(salon.Magacin);
}
public IActionResult Edit(int id, [Bind("CustomerId,EmailAddress,CustomerFN,CustomerLN,StreetAddress,City,State,Zip,PhoneNumber")] CustomerAccount customerAccount)
{
if (id != customerAccount.CustomerId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
Salon.EditAccount(customerAccount);
}
catch (DbUpdateConcurrencyException)
{
if (!Salon.CustomerAccountExists(customerAccount.CustomerId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(customerAccount));
}
private static void DodavanjeNovogSalona()
{
var lista = Projekat.Instance.Salon;
Console.WriteLine("===Dodavanje novog salona===");
var noviSalon = new Salon();
noviSalon.Id = lista.Count + 1;
Console.WriteLine("Unesite naziv: ");
noviSalon.Naziv = Console.ReadLine();
Console.WriteLine("Unesite adresu: ");
noviSalon.Adresa = Console.ReadLine();
Console.WriteLine("Unesite telefon: ");
noviSalon.Telefon = Console.ReadLine();
Console.WriteLine("Unesite email: ");
noviSalon.Email = Console.ReadLine();
Console.WriteLine("Unesite sajt: ");
noviSalon.Sajt = Console.ReadLine();
Console.WriteLine("Unesite pib: ");
noviSalon.PIB = int.Parse(Console.ReadLine());
Console.WriteLine("Unesite maticni broj: ");
noviSalon.MaticniBroj = int.Parse(Console.ReadLine());
Console.WriteLine("Unesite broj ziro racuna: ");
noviSalon.ZiroRacun = Console.ReadLine();
lista.Add(noviSalon);
GenericSerializer.Serialize <Salon>("salon.xml", lista);
SalonMeni();
}
//Салон за продажба на возила:
//1. 3 типа на возила: Автомобили, Комбиња и Камиони
//2. Тежина на возилот, бројот на гуми, Зафатнина на мотор
//- Автомобил: Кожа да/не, Металик боја да/не, Сензори за паркирање да/не
//- Комбе: носивост, Автоматик да/не
//- Камион: Колку приколку може да влече
//3. Пресметка на цена:
//- Автомобил: тежина на возилот + зафатнина на моторот + (ако е кожа внатрешноста +1000е) + (ако е металик +500е) + (ако има сензори +1500е)
//- Комбе: (тежина на возилот + зафатнина на моторот) * 2 + носивост + (3000е ако е аутоматик)
//- Камион: зафатнина на моторот* 5 + (за секоја приколка што може да ја влече + 10000е)
static void Main(string[] args)
{
Salon salon = new Salon("Avto Cajka");
//Vans
//Mercedes Benz Sprinter 210 D (2874 cc, 3,000kg, 1455)
//Mercedes Benz Sprinter 208 D (2299 cc, 3,000kg, 1500)
Van van1 = new Van("Mercedes Benz", "Sprinter 210 D", 3000, 4, 2874, 1455, false);
Van van2 = new Van("Mercedes Benz", "Sprinter 208 D", 3000, 4, 2299, 1500, true);
salon.AddVehicle(van1);
salon.AddVehicle(van2);
//Trucks
//MAN Truck 1 (6,871 cc, 8, 1)
//MAN Truck 1 (6,900 cc, 8.5, 2)
Truck truck1 = new Truck("MAN", "1", 8000, 6, 6871, 1);
Truck truck2 = new Truck("MAN", "2", 8500, 6, 6000, 2);
salon.AddVehicle(truck1);
salon.AddVehicle(truck2);
//Cars
//Audi A8 (2995 cc, 1,945)
Car car = new Car("Audi", "A8", 1945, 4, 2995, InteriorType.Leather, ColorType.Plain, true);
salon.AddVehicle(car);
Console.WriteLine(salon.GetCatalog());
}
private void btnIzmjena_Click(object sender, RoutedEventArgs e)
{
Salon a = dgSalon.SelectedItem as Salon;
EditSalonWindow esw = new EditSalonWindow(a);
esw.ShowDialog();
}
public bool EliminarSalon(int id)
{
bool resultado = false;
using (ExperisDBEntities experisDBEntities = new ExperisDBEntities())
{
using (var transacion = experisDBEntities.Database.BeginTransaction())
{
try
{
Salon salon = experisDBEntities.Salon.Find(id);
experisDBEntities.Salon.Remove(salon);
experisDBEntities.SaveChanges();
transacion.Commit();
resultado = true;
}
catch (Exception e)
{
transacion.Rollback();
throw new Exception(e.Message);
}
}
}
return(resultado);
}
public void ReservarSalon(Reserva reserva)
{
Salon salonSeleccionado = EdificioSeleccionado.Salones.First(s =>
s.Reservas.Any(r => ((reserva.HoraFin <= r.HoraInicio || reserva.HoraInicio >= r.HoraFin) && reserva.Dia == r.Dia)));
salonSeleccionado.Reservas.Add(reserva);
}
static void Main(string[] args)
{
var s1 = new Salon()
{
Id = 1,
Naziv = "Formna FTN",
Adresa = "Trg Dositeja Obradovica 6",
BrojZiroRacuna = "840-00073666-83",
Email = "*****@*****.**",
MaticniBroj = 234324,
PIB = 323443,
Telefon = "021/342-343",
AdresaInternetSajta = "http://www.ftn.uns.ac.rs"
};
Console.WriteLine($"==== Dobrodosli u salon ====>>>>>>>>>>>>>>>>>{s1.Naziv}\n");
for (int i = 0; i < 3; i++)
{
var korisnici = Projekat.Instance.Korisnik;
Console.WriteLine("Unesite korisnicko ime: ");
var kIme = Console.ReadLine();
Console.WriteLine("Unesite lozinku: ");
var lozinka = Console.ReadLine();
foreach (Korisnik k in korisnici)
{
if (k.KorisnickoIme == kIme && k.Lozinka == lozinka)
{
IspisGlavnogMenija();
return;
}
}
}
Environment.Exit(0);
}
public Salon buscarSalon(int idSalon)
{
SqlConnection connection = SQL.Conexion.getConnection();
try
{
connection.Open();
SqlCommand command = new SqlCommand("SELECT * FROM salon where idSalon = " + idSalon + ";", connection);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
Salon salon = new Salon(reader.GetInt32(0), reader.GetString(1), reader.GetInt32(2), reader.GetInt32(3));
connection.Close();
return(salon);
}
else
{
connection.Close();
return(null);
}
}
catch (Exception e)
{
connection.Close();
return(null);
}
}
public IHttpActionResult PutSalon(int id, Salon salon)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != salon.SalonID)
{
return(BadRequest());
}
db.Entry(salon).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!SalonExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Create([Bind(Include = "ID,MemID,SalonAddress,Introduction,SalonName")] Salon salon)
{
if (ModelState.IsValid)
{
db.Salons.Add(salon);
db.SaveChanges();
Notification notification = new Notification();
notification.Content = "Yêu cầu đăng ký Salon của bạn đã được chấp nhận";
notification.DateCreate = DateTime.Now;
notification.ForAdmin = false;
notification.IsRead = false;
notification.MemID = salon.MemID;
notification.PostID = null;
notification.Type = "AcceptSalonNotification";
db.Notifications.Add(notification);
db.SaveChanges();
var member = db.Members.Find(salon.MemID);
member.IsSalon = true;
db.Entry(member).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(salon));
}
public void RegisterSalonAccount(SalonViewModel newSalon)
{
if (newSalon != null)
{
var account = _accountRepo.Gets().Where(c => c.Id.Equals(newSalon.AccountId)).FirstOrDefault();
if (account != null)
{
var salon = new Salon
{
Name = newSalon.SalonName,
AspNetUsers = account,
Address = newSalon.Address,
Email = newSalon.Email,
Latitude = 0,
Longitude = 0,
RatingAverage = 0,
Phone = newSalon.Phone,
IsForMen = newSalon.IsForMen,
IsForWomen = newSalon.IsForWomen,
};
_salonRepo.Insert(salon);
_unitOfWork.SaveChanges();
}
}
}
public ActionResult Create(Salon model)
{
//dynamic seatsLayout = Utils.DynamicJSON.Parse(seatsLayoutJSON);
var newSalon = new Salon();
newSalon.Title = model.Title;
newSalon.Address = model.Address;
newSalon.Phone = model.Phone;
salonRepository.Save(model);
return RedirectToAction("Manage");
}
