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)
{
}
