public ActionResult DeleteConfirmed(int id) { AspNetVirtualRole aspNetVirtualRole = db.AspNetVirtualRoles.Find(id); db.AspNetVirtualRoles.Remove(aspNetVirtualRole); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,Name")] AspNetVirtualRole aspNetVirtualRole) { if (ModelState.IsValid) { db.Entry(aspNetVirtualRole).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Id = new SelectList(db.AspNetVirtualRoles, "Id", "Name", aspNetVirtualRole.Id); ViewBag.Id = new SelectList(db.AspNetVirtualRoles, "Id", "Name", aspNetVirtualRole.Id); return(View(aspNetVirtualRole)); }
public ActionResult Create([Bind(Include = "Id,Name")] AspNetVirtualRole aspNetVirtualRole) { if (ModelState.IsValid) { db.AspNetVirtualRoles.Add(aspNetVirtualRole); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Id = new SelectList(db.AspNetVirtualRoles, "Id", "Name", aspNetVirtualRole.Id); ViewBag.Id = new SelectList(db.AspNetVirtualRoles, "Id", "Name", aspNetVirtualRole.Id); return(View(aspNetVirtualRole)); }
// GET: AspNetVirtualRoles/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AspNetVirtualRole aspNetVirtualRole = db.AspNetVirtualRoles.Find(id); if (aspNetVirtualRole == null) { return(HttpNotFound()); } return(View(aspNetVirtualRole)); }
public ActionResult Excel_Data(HttpPostedFileBase excelfile) { var dbTransaction = db.Database.BeginTransaction(); try { if (excelfile == null || excelfile.ContentLength == 0) { TempData["Error"] = "Please select an excel file"; return(RedirectToAction("Create", "AspNetVirtualRoles")); } else if (excelfile.FileName.EndsWith("xls") || excelfile.FileName.EndsWith("xlsx")) { HttpPostedFileBase file = excelfile; // Request.Files["excelfile"]; using (var package = new ExcelPackage(file.InputStream)) { var currentSheet = package.Workbook.Worksheets; var workSheet = currentSheet.First(); var noOfCol = workSheet.Dimension.End.Column; var noOfRow = workSheet.Dimension.End.Row; ApplicationDbContext context = new ApplicationDbContext(); for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++) { AspNetVirtualRole Vr = new AspNetVirtualRole(); Vr.Name = workSheet.Cells[rowIterator, 1].Text.ToString(); db.AspNetVirtualRoles.Add(Vr); db.SaveChanges(); } dbTransaction.Commit(); } return(RedirectToAction("Index", "AspNetVirtualRoles")); } else { TempData["Error"] = "File type is incorrect"; return(RedirectToAction("Create", "AspNetVirtualRoles")); } } catch { dbTransaction.Dispose(); TempData["Error"] = "Incorrect Data in files"; return(RedirectToAction("Create", "AspNetVirtualRoles")); } }
// GET: AspNetVirtualRoles/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AspNetVirtualRole aspNetVirtualRole = db.AspNetVirtualRoles.Find(id); if (aspNetVirtualRole == null) { return(HttpNotFound()); } ViewBag.Id = new SelectList(db.AspNetVirtualRoles, "Id", "Name", aspNetVirtualRole.Id); ViewBag.Id = new SelectList(db.AspNetVirtualRoles, "Id", "Name", aspNetVirtualRole.Id); return(View(aspNetVirtualRole)); }