protected void loadTeacherCourseGradeGrid()
{
courseID = Convert.ToInt32(Request.QueryString["classID"]);
using (var context = new GradebookDataEntities())
{
var gradeDistribution = (from c in context.Courses from g in c.GradeDistributions where c.CourseID == courseID select new { g.GradeID, g.Category, g.Weight }).ToList();
if (gradeDistribution.Any())
{
teacherCourseGradeGrid.DataSource = gradeDistribution;
teacherCourseGradeGrid.DataBind();
}
else
{
var obj = new List <GradeDistribution>();
obj.Add(new GradeDistribution());
// Bind the DataTable which contain a blank row to the GridView
teacherCourseGradeGrid.DataSource = obj;
teacherCourseGradeGrid.DataBind();
int columnsCount = teacherCourseGradeGrid.Columns.Count;
teacherCourseGradeGrid.Rows[0].Cells.Clear(); // clear all the cells in the row
teacherCourseGradeGrid.Rows[0].Cells.Add(new TableCell()); //add a new blank cell
teacherCourseGradeGrid.Rows[0].Cells[0].ColumnSpan = columnsCount; //set the column span to the new added cell
//You can set the styles here
teacherCourseGradeGrid.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center;
teacherCourseGradeGrid.Rows[0].Cells[0].ForeColor = System.Drawing.Color.Red;
teacherCourseGradeGrid.Rows[0].Cells[0].Font.Bold = true;
//set No Results found to the new added cell
teacherCourseGradeGrid.Rows[0].Cells[0].Text = "NO RESULT FOUND!";
}
}
loadTeacherCourseAssignmentGrid();
}
protected void teacherAssignment_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "InsertNew")
{
GridViewRow row = teacherCourseAssignmentGrid.FooterRow;
string description = ((TextBox)teacherCourseAssignmentGrid.FooterRow.FindControl("txtDescription")).Text;
int pp = Convert.ToInt32(((TextBox)teacherCourseAssignmentGrid.FooterRow.FindControl("txtPP")).Text);
DropDownList ddlGrade = row.FindControl("ddlGradeNew") as DropDownList;
int gradeID = Convert.ToInt32(ddlGrade.SelectedValue);
using (var context = new GradebookDataEntities())
{
var result = context.AddAssignment(pp, description, gradeID);
}
loadTeacherCourseAssignmentGrid();
}
if (e.CommandName == "Assign")
{
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow row = teacherCourseAssignmentGrid.Rows[index];
int assignmentID = Convert.ToInt32(teacherCourseAssignmentGrid.DataKeys[index].Value);
using (var context = new GradebookDataEntities())
{
context.Assign(courseID, assignmentID);
loadTeacherStudentGradesGrid();
}
}
}
protected void teacherAssignment_RowDataBound(object sender, GridViewRowEventArgs e)
{
DropDownList ddl = null;
if (e.Row.RowType == DataControlRowType.Footer)
{
ddl = e.Row.FindControl("ddlGradeNew") as DropDownList;
}
if (e.Row.RowType == DataControlRowType.DataRow)
{
ddl = e.Row.FindControl("ddlGrade") as DropDownList;
}
if (ddl != null)
{
using (var context = new GradebookDataEntities())
{
var gradeDistribution = (from c in context.Courses from g in c.GradeDistributions where c.CourseID == courseID select new { g.GradeID, g.Category }).ToList();
ddl.DataSource = gradeDistribution;
ddl.DataTextField = "Category";
ddl.DataValueField = "GradeID";
ddl.DataBind();
ddl.Items.Insert(0, new ListItem(""));
}
/*if (e.Row.RowType == DataControlRowType.DataRow)
* {
* DataRowView drv = e.Row.DataItem as DataRowView;
* ddl.SelectedValue = drv["Category"].ToString();
* }*/
}
}
protected void loadStudentCourseAssignmentGrid()
{
using (var context = new GradebookDataEntities())
{
var query = (from c in context.Courses from grade in c.GradeDistributions from assignment in grade.Assignments where c.CourseID == courseID select new { assignment.Description, assignment.PointsPossible }).ToList();
studentCourseAssignmentGrid.DataSource = query;
studentCourseAssignmentGrid.DataBind();
}
}
protected void loadTeacherCourseStudentGrid()
{
using (var context = new GradebookDataEntities())
{
var query = (from c in context.Courses where c.CourseID == courseID select c.Students).FirstOrDefault();
teacherCourseStudentGrid.DataSource = query;
teacherCourseStudentGrid.DataBind();
}
}
protected void studentCourseGridViewFill()
{
using (var context = new GradebookDataEntities())
{
var l2equery = from s in context.Students where s.Email == email select s.Courses;
var courses = l2equery.FirstOrDefault();
studentCourseGridView.DataSource = courses;
studentCourseGridView.DataBind();
}
}
protected void TermDropDownList_SelectedIndexChanged(object sender, EventArgs e)
{
using (var context = new GradebookDataEntities())
{
var l2equery = from c in context.Courses where c.Year >= DateTime.Now.Year && c.Term == TermDropDownList.SelectedValue select c;
var courses = l2equery.ToList();
CourseNumberDropDownList.DataSource = courses;
CourseNumberDropDownList.DataBind();
}
}
public void fillGrid3()
{
using (var context = new GradebookDataEntities())
{
var l2equery = from s in context.Students where s.Email.Contains(searchStudentsTextBox.Text) select s;
var s1 = l2equery.ToList();
studentGridView.DataSource = s1;
studentGridView.DataBind();
}
}
/*void BindGrid()
* {
* using (var context = new GradebookDataEntities())
* {
* if (context.GradeDistributions.Count() > 0)
* {
* var gradeDistribution = (from c in context.Courses from g in c.GradeDistributions where c.CourseID == courseID select new { g.GradeID, g.Category, g.Weight }).ToList();
*
* teacherCourseGradeGrid.DataSource = gradeDistribution;
* teacherCourseGradeGrid.DataBind();
* }
* else
* {
* var obj = new List<GradeDistribution>();
* obj.Add(new GradeDistribution());
* // Bind the DataTable which contain a blank row to the GridView
* teacherCourseGradeGrid.DataSource = obj;
* teacherCourseGradeGrid.DataBind();
* int columnsCount = teacherCourseGradeGrid.Columns.Count;
* teacherCourseGradeGrid.Rows[0].Cells.Clear();// clear all the cells in the row
* teacherCourseGradeGrid.Rows[0].Cells.Add(new TableCell()); //add a new blank cell
* teacherCourseGradeGrid.Rows[0].Cells[0].ColumnSpan = columnsCount; //set the column span to the new added cell
*
* //You can set the styles here
* teacherCourseGradeGrid.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center;
* teacherCourseGradeGrid.Rows[0].Cells[0].ForeColor = System.Drawing.Color.Red;
* teacherCourseGradeGrid.Rows[0].Cells[0].Font.Bold = true;
* //set No Results found to the new added cell
* teacherCourseGradeGrid.Rows[0].Cells[0].Text = "NO RESULT FOUND!";
* }
* }
* loadTeacherCourseAssignmentGrid();
* }*/
protected void getClassName()
{
string cName;
using (var context = new GradebookDataEntities())
{
var query = (from c in context.Courses where c.CourseID == courseID select c).FirstOrDefault();
cName = query.CourseNumber.ToString();
ClassLabel.Text = cName;
}
}
public void fillCourseGridView()
{
using (var context = new GradebookDataEntities())
{
var l2equery = from s in context.Students where s.Email.Contains(searchStudentsTextBox.Text) select s.Courses;
var courses = l2equery.FirstOrDefault();
courseGridView.DataSource = courses;
courseGridView.DataBind();
}
}
protected void teacherCourseGridViewFill()
{
using (var context = new GradebookDataEntities())
{
var l2equery = from t in context.Teachers where t.Email == email select t.Courses;
var teacherCourses = l2equery.FirstOrDefault();
teacherCourseGridView.DataSource = teacherCourses;
teacherCourseGridView.DataBind();
}
}
public void fillDefault()
{
using (var context = new GradebookDataEntities())
{
var l2equery = from c in context.Courses select c;
var courses = l2equery.ToList();
courseGridView.DataSource = courses;
courseGridView.DataBind();
}
}
protected void studentGridView_SelectedIndexChanged(Object sender, EventArgs e)
{
string email = studentGridView.Rows[studentGridView.SelectedIndex].Cells[0].Text.ToString();
using (var context = new GradebookDataEntities())
{
var l2equery = from s in context.Students where s.Email.Contains(email) select s.Courses;
var courses = l2equery.FirstOrDefault();
courseGridView.DataSource = courses;
courseGridView.DataBind();
}
searchStudentsTextBox.Text = email;
}
protected void initializeStudent()
{
studentCourseDropDown.Items.Clear();
studentCourseDropDown.Items.Add(new ListItem("--Select--", null));
using (var context = new GradebookDataEntities())
{
var query = from c in context.Courses select new { c.CourseID, c.CourseNumber, c.Term, c.Year };
foreach (var course in query)
{
string courseFormat = String.Format("{0,-10}\t{1,-10}\t{2, 10}", course.CourseID, course.CourseNumber, course.Term, course.Year);
studentCourseDropDown.Items.Add(new ListItem(courseFormat, courseFormat));
}
}
}
protected void DeleteGrade(object sender, EventArgs e)
{
LinkButton lnkRemove = (LinkButton)sender;
var rowIndex = ((GridViewRow)((Control)sender).NamingContainer).RowIndex;
int gradeID = Convert.ToInt32(((Label)teacherCourseGradeGrid.Rows[rowIndex].FindControl("lblGradeID")).Text);
using (var context = new GradebookDataEntities())
{
var grade = (from g in context.GradeDistributions where g.GradeID == gradeID select g).FirstOrDefault();
context.GradeDistributions.Attach(grade);
context.GradeDistributions.Remove(grade);
context.SaveChanges();
}
loadTeacherCourseGradeGrid();
}
protected bool checkIfStudent()
{
string studentEmail;
using (var context = new GradebookDataEntities())
{
var query = (from c in context.Courses from s in c.Students where c.CourseID == courseID && s.Email == User.Identity.Name select s.Email);
studentEmail = query.FirstOrDefault();
}
if (studentEmail == null)
{
return(false);
}
return(true);
}
protected void gridSample_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int gradeID = Convert.ToInt32(teacherCourseGradeGrid.DataKeys[e.RowIndex].Value);
using (var context = new GradebookDataEntities())
{
GradeDistribution obj = context.GradeDistributions.First(x => x.GradeID == gradeID);
//context.Assignments.Where(x => x.GradeID == gradeID).Delete();
context.GradeDistributions.Remove(obj);
context.SaveChanges();
//BindGrid();
loadTeacherCourseGradeGrid();
loadTeacherStudentGradesGrid();
}
}
protected void teacherAssignment_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int assignmentID = Convert.ToInt32(teacherCourseAssignmentGrid.DataKeys[e.RowIndex].Value);
using (var context = new GradebookDataEntities())
{
Assignment obj = context.Assignments.First(x => x.AssignmentID == assignmentID);
//Undertake und = context.Undertakes.First(x => x.AssignmentID == assignmentID);
//context.Undertakes.Remove(und);
context.Assignments.Remove(obj);
context.SaveChanges();
loadTeacherCourseAssignmentGrid();
loadTeacherStudentGradesGrid();
}
}
protected void registerStudentCourseButton_Click(object sender, EventArgs e)
{
if (courseID != 0)
{
using (var context = new GradebookDataEntities())
{
Course course = context.Courses.FirstOrDefault(c => c.CourseID == courseID);
Student student = context.Students.FirstOrDefault(s => s.Email == email);
course.Students.Add(student);
context.SaveChanges();
}
}
studentCourseGridViewFill();
}
protected void registerCourseButton_Click(object sender, EventArgs e)
{
using (var context = new GradebookDataEntities())
{
var query = (from t in context.Teachers where t.Email == email select t.TeacherID).FirstOrDefault();
int teacher = Convert.ToInt32(query);
string cNumber = CourseNumber.Text;
string term = termDropDownList.SelectedValue;
int year = Convert.ToInt32(yearDropDownList.SelectedValue);
var result = context.AddClass(cNumber, term, year, CourseDescription.Text, query);
}
teacherCourseGridViewFill();
}
protected void gridSample_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "InsertNew")
{
courseID = Convert.ToInt32(Request.QueryString["classID"]);
string category = ((TextBox)teacherCourseGradeGrid.FooterRow.FindControl("txtCategory")).Text;
decimal weight = Convert.ToDecimal(((TextBox)teacherCourseGradeGrid.FooterRow.FindControl("txtWeight")).Text);
using (var context = new GradebookDataEntities())
{
var result = context.AddGradeDistribution(category, weight, courseID);
}
//BindGrid();
loadTeacherCourseGradeGrid();
}
}
protected bool checkIfTeacher()
{
string teacherEmail;
using (var context = new GradebookDataEntities())
{
var query = (from c in context.Courses where c.CourseID == courseID select c.Teacher).FirstOrDefault();
teacherEmail = query.Email;
}
if (teacherEmail == User.Identity.Name)
{
return(true);
}
else
{
return(false);
}
}
protected void checkRole()
{
using (var context = new GradebookDataEntities())
{
var l2equery = (from s in context.Students where s.Email == email select s).FirstOrDefault();
if (l2equery != null)
{
studentPanel.Visible = true;
teacherPanel.Visible = false;
studentCourseGridViewFill();
}
else
{
teacherPanel.Visible = true;
studentPanel.Visible = false;
teacherCourseGridViewFill();
}
}
}
protected void gridSample_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = teacherCourseGradeGrid.Rows[e.RowIndex];
TextBox txtCategory = row.FindControl("txtCategory") as TextBox;
TextBox txtWeight = row.FindControl("txtWeight") as TextBox;
if (txtCategory != null && txtWeight != null)
{
using (var context = new GradebookDataEntities())
{
int gradeID = Convert.ToInt32(teacherCourseGradeGrid.DataKeys[e.RowIndex].Value);
GradeDistribution obj = context.GradeDistributions.First(x => x.GradeID == gradeID);
obj.Category = txtCategory.Text;
obj.Weight = Convert.ToDecimal(txtWeight.Text);
context.SaveChanges();
teacherCourseGradeGrid.EditIndex = -1;
//BindGrid();
loadTeacherCourseGradeGrid();
}
}
}
protected void loadTeacherCourseAssignmentGrid()
{
using (var context = new GradebookDataEntities())
{
var query = (from c in context.Courses from grade in c.GradeDistributions from assignment in grade.Assignments where c.CourseID == courseID select new { assignment.AssignmentID, assignment.Description, assignment.PointsPossible, grade.Category }).ToList();
if (query.Any())
{
teacherCourseAssignmentGrid.DataSource = query;
teacherCourseAssignmentGrid.DataBind();
teacherCourseAssignmentGrid.Rows[0].Visible = true;
}
else
{
var query2 = from c in context.EmptyTables select c;
teacherCourseAssignmentGrid.DataSource = query2.ToList();
teacherCourseAssignmentGrid.DataBind();
teacherCourseAssignmentGrid.Rows[0].Visible = false;
}
}
loadTeacherStudentGradesGrid();
}
protected void teacherAssignment_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = teacherCourseAssignmentGrid.Rows[e.RowIndex];
TextBox txtDescription = row.FindControl("txtDescription") as TextBox;
TextBox txtPP = row.FindControl("txtPP") as TextBox;
if (txtDescription != null && txtPP != null)
{
using (var context = new GradebookDataEntities())
{
int assignmentID = Convert.ToInt32(teacherCourseAssignmentGrid.DataKeys[e.RowIndex].Value);
Assignment obj = context.Assignments.First(x => x.AssignmentID == assignmentID);
DropDownList ddlGrade = row.FindControl("ddlGrade") as DropDownList;
obj.Description = txtDescription.Text;
obj.PointsPossible = Convert.ToInt32(txtPP.Text);
obj.GradeID = Convert.ToInt32(ddlGrade.SelectedValue);
context.SaveChanges();
teacherCourseAssignmentGrid.EditIndex = -1;
loadTeacherCourseAssignmentGrid();
}
}
}
protected void AddStudentButton_Click(object sender, EventArgs e)
{
if (AddStudentTextBox.Text != "")
{
using (var context = new GradebookDataEntities())
{
Course course = context.Courses.FirstOrDefault(c => c.CourseNumber == CourseNumberDropDownList.SelectedValue);
Student student = context.Students.FirstOrDefault(s => s.Email == AddStudentTextBox.Text);
course.Students.Add(student);
context.SaveChanges();
var l2equery = from s in context.Students where s.Email.Contains(searchStudentsTextBox.Text) select s.Courses;
var courses = l2equery.FirstOrDefault();
courseGridView.DataSource = courses;
courseGridView.DataBind();
}
}
else
{
string email = studentGridView.Rows[studentGridView.SelectedIndex].Cells[0].Text.ToString();;
using (var context = new GradebookDataEntities())
{
Course course = context.Courses.FirstOrDefault(c => c.CourseNumber == CourseNumberDropDownList.SelectedValue);
Student student = context.Students.FirstOrDefault(s => s.Email == email);
course.Students.Add(student);
context.SaveChanges();
var l2equery = from s in context.Students where s.Email.Contains(searchStudentsTextBox.Text) select s.Courses;
var courses = l2equery.FirstOrDefault();
courseGridView.DataSource = courses;
courseGridView.DataBind();
}
}
}
protected void dynamicBoundFields()
{
BoundField bfield = new BoundField();
bfield.HeaderText = "Student ID";
bfield.DataField = "StudentID";
teacherStudentGradesGrid.Columns.Add(bfield);
List <TemplateField> tfields = new List <TemplateField>();
List <string> headers = new List <string>();
List <string> headerText = new List <string>();
using (var context = new GradebookDataEntities())
{
var query = (from x in context.teacherGradesView2(courseID) select x.AssignmentID).Distinct();
foreach (var name in query)
{
headers.Add(name.ToString());
}
var query2 = (from x in context.Assignments from a in context.teacherGradesView2(courseID).Where(a => a.AssignmentID == x.AssignmentID) select x.Description).Distinct();
foreach (var x in query2)
{
headerText.Add(x);
}
}
for (int i = 0; i < headers.Count; i++)
{
tfields.Add(new TemplateField());
}
for (int i = 0; i < tfields.Count; i++)
{
tfields[i].HeaderText = headerText[i];
tfields[i].ItemTemplate = new AddTemplateToGridView(ListItemType.Item, headers[i]);
teacherStudentGradesGrid.Columns.Add(tfields[i]);
}
}
