public ActionResult Edit(Model_city obj)
{
tbl_city tb = db.tbl_cities.Where(x => x.city_id == obj.city_id).Single <tbl_city>();
tb.city_id = obj.city_id;
tb.state_id = obj.state_id;
tb.country_id = obj.country_id;
tb.city_name = obj.city_name;
db.SubmitChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create(Model_city obj)
{
tbl_city tb = new tbl_city();
tb.state_id = obj.state_id;
tb.country_id = obj.country_id;
tb.city_name = obj.city_name;
db.tbl_cities.InsertOnSubmit(tb);
db.SubmitChanges();
return(RedirectToAction("Index"));
}
public ActionResult Delete(Int16 id)
{
Model_city obj = db.tbl_cities.Where(x => x.city_id == id).Select(x => new Model_city()
{
city_id = x.city_id,
state_id = x.state_id,
country_id = x.country_id,
city_name = x.city_name
}).SingleOrDefault();
return(View(obj));
}
public ActionResult Edit(int id)
{
Model_city obj = db.tbl_cities.Where(x => x.city_id == id).Select(x => new Model_city()
{
city_id = x.city_id,
state_id = x.state_id,
country_id = x.country_id,
city_name = x.city_name
}).SingleOrDefault();
ViewBag.stateid = new SelectList(db.tbl_states.ToList(), "state_id", "state_name", obj.state_id);
ViewBag.countryid = new SelectList(db.tbl_countries.ToList(), "country_id", "country_name", obj.country_id);
return(View(obj));
}
