public void runStates() { GenericClass obj = new GenericClass(); var nextpageurl = "http://www.mapsofindia.com/villages/data.php?state=all"; var webpage = obj.GetWebPage(nextpageurl); IList <MasterDataJson> persons = new JavaScriptSerializer().Deserialize <IList <MasterDataJson> >(webpage); for (int i = 0; i < persons.Count; i++) { using (var context = new MasterDataEntities()) { var t = new tbl_state { stateId = Convert.ToInt16(persons[i].value), stateName = persons[i + 1].text }; context.tbl_state.Add(t); context.SaveChanges(); } i = i + 1; } }
public ActionResult DeleteConfirmed(int id) { tbl_state tbl_state = db.tbl_state.Find(id); db.tbl_state.Remove(tbl_state); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Delete(Int16 id) { tbl_state tb = db.tbl_states.Where(x => x.state_id == id).Single <tbl_state>(); db.tbl_states.DeleteOnSubmit(tb); db.SubmitChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,subject,active")] tbl_state tbl_state) { if (ModelState.IsValid) { db.Entry(tbl_state).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tbl_state)); }
public ActionResult Edit(Model_State obj) { tbl_state tb = db.tbl_states.Where(x => x.state_id == obj.state_id).Single <tbl_state>(); tb.state_id = obj.state_id; tb.country_id = obj.country_id; tb.state_name = obj.state_name; db.SubmitChanges(); return(RedirectToAction("Index")); }
public ActionResult Create(Model_State obj) { tbl_state tb = new tbl_state(); tb.country_id = obj.country_id; tb.state_name = obj.state_name; db.tbl_states.InsertOnSubmit(tb); db.SubmitChanges(); return(RedirectToAction("Index")); }
public ActionResult Create([Bind(Include = "Id,subject,active")] tbl_state tbl_state) { if (ModelState.IsValid) { db.tbl_state.Add(tbl_state); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tbl_state)); }
// GET: state/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_state tbl_state = db.tbl_state.Find(id); if (tbl_state == null) { return(HttpNotFound()); } return(View(tbl_state)); }
partial void Deletetbl_state(tbl_state instance);
partial void Updatetbl_state(tbl_state instance);
partial void Inserttbl_state(tbl_state instance);