public ActionResult Create(EmployeeVM employee) { if (ModelState.IsValid) { var parkEmployee = new ParkEmployee(); parkEmployee.FirstName = employee.FirstName; parkEmployee.LastName = employee.LastName; parkEmployee.MiddleName = employee.MiddleName; parkEmployee.StreetAddress = employee.StreetAddress; parkEmployee.City = employee.City; parkEmployee.State = employee.State; parkEmployee.ZipCode = employee.ZipCode; parkEmployee.PhoneNumber = employee.PhoneNumber; parkEmployee.DateOfBirth = employee.DateOfBirth; parkEmployee.Sex = employee.Sex; parkEmployee.JobTitle = employee.JobTitle; parkEmployee.DepartmentID = employee.DepartmentID; var login = new EmployeeLogin(); login.ParkEmployee = parkEmployee; login.LoginEmail = employee.LoginEmail; login.Pswd = employee.Pswd; db.ParkEmployees.Add(parkEmployee); db.EmployeeLogins.Add(login); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.DepartmentID = new SelectList(db.Departments, "DepartmentID", "DName", employee.DepartmentID); return(View(employee)); }
public ActionResult Obrisi(int dobavljacId) { Dobavljac dobavljac = ctx.Dobavljaci.Find(dobavljacId); List <Nabavka> lista = ctx.Nabavke.Where(x => x.DobavljacId == dobavljacId).ToList(); List <NabavkaStavka> stavke = ctx.StavkeNabavke.ToList(); foreach (var item in lista) { foreach (var s in stavke) { if (item.Id == s.NabavkaId) { ctx.StavkeNabavke.Remove(s); } } } foreach (var n in lista) { ctx.Nabavke.Remove(n); } ctx.Dobavljaci.Remove(dobavljac); ctx.SaveChanges(); return(RedirectToAction("Prikazi")); }
public ActionResult Dodaj(InstradacijaDetaljnoVM instradacija) { if (ModelState.IsValid) { Instradacija i = new Instradacija { UlaznaCarinarnica = instradacija.UlaznaCarinarnica, IzlaznaCarinarnica = instradacija.IzlaznaCarinarnica, VozacId = instradacija.VozacId, StatusInstradacijeId = 1, Datum = DateTime.Now, VoziloId = instradacija.VoziloId, PrikljucnoVoziloId = instradacija.PrikljucnoVoziloId, DispozicijaId = instradacija.DispozicijaId, IsDeleted = false }; ctx.Instradacije.Add(i); ctx.SaveChanges(); return(RedirectToAction("DispozicijaInstradacije", new { dispozicijaId = instradacija.DispozicijaId })); } else { getInstradacijaFormInfo(ref instradacija, instradacija.DispozicijaId); return(View("Dodaj", instradacija)); } }
public ActionResult Create(SPH_VM sph) { if (ModelState.IsValid) { SeasonPassHolder seasonPassHolder = new SeasonPassHolder(); seasonPassHolder.FirstName = sph.FirstName; seasonPassHolder.MiddleName = sph.MiddleName; seasonPassHolder.LastName = sph.LastName; seasonPassHolder.StreetAddress = sph.StreetAddress; seasonPassHolder.CityOfAddress = sph.CityOfAddress; seasonPassHolder.StateOfAddress = sph.StateOfAddress; seasonPassHolder.ZipCode = sph.ZipCode; seasonPassHolder.TicketNumber = ApplicationSession.TicketNumber; SPHLogin login = new SPHLogin(); login.LoginEmail = sph.LoginEmail; login.Pswd = sph.Pswd; login.SeasonPassHolder = seasonPassHolder; ApplicationSession.Username = sph.LoginEmail; ApplicationSession.AccessLevel = "SPH"; db.SeasonPassHolders.Add(seasonPassHolder); db.SPHLogins.Add(login); db.SaveChanges(); return(RedirectToAction("DepQuestion", "DependentPassHolders")); } ViewBag.TicketNumber = new SelectList(db.Tickets, "TicketNumber", "TicketNumber", sph.TicketNumber); return(View(sph)); }
public ActionResult SPH_Profile([Bind(Include = "StreetAddress,CityOfAddress,StateOfAddress,ZipCode,FirstName,LastName,MiddleName,TicketNumber")] SeasonPassHolder sPHolder) { if (ModelState.IsValid) { db.Entry(sPHolder).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("SPH_Profile")); } return(View(sPHolder)); }
public ActionResult Create([Bind(Include = "ItemName,ItemPrice,ItemDescription")] Concession concession) { if (ModelState.IsValid) { db.Concessions.Add(concession); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(concession)); }
public ActionResult Create([Bind(Include = "TicketCode1,TicketType")] TicketCode ticketCode) { if (ModelState.IsValid) { db.TicketCodes.Add(ticketCode); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(ticketCode)); }
public ActionResult Create([Bind(Include = "RideID,RideName,RideDiscription,RideLocation,RideCapacity")] Ride ride) { if (ModelState.IsValid) { db.Rides.Add(ride); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.RideID = new SelectList(db.Rides, "Ride ID", "RideName", "RideDiscription", "RideLocation", "RideCapacity"); return(View(ride)); }
public ActionResult Create([Bind(Include = "LoginEmail,Pswd,SPH_ID")] SPHLogin sPHLogin) { if (ModelState.IsValid) { db.SPHLogins.Add(sPHLogin); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.SPH_ID = new SelectList(db.SeasonPassHolders, "SPH_ID", "StreetAddress", sPHLogin.SPH_ID); return(View(sPHLogin)); }
public ActionResult SnimiOdrzavanje(OdrzavanjeVM o) { if (o.odrzavanjeId != 0) { if (ModelState.IsValid) { Odrzavanje odrzavanje = ctx.Odrzavanja.Find(o.odrzavanjeId); odrzavanje.Datum = o.datum; odrzavanje.Kilometraza = o.kilometraza; odrzavanje.Troskovi = o.troskovi; odrzavanje.Detaljno = o.detaljno; odrzavanje.TipOdrzavanjaId = o.tipOdrzavanjaId; ctx.SaveChanges(); return(RedirectToAction("OdrzavanjaVozila", new { id = o.voziloId })); } else { o.tipoviOdrzavanja = ctx.TipoviOdrzavanja.Select(y => new SelectListItem { Value = y.TipOdrzavanjaId.ToString(), Text = y.Naziv }).ToList(); return(View("_UrediOdrzavanje", o)); } } else { if (ModelState.IsValid) { ctx.Odrzavanja.Add(new Odrzavanje { VoziloId = o.voziloId, Datum = o.datum, Kilometraza = o.kilometraza, Troskovi = o.troskovi, Detaljno = o.detaljno, TipOdrzavanjaId = o.tipOdrzavanjaId }); ctx.SaveChanges(); return(RedirectToAction("OdrzavanjaVozila", new { id = o.voziloId })); } else { o.tipoviOdrzavanja = ctx.TipoviOdrzavanja.Select(y => new SelectListItem { Value = y.TipOdrzavanjaId.ToString(), Text = y.Naziv }).ToList(); return(View("_DodajOdrzavanje", o)); } } }
public ActionResult Create([Bind(Include = "LoginEmail,Pswd,EmployeeID")] EmployeeLogin employeeLogin) { if (ModelState.IsValid) { db.EmployeeLogins.Add(employeeLogin); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.EmployeeID = new SelectList(db.ParkEmployees, "EmployeeID", "FirstName", employeeLogin.EmployeeID); return(View(employeeLogin)); }
public ActionResult Create([Bind(Include = "RideID,EmployeeID,DateTended")] TENDED_BY tENDED_BY) { if (ModelState.IsValid) { db.TENDED_BY.Add(tENDED_BY); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.EmployeeID = new SelectList(db.ParkEmployees, "EmployeeID", "FirstName", tENDED_BY.EmployeeID); ViewBag.RideID = new SelectList(db.Rides, "RideID", "RideName", tENDED_BY.RideID); return(View(tENDED_BY)); }
public ActionResult Create([Bind(Include = "MaintenanceID,MaintDescription,CorrectiveAction,DateAdded,DateFixed,MaintCode,SupervisorID,RideID")] Maintenance maintenance) { if (ModelState.IsValid) { db.Maintenances.Add(maintenance); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.MaintCode = new SelectList(db.MaintCodes, "MaintCode1", "MaintType", maintenance.MaintCode); ViewBag.RideID = new SelectList(db.Rides, "RideID", "RideName", maintenance.RideID); return(View(maintenance)); }
public ActionResult Create([Bind(Include = "TicketID,EmployeeID,AdmissionsDate")] ADMITTED_BY aDMITTED_BY) { if (ModelState.IsValid) { db.ADMITTED_BY.Add(aDMITTED_BY); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.EmployeeID = new SelectList(db.ParkEmployees, "EmployeeID", "FirstName", aDMITTED_BY.EmployeeID); ViewBag.TicketID = new SelectList(db.Tickets, "TicketNumber", "TicketNumber", aDMITTED_BY.TicketID); return(View(aDMITTED_BY)); }
public ActionResult Create([Bind(Include = "CriancaId,Idade,Nome,UserId,CandidaturaId")] Crianca crianca) { if (ModelState.IsValid) { crianca.UserId = User.Identity.GetUserId(); db.Criancas.Add(crianca); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CandidaturaId = new SelectList(db.Candidaturas, "CandidaturaId", "Estado", crianca.CandidaturaId); return(View(crianca)); }
public ActionResult Create([Bind(Include = "ID,Nome,Tipo,Creche,PreEscolar,TransporteCriancas,AulasNatacao,AulasMusica,Valor,UserId")] Instituicao instituicao) { if (ModelState.IsValid) { instituicao.UserId = User.Identity.GetUserId(); instituicao.Rating = instituicao.Avaliacoes = instituicao.PontuacaoTotal = 0; instituicao.RatingMedio = 0.0; db.Instituicaos.Add(instituicao); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(instituicao)); }
public ActionResult Create([Bind(Include = "ItemName,EmployeeID,DateSold")] SOLD_BY sOLD_BY) { if (ModelState.IsValid) { TimeSpan d = DateTime.Now.TimeOfDay; sOLD_BY.DateSold += d; db.SOLD_BY.Add(sOLD_BY); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ItemName = new SelectList(db.Concessions, "ItemName", "ItemDescription", sOLD_BY.ItemName); ViewBag.EmployeeID = new SelectList(db.ParkEmployees, "EmployeeID", "FirstName", sOLD_BY.EmployeeID); return(View(sOLD_BY)); }
public ActionResult Snimi(NabavkaDetaljnoVM nabavka) { Nabavka n = new Nabavka { Id = nabavka.NabavkaId, Datum = nabavka.DatumNabavke, Sifra = nabavka.Sifra, DobavljacId = nabavka.DobavljacId, }; n.Stavke = new List <NabavkaStavka>(); int NabavkaStavkaId = 0; foreach (NabavkaStavka item in nabavka.nabavke) { NabavkaStavka stavka = new NabavkaStavka { Naziv = item.Naziv, Cijena = item.Cijena, NabavkaId = item.NabavkaId, Id = NabavkaStavkaId-- }; nabavka.nabavke.Add(stavka); } ctx.Nabavke.Add(n); ctx.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult ZakljuciStatus(Instradacija Model, int statusInstradacijeId) { Instradacija instradacija; if (Model.InstradacijaId != 0) { instradacija = ctx.Instradacije.Where(x => x.InstradacijaId == Model.InstradacijaId).FirstOrDefault(); instradacija.StatusInstradacijeId = statusInstradacijeId; } ctx.SaveChanges(); return(RedirectToAction("Details", new { id = Model.InstradacijaId })); }
public ActionResult Create([Bind(Include = "TicketNumber,Price,DateOfPurchase,TicketCode")] Ticket ticket) { if (ModelState.IsValid) { if (ticket.TicketCode == 1) { ticket.Price = (decimal)12.00; } else if (ticket.TicketCode == 2) { ticket.Price = (decimal)8.00; } else if (ticket.TicketCode == 3) { ticket.Price = (decimal)10.00; } else if (ticket.TicketCode == 4) { ticket.Price = (decimal)10.00; } else if (ticket.TicketCode == 5) { ticket.Price = (decimal)40.00; } ticket.DateOfPurchase = DateTime.Now.Date; db.Tickets.Add(ticket); db.SaveChanges(); if (ticket.TicketCode == 5) { ApplicationSession.TicketNumber = ticket.TicketNumber; return(RedirectToAction("Create", "SeasonPassholders")); } else { return(RedirectToAction("Receipt", "Tickets")); } } ViewBag.TicketCode = new SelectList(db.TicketCodes, "TicketCode1", "TicketType", ticket.TicketCode); return(View(ticket)); }
public ActionResult UkloniPrikljucnoSaOdrzavanja(int id, int prikljucnoid) { Odrzavanje odrzavanje = ctx.Odrzavanja.Find(id); odrzavanje.PrikljucnoVoziloId = null; ctx.Odrzavanja.AddOrUpdate(odrzavanje); ctx.SaveChanges(); return(RedirectToAction("OdrzavanjaPrikljucnoVozilo", new { id = prikljucnoid })); }
public ActionResult Create(EmployeeVM employee) { if (ModelState.IsValid) { //check database for existing username if (db.EmployeeLogins.Any(x => x.LoginEmail == employee.LoginEmail)) { ModelState.AddModelError(string.Empty, "Email already exists"); return(RedirectToAction("Index")); } else { var parkEmployee = new ParkEmployee(); parkEmployee.FirstName = employee.FirstName; parkEmployee.LastName = employee.LastName; parkEmployee.MiddleName = employee.MiddleName; parkEmployee.StreetAddress = employee.StreetAddress; parkEmployee.City = employee.City; parkEmployee.State = employee.State; parkEmployee.ZipCode = employee.ZipCode; parkEmployee.PhoneNumber = employee.PhoneNumber; parkEmployee.DateOfBirth = employee.DateOfBirth; parkEmployee.Sex = employee.Sex; parkEmployee.JobTitle = employee.JobTitle; parkEmployee.DepartmentID = employee.DepartmentID; var login = new EmployeeLogin(); login.ParkEmployee = parkEmployee; login.LoginEmail = employee.LoginEmail; login.Pswd = employee.Pswd; db.ParkEmployees.Add(parkEmployee); db.EmployeeLogins.Add(login); db.SaveChanges(); return(RedirectToAction("Index")); } } ViewBag.DepartmentID = new SelectList(db.Departments, "DepartmentID", "DName", employee.DepartmentID); return(View(employee)); }
public ActionResult Create([Bind(Include = "DepID,FirstName,LastName,MiddleName,TicketNumber,SPH_ID")] DependentPassHolder dependentPassHolder) { if (ModelState.IsValid) { var sphLogin = db.SPHLogins.First(x => x.LoginEmail == ApplicationSession.Username); var SPHId = sphLogin.SPH_ID; dependentPassHolder.SPH_ID = SPHId; var ticket = new Ticket(); ticket.Price = (decimal)30.00; ticket.DateOfPurchase = DateTime.Now.Date; ticket.TicketCode = 5; dependentPassHolder.Ticket = ticket; db.DependentPassHolders.Add(dependentPassHolder); db.SaveChanges(); return(RedirectToAction("DepQuestion")); } ViewBag.SPH_ID = new SelectList(db.SeasonPassHolders, "SPH_ID", "StreetAddress", dependentPassHolder.SPH_ID); ViewBag.TicketNumber = new SelectList(db.Tickets, "TicketNumber", "TicketNumber", dependentPassHolder.TicketNumber); return(View(dependentPassHolder)); }
public ActionResult ZakljuciStatus(int statusID, OdrzavanjeDetaljnoVM vm) { //if (!ModelState.IsValid) //{ // Model.Statusi = BindStatusi(); // return View("Statusi", Model); //} Vozilo vozilo; if (vm.Voziloo.VoziloId != 0) { vozilo = ctx.Vozila.Where(x => x.VoziloId == vm.Voziloo.VoziloId).FirstOrDefault(); vozilo.StatusVozilaId = statusID; } ctx.SaveChanges(); return(Redirect("/ModulMehanicar/Odrzavanje/Details?odrzavanjeID=" + vm.OdrzavanjeId)); }
public ActionResult Dodaj(KlijentProfilVM k) { if (ModelState.IsValid) { Klijent klijent = new Klijent() { Naziv = k.Naziv, DrzavaId = k.DrzavaId, Adresa = k.Adresa, Telefon = k.Telefon, Fax = k.Fax, Mail = k.Mail, IdBroj = k.IDBroj }; ctx.Klijenti.Add(klijent); ctx.SaveChanges(); return(RedirectToAction("Dodaj")); } k.Drzave = GetDrzave(); return(View(k)); }
public ActionResult SnimiKarticu(VozacKarticaVM s) { if (s.karticaId != 0) { if (ModelState.IsValid) { KarticaVozac kartica = ctx.KarticaVozaci.Find(s.karticaId); kartica.KolicinaLitara = s.kolicinaLitara; kartica.BenzinskaPumpaId = s.benzinskaId; kartica.DatumKoristenja = s.datumKoristenja; kartica.UkupanIznos = s.ukupniIznos; ctx.SaveChanges(); return(RedirectToAction("VozacKartice", new { vozacid = s.vozacId })); } else { s.benzinske = ctx.BenzinskePumpe.Select(z => new SelectListItem { Value = z.BenzinskaPumpaId.ToString(), Text = z.Adresa }).ToList(); return(View("_UrediKarticu", s)); } } else { if (ModelState.IsValid) { ctx.KarticaVozaci.Add(new KarticaVozac() { VozacId = s.vozacId, DatumKoristenja = s.datumKoristenja, KolicinaLitara = s.kolicinaLitara, BenzinskaPumpaId = s.benzinskaId, UkupanIznos = s.ukupniIznos }); ctx.SaveChanges(); return(RedirectToAction("VozacKartice", new { vozacid = s.vozacId })); } else { s.benzinske = ctx.BenzinskePumpe.Select(z => new SelectListItem { Value = z.BenzinskaPumpaId.ToString(), Text = z.Adresa }).ToList(); return(View("_DodajKarticu", s)); } } }
public ActionResult Aprovar(int id) { foreach (var x in db.Candidaturas.ToList()) { if (id == x.CandidaturaId) { x.Estado = "Aprovado"; db.Entry(x).State = EntityState.Modified; db.SaveChanges(); } } return(RedirectToAction("Lista")); }
public ActionResult Dodaj(DispozicijaDetaljnoVM d) { d.DatumDispozicije = DateTime.Now; if (ModelState.IsValid) { Dispozicija dispozicija = new Dispozicija() { KlijentId = d.KlijentId, Primalac = d.Primalac, DrzavaOdId = d.DrzavaOdId, AdresaOd = d.AdresaOd, DrzavaDoId = d.DrzavaDoId, AdresaDo = d.AdresaDo, DatumDispozicije = DateTime.Now, DatumIspostave = d.DatumIspostave, DatumPlacanja = d.DatumPlacanja, DodatneInformacije = d.DodatneInformacije, Cijena = d.Cijena, RowGuid = Guid.NewGuid().ToString().Substring(0, 15) }; dispozicija.Stavke = new List <Stavka>(); foreach (StavkaVM item in d.Stavke) { dispozicija.Stavke.Add(new Stavka { DispozicijaId = dispozicija.DispozicijaId, KolicinaTipId = item.KolicinaTipId, Kolicina = item.Kolicina, Naziv = item.Naziv }); } ctx.Dispozicije.Add(dispozicija); ctx.SaveChanges(); return(RedirectToAction("Dodaj", "Dispozicija")); } else { return(View(d)); } }
public int SaveChanges() { try { return(_db.SaveChanges()); } catch (DbUpdateConcurrencyException ex) { //A concurrency error occurred logger.Error("Database cannot be updated.", ex); throw; } catch (RetryLimitExceededException ex) { //_dbResiliency retry limit exceeded logger.Error("Maximum retry limit reached.", ex); throw; } catch (Exception ex) { logger.Error("Error occurred.", ex); throw; } }