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