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