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