private void BindClassDetails(int classID)
{
string constr = ConfigurationManager.ConnectionStrings["CS414_FasTestConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (con)
{
using (SqlCommand getcmd = new SqlCommand("Get_Class_Details", con))
{
con.Open();
//Get details for the selected class
SqlDataAdapter da = new SqlDataAdapter(getcmd);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.AddWithValue("@pClassID", Convert.ToInt32(classID));
DataSet ds = new DataSet();
da.Fill(ds, "Assignment");
ClassInformation.DataSource = ds.Tables["Assignment"];
ClassInformation.DataBind();
da.Dispose();
con.Close();
}
}
}
ClassStudents.SelectParameters["pClassID"].DefaultValue = classID.ToString();
ClassStudents.DataBind();
StudentsEnrolledgrid.DataBind();
}
public void Fill(int quantityBeds)
{
while (ClassStudents.Count() < quantityBeds)
{
ClassStudents.Add(new ClassStudentDto(StudentDto.StudentFree, false));
}
}
public async Task <ClassStudents> GetClassRegisterByClassIdAsync(int classId)
{
await ClassShouldExistAsync(classId);
var list = await classRegisterRepository.GetAllStudentsByClassAsync(classId);
if (list.Any())
{
// Would normally use a library like AutoMapper for these kinds of mapping operations,
// but this is so simple in this case it was not deemed practical
var students = new List <Student>();
foreach (var classRegister in list)
{
students.Add(new Student
{
StudentId = classRegister.StudentId,
FirstName = classRegister.FirstName,
LastName = classRegister.LastName
});
}
var classStudents = new ClassStudents
{
Class = new Class
{
ClassId = classId,
ClassName = list.First().ClassName
},
Students = students
};
return(classStudents);
}
return(null);
}
protected void GridViewStudents_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
ClassStudents searchStudent = new ClassStudents();
searchStudent.SearchStudent(ddStudentSearch, txStudentSearch, GridViewStudents);
GridViewStudents.PageIndex = e.NewPageIndex;
GridViewStudents.DataBind();
}
protected void GridViewStudentModules_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
ClassStudents loadGradeDetails = new ClassStudents();
loadGradeDetails.LoadStudentGradesToStudentGrade(GridViewStudents, GridViewStudentModules);
GridViewStudentModules.PageIndex = e.NewPageIndex;
GridViewStudentModules.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ClassStudents loadDetails = new ClassStudents();
loadDetails.LoadStudentDetailsToStudentGrade(GridViewStudents);
}
}
protected void btnUpdateStudentSubmit_Click(object sender, EventArgs e)
{
ClassStudents updateStudent = new ClassStudents();
updateStudent.UpdateStudent(this);
string messageString = txUpdateFirstName.Text + " " + txUpdateLastName.Text + " has successfully updated.";
ClientScript.RegisterStartupScript(this.GetType(), "Successful", "alert('" + messageString + "'); window.location='Students.aspx';", true);
}
protected void btnAddStudentSubmit_Click(object sender, EventArgs e)
{
Label lblAddedBy = this.Master.FindControl("lblLoggedInUser") as Label;
ClassStudents addStudent = new ClassStudents();
addStudent.AddNewStudent(this, lblAddedBy, lblAddAlert);
string messageString = txAddFirstName.Text + " " + txAddLastName.Text + " has successfully registered. Student ID is " + txAddStudentId.Text;
ClientScript.RegisterStartupScript(this.GetType(), "Successful", "alert('" + messageString + "'); window.location='Students.aspx';", true);
}
protected void GridViewStudentObtainedGrades_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
Label lblloggedInStudent = this.Master.FindControl("lblLoggedInUser") as Label;
lblloggedInStudent.Text = Session["loggedInUser"].ToString();
ClassStudents loadObtainedGrades = new ClassStudents();
loadObtainedGrades.LoadStudentGradesToStudentGrade(GridViewStudentObtainedGrades, lblloggedInStudent);
GridViewStudentObtainedGrades.PageIndex = e.NewPageIndex;
GridViewStudentObtainedGrades.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["loggedInUser"] == null)
{
Response.Redirect("login.aspx");
}
else
{
Label lblloggedInStudent = this.Master.FindControl("lblLoggedInUser") as Label;
lblloggedInStudent.Text = Session["loggedInUser"].ToString();
ClassStudents loadObtainedGrades = new ClassStudents();
loadObtainedGrades.LoadStudentGradesToStudentGrade(GridViewStudentObtainedGrades, lblloggedInStudent);
loadObtainedGrades.CalculateStudentAverageScore(GridViewStudentObtainedGrades, lblAverageScore);
}
}
public ActionResult Join(int id)
{
int uid = HttpContext.Session.GetInt32("userId").Value;
var r = _context.ClassStudents.Select(x => x).Where(x => x.ClassId == id && x.StudentId == uid).FirstOrDefault();
ClassStudents classStudents = new ClassStudents
{
ClassId = id,
StudentId = uid
};
if (r == null)
{
_context.ClassStudents.Add(classStudents);
_context.SaveChanges();
}
ViewBag.classId = id;
var classname = _context.Class.Select(x => x).Where(x => x.Id == id).FirstOrDefault().Name;
HttpContext.Session.SetString("ClassName", classname);
HttpContext.Session.SetInt32("classid", id);
var messages = from x in _context.Chat
where x.ClassId == id
select x;
var files = from x in _context.FileStorage
where x.ClassId == id
select x;
var cid = from x in _context.Class
where x.Id == id
select x.CreatorId;
JoinViewModel joinViewModel = new JoinViewModel
{
Chats = messages.ToList(),
FileStorages = files.ToList()
,
CreatorId = cid.FirstOrDefault().HasValue ? cid.FirstOrDefault().Value : 0
};
return(View(joinViewModel));
}
protected void btnStudentSearch_Click(object sender, EventArgs e)
{
ClassStudents searchStudent = new ClassStudents();
searchStudent.SearchStudent(ddStudentSearch, txStudentSearch, GridViewStudents);
}
protected void Page_Load(object sender, EventArgs e)
{
ClassStudents generateId = new ClassStudents();
txAddStudentId.Text = generateId.GenerateStudentId();
}
protected void GridViewStudents_SelectedIndexChanged(object sender, EventArgs e)
{
ClassStudents loadGradeDetails = new ClassStudents();
loadGradeDetails.LoadStudentGradesToStudentGrade(GridViewStudents, GridViewStudentModules);
}
