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