public ActionResult DeleteConfirmed(int id) { RandREng.MeasureDBEntity.Store store = db.Stores.Find(id); store.Active = false; db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,TypeID,Number,Address,City,State,ZipCode,StorePhoneNumber,DirectPhoneNumber,FaxNumber,Notes,BranchId,Active,NickName,Latitude,Longitude,DistrictNumber,IncludeInStatusReportAll")] RandREng.MeasureDBEntity.Store store) { if (ModelState.IsValid) { db.Entry(store).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.BranchId = new SelectList(db.Branches, "Id", "Name", store.BranchId); ViewBag.TypeID = new SelectList(db.StoreTypes, "Id", "TypeName", store.TypeID); return(View(store)); }
// GET: /Store/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } RandREng.MeasureDBEntity.Store store = (from c in new MeasureEntities().Stores.Include(c => c.Techs) where c.Id == id.Value select c).FirstOrDefault(); if (store == null) { return(HttpNotFound()); } return(View(store)); }
// GET: /Store/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } RandREng.MeasureDBEntity.Store store = db.Stores.Find(id); if (store == null) { return(HttpNotFound()); } return(View(store)); }
// GET: /Store/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } RandREng.MeasureDBEntity.Store store = db.Stores.Find(id); if (store == null) { return(HttpNotFound()); } ViewBag.BranchId = new SelectList(db.Branches, "Id", "Name", store.BranchId); ViewBag.TypeID = new SelectList(db.StoreTypes, "Id", "TypeName", store.TypeID); return(View(store)); }
public ActionResult AddTech(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } RandREng.MeasureDBEntity.Store store = db.Stores.Find(id); if (store == null) { return(HttpNotFound()); } Models.AddTech item = new Models.AddTech(); item.Id = id.Value; ViewBag.TechId = new SelectList(db.Teches, "Id", "Name", item.TechId); return(View(item)); }
public ActionResult AddTech(Models.AddTech item) { if (ModelState.IsValid) { RandREng.MeasureDBEntity.Store store = db.Stores.Find(item.Id); RandREng.MeasureDBEntity.Tech tech = db.Teches.Find(item.TechId); if ((store == null || tech == null)) { return(HttpNotFound()); } if (!store.Techs.Contains(tech)) { store.Techs.Add(tech); db.Entry(store).State = EntityState.Modified; int c = db.SaveChanges(); } return(RedirectToAction("Details", "Store", new { id = item.Id })); } ViewBag.TechId = new SelectList(db.Teches, "Id", "Name", item.TechId); return(View(item)); }
static void PopulateLowesStores(string connection) { System.Console.WriteLine("PopulateLowesStores {0}", connection); RandREng.MeasureDBEntity.MeasureEntities conn = new RandREng.MeasureDBEntity.MeasureEntities(connection); StoreType type = conn.StoreTypes.FirstOrDefault(st => st.Name == "LOWES"); if (type == null) { type = new StoreType(); type.Name = "LOWES"; conn.StoreTypes.Add(type); conn.SaveChanges(); } Branch branch = conn.Branches.FirstOrDefault(st => st.Name == "Atlanta"); Dictionary <string, Store> Stores = new Dictionary <string, Store>(); for (decimal lat = 27.0m; lat < 38.5m; lat += .5m) { for (decimal llong = -76.0m; llong > -88.4m; llong -= .5m) { string dest = string.Format("http://www.lowes.com/IntegrationServices/resources/storeLocator/json/v2_0/stores?langId=-1&storeId=10702&catalogId=10051&place={0},{1}&count=100", lat, llong); HttpWebRequest req = (HttpWebRequest)WebRequest.Create(dest); req.Accept = "application/json, text/javascript, */*; q=0.01"; req.UserAgent = "Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36"; req.Referer = "http://www.lowes.com/StoreLocatorDisplayView?storeId=10151&langId=-1&catalogId=10051"; req.AutomaticDecompression = DecompressionMethods.GZip; req.Headers.Add("Accept-Language", "en-USen;q=0.8"); req.Timeout = 600000; HttpWebResponse webResponse = (HttpWebResponse)req.GetResponse(); Stream responseStream = webResponse.GetResponseStream(); StreamReader streamReader = new StreamReader(responseStream); string responseString = ""; responseString = streamReader.ReadToEnd(); lll stuff = JsonConvert.DeserializeObject <lll>(responseString); foreach (Store store in stuff.Location) { if (!Stores.Keys.Contains(store.KEY)) { RandREng.MeasureDBEntity.Store client = (from c in conn.Stores where c.Number == store.KEY select c).FirstOrDefault(); if (client == null) { Stores.Add(store.KEY, store); System.Console.WriteLine("Adding store " + store.KEY); client = new RandREng.MeasureDBEntity.Store(); client.Address = store.ADDR; client.Active = true; client.BranchId = branch.Id; client.City = store.CITY; client.TypeID = 1; client.FaxNumber = store.COMMFAX; client.Latitude = double.Parse(store.LLAT); client.Longitude = double.Parse(store.LLON); client.NickName = store.NAME; client.State = store.STATE; client.Number = store.KEY; client.StorePhoneNumber = store.PHONE; client.DistrictNumber = store.DIST; client.ZipCode = store.ZIP; conn.Stores.Add(client); } else { client.Address = store.ADDR; } } } conn.SaveChanges(); } } }