public ActionResult Detali(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Charging_station charging_station = db.Charging_station.Find(id); if (charging_station == null) { return(HttpNotFound()); } return(View(charging_station)); }
protected override void Seed(SkopjeCS.Models.ApplicationDbContext context) { // This method will be called after migrating to the latest version. // You can use the DbSet<T>.AddOrUpdate() helper extension method // to avoid creating duplicate seed data. System.IO.StreamReader file = new System.IO.StreamReader("C:\\Users\\Blagica\\Desktop\\finalen_csv.csv"); string line = file.ReadLine(); while ((line = file.ReadLine()) != null) { string[] parts = line.Split(','); Charging_station scs = new Charging_station(); int id = Int32.Parse(parts[0].ToString()); scs.id = id; scs.longitude = Double.Parse(parts[1]); scs.latitude = Double.Parse(parts[2]); scs.amenity = parts[3]; scs.fee = parts[4]; scs.openingHours = parts[5]; scs.operatorCS = parts[6]; scs.socket = parts[7]; scs.tip = parts[8]; scs.address = parts[9]; scs.municipality = parts[10]; var existsInDb = context.Charging_station .Where(c => c.id == scs.id) .SingleOrDefault(); if (existsInDb != null) { context.Charging_station.AddOrUpdate(scs); } else { context.Charging_station.Add(scs); } } }
public static void Initialize(Demo.Data.ApplicationDbContext context) { context.Database.EnsureCreated(); if (context.Charging_station.Any()) { return; } System.IO.StreamReader file = new System.IO.StreamReader("C:\\Users\\Blagica\\Desktop\\finalen_csv.csv"); string line = ""; file.ReadLine(); while ((line = file.ReadLine()) != null) { if (line == null || line.StartsWith(" ")) { break; } string[] parts = line.Split(','); Charging_station scs = new Charging_station(); // int id = Int32.Parse(parts[0].ToString()); // scs.id = id; scs.longitude = Double.Parse(parts[1]); scs.latitude = Double.Parse(parts[2]); scs.amenity = parts[3]; scs.fee = parts[4]; scs.openingHours = parts[5]; scs.operatorCS = parts[6]; scs.socket = parts[7]; scs.tip = parts[8]; scs.address = parts[9]; scs.municipality = parts[10]; context.Charging_station.Add(scs); } //_ = context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.atm ON;"); context.SaveChanges(); }