protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { int index = Convert.ToInt32(e.CommandArgument); if (index >= GridView1.Rows.Count) return; GridViewRow selectedRow = ((GridView)e.CommandSource).Rows[index]; string ID = selectedRow.Cells[2].Text; if (e.CommandName == "remove") { if (GridView1.Rows.Count == 0) return; HogwartsDatabaseModelDataContext db = new HogwartsDatabaseModelDataContext(); var DeleteAr = (from ar in db.Articles where ar.ArticleID.ToString() == ID select ar).First(); db.Articles.DeleteOnSubmit(DeleteAr); db.SubmitChanges(); db.Connection.Close(); //delete relevant content in table Classes.TableDataContract.DeleteArticle(Convert.ToInt32(ID)); ReloadAnnouncements(); Response.Redirect("StaffAnnouncements.aspx"); } else if (e.CommandName == "view") { Session["ArticleID"] = Convert.ToInt32(ID); Response.Redirect("./NewsPage.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (Classes.HogwartsDataAccess.GetRole(Context.User.Identity.Name) == 1) { Response.Redirect("~/StaffWorks/StaffHome/StaffProfile.aspx"); } HogwartsDatabaseModelDataContext db = new HogwartsDatabaseModelDataContext(); int StudentID = (int)Session["studentID"]; var EachStudent = (from st in db.Students where st.StudentID == StudentID select st).First(); var rec = (from sr in db.StudentRequests where StudentID == sr.StudentID select sr).FirstOrDefault(); if (rec != null) { LinkButton1.Enabled = false; } else { LinkButton1.Enabled = true; } Label2.Text = EachStudent.FirstName + " " + EachStudent.LastName; Label3.Text = EachStudent.Nationality; Label4.Text = EachStudent.MmailAddress; Label5.Text = EachStudent.House.HouseName; Label6.Text = Context.User.Identity.Name; }
protected void Button1_Click(object sender, EventArgs e) { if (DropDownList1.Items.Count == 0) { return; } HogwartsDatabaseModelDataContext db = new HogwartsDatabaseModelDataContext(); int StudentID = Convert.ToInt32(DropDownList1.SelectedValue); var NeededStu = (from stu in db.Students join house in db.Houses on stu.HouseID equals house.HouseID where stu.StudentID == StudentID && stu.HouseID == house.HouseID select new { StudentID = stu.StudentID, CurrentFirstname = stu.FirstName, CurrentLastname = stu.LastName, CurrentNationality = stu.Nationality, CurrentMMailAddress = stu.MmailAddress, CurrentHouseName = house.HouseName }); GridView1.DataSource = NeededStu; GridView1.DataBind(); var NewStu = (from stu in db.StudentRequests where stu.StudentID == StudentID select stu); GridView2.DataSource = NewStu; GridView2.DataBind(); Button2.Visible = true; Button3.Visible = true; }
protected void Reload() { int CourseID = Int32.Parse((string)Session["CourseID"]); HogwartsDatabaseModelDataContext db = new HogwartsDatabaseModelDataContext(); Course ret = (from course in db.Courses where course.CourseID == CourseID select course).First(); SemH.InnerText = "semester: " + ret.Semester.Time; DeptH.InnerText = "department: " + ret.Discipline.Department.Name; CourseH.InnerText = "course: #" + ret.CourseID.ToString() + " | " + ret.Discipline.Name; InstructorH.InnerText = "instructor: " + ret.Staff.FirstName + " " + ret.Staff.LastName; if (ret.AttendeeNumber == null) { Label1.Text = "There's no student in this course"; GridView1.Visible = false; Button1.Visible = false; return; } Label1.Text = ""; var sics = (from sic in db.StudentInCourses where sic.CourseID == CourseID select new { sic.StudentID, sic.Student.FirstName, sic.Student.LastName }).ToList(); GridView1.DataSource = sics; GridView1.DataBind(); foreach (GridViewRow gvr in GridView1.Rows) { DropDownList ddl = (DropDownList)gvr.FindControl("DropDownList1"); ddl.SelectedValue = Classes.HogwartsDataAccess.GetStudentInCourse(Int32.Parse(gvr.Cells[0].Text), CourseID); } GridView1.Visible = true; Button1.Visible = true; db.Connection.Close(); }
protected void Reload() { int CourseID = Int32.Parse((string)Session["CourseID"]); HogwartsDatabaseModelDataContext db = new HogwartsDatabaseModelDataContext(); Course ret = (from course in db.Courses where course.CourseID == CourseID select course).First(); SemH.InnerText = "semester: "+ret.Semester.Time; DeptH.InnerText = "department: "+ret.Discipline.Department.Name; CourseH.InnerText = "course: #" + ret.CourseID.ToString() + " | " + ret.Discipline.Name; InstructorH.InnerText = "instructor: "+ret.Staff.FirstName + " " + ret.Staff.LastName; if (ret.AttendeeNumber == null) { Label1.Text = "There's no student in this course"; GridView1.Visible = false; Button1.Visible = false; return; } Label1.Text = ""; var sics = (from sic in db.StudentInCourses where sic.CourseID == CourseID select new { sic.StudentID, sic.Student.FirstName, sic.Student.LastName }).ToList(); GridView1.DataSource = sics; GridView1.DataBind(); foreach (GridViewRow gvr in GridView1.Rows) { DropDownList ddl = (DropDownList)gvr.FindControl("DropDownList1"); ddl.SelectedValue = Classes.HogwartsDataAccess.GetStudentInCourse(Int32.Parse(gvr.Cells[0].Text), CourseID); } GridView1.Visible = true; Button1.Visible = true; db.Connection.Close(); }
public static bool[][] GetStudentAllotedTable(int SemesterID, int StudentID) { bool[][] sat = new bool[7][]; for (int i = 0; i < 7; i++) { sat[i] = new bool[9]; } for (int i = 0; i < 7; i++) { for (int j = 0; j < 9; j++) { sat[i][j] = false; } } HogwartsDatabaseModelDataContext context = new HogwartsDatabaseModelDataContext(ConnectionString); var sessions = (from sic in context.StudentInCourses where sic.StudentID == StudentID && sic.Course.SemesterID == SemesterID from s in context.Sessions where s.CourseID == sic.CourseID select s); foreach (Session s in sessions) { sat[s.Weekday][s.StartingPeriod] = true; sat[s.Weekday][s.StartingPeriod + 1] = true; } context.Connection.Close(); return(sat); }
protected void Button2_Click(object sender, EventArgs e) { HogwartsDatabaseModelDataContext db = new HogwartsDatabaseModelDataContext(); int StudentID = Convert.ToInt32(GridView1.Rows[0].Cells[0].Text); var NewStu = (from nstu in db.StudentRequests where nstu.StudentID == StudentID select nstu).First(); string NewHouseName = NewStu.NewHouseName; var house = (from h in db.Houses where h.HouseName == NewHouseName select h).First(); var stu = (from s in db.Students where s.StudentID == StudentID select s).First(); stu.FirstName = NewStu.NewFirstName; stu.LastName = NewStu.NewLastName; stu.Nationality = NewStu.NewNationality; stu.MmailAddress = NewStu.NewMMailAddress; stu.HouseID = house.HouseID; db.SubmitChanges(); deleteStudentRequest(); //give notification to the student in charge Staff staff = Classes.HogwartsDataAccess.GetStaff(Context.User.Identity.Name); Classes.TableDataContract.AddNotice(staff.StaffID, StudentID, "accepted", 0, true, false); Response.Redirect("ProcessStudentRequests.aspx"); }
protected void Button2_Click(object sender, EventArgs e) { RestartGeneration(); HideInfo(); HogwartsDatabaseModelDataContext db = new HogwartsDatabaseModelDataContext(); Dictionary <int, int> D = new Dictionary <int, int>(); foreach (Course c in (List <Course>)Session["CourseLst"]) { int disp1 = c.CourseID; db.Courses.InsertOnSubmit(c); db.SubmitChanges(); int disp2 = c.CourseID; D[disp1] = disp2; } foreach (Session s in (List <Session>)Session["SessionLst"]) { s.CourseID = D[s.CourseID]; db.Sessions.InsertOnSubmit(s); db.SubmitChanges(); } db.Connection.Close(); Response.Redirect("GenerateCourses.aspx"); }
public static void FillAllottedClass(string time, bool[][][] AllottedClass) { for (int i = 1; i <= 10; i++) { for (int j = 2; j <= 6; j++) { for (int k = 1; k <= 8; k++) { AllottedClass[i][j][k] = false; } } } HogwartsDatabaseModelDataContext context = new HogwartsDatabaseModelDataContext(ConnectionString); var ret = (from semester in context.Semesters where semester.Time == time from course in context.Courses where course.SemesterID == semester.SemesterID from session in context.Sessions where session.CourseID == course.CourseID select session); foreach (Session s in ret) { AllottedClass[s.Classroom][s.Weekday][s.StartingPeriod] = true; AllottedClass[s.Classroom][s.Weekday][s.StartingPeriod + 1] = true; } context.Connection.Close(); }
protected void Page_Load(object sender, EventArgs e) { if (Classes.HogwartsDataAccess.GetRole(Context.User.Identity.Name) == 0) { Response.Redirect("~/StudentWorks/StudentHome/StudentProfile.aspx"); } string username = Context.User.Identity.Name; HogwartsDatabaseModelDataContext db = new HogwartsDatabaseModelDataContext(); var staff = (from s in db.Staffs where s.UserName == username select s).First(); ViewState["title"] = staff.FirstName + " " + staff.LastName; try { if (!IsPostBack) { this.EnsureContainerExists(); } this.RefreshGallery(); } catch (System.Net.WebException we) { status.Text = "Network error: " + we.Message; if (we.Status == System.Net.WebExceptionStatus.ConnectFailure) { status.Text += "<br />Please check if the blob storage service is running at " + ConfigurationManager.AppSettings["storageEndpoint"]; } } catch (StorageException se) { Console.WriteLine("Storage service error: " + se.Message); } }
public static List <Department> GetDepartments() { HogwartsDatabaseModelDataContext context = new HogwartsDatabaseModelDataContext(ConnectionString); var result = (from department in context.Departments select department).ToList <Department>(); context.Connection.Close(); return(result); }
public static Department GetDepartment(string username) { HogwartsDatabaseModelDataContext context = new HogwartsDatabaseModelDataContext(ConnectionString); var result = (from stu in context.Students where stu.UserName == username select stu).First(); return(result.Department); }
public static IQueryable <string> GetSemesterList() { HogwartsDatabaseModelDataContext context = new HogwartsDatabaseModelDataContext(ConnectionString); var result = (from semester in context.Semesters select semester.Time); context.Connection.Close(); return(result); }
public static int InsertSession(Session session) { HogwartsDatabaseModelDataContext context = new HogwartsDatabaseModelDataContext(ConnectionString); context.Sessions.InsertOnSubmit(session); context.SubmitChanges(); context.Connection.Close(); return(session.SessionID); }
public static IQueryable <string> GetDepartmentList() { HogwartsDatabaseModelDataContext context = new HogwartsDatabaseModelDataContext(ConnectionString); var result = (from department in context.Departments select department.Name); context.Connection.Close(); return(result); }
public static List <Semester> GetAllSemesters() { HogwartsDatabaseModelDataContext context = new HogwartsDatabaseModelDataContext(ConnectionString); var result = (from semester in context.Semesters select semester).ToList <Semester>(); context.Connection.Close(); return(result); }
public static List <Course> GetAllCourses() { HogwartsDatabaseModelDataContext context = new HogwartsDatabaseModelDataContext(ConnectionString); var courses = (from course in context.Courses select course).ToList <Course>(); context.Connection.Close(); return(courses); }
public static Semester GetSemester(int semesterID) { HogwartsDatabaseModelDataContext context = new HogwartsDatabaseModelDataContext(ConnectionString); Semester outSemester = (from semester in context.Semesters where semester.SemesterID == semesterID select semester).FirstOrDefault <Semester>(); return(outSemester); }
public static int InsertCourse(Course course) { HogwartsDatabaseModelDataContext context = new HogwartsDatabaseModelDataContext(ConnectionString); context.Courses.InsertOnSubmit(course); context.SubmitChanges(); context.Connection.Close(); return(course.CourseID); }
public static List <Student> GetStudent(int studentID) { HogwartsDatabaseModelDataContext context = new HogwartsDatabaseModelDataContext(ConnectionString); List <Student> students = (from stu in context.Students where stu.StudentID == studentID select stu).ToList <Student>(); context.Connection.Close(); return(students); }
public static Discipline GetDiscipline(int disciplineID) { HogwartsDatabaseModelDataContext context = new HogwartsDatabaseModelDataContext(ConnectionString); Discipline discipline = (from d in context.Disciplines where d.DisciplineID == disciplineID select d).FirstOrDefault <Discipline>(); context.Connection.Close(); return(discipline); }
public static string GetStudentInCourse(int StudentID, int CourseID) { HogwartsDatabaseModelDataContext context = new HogwartsDatabaseModelDataContext(ConnectionString); var CourseGPA = (from sic in context.StudentInCourses where sic.StudentID == StudentID && sic.CourseID == CourseID select sic.CourseGPA).First(); context.Connection.Close(); return(CourseGPA); }
public static string GetDepartment(int DepartmentID) { HogwartsDatabaseModelDataContext context = new HogwartsDatabaseModelDataContext(ConnectionString); var ret = (from department in context.Departments where department.DepartmentID == DepartmentID select department.Name).First(); context.Connection.Close(); return(ret); }
public static List <Session> GetSessions(int courseID) { HogwartsDatabaseModelDataContext context = new HogwartsDatabaseModelDataContext(ConnectionString); var sessions = (from session in context.Sessions where session.CourseID == courseID select session).ToList <Session>(); context.Connection.Close(); return(sessions); }
public static Staff GetStaff(string UserName, string Password) { HogwartsDatabaseModelDataContext context = new HogwartsDatabaseModelDataContext(ConnectionString); Staff staff = (from sta in context.Staffs where sta.UserName == UserName && sta.Password == Password select sta).FirstOrDefault <Staff>(); context.Connection.Close(); return(staff); }
public static Course GetCourse(int CourseID) { HogwartsDatabaseModelDataContext context = new HogwartsDatabaseModelDataContext(ConnectionString); var course = (from c in context.Courses where c.CourseID == CourseID select c).First(); context.Connection.Close(); return(course); }
public static List <Course> GetCourses(int semesterID) { HogwartsDatabaseModelDataContext context = new HogwartsDatabaseModelDataContext(ConnectionString); List <Course> courses = (from course in context.Courses where course.SemesterID == semesterID select course).ToList <Course>(); context.Connection.Close(); return(courses); }
public static List <Discipline> GetDisciplines(int departmentID) { HogwartsDatabaseModelDataContext context = new HogwartsDatabaseModelDataContext(); var result = (from discipline in context.Disciplines where discipline.DepartmentID == departmentID select discipline).ToList <Discipline>(); context.Connection.Close(); return(result); }
public static Student GetStudent(string UserName, string Password) { HogwartsDatabaseModelDataContext context = new HogwartsDatabaseModelDataContext(ConnectionString); Student student = (from stu in context.Students where stu.UserName == UserName && stu.Password == Password select stu).FirstOrDefault <Student>(); context.Connection.Close(); return(student); }
public static List <Staff> GetStaffs(int deparmentID) { HogwartsDatabaseModelDataContext context = new HogwartsDatabaseModelDataContext(); var result = (from staff in context.Staffs where staff.DepartmentID == deparmentID select staff).ToList <Staff>(); context.Connection.Close(); return(result); }
public static string GetStudentName(int StudentID) { HogwartsDatabaseModelDataContext context = new HogwartsDatabaseModelDataContext(ConnectionString); Student student = (from stu in context.Students where stu.StudentID == StudentID select stu).FirstOrDefault <Student>(); context.Connection.Close(); return(student.FirstName + " " + student.LastName); }
public static int GetSemesterID(string time) { HogwartsDatabaseModelDataContext context = new HogwartsDatabaseModelDataContext(ConnectionString); var ret = (from semester in context.Semesters where semester.Time == time select semester.SemesterID).First(); context.Connection.Close(); return(ret); }
private void ReloadAnnouncements() { HogwartsDatabaseModelDataContext db = new HogwartsDatabaseModelDataContext(); var ars = (from ar in db.Articles where ar.StaffID == (int)Session["StaffID"] select new { ar.ArticleID, ar.Title, PostingDate = ar.DateTime }).ToList(); GridView1.DataSource = ars; GridView1.DataBind(); db.Connection.Close(); }
protected void Page_Load(object sender, EventArgs e) { if (Classes.HogwartsDataAccess.GetRole(Context.User.Identity.Name) == 0) Response.Redirect("~/StudentWorks/StudentHome/StudentProfile.aspx"); if (!Page.IsPostBack) { HogwartsDatabaseModelDataContext db = new HogwartsDatabaseModelDataContext(); string username = Context.User.Identity.Name; var rec = (from c in db.Staffs where username == c.UserName select c).First(); Session["StaffID"] = rec.StaffID; } }
protected void Page_Load(object sender, EventArgs e) { if (Classes.HogwartsDataAccess.GetRole(Context.User.Identity.Name) == 0) Response.Redirect("~/StudentWorks/StudentHome/StudentProfile.aspx"); HogwartsDatabaseModelDataContext db = new HogwartsDatabaseModelDataContext(); int ArticleID = (int)Session["ArticleID"]; var ar = (from a in db.Articles where ArticleID == a.ArticleID select a).First(); title.InnerText = ar.Title; time.InnerText = ar.DateTime.ToString(); content.InnerHtml = ar.Content; }
protected void Button1_Click(object sender, EventArgs e) { if (TextBox1.Text != TextBox2.Text || TextBox1.Text == "") { Label1.Text = "Passwords do not match. Type them again."; return; } string UserName = Context.User.Identity.Name; HogwartsDatabaseModelDataContext db = new HogwartsDatabaseModelDataContext(); var NeededStu = (from st in db.Students where st.UserName == UserName select st).First(); NeededStu.Password = TextBox1.Text; db.SubmitChanges(); Label1.Text = "Your password has been changed successfully."; }
protected void Button1_Click(object sender, EventArgs e) { int CourseID = Int32.Parse((string)Session["CourseID"]); HogwartsDatabaseModelDataContext db = new HogwartsDatabaseModelDataContext(); foreach (GridViewRow gvr in GridView1.Rows) { DropDownList ddl = (DropDownList)gvr.FindControl("DropDownList1"); int StudentID = Int32.Parse(gvr.Cells[0].Text); string grade = ddl.SelectedValue; var sic = (from s in db.StudentInCourses where s.StudentID == StudentID && s.CourseID == CourseID select s).First(); sic.CourseGPA = grade; db.SubmitChanges(); } db.Connection.Close(); Label1.Text = "Grades have been updated"; }
protected void Page_Load(object sender, EventArgs e) { if (Classes.HogwartsDataAccess.GetRole(Context.User.Identity.Name) == 1) Response.Redirect("~/StaffWorks/StaffHome/StaffProfile.aspx"); HogwartsDatabaseModelDataContext db = new HogwartsDatabaseModelDataContext(); int ArticleID = (int)Session["ArticleID"]; var ar = (from a in db.Articles where ArticleID == a.ArticleID select a).FirstOrDefault(); if (ar == null) { ErrorH.Visible = true; return; } ErrorH.Visible = false; title.InnerText = ar.Title; time.InnerText = ar.DateTime.ToString(); content.InnerHtml = ar.Content; }
protected void Button1_Click(object sender, EventArgs e) { if (TextBox1.Text == "") { Label1.Text = "Title must not be nill"; return; } if (TextBox1.Text.Length>100) { Label1.Text = "Title is too long"; return; } HogwartsDatabaseModelDataContext db = new HogwartsDatabaseModelDataContext(); string username = Context.User.Identity.Name; Staff staff = Classes.HogwartsDataAccess.GetStaff(username); //Insert new article to database Article ar = new Article(); ar.Title = TextBox1.Text; ar.Content = FreeTextBox1.ViewStateText; ar.DateTime = DateTime.Now; ar.StaffID = staff.StaffID; db.Articles.InsertOnSubmit(ar); db.SubmitChanges(); //GET LATEST SUBMITTED ARTICLE ID List<Article> ArticleLst = db.Articles.ToList() ; int UpdateArticleID = 0; for(int i=ArticleLst.Count - 1; i>=0; i--) if(ArticleLst[i].StaffID == ar.StaffID) { UpdateArticleID = ArticleLst[i].ArticleID; break; } Session["ArticleID"] = UpdateArticleID; //NOTICE TO ALL ONLINE STUDENT List<Student> lst = db.Students.ToList(); for(int i=0;i<lst.Count;i++) Classes.TableDataContract.AddNotice(ar.StaffID, lst[i].StudentID, ar.Title, UpdateArticleID, false, false); Response.Redirect("./NewsPage.aspx"); }
protected void Reload() { HogwartsDatabaseModelDataContext db = new HogwartsDatabaseModelDataContext(); var courses = (from course in db.Courses where course.Semester.Time == (string)ViewState["SemesterTime"] && course.Discipline.Department.Name == (string)ViewState["DepartmentName"] select new { course.CourseID, course.Semester.Time, Department = course.Discipline.Department.Name, Discipline = course.Discipline.Name, Teacher = course.Staff.FirstName + " " + course.Staff.LastName, course.AttendeeNumber, course.MaxCapacity }).ToList(); if (courses.Count() == 0) { Label1.Text = "There's no course for this semester"; CourseGeH.Visible = false; SessionGeH.Visible = false; GridView1.Visible = false; GridView2.Visible = false; return; } GridView1.DataSource = courses; GridView1.DataBind(); foreach (GridViewRow gvr in GridView1.Rows) { int CourseID = Int32.Parse(gvr.Cells[0].Text); Course course = HogwartsDataAccess.GetCourse(CourseID); if (course.AttendeeNumber == null) gvr.Cells[7].Text = ""; } List<TempSession> TSessionLst = Utility.CreateNewTempSessionList(db.Sessions.ToList<Session>()); var sessions = (from ts in TSessionLst from c in courses where ts.TempCourseID == c.CourseID select new { CourseID = ts.TempCourseID, SessionID = ts.TempSessionID, ts.Classroom, ts.Weekday, ts.StartingTime, ts.FinishingTime }).ToList(); GridView2.DataSource = sessions; GridView2.DataBind(); Label1.Text = ""; CourseGeH.Visible = true; SessionGeH.Visible = true; GridView1.Visible = true; GridView2.Visible = true; db.Connection.Close(); }
protected void Button2_Click(object sender, EventArgs e) { HogwartsDatabaseModelDataContext db = new HogwartsDatabaseModelDataContext(); int StudentID = (int)Session["StudentID"]; int SemesterID = Classes.HogwartsDataAccess.GetSemesterID(DropDownList1.SelectedValue); var courses = (from sic in db.StudentInCourses where sic.Student.StudentID == StudentID && sic.Course.SemesterID == SemesterID select sic.Course); var sessions = (from c in courses from s in db.Sessions where c.CourseID == s.CourseID select new { Semester = c.Semester.Time, c.CourseID, Discipline = c.Discipline.Name, c.Discipline.CreditNumber, s.SessionID, Weekday = Utility.GetWeekday(s.Weekday), StartingTime = Utility.GetStartingTime(s.StartingPeriod), FinishingTime = Utility.GetFinishingTime(s.StartingPeriod) }); if (sessions.Count() == 0) { Label1.Text = "NO DATA AVAILABLE"; GridView1.Visible = false; Label2.Text = ""; return; } Label1.Text = ""; GridView1.Visible = true; GridView1.DataSource = sessions; GridView1.DataBind(); for (int i = GridView1.Rows.Count-1; i>0 ; i--) { int j = 1; while (i>0 && GridView1.Rows[i].Cells[1].Text == GridView1.Rows[i-1].Cells[1].Text) { GridView1.Rows[i].Cells.RemoveAt(3); GridView1.Rows[i].Cells.RemoveAt(2); GridView1.Rows[i].Cells.RemoveAt(1); i--; j++; } GridView1.Rows[i].Cells[3].RowSpan = j; GridView1.Rows[i].Cells[2].RowSpan = j; GridView1.Rows[i].Cells[1].RowSpan = j; } for (int i = GridView1.Rows.Count - 1; i > 0; i--) GridView1.Rows[i].Cells.RemoveAt(0); GridView1.Rows[0].Cells[0].RowSpan = GridView1.Rows.Count; db.Connection.Close(); int CreditHrs = 0; Course[] CA = courses.ToArray(); for (int i = 0; i < CA.Count(); i++) { bool found = false; for (int j = i + 1; j < CA.Count(); j++) if (CA[i].DisciplineID == CA[j].DisciplineID) { found = true; break; } if (!found) CreditHrs += CA[i].Discipline.CreditNumber; } Label2.Text = "Credit Hours: "+CreditHrs.ToString(); }
protected void Page_Load(object sender, EventArgs e) { if (Classes.HogwartsDataAccess.GetRole(Context.User.Identity.Name) == 1) Response.Redirect("~/StaffWorks/StaffHome/StaffProfile.aspx"); if (!Page.IsPostBack) { HogwartsDatabaseModelDataContext db = new HogwartsDatabaseModelDataContext(); List<Semester> Semesters = (from s in db.Semesters select s).ToList<Semester>(); for (int i = 0; i < Semesters.Count; i++) DropDownList1.Items.Add(Semesters[i].Time); db.Connection.Close(); } }
protected void Button2_Click(object sender, EventArgs e) { RestartGeneration(); HideInfo(); HogwartsDatabaseModelDataContext db = new HogwartsDatabaseModelDataContext(); Dictionary<int, int> D = new Dictionary<int, int>(); foreach (Course c in (List<Course>)Session["CourseLst"]) { int disp1 = c.CourseID; db.Courses.InsertOnSubmit(c); db.SubmitChanges(); int disp2 = c.CourseID; D[disp1] = disp2; } foreach (Session s in (List<Session>)Session["SessionLst"]) { s.CourseID = D[s.CourseID]; db.Sessions.InsertOnSubmit(s); db.SubmitChanges(); } db.Connection.Close(); Response.Redirect("GenerateCourses.aspx"); }
protected void CheckBox1_CheckedChanged(object sender, EventArgs e) { CheckBox cb = (CheckBox)sender; GridViewRow gvr = (GridViewRow)cb.NamingContainer; Label1.Text = ""; int CourseID = Int32.Parse(gvr.Cells[0].Text); int StudentID = (int)Session["StudentID"]; if (cb.Checked) { //Array[7][9] bool[][] AllottedTable = Classes.HogwartsDataAccess.GetStudentAllotedTable((int)Session["SemesterID"], StudentID); List<Session> ls = Classes.HogwartsDataAccess.GetSessions(CourseID); foreach (Session s in ls) { if (AllottedTable[s.Weekday][s.StartingPeriod] || AllottedTable[s.Weekday][s.StartingPeriod + 1]) { Label1.Text = "School time is ovelapped"; cb.Checked = false; return; } } HogwartsDatabaseModelDataContext db = new HogwartsDatabaseModelDataContext(); var course = (from c in db.Courses where c.CourseID == CourseID select c).First(); if (course.AttendeeNumber >= course.MaxCapacity) { Label1.Text = "Course is full"; return; } StudentInCourse sic = new StudentInCourse(); sic.CourseID = CourseID; sic.StudentID = StudentID; db.StudentInCourses.InsertOnSubmit(sic); if (course.AttendeeNumber == null) { course.AttendeeNumber = 1; gvr.Cells[5].Text = "1"; } else { course.AttendeeNumber++; gvr.Cells[5].Text = (Int32.Parse(gvr.Cells[5].Text) + 1).ToString(); } db.SubmitChanges(); db.Connection.Close(); } else { HogwartsDatabaseModelDataContext db = new HogwartsDatabaseModelDataContext(); StudentInCourse sic = (from sc in db.StudentInCourses where sc.CourseID == CourseID && sc.StudentID == StudentID select sc).First(); db.StudentInCourses.DeleteOnSubmit(sic); var course = (from c in db.Courses where c.CourseID == CourseID select c).First(); if (course.AttendeeNumber == 1) { course.AttendeeNumber = null; gvr.Cells[5].Text = ""; } else { course.AttendeeNumber--; gvr.Cells[5].Text = (Int32.Parse(gvr.Cells[5].Text) - 1).ToString(); } db.SubmitChanges(); db.Connection.Close(); } Response.Redirect("AddCourses.aspx"); }
private void ReLoad() { int SemesterID = (int)Session["SemesterID"]; int DepartmentID = (int)Session["DepartmentID"]; HogwartsDatabaseModelDataContext db = new HogwartsDatabaseModelDataContext(); var courses = (from course in db.Courses where course.SemesterID == SemesterID && course.Discipline.DepartmentID == DepartmentID select new { course.CourseID, course.Semester.Time, Department = course.Discipline.Department.Name, Discipline = course.Discipline.Name, Teacher = course.Staff.FirstName + " " + course.Staff.LastName, course.AttendeeNumber, course.MaxCapacity }).ToList(); SemH.InnerText = "semester: " + Classes.HogwartsDataAccess.GetSemester(SemesterID).Time; DeptH.InnerText = "department: " + Classes.HogwartsDataAccess.GetDepartment(DepartmentID); if (courses.Count() == 0) { Label1.Text = "There's no course for this semester"; CourseGeH.Visible = false; SessionGeH.Visible = false; GridView1.Visible = false; GridView2.Visible = false; return; } GridView1.DataSource = courses; GridView1.DataBind(); foreach (GridViewRow gvr in GridView1.Rows) { if (Classes.HogwartsDataAccess.StudentInCourse((int)Session["StudentID"], Int32.Parse(gvr.Cells[0].Text))) { CheckBox cb = (CheckBox)gvr.FindControl("Checkbox1"); cb.Checked = true; } } List<TempSession> TSessionLst = Utility.CreateNewTempSessionList(db.Sessions.ToList<Session>()); var sessions = (from ts in TSessionLst from c in courses where ts.TempCourseID == c.CourseID select new { CourseID = ts.TempCourseID, SessionID = ts.TempSessionID, ts.Classroom, ts.Weekday, ts.StartingTime, ts.FinishingTime }).ToList(); GridView2.DataSource = sessions; GridView2.DataBind(); Label1.Text = ""; CourseGeH.Visible = true; SessionGeH.Visible = true; GridView1.Visible = true; GridView2.Visible = true; db.Connection.Close(); }