public IList <Cennik> getCen() { var result = new List <Cennik>(); using (var sqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["Default"].ConnectionString)) { var sqlCommand = new SqlCommand("SELECT IDM, Nr_sali, Nr_miejsca, Cena FROM Miejsce", sqlCon); sqlCon.Open(); var dr = sqlCommand.ExecuteReader(); while (dr.Read()) { var newCennik = new Cennik { IDM = (int)dr["IDM"], Nr_sali = (int)dr["Nr_sali"], Nr_miejsca = (int)dr["Nr_miejsca"], Cena = (decimal)dr["Cena"] }; result.Add(newCennik); } dr.Dispose(); sqlCon.Dispose(); } return(result); }
public ActionResult DeleteConfirmed(int id) { Cennik cennik = db.Cennik.Find(id); db.Cennik.Remove(cennik); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit(int id) { List <SelectListItem> opisList = new SelectList(CennikSelectList.OpisList, "Key", "Value").ToList(); ViewData["opisList"] = opisList; Cennik cennik = cennikRepository.GetCennikById(id); return(View(cennik)); }
public ActionResult Edit([Bind(Include = "ID,MinWaga,MaxWaga,Cena")] Cennik cennik) { if (ModelState.IsValid) { db.Entry(cennik).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cennik)); }
public ActionResult Create(int id) { List <SelectListItem> opisList = new SelectList(CennikSelectList.OpisList, "Key", "Value").ToList(); ViewData["opisList"] = opisList; Cennik cennik = new Cennik(); cennik.SamochodId = id; return(View(cennik)); }
public ActionResult Create([Bind(Include = "ID,MinWaga,MaxWaga,Cena")] Cennik cennik) { if (ModelState.IsValid) { db.Cennik.Add(cennik); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cennik)); }
// GET: Cennik/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Cennik cennik = db.Cennik.Find(id); if (cennik == null) { return(HttpNotFound()); } return(View(cennik)); }
public ActionResult Edit(int id, FormCollection collection) { Cennik cennik = cennikRepository.GetCennikById(id); var samid = cennik.SamochodId; if (TryUpdateModel(cennik)) { cennikRepository.Save(); TempData["okMessage"] = "Cennik został zapisany."; return(RedirectToAction("ShowCennikiForSamochod", "Cennik", new { id = samid })); } else { TempData["errorMessage"] = "Cennik nie został zapisany!"; return(View(cennik)); } }
public ActionResult Create(Cennik cennik, FormCollection collection) { var samid = cennik.SamochodId; if (ModelState.IsValid) { cennikRepository.Add(cennik); cennikRepository.Save(); TempData["okMessage"] = "Cennik został zapisany."; return(RedirectToAction("ShowCennikiForSamochod", "Cennik", new { id = samid })); } else { TempData["errorMessage"] = "Nie dodano Cennika"; return(View(cennik)); } }
public CennikDecorator(Cennik cennik) { _cennik = cennik; }
public BoksDecorator(Cennik cennik) : base(cennik) { }
public JogaDecorator(Cennik cennik) : base(cennik) { }
public async Task <Cennik> Get() { string host = _configuration.GetSection("FtpConn").GetSection("Address").Value; string username = _configuration.GetSection("FtpConn").GetSection("Login").Value; string password = _configuration.GetSection("FtpConn").GetSection("Pass").Value; string imageUrl = _configuration.GetSection("ImageFolder").Value; string localPath = Path.Combine(System.IO.Directory.GetCurrentDirectory(), "cennik.json"); string remotePath = "/srv/kasy/cennik.json"; string imageFile = Path.Combine(System.IO.Directory.GetCurrentDirectory(), "urls/images/"); using (SftpClient sftp = new SftpClient(host, 11122, username, password)) { try { sftp.Connect(); var sftpFile = sftp.GetLastWriteTime(remotePath); var localFile = System.IO.File.GetLastWriteTime(localPath); var fileExists = System.IO.File.Exists(localPath); if (fileExists) { if (sftpFile > localFile) { await using Stream fileStream = System.IO.File.OpenWrite(localPath); sftp.DownloadFile(remotePath, fileStream); } } else { await using Stream fileStream = System.IO.File.OpenWrite(localPath); sftp.DownloadFile(remotePath, fileStream); } sftp.Disconnect(); var json = System.IO.File.ReadAllText(localPath); Cennik Cennik = JsonConvert.DeserializeObject <Cennik>(json); Cennik.cennik = Cennik.cennik.Where(x => x.promocja || x.rabat > 0).ToList(); DirectoryInfo dir = new DirectoryInfo(imageFile); foreach (var item in Cennik.cennik) { FileInfo[] files = dir.GetFiles(item.index + ".*"); if (files.Length > 0) { var name = files[0].Name; item.imageUrl = imageUrl + name; } } return(Cennik); } catch (Exception ex) { Console.WriteLine(ex); System.IO.File.Delete(localPath); } } return(null); }
public FitnessDecorator(Cennik cennik) : base(cennik) { }
public void DodajDoListy(Cennik c) { listaCennikow.Add(c); }
public TaniecDecorator(Cennik cennik) : base(cennik) { }