// GET: /Users/
public ActionResult Index(int isdelete = 0, int restoreid = 0)
{
var list = (dynamic)null;
TempData["restore"] = "";
if (isdelete == 0)
{
if (restoreid > 0)
{
if (db.tblProvince.Any(a => a.ProvinceID == restoreid && a.IsDelete == true))
{
tblProvince tblProvince = db.tblProvince.Find(restoreid);
tblProvince.IsDelete = false;
db.Entry(tblProvince).State = EntityState.Modified;
db.SaveChanges();
TempData["msg"] = "Record Restore Successfully";
// return View("Index","Province");
}
}
list = db.tblProvince.Where(a => a.IsDelete != true).OrderByDescending(a => a.ProvinceID).ToList();
}
else
{
TempData["restore"] = "restore";
list = db.tblProvince.Where(a => a.IsDelete == true).OrderByDescending(a => a.ProvinceID).ToList();
}
return(View(list));
}
public ActionResult DeleteConfirmed(int id)
{
tblProvince tblProvince = db.tblProvince.Find(id);
db.tblProvince.Remove(tblProvince);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "ProvinceID,ProvinceName,CreatedBy,UpdatedBy,CreateDate,UpdateDate,IsLogin,IsDelete,IsActive,CountryID,DeleteBy,DeleteDate")] tblProvince tblProvince)
{
if (ModelState.IsValid)
{
db.tblProvince.Add(tblProvince);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblProvince));
}
public ActionResult Edit([Bind(Include = "ProvinceID,ProvinceName,CreatedBy,UpdatedBy,CreateDate,UpdateDate,IsLogin,IsDelete,IsActive,ProvinceID,DeleteBy,DeleteDate")] tblProvince tblProvince)
{
if (ModelState.IsValid)
{
db.Entry(tblProvince).State = EntityState.Modified;
db.SaveChanges();
TempData["msg"] = "Record Update Successfully";
return(RedirectToAction("Index"));
}
return(View(tblProvince));
}
// GET: /Users/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblProvince tblProvince = db.tblProvince.Find(id);
if (tblProvince == null)
{
return(HttpNotFound());
}
return(View(tblProvince));
}
// GET: /Country/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblProvince tblProvince = db.tblProvince.Find(id);
ViewBag.CountryID = new SelectList(db.tblCountry, "CountryID", "CountryName", tblProvince.CountryID);
if (tblProvince == null)
{
return(HttpNotFound());
}
return(View(tblProvince));
}
