public async Task <IActionResult> Edit(int id, [Bind("Id,BrojMjesta,BrojStola,Dostupan")] Sto sto) { if (id != sto.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(sto); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!StoExists(sto.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(sto)); }
public IHttpActionResult ProvjeriRezervacije() { var rezervisaniStolovi = ctx.Rezervacija.Where(x => !x.IsDeleted && (x.datumVrijemeOd.Day == DateTime.Now.Day && x.datumVrijemeOd.Month == DateTime.Now.Month && x.datumVrijemeOd.Year == DateTime.Now.Year) && (((DateTime.Now.Hour - x.datumVrijemeOd.Hour) == 0) && ((DateTime.Now.Minute - x.datumVrijemeOd.Minute) <= 15 && (DateTime.Now.Minute - x.datumVrijemeOd.Minute) >= -30))).ToList() .Select(x => new StoloviRezervacijaVM() { StoId = x.StoId, IsSlobodan = x.Sto.IsSlobodan, RedniBrojStola = x.Sto.RedniBroj, RezervacijaId = x.Id, DatumOd = x.datumVrijemeOd }) .ToList(); foreach (var x in rezervisaniStolovi) { Sto sto = ctx.Stolovi.Where(y => y.Id == x.StoId).SingleOrDefault(); ctx.Entry(sto).Entity.IsSlobodan = false; ctx.SaveChanges(); } var slobodniStolovi = ctx.Rezervacija.Where(x => x.Sto.IsSlobodan == true).ToList(); foreach (var x in slobodniStolovi) { Sto sto = ctx.Stolovi.Where(y => y.Id == x.StoId).SingleOrDefault(); ctx.Entry(sto).Entity.IsSlobodan = true; var rez = ctx.Rezervacija.Where(y => y.Id == x.Id).FirstOrDefault(); ctx.Rezervacija.Remove(rez); ctx.SaveChanges(); } return(Ok()); }
public async Task <Sto> DodajSto(Sto s) { var sto = unitOfWork.StoRepository.Add(s); await unitOfWork.Commit(); return(sto); }
// Start is called before the first frame update void Start() { pausespin = false; Pau.SetActive(true); Sto.SetActive(false); gameover.SetActive(false); }
public static Sto Restore() { Sto network = new Sto(); using (var context = new STODbContext()) { var servicesQuery = context.Services .Include(s => s.material); foreach (Service service in servicesQuery) { network.serviceList.AddService(service); } var accountQuery = context.Accounts .Include(a => a.customer); foreach (Account acc in accountQuery) { network.Accounts.Add(acc); } var ordersQuery = context.Orders; foreach (Order o in ordersQuery) { network.Orders.Add(o); } } return(network); }
public async Task AzurirajSto(Sto s) { Sto sto = unitOfWork.StoRepository.Get(s.Id); if (sto != null) { unitOfWork.StoRepository.Update(s); await unitOfWork.Commit(); } }
public async Task ObrisiSto(int id) { Sto s = unitOfWork.StoRepository.Get(id); if (s != null) { unitOfWork.StoRepository.Delete(s); await unitOfWork.Commit(); } }
public static void Main(string[] args) { Test testModelGenerator = new Test(); Sto network1 = testModelGenerator.generate(); STOOrm.Save(network1); Sto network2 = STOOrm.Restore(); compareNetworks(network1, network2); }
public async Task <IActionResult> Create([Bind("Id,BrojMjesta,BrojStola,Dostupan")] Sto sto) { if (ModelState.IsValid) { _context.Add(sto); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(sto)); }
public static void Save(Sto network) { using (var context = new STODbContext()) { context.Database.Delete(); context.Orders.AddRange(network.Orders); context.Accounts.AddRange(network.Accounts); context.Services.AddRange(network.serviceList.Services); context.SaveChanges(); } }
public IHttpActionResult OznaciSto([FromBody] int Id) { Sto sto = ctx.Stolovi.Where(x => x.RedniBroj == Id).SingleOrDefault(); if (sto != null) { ctx.Entry(sto).Entity.IsSlobodan = false; ctx.SaveChanges(); return(Ok()); } return(BadRequest()); }
public void Buttons(string paneladi) { if (paneladi == "starting") { pausespin = true; Sto.SetActive(true); Pau.SetActive(false); } if (paneladi == "stoping") { pausespin = false; Pau.SetActive(true); Sto.SetActive(false); } }
public async Task <IActionResult> Reserved([Bind("Id")] Sto sto) { if (ModelState.IsValid) { var stoId = sto.Id; var stariSto = await _context.Sto.FindAsync(stoId); stariSto.Dostupan = 1; _context.Sto.Update(stariSto); await _context.SaveChangesAsync(); return(RedirectToAction("Reserved", "Sto")); } return(View(sto)); }
private static void compareNetworks(Sto network1, Sto network2) { StringWriter writer1 = new StringWriter(new StringBuilder()); var reportGenerator1 = new Report(writer1, network1); reportGenerator1.generate(); StringWriter writer2 = new StringWriter(new StringBuilder()); var reportGenerator2 = new Report(writer2, network2); reportGenerator2.generate(); String report1Content = writer1.ToString(); String report2Content = writer2.ToString(); Console.WriteLine(report1Content); Console.WriteLine(report2Content); Console.WriteLine(report1Content.Equals(report2Content) ? "PASSED: Models match" : "FAILED: Models mismatch"); Console.ReadKey(); //DbMappingViewCache mv = new DbMappingViewCache); //Console.WriteLine(mv.GetView("CodeFirstDatabase.Account")); }
public async Task AzurirajStolove(List <Sto> stolovi) { if (stolovi.Count > 0) { List <Sto> result = new List <Sto>(); foreach (Sto s in stolovi) { Sto noviSto = new Sto { Id = s.Id, BrojMesta = s.BrojMesta, Oznaka = s.Oznaka, X = s.X, Y = s.Y, KonobarId = s.KonobarId, Slobodan = s.Slobodan }; result.Add(noviSto); } unitOfWork.StoRepository.UpdateRange(result); await unitOfWork.Commit(); } }
public async Task <Sto> ZauzmiIliOslobodiSto(string sifra, int idStola) { Sto s = unitOfWork.StoRepository.FindWithIncludes(x => x.Id == idStola, x => x.Konobar).FirstOrDefault(); if (s != null) { s.Slobodan = !s.Slobodan; if (s.Slobodan == true) { s.Sifra = null; } else { s.Sifra = sifra; } var sto = unitOfWork.StoRepository.Update(s); await unitOfWork.Commit(); sto.Konobar = s.Konobar; return(sto); } throw new ArgumentNullException("Not found"); }
public bool ExportCore(Project Proj, string FileName) { Directory.CreateDirectory(FileName); Directory.SetCurrentDirectory(FileName); foreach (Basin Bas in Proj.OpenBasins) { //this feature is totally moot //this will be reimplemented in 3.0 better //Directory.CreateDirectory(Bas.Name); //Directory.SetCurrentDirectory(Bas.Name); List <Storm> FlatStorms = Bas.GetFlatListOfStorms(); foreach (Storm Sto in FlatStorms) { using (StreamWriter SW = new StreamWriter(new FileStream($"{Bas.Name}_{Sto.Name}.dat", FileMode.Create))) { // write HURDAT2 Format Header // should probably make this a method at some point string BasAbbreviation = Bas.Abbreviation; string StormAdvisoryCount = Utilities.PadZero(Sto.NodeList.Count); // this should return an int string StormName = Sto.Name; string Year = Sto.FormationDate.ToString("yyyy"); if (StormName.Length > 19) { Sto.Name = Sto.Name.Substring(0, 19); } int NoOfSpacesBeforeName = 19 - StormName.Length; if (StormAdvisoryCount.Length > 7) { Sto.Name = Sto.Name.Substring(0, 7); } int NoOfSpacesBeforeStormAdvisoryCount = 7 - StormAdvisoryCount.Length; string StDesignation = $"{BasAbbreviation}{StormAdvisoryCount}{Year}"; SW.Write(StDesignation); SW.Write(','); for (int i = 0; i < NoOfSpacesBeforeName; i++) { SW.Write(' '); } SW.Write(StormName); SW.Write(','); for (int i = 0; i < NoOfSpacesBeforeStormAdvisoryCount; i++) { SW.Write(' '); } SW.Write(StormAdvisoryCount); SW.Write(','); SW.WriteLine(); foreach (Node No in Sto.NodeList) { // this is going to go here, too tired for this //Temporary Code MainWindow MnWindow = (MainWindow)Application.Current.MainWindow; Category Cat = Sto.GetNodeCategory(No, GlobalState.CategoryManager.CurrentCategorySystem); if (Cat == null) { Logging.Log("Export Warning: Skipping node with nonexistent or illegal category"); continue; } DateTime NoDate = Sto.GetNodeDate(No.Id); // Write the node date SW.Write(NoDate.ToString("yyyyMMdd")); SW.Write(", "); // Write the node time... SW.Write(NoDate.ToString("HHmm")); SW.Write(", "); int Peak = Sto.GetPeakIntensity(); // Write the tag. We will support more of these in future. if (Peak == No.Intensity) { SW.Write(", I, "); } else { SW.Write(", , "); } string[] CatWords = Cat.Name.Split(' '); // select the last word string Abbv = Cat.GetAbbreviatedCategoryName(Cat.Name, CatWords.Length - 1, 0, 1, true); SW.Write($"{Abbv}, "); Coordinate CD = Proj.SelectedBasin.FromNodePositionToCoordinate(No.Position, VolatileApplicationSettings.WindowSize); // dumb f*****g piece of shit hack because what the f**k is compatibility you f*****g NOAA dumb f***s CD.Coordinates = new Point(CD.Coordinates.X / 10, CD.Coordinates.Y / 10); SW.Write($"{CD.Coordinates.X}{CD.Directions[0].ToString()}, {CD.Coordinates.Y}{CD.Directions[1]}, "); // we don't save this data lol. // yes i could just write the comma SW.Write($"{No.Intensity}, {No.Pressure}, 150, 110, 90, 150, 80, 60, 50, 70, 45, 40, 30, 45"); if (No.Id != Sto.NodeList.Count - 1) { SW.Write(","); } SW.WriteLine(); } } } Directory.SetCurrentDirectory(FileName); } Directory.SetCurrentDirectory(AppDomain.CurrentDomain.BaseDirectory); // on success GlobalState.SetCurrentOpenFile(FileName); return(true); }
public async Task <Sto> VratiSto(int id) { Sto result = await unitOfWork.StoRepository.VratiSto(id); return(result); }
public async Task <IActionResult> DodajSto([FromBody] Sto s) { return(new JsonResult(await stoService.DodajSto(s))); }
public async Task <IActionResult> AzurirajSto([FromBody] Sto s) { await stoService.AzurirajSto(s); return(Ok()); }
public async Task <IActionResult> OnPostNextAsync() { string email = HttpContext.Session.GetString("email"); if (email == null) { return(RedirectToPage("/Index")); } Korisnik korisnik = db.Korisnici.Where(kor => kor.eMail == email && kor.tipKorisnika == "Menadzer" && kor.validanNalog == true).FirstOrDefault(); if (korisnik == null) { return(RedirectToPage("/Index")); } Korisnik korBaza = db.Korisnici.Where(korisnik => korisnik.eMail == email).Include(x => x.mojLokal).AsNoTracking().FirstOrDefault(); if (korBaza == null) { return(RedirectToPage("/Index")); } if (noviLokal.Id != korBaza.mojLokal.Id) { return(RedirectToPage("/Index")); } int validImageCount = 0; if (!string.IsNullOrEmpty(slika1)) { validImageCount++; } if (!string.IsNullOrEmpty(slika2)) { validImageCount++; } if (!string.IsNullOrEmpty(slika3)) { validImageCount++; } if (!string.IsNullOrEmpty(slika4)) { validImageCount++; } if (!string.IsNullOrEmpty(slika5)) { validImageCount++; } if (validImageCount < 3 || string.IsNullOrEmpty(glavnaSlika) || !validTableLayout(tableLayout) || !validNoviLokal()) { return(RedirectToPage()); } System.IO.DirectoryInfo di = new DirectoryInfo(Path.Combine(_environment.ContentRootPath, "wwwroot/images/" + folder)); foreach (FileInfo file in di.GetFiles()) { file.Delete(); } string folderName = folder; string fileName = ""; try { if (!string.IsNullOrEmpty(slika1)) { fileName = saveBase64AsImage(slika1, folderName); noviLokal.slika1 = "images/" + folderName + "/" + fileName; } if (!string.IsNullOrEmpty(slika2)) { fileName = saveBase64AsImage(slika2, folderName); noviLokal.slika2 = "images/" + folderName + "/" + fileName; } if (!string.IsNullOrEmpty(slika3)) { fileName = saveBase64AsImage(slika3, folderName); noviLokal.slika3 = "images/" + folderName + "/" + fileName; } if (!string.IsNullOrEmpty(slika4)) { fileName = saveBase64AsImage(slika4, folderName); noviLokal.slika4 = "images/" + folderName + "/" + fileName; } if (!string.IsNullOrEmpty(slika5)) { fileName = saveBase64AsImage(slika5, folderName); noviLokal.slika5 = "images/" + folderName + "/" + fileName; } if (!string.IsNullOrEmpty(glavnaSlika)) { fileName = saveBase64AsImage(glavnaSlika, folderName); noviLokal.nazivSlike = "images/" + folderName + "/" + fileName; } } catch (FormatException fe) { RedirectToPage("/Error?errorCode=" + fe); } if (noviLokal.openTime.Minute < 15 && noviLokal.openTime.Minute > 0) { noviLokal.openTime = noviLokal.openTime.AddMinutes(-(noviLokal.openTime.Minute)); } if (noviLokal.openTime.Minute < 30 && noviLokal.openTime.Minute > 15) { noviLokal.openTime = noviLokal.openTime.AddMinutes(-(noviLokal.openTime.Minute - 15)); } if (noviLokal.openTime.Minute < 45 && noviLokal.openTime.Minute > 30) { noviLokal.openTime = noviLokal.openTime.AddMinutes(-(noviLokal.openTime.Minute - 30)); } if (noviLokal.openTime.Minute > 45) { noviLokal.openTime = noviLokal.openTime.AddMinutes(-(noviLokal.openTime.Minute - 45)); } if (noviLokal.closeTime.Minute < 15 && noviLokal.closeTime.Minute > 0) { noviLokal.closeTime = noviLokal.closeTime.AddMinutes(-(noviLokal.closeTime.Minute)); } if (noviLokal.closeTime.Minute < 30 && noviLokal.closeTime.Minute > 15) { noviLokal.closeTime = noviLokal.closeTime.AddMinutes(-(noviLokal.closeTime.Minute - 15)); } if (noviLokal.closeTime.Minute < 45 && noviLokal.closeTime.Minute > 30) { noviLokal.closeTime = noviLokal.closeTime.AddMinutes(-(noviLokal.closeTime.Minute - 30)); } if (noviLokal.closeTime.Minute > 45) { noviLokal.closeTime = noviLokal.closeTime.AddMinutes(-(noviLokal.closeTime.Minute - 45)); } if (DateTime.Compare(noviLokal.openTime, noviLokal.closeTime) == 0) { noviLokal.closeTime = noviLokal.closeTime.AddMinutes(-15); } string stariLayout = ""; List <Sto> stariStolovi = db.Stolovi.Where(sto => sto.Lokal.Id == noviLokal.Id).ToList(); for (int i = 0; i < stariStolovi.Count; i++) { stariLayout = stariLayout + stariStolovi[i].gsX + "`" + stariStolovi[i].gsY + "`" + stariStolovi[i].gsWidth + "`" + stariStolovi[i].gsHeight + "`" + stariStolovi[i].brojMesta + "`" + stariStolovi[i].oznaka; if (i != stariStolovi.Count - 1) { stariLayout = stariLayout + "~"; } } if (String.Compare(stariLayout, tableLayout) != 0) { int counter = 1; List <Sto> noviStolovi = new List <Sto>(tableLayout.Split('~').Length); int objectSeatsCount = 0; Sto noviSto = new Sto(); foreach (string num in tableLayout.Split(new char[] { '`', '~' })) { if (counter == 1) { noviSto.gsX = int.Parse(num); } else if (counter == 2) { noviSto.gsY = int.Parse(num); } else if (counter == 3) { noviSto.gsWidth = int.Parse(num); } else if (counter == 4) { noviSto.gsHeight = int.Parse(num); } else if (counter == 5) { noviSto.brojMesta = int.Parse(num); objectSeatsCount += int.Parse(num); } else { noviSto.oznaka = num; noviStolovi.Add(noviSto); noviSto = new Sto(); } counter = counter % 6 + 1; } noviLokal.maxKapacitet = objectSeatsCount; foreach (Sto sto in stariStolovi) { foreach (Rezervacija rez in db.Rezervacije.Where(rezer => rezer.Sto.Id == sto.Id).Include(x => x.Korisnik).ToList()) { if (rez.Vreme > DateTime.Now) { string sadrzajMejla = $"Dear {rez.Korisnik.Ime}, \n\n Your reservation at {noviLokal.Naziv} for {rez.Vreme} has been canceled. Sorry for inconvenience.\n\n Check out our website for other places to make reservations at.\n\n\n Table4U"; RegisterModel.SendEmail("Table4U", /*rez.Korisnik.eMail*/ "*****@*****.**", "Reservation canceled", sadrzajMejla); } db.Remove(rez); } db.Stolovi.Remove(sto); } noviLokal.listaStolova = noviStolovi; } korisnik.mojLokal = noviLokal; await db.SaveChangesAsync(); return(RedirectToPage("/Index")); }
public async Task <IActionResult> OnPostNextAsync() { if (HttpContext.Session.GetString("email") != null) { return(RedirectToPage("/Index")); } int validImageCount = 0; if (!string.IsNullOrEmpty(slika1)) { validImageCount++; } if (!string.IsNullOrEmpty(slika2)) { validImageCount++; } if (!string.IsNullOrEmpty(slika3)) { validImageCount++; } if (!string.IsNullOrEmpty(slika4)) { validImageCount++; } if (!string.IsNullOrEmpty(slika5)) { validImageCount++; } if (validImageCount < 3 || string.IsNullOrEmpty(glavnaSlika) || !validTableLayout(tableLayout) || !validNoviLokal()) { return(RedirectToPage()); } string folderName = System.Guid.NewGuid().ToString(); string fileName = ""; try { if (!string.IsNullOrEmpty(slika1)) { fileName = saveBase64AsImage(slika1, folderName); noviLokal.slika1 = "images/" + folderName + "/" + fileName; } if (!string.IsNullOrEmpty(slika2)) { fileName = saveBase64AsImage(slika2, folderName); noviLokal.slika2 = "images/" + folderName + "/" + fileName; } if (!string.IsNullOrEmpty(slika3)) { fileName = saveBase64AsImage(slika3, folderName); noviLokal.slika3 = "images/" + folderName + "/" + fileName; } if (!string.IsNullOrEmpty(slika4)) { fileName = saveBase64AsImage(slika4, folderName); noviLokal.slika4 = "images/" + folderName + "/" + fileName; } if (!string.IsNullOrEmpty(slika5)) { fileName = saveBase64AsImage(slika5, folderName); noviLokal.slika5 = "images/" + folderName + "/" + fileName; } if (!string.IsNullOrEmpty(glavnaSlika)) { fileName = saveBase64AsImage(glavnaSlika, folderName); noviLokal.nazivSlike = "images/" + folderName + "/" + fileName; } } catch (FormatException fe) { RedirectToPage("/Error?errorCode=" + fe); } if (noviLokal.openTime.Minute < 15 && noviLokal.openTime.Minute > 0) { noviLokal.openTime = noviLokal.openTime.AddMinutes(-(noviLokal.openTime.Minute)); } if (noviLokal.openTime.Minute < 30 && noviLokal.openTime.Minute > 15) { noviLokal.openTime = noviLokal.openTime.AddMinutes(-(noviLokal.openTime.Minute - 15)); } if (noviLokal.openTime.Minute < 45 && noviLokal.openTime.Minute > 30) { noviLokal.openTime = noviLokal.openTime.AddMinutes(-(noviLokal.openTime.Minute - 30)); } if (noviLokal.openTime.Minute > 45) { noviLokal.openTime = noviLokal.openTime.AddMinutes(-(noviLokal.openTime.Minute - 45)); } if (noviLokal.closeTime.Minute < 15 && noviLokal.closeTime.Minute > 0) { noviLokal.closeTime = noviLokal.closeTime.AddMinutes(-(noviLokal.closeTime.Minute)); } if (noviLokal.closeTime.Minute < 30 && noviLokal.closeTime.Minute > 15) { noviLokal.closeTime = noviLokal.closeTime.AddMinutes(-(noviLokal.closeTime.Minute - 15)); } if (noviLokal.closeTime.Minute < 45 && noviLokal.closeTime.Minute > 30) { noviLokal.closeTime = noviLokal.closeTime.AddMinutes(-(noviLokal.closeTime.Minute - 30)); } if (noviLokal.closeTime.Minute > 45) { noviLokal.closeTime = noviLokal.closeTime.AddMinutes(-(noviLokal.closeTime.Minute - 45)); } if (DateTime.Compare(noviLokal.openTime, noviLokal.closeTime) == 0) { noviLokal.closeTime = noviLokal.closeTime.AddMinutes(-15); } int counter = 1; List <Sto> noviStolovi = new List <Sto>(tableLayout.Split('~').Length); int objectSeatsCount = 0; Sto noviSto = new Sto(); foreach (string num in tableLayout.Split(new char[] { '`', '~' })) { if (counter == 1) { noviSto.gsX = int.Parse(num); } else if (counter == 2) { noviSto.gsY = int.Parse(num); } else if (counter == 3) { noviSto.gsWidth = int.Parse(num); } else if (counter == 4) { noviSto.gsHeight = int.Parse(num); } else if (counter == 5) { noviSto.brojMesta = int.Parse(num); objectSeatsCount += int.Parse(num); } else { noviSto.oznaka = num; noviStolovi.Add(noviSto); noviSto = new Sto(); } counter = counter % 6 + 1; } noviLokal.maxKapacitet = objectSeatsCount; noviLokal.listaStolova = noviStolovi; Korisnik noviKorisnik = db.Korisnici.Where(korisnik => korisnik.hash == guid && korisnik.eMail == email && korisnik.tipKorisnika == "Menadzer" && !korisnik.validanNalog).FirstOrDefault(); if (noviKorisnik == null) { return(RedirectToPage("/Index")); } noviKorisnik.validanNalog = true; noviKorisnik.mojLokal = noviLokal; HttpContext.Session.SetString("email", noviKorisnik.eMail); await db.SaveChangesAsync(); return(RedirectToPage("/Success")); }