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 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 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); } }
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(); var halls = (from hall in db.Houses select hall.HouseName); DropDownList1.DataSource = halls; DropDownList1.DataBind(); } }
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(); string username = Context.User.Identity.Name; var rec = (from c in db.Students where username == c.UserName select c).First(); Session["StudentID"] = rec.StudentID; Session["StudentName"] = rec.FirstName + " " + rec.LastName; Label2.Text = Classes.HogwartsDataAccess.GetStudentName(rec.StudentID); } }
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) { HogwartsDatabaseModelDataContext db = new HogwartsDatabaseModelDataContext(); Student student = HogwartsDataAccess.GetStudent(UsernameTextBox.Text, PasswordTextBox.Text); if (student == null) { Staff staff = HogwartsDataAccess.GetStaff(UsernameTextBox.Text, PasswordTextBox.Text); if (staff == null) { UsernameTextBox.Text = ""; PasswordTextBox.Text = ""; error.Visible = true; return; } FormsAuthentication.RedirectFromLoginPage(UsernameTextBox.Text,false); Response.Redirect("~/StaffWorks/StaffHome/StaffProfile.aspx"); return; } FormsAuthentication.RedirectFromLoginPage(UsernameTextBox.Text, false); Response.Redirect("~/StudentWorks/StudentHome/StudentProfile.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 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 Page_Load(object sender, EventArgs e) { if (Classes.HogwartsDataAccess.GetRole(Context.User.Identity.Name) == 0) Response.Redirect("~/StudentWorks/StudentHome/StudentProfile.aspx"); if (!IsPostBack) { Button2.Visible = false; Button3.Visible = false; HogwartsDatabaseModelDataContext db = new HogwartsDatabaseModelDataContext(); List<StudentRequest> rec = (from stu in db.StudentRequests select stu).ToList<StudentRequest>(); for (int i = 0; i < rec.Count; i++) DropDownList1.Items.Add(Convert.ToString(rec[i].StudentID)); } }