public ActionResult Upload(List <Datasheet> lstDatasheets)
{
if (Request != null)
{
if (Request.Form["LoadDatasheets"] != null)
{
CCTokenSystemContext dbcontext = new CCTokenSystemContext();
HttpPostedFileBase file = Request.Files["DataFileupload"];
string fileExtension = System.IO.Path.GetExtension(Request.Files["DataFileupload"].FileName);
Session["resourceFile"] = file;
if (fileExtension == ".xls" || fileExtension == ".xlsx")
{
var package = new ExcelPackage(file.InputStream);
lstDatasheets = new List <Datasheet>();
int id = 0;
foreach (ExcelWorksheet ws in package.Workbook.Worksheets)
{
Datasheet ds = new Datasheet();
ds.id = ++id;
ds.Name = ws.Name;
lstDatasheets.Add(ds);
}
}
else
{
ViewData["error"] = "Please, Uplaod Excel file only";
}
return(View("Index", lstDatasheets));
}
if (Request.Form["LoadData"] != null)
{
if (lstDatasheets != null && lstDatasheets.Count >= 1)
{
HttpPostedFileBase file = (HttpPostedFileBase)Session["resourceFile"];
foreach (Datasheet ds in lstDatasheets)
{
if (ds.Name.Equals("students") && ds.TobeUploaded)
{
LoadStudent(file);
}
if (ds.Name.Equals("campus") && ds.TobeUploaded)
{
LoadCampus(file);
}
if (ds.Name.Equals("Depts") && ds.TobeUploaded)
{
LoadDept(file);
}
if (ds.Name.Equals("Advisors") && ds.TobeUploaded)
{
LoadAdvisors(file);
}
}
}
}
}
ViewData["message"] = "Data successfully uploaded";
return(View("Index"));
}
public ActionResult Upload(List<Datasheet> lstDatasheets)
{
if (Request != null)
{
if (Request.Form["LoadDatasheets"] != null)
{
CCTokenSystemContext dbcontext = new CCTokenSystemContext();
HttpPostedFileBase file = Request.Files["DataFileupload"];
string fileExtension = System.IO.Path.GetExtension(Request.Files["DataFileupload"].FileName);
Session["resourceFile"] = file;
if (fileExtension == ".xls" || fileExtension == ".xlsx")
{
var package = new ExcelPackage(file.InputStream);
lstDatasheets = new List<Datasheet>();
int id = 0;
foreach (ExcelWorksheet ws in package.Workbook.Worksheets)
{
Datasheet ds = new Datasheet();
ds.id = ++id;
ds.Name = ws.Name;
lstDatasheets.Add(ds);
}
}
else
{
ViewData["error"] = "Please, Uplaod Excel file only";
}
return View("Index", lstDatasheets);
}
if (Request.Form["LoadData"] != null)
{
if (lstDatasheets != null && lstDatasheets.Count >= 1)
{
HttpPostedFileBase file = (HttpPostedFileBase)Session["resourceFile"];
foreach (Datasheet ds in lstDatasheets)
{
if (ds.Name.Equals("students") && ds.TobeUploaded)
{
LoadStudent(file);
}
if (ds.Name.Equals("campus") && ds.TobeUploaded)
{
LoadCampus(file);
}
if (ds.Name.Equals("Depts") && ds.TobeUploaded)
{
LoadDept(file);
}
if (ds.Name.Equals("Advisors") && ds.TobeUploaded)
{
LoadAdvisors(file);
}
}
}
}
}
ViewData["message"] = "Data successfully uploaded";
return View("Index");
}