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 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 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"); }
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 int InsertCourse(Course course) { HogwartsDatabaseModelDataContext context = new HogwartsDatabaseModelDataContext(ConnectionString); context.Courses.InsertOnSubmit(course); context.SubmitChanges(); context.Connection.Close(); return(course.CourseID); }
public static void DeleteSession(Session session) { HogwartsDatabaseModelDataContext context = new HogwartsDatabaseModelDataContext(ConnectionString); Session outSession = (from s in context.Sessions where s.CourseID == session.CourseID && s.SessionID == session.SessionID select s).FirstOrDefault <Session>(); context.Sessions.DeleteOnSubmit(outSession); context.SubmitChanges(); context.Connection.Close(); }
public static void DeleteCourse(Course course) { HogwartsDatabaseModelDataContext context = new HogwartsDatabaseModelDataContext(ConnectionString); Course outCourse = (from c in context.Courses where c.CourseID == course.CourseID select c).FirstOrDefault <Course>(); context.Courses.DeleteOnSubmit(outCourse); context.SubmitChanges(); context.Connection.Close(); }
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 Button1_Click(object sender, EventArgs e) { Label1.Text = Label2.Text = Label3.Text = Label4.Text = ""; if (TextBox1.Text == "") { Label1.Text = "Field can't be nill"; } if (TextBox2.Text == "") { Label2.Text = "Field can't be nill"; } if (TextBox3.Text == "") { Label3.Text = "Field can't be nill"; } if (TextBox4.Text == "") { Label4.Text = "Field can't be nill"; } if (TextBox1.Text == "" || TextBox2.Text == "" || TextBox3.Text == "" || TextBox4.Text == "") { return; } //update username + password string OldUserName = Context.User.Identity.Name; HogwartsDatabaseModelDataContext db = new HogwartsDatabaseModelDataContext(); var NeededStu = (from st in db.Students where st.UserName == OldUserName select st).First(); StudentRequest sr = new StudentRequest(); sr.StudentID = NeededStu.StudentID; sr.NewFirstName = TextBox1.Text; sr.NewLastName = TextBox2.Text; sr.NewNationality = TextBox3.Text; sr.NewMMailAddress = TextBox4.Text; sr.NewHouseName = DropDownList1.SelectedValue; db.StudentRequests.InsertOnSubmit(sr); db.SubmitChanges(); //NOTICE TO ALL ONLINE STAFF List <Staff> lst = db.Staffs.ToList(); for (int i = 0; i < lst.Count; i++) { Classes.TableDataContract.AddStudentRequest(Classes.HogwartsDataAccess.GetStudentID(Context.User.Identity.Name), lst[i].StaffID, false); } Response.Redirect("./StudentInfo.aspx"); }
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 deleteStudentRequest() { HogwartsDatabaseModelDataContext db = new HogwartsDatabaseModelDataContext(); int StudentID = Convert.ToInt32(GridView1.Rows[0].Cells[0].Text); var Stu = (from stu in db.StudentRequests where stu.StudentID == StudentID select stu).First(); db.StudentRequests.DeleteOnSubmit(Stu); db.SubmitChanges(); GridView1.DataSource = null; GridView1.DataBind(); GridView2.DataSource = null; GridView2.DataBind(); DropDownList1.Items.Remove(Convert.ToString(StudentID)); Button2.Visible = false; Button3.Visible = false; }
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 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 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 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"); }
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"); }