// GET: SpreadsheetVariables/Create
public IActionResult Create()
{
User currentUser = SessionVariables.GetCurrentUser(HttpContext);
if (currentUser != null && currentUser.Role != null && currentUser.Role.Spreadsheets.CanAdd)
{
SpreadsheetVariables sv = new SpreadsheetVariables();
return(View(sv));
}
else
{
SessionVariables.SetErrorMessage("You do not have permission to create spreadsheet details");
return(RedirectToAction("Index"));
}
}
// GET: SpreadsheetVariables/Details/5
public IActionResult Details(int?id)
{
if (id == null)
{
return(NotFound());
}
SpreadsheetVariables spreadsheetVariables = DAL.GetSpreadsheetVariables((int)id);
if (spreadsheetVariables == null)
{
return(NotFound());
}
return(View(spreadsheetVariables));
}
public IActionResult Create([Bind("StartingRowNumber,AcademicSemester,AddChangeDelete,Department,SectionCRN," +
"CourseNumber,SectionNumber,CrossListID,CourseTitle,Campus,ScheduleType,MoodleRequired,InstructorApprovalRequired," +
"PartOfTerm,FixedCredit,MinimumCredits,MaximumCredits,ClassLimit,Monday,Tuesday,Wednesday,Thursday,Friday,Saturday," +
"Sunday,StartTime,EndTime,Building,Room,PrimaryInstructorFirstName,PrimaryInstructorLastName,PrimaryInstructorNumber," +
"PrimaryInstructorTeachingPercentage,SecondaryInstructorFirstName,SecondaryInstructorLastName,SecondaryInstructorNumber," +
"SecondaryInstructorTeachingPercentage,ClassFeeDetailCode,ClassFeeAmount,SectionNotes,CrossListSubject,CrossListCourseNumber," +
"DepartmentComments,ID,DefaultFontStyle,DefaultFontSize,RequiresPermissionAbbreviation,RequiresMoodleAbbreviation")]
SpreadsheetVariables spreadsheetVariables, IFormFile file)
{
if (ModelState.IsValid)
{
try {
ExcelPackage package = new ExcelPackage(file.OpenReadStream());
DAL.AddSpreadsheetVariables(spreadsheetVariables);
return(RedirectToAction("Index"));
}
catch (Exception error) {
}
}
return(View(spreadsheetVariables));
}
// GET: SpreadsheetVariables/Delete/5
public async Task <IActionResult> Delete(int?id)
{
User currentUser = SessionVariables.GetCurrentUser(HttpContext);
if (currentUser != null && currentUser.Role != null && currentUser.Role.Spreadsheets.CanDelete)
{
if (id == null)
{
return(NotFound());
}
SpreadsheetVariables spreadsheetVariables = DAL.GetSpreadsheetVariables((int)id);
if (spreadsheetVariables == null)
{
return(NotFound());
}
return(View(spreadsheetVariables));
}
else
{
SessionVariables.SetErrorMessage("You do not have permission to delete spreadsheet details");
return(RedirectToAction("Index"));
}
}
public async Task <IActionResult> Edit(int id, [Bind("StartingRowNumber,AcademicSemester,AddChangeDelete,Department,SectionCRN," +
"CourseNumber,SectionNumber,CrossListID,CourseTitle,Campus,ScheduleType,MoodleRequired,InstructorApprovalRequired," +
"PartOfTerm,FixedCredit,MinimumCredits,MaximumCredits,ClassLimit,Monday,Tuesday,Wednesday,Thursday,Friday,Saturday," +
"Sunday,StartTime,EndTime,Building,Room,PrimaryInstructorFirstName,PrimaryInstructorLastName,PrimaryInstructorNumber," +
"PrimaryInstructorTeachingPercentage,SecondaryInstructorFirstName,SecondaryInstructorLastName,SecondaryInstructorNumber," +
"SecondaryInstructorTeachingPercentage,ClassFeeDetailCode,ClassFeeAmount,SectionNotes,CrossListSubject,CrossListCourseNumber," +
"DepartmentComments,ID,DefaultFontStyle,DefaultFontSize,RequiresPermissionAbbreviation,RequiresMoodleAbbreviation")]
SpreadsheetVariables spreadsheetVariables, IFormFile file)
{
if (id != spreadsheetVariables.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
if (DAL.UpdateSpreadsheetVariables(spreadsheetVariables) > 0)
{
SessionVariables.SetSuccessMessage("Spreadsheet variables edited successfully");
}
if (file != null)
{
try {
ExcelPackage package = new ExcelPackage(file.OpenReadStream());
ExcelWorksheet worksheet = package.Workbook.Worksheets[1];
string webRoot = _Environment.WebRootPath;
//saves a spreadsheet for formatting not needing to save the changes each time though because it is just using the top 3 rows
package.SaveAs(new FileInfo(webRoot + "\\currentSheet.xlsx"));
}
catch (Exception error) {
SessionVariables.SetErrorMessage("Spreadsheet template save failed");
}
}
return(RedirectToAction("Index"));
}
return(View(spreadsheetVariables));
}
