public ActionResult DeleteConfirmed(int id)
{
AspNetAssessment_Question aspNetAssessment_Question = db.AspNetAssessment_Question.Find(id);
db.AspNetAssessment_Question.Remove(aspNetAssessment_Question);
db.SaveChanges();
return(RedirectToAction("Index"));
}
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", "AspNetAssessment_Question"));
}
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++)
{
AspNetAssessment_Question Question = new AspNetAssessment_Question();
string ClassName = workSheet.Cells[rowIterator, 1].Text.ToString().ToUpper();
string SubjectName = workSheet.Cells[rowIterator, 2].Text.ToString().ToUpper();
string Catageory = workSheet.Cells[rowIterator, 3].Text.ToString().ToUpper();
int ClassID = db.AspNetClasses.Where(x => x.ClassName.ToUpper() == ClassName).Select(x => x.Id).FirstOrDefault();;
int subjectID = db.AspNetSubjects.Where(x => x.ClassID == ClassID && x.SubjectName.ToUpper() == SubjectName).Select(x => x.Id).FirstOrDefault();
int catageoryID = db.AspNetAssessment_Questions_Category.Where(x => x.CategoryName.ToUpper() == Catageory).Select(x => x.Id).FirstOrDefault();
Question.SubjectID = subjectID;
Question.QuestionCategory = catageoryID;
Question.Question = workSheet.Cells[rowIterator, 4].Text.ToString();
db.AspNetAssessment_Question.Add(Question);
}
db.SaveChanges();
}
dbTransaction.Commit();
return(RedirectToAction("Index", "AspNetAssessment_Question"));
}
else
{
TempData["Error"] = "File type is incorrect";
return(RedirectToAction("Create", "AspNetAssessment_Question"));
}
}
catch
{
dbTransaction.Dispose();
TempData["Error"] = "Incorrect data in file";
return(RedirectToAction("Create", "AspNetAssessment_Question"));
}
}
public ActionResult Create([Bind(Include = "Id,Question,SubjectID,QuestionCategory")] AspNetAssessment_Question aspNetAssessment_Question)
{
if (ModelState.IsValid)
{
db.AspNetAssessment_Question.Add(aspNetAssessment_Question);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ClassID = new SelectList(db.AspNetClasses, "Id", "ClassName");
ViewBag.QuestionCategory = new SelectList(db.AspNetAssessment_Questions_Category, "Id", "CategoryName", aspNetAssessment_Question.QuestionCategory);
ViewBag.SubjectID = new SelectList(db.AspNetSubjects, "Id", "SubjectName", aspNetAssessment_Question.SubjectID);
return(View(aspNetAssessment_Question));
}
// GET: AspNetAssessment_Question/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AspNetAssessment_Question aspNetAssessment_Question = db.AspNetAssessment_Question.Find(id);
if (aspNetAssessment_Question == null)
{
return(HttpNotFound());
}
return(View(aspNetAssessment_Question));
}
// GET: AspNetAssessment_Question/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AspNetAssessment_Question aspNetAssessment_Question = db.AspNetAssessment_Question.Find(id);
if (aspNetAssessment_Question == null)
{
return(HttpNotFound());
}
ViewBag.ClassID = new SelectList(db.AspNetClasses, "Id", "ClassName", aspNetAssessment_Question.AspNetSubject.ClassID);
ViewBag.QuestionCategory = new SelectList(db.AspNetAssessment_Questions_Category, "Id", "CategoryName", aspNetAssessment_Question.QuestionCategory);
ViewBag.SubjectID = new SelectList(db.AspNetSubjects, "Id", "SubjectName", aspNetAssessment_Question.SubjectID);
return(View(aspNetAssessment_Question));
}
public ActionResult DeleteCnfm(int id)
{
AspNetAssessment_Question aspNetAssessment_Question = db.AspNetAssessment_Question.Find(id);
try
{
db.AspNetAssessment_Question.Remove(aspNetAssessment_Question);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
ViewBag.Error = "It can't be deleted";
ViewBag.SubjectID = new SelectList(db.AspNetSubjects, "Id", "SubjectName", aspNetAssessment_Question.SubjectID);
ViewBag.QuestionCategory = new SelectList(db.AspNetAssessment_Questions_Category, "Id", "CategoryName", aspNetAssessment_Question.QuestionCategory);
return(View("Details", aspNetAssessment_Question));
}
}
