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