protected void Page_Load(object sender, EventArgs e) { link = new ClsTempLink("MasterSchedule"); link.SectionId = (Guid)Session["NewSectionID"]; if (!IsPostBack) { // MultiView1.ActiveViewIndex = 0; SectionID.Value = Session["NewSectionID"].ToString(); } }
private string getCourseInfo() { StringBuilder sb = new StringBuilder(); sb.Append("Course Details<br/>"); sb.Append("Year: " + SectionDetails1.Year); sb.Append("<br/>Semester: " + SectionDetails1.Semester); sb.Append("<br/>Department: " + SectionDetails1.Department); sb.Append("<br/>Catalog Number: " + SectionDetails1.CatalogNumber); sb.Append("<br/>Section Number: " + SectionDetails1.SectionNumber); sb.Append("<br/>Start Date: " + SectionDetails1.DateStart); sb.Append("<br/>End Date: " + SectionDetails1.DateEnd); sb.Append("<br/>Capacity: " + SectionDetails1.Capacity); sb.Append("<br/><br/>"); sb.Append("Faculty<ul>"); ClsTempFaculty faculty = new ClsTempFaculty("MasterSchedule"); faculty.SectionId = section.SectionId; DataSet facultyds = faculty.FillDs(); for (int i = 0; i < facultyds.Tables[0].Rows.Count; i++) { sb.Append("<li>" + facultyds.Tables[0].Rows[i]["FacultyName"].ToString() + "</li>"); } facultyds.Dispose(); sb.Append("</ul><br/>"); sb.Append("Meetings<br/><br/>"); ClsTempMeeting meeting = new ClsTempMeeting("MasterSchedule"); meeting.SectionId = section.SectionId; DataSet meetingds = meeting.FillDs(); for (int i = 0; i < meetingds.Tables[0].Rows.Count; i++) { sb.Append("Meeting " + ((int)(i + 1)).ToString()); sb.Append("<br/>Campus: " + meetingds.Tables[0].Rows[i]["Campus"].ToString()); sb.Append("<br/>Room: " + meetingds.Tables[0].Rows[i]["Room"].ToString()); sb.Append("<br/>Start Time: " + meetingds.Tables[0].Rows[i]["StartTime"].ToString()); sb.Append("<br/>End Time: " + meetingds.Tables[0].Rows[i]["EndTime"].ToString()); sb.Append("<br/>Days: " + meetingds.Tables[0].Rows[i]["Days"].ToString()); sb.Append("<br/>Type: " + meetingds.Tables[0].Rows[i]["Type"].ToString()); sb.Append("<br/><br/>"); } meetingds.Dispose(); sb.Append("Co-Listed Courses<ul>"); ClsTempColink colink = new ClsTempColink("MasterSchedule"); colink.SectionId = section.SectionId; DataSet colinkds = colink.FillDs(); for (int i = 0; i < colinkds.Tables[0].Rows.Count; i++) { sb.Append("<li>" + colinkds.Tables[0].Rows[i]["Department"].ToString() + " - " + colinkds.Tables[0].Rows[i]["Course"].ToString() + " - " + colinkds.Tables[0].Rows[i]["Section"].ToString() + "</li>"); } colinkds.Dispose(); sb.Append("</ul><br/>"); sb.Append("Cross Linked Courses<ul>"); ClsTempLink link = new ClsTempLink("MasterSchedule"); link.SectionId = section.SectionId; DataSet linkds = link.FillDs(); for (int i = 0; i < linkds.Tables[0].Rows.Count; i++) { sb.Append("<li>" + linkds.Tables[0].Rows[i]["Department"].ToString() + " - " + linkds.Tables[0].Rows[i]["Course"].ToString() + " - " + linkds.Tables[0].Rows[i]["Section"].ToString() + "</li>"); } linkds.Dispose(); sb.Append("</ul><br/>"); sb.Append("Co-requisite Courses<ul>"); ClsTempCoreq coreq = new ClsTempCoreq("MasterSchedule"); coreq.SectionId = section.SectionId; DataSet coreqds = coreq.FillDs(); for (int i = 0; i < coreqds.Tables[0].Rows.Count; i++) { sb.Append("<li>" + coreqds.Tables[0].Rows[i]["Department"].ToString() + " - " + coreqds.Tables[0].Rows[i]["Course"].ToString() + " - " + coreqds.Tables[0].Rows[i]["Section"].ToString() + "</li>"); } coreqds.Dispose(); sb.Append("</ul><br/>"); sb.Append("Comments<ul>"); string InitiatorComments = string.Empty; if (string.IsNullOrEmpty(Comments_New1.Comments)) { InitiatorComments = "No Comments."; } else { InitiatorComments = Comments_New1.Comments; } sb.Append("<br/>Initiator: " + InitiatorComments); sb.Append("</ul><br/>"); return(sb.ToString()); }
protected void btnAddNewCourse_Click(object sender, EventArgs e) { StringBuilder sb = new StringBuilder(); sb.Append("<h4>Add Course:</h4><br/><br/>"); sb.Append("Course Details<br/>"); sb.Append("Year: " + SectionDetails1.Year); sb.Append("<br/>Semester: " + SectionDetails1.Semester); sb.Append("<br/>Department: " + SectionDetails1.Department); sb.Append("<br/>Catalog Number: " + SectionDetails1.CatalogNumber); sb.Append("<br/>Section Number: " + SectionDetails1.SectionNumber); sb.Append("<br/>Start Date: " + SectionDetails1.DateStart); sb.Append("<br/>End Date: " + SectionDetails1.DateEnd); sb.Append("<br/>Capacity: " + SectionDetails1.Capacity); sb.Append("<br/><br/>"); sb.Append("Faculty<ul>"); ClsTempFaculty faculty = new ClsTempFaculty("MasterSchedule"); faculty.SectionId = section.SectionId; DataSet facultyds = faculty.FillDs(); for (int i = 0; i < facultyds.Tables[0].Rows.Count; i++) { sb.Append("<li>" + facultyds.Tables[0].Rows[i]["FacultyName"].ToString() + "</li>"); } facultyds.Dispose(); sb.Append("</ul><br/>"); sb.Append("Meetings<br/><br/>"); ClsTempMeeting meeting = new ClsTempMeeting("MasterSchedule"); meeting.SectionId = section.SectionId; DataSet meetingds = meeting.FillDs(); for (int i = 0; i < meetingds.Tables[0].Rows.Count; i++) { sb.Append("Meeting " + ((int)(i + 1)).ToString()); sb.Append("<br/>Campus: " + meetingds.Tables[0].Rows[i]["Campus"].ToString()); sb.Append("<br/>Room: " + meetingds.Tables[0].Rows[i]["Room"].ToString()); sb.Append("<br/>Start Time: " + meetingds.Tables[0].Rows[i]["StartTime"].ToString()); sb.Append("<br/>End Time: " + meetingds.Tables[0].Rows[i]["EndTime"].ToString()); sb.Append("<br/>Days: " + meetingds.Tables[0].Rows[i]["Days"].ToString()); sb.Append("<br/><br/>"); } meetingds.Dispose(); sb.Append("Cross Linked Courses<ul>"); ClsTempLink link = new ClsTempLink("MasterSchedule"); link.SectionId = section.SectionId; DataSet linkds = link.FillDs(); for (int i = 0; i < linkds.Tables[0].Rows.Count; i++) { sb.Append("<li>" + linkds.Tables[0].Rows[i]["Department"].ToString() + " - " + linkds.Tables[0].Rows[i]["Course"].ToString() + " - " + linkds.Tables[0].Rows[i]["Section"].ToString() + "</li>"); } linkds.Dispose(); sb.Append("</ul><br/>"); sb.Append("Co-requisite Courses<ul>"); ClsTempCoreq coreq = new ClsTempCoreq("MasterSchedule"); coreq.SectionId = section.SectionId; DataSet coreqds = coreq.FillDs(); for (int i = 0; i < coreqds.Tables[0].Rows.Count; i++) { sb.Append("<li>" + coreqds.Tables[0].Rows[i]["Department"].ToString() + " - " + coreqds.Tables[0].Rows[i]["Course"].ToString() + " - " + coreqds.Tables[0].Rows[i]["Section"].ToString() + "</li>"); } coreqds.Dispose(); sb.Append("</ul><br/>"); log.SectionsId = 0; log.SubmittedBy = Session["deltaid"].ToString(); log.DepartmentsId = SectionDetails1.DepartmentsID; log.Change = sb.ToString(); log.AddRecord(); section.DeleteRecord(); MultiView1.ActiveViewIndex = 1; List <ClsChangeLog> logs = new List <ClsChangeLog>(); logs.Add(log); gvPendingChanges.DataSource = logs; gvPendingChanges.DataBind(); }