// GET: NewElectivesTables/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
NewElectivesTable newElectivesTable = db.NewElectivesTables.Find(id);
if (newElectivesTable == null)
{
return(HttpNotFound());
}
ViewBag.SubCode = new SelectList(db.Subjects, "SubCode", "SubName", newElectivesTable.SubCode);
if (!User.IsInRole("Admin"))
{
string department = (string)TempData.Peek("Department");
ViewBag.USN = new SelectList(db.STUDENTs.Where(x => x.DeptID == department), "USN", "USN", newElectivesTable.SubCode);
}
else
{
ViewBag.USN = new SelectList(db.STUDENTs, "USN", "USN", newElectivesTable.USN);
}
return(View(newElectivesTable));
}
public ActionResult DeleteConfirmed(int id)
{
NewElectivesTable newElectivesTable = db.NewElectivesTables.Find(id);
db.NewElectivesTables.Remove(newElectivesTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: NewElectivesTables/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
NewElectivesTable newElectivesTable = db.NewElectivesTables.Find(id);
if (newElectivesTable == null)
{
return(HttpNotFound());
}
return(View(newElectivesTable));
}
public ActionResult Edit([Bind(Include = "USN,SubCode,id")] NewElectivesTable newElectivesTable)
{
if (ModelState.IsValid)
{
db.Entry(newElectivesTable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.SubCode = new SelectList(db.Subjects, "SubCode", "SubName", newElectivesTable.SubCode);
if (!User.IsInRole("Admin"))
{
string department = (string)TempData.Peek("Department");
ViewBag.USN = new SelectList(db.STUDENTs.Where(x => x.DeptID == department), "USN", "USN", newElectivesTable.SubCode);
}
else
{
ViewBag.USN = new SelectList(db.STUDENTs, "USN", "USN", newElectivesTable.USN);
}
return(View(newElectivesTable));
}
public ActionResult BulkUpload(HttpPostedFileBase postedFile)
{
string filePath = string.Empty;
List <ElectiveError> errorList = new List <ElectiveError>();
if (postedFile != null)
{
string path = Server.MapPath("~/Uploads/");
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
filePath = path + Path.GetFileName(postedFile.FileName) + DateTime.Now.Ticks;
string extension = Path.GetExtension(postedFile.FileName);
postedFile.SaveAs(filePath);
Excel.Application xlApp = new Excel.Application();
Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(filePath);
Excel._Worksheet xlWorksheet = xlWorkbook.Sheets[1];
Excel.Range xlRange = xlWorksheet.UsedRange;
int rowCount = xlRange.Rows.Count;
for (int i = 2; i <= rowCount; i++)
{
string Usn = xlRange.Cells[i, 1].Value2.ToString();
string SubjectCode = xlRange.Cells[i, 2].Value2.ToString();
NewElectivesTable table = new NewElectivesTable
{
SubCode = SubjectCode,
USN = Usn
};
try
{
db.NewElectivesTables.Add(table);
db.SaveChanges();
}
catch (DbEntityValidationException e)
{
ElectiveError error = new ElectiveError();
error.Usn = Usn;
error.SubjectCode = SubjectCode;
foreach (var eve in e.EntityValidationErrors)
{
foreach (var ve in eve.ValidationErrors)
{
error.Errors.Add(new Error
{
AttributeName = ve.PropertyName,
ErrorMessage = ve.ErrorMessage
});
}
}
errorList.Add(error);
}
catch (DbUpdateException d)
{
ElectiveError error = new ElectiveError();
error.Usn = Usn;
error.SubjectCode = SubjectCode;
error.Errors.Add(new Error
{
AttributeName = "",
ErrorMessage = "Invalid Combination"
});
errorList.Add(error);
}
}
}
return(View("ElectivesError", errorList));
}
