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();
}
}
}
