protected void btnAddTerm_Click(object sender, EventArgs e) { TermYearClassSectionTable termTable = new TermYearClassSectionTable(db); var YCSId = new YearClassSectionTable(db). GetYearClassSectionId(ddlYear.SelectedValue, ddlClass.SelectedValue, ddlSection.SelectedValue); //termTable.RemoveTermByYearClassSection(YCSId); foreach (GridViewRow row in gvAddTerm.Rows) { if ((row.FindControl("cb") as CheckBox).Checked) { var percentage = (row.FindControl("txt") as TextBox).Text; if (string.IsNullOrEmpty(percentage)) { continue; } var termId = (row.FindControl("hf") as HiddenField).Value; bool alreadyExsist = termTable.CheckTermByTermId(termId, YCSId); if (!alreadyExsist) { termTable.AddTermYearClassSection(termId, YCSId.ToString(), percentage); } } } LoadGVTerm(null, null); }
protected void btnAssign_Click(object sender, EventArgs e) { var YCSId = new YearClassSectionTable(db).GetYearClassSectionId(ddlYear.SelectedValue, ddlClass.SelectedValue, ddlSection.SelectedValue); TeacherSubjectTable TSTable = new TeacherSubjectTable(db); TSTable.RemoveTeacherSubject(ddlTeacher.SelectedValue, ddlSubject.SelectedValue, YCSId); var teacherSubjectId = TSTable.AddTeacherSubject(ddlTeacher.SelectedValue, ddlSubject.SelectedValue, YCSId); foreach (GridViewRow row in gvMarkPortions.Rows) { if ((row.FindControl("cbInclude") as CheckBox).Checked) { string strPerrcent; if (string.IsNullOrEmpty(strPerrcent = (row.FindControl("txtPercentage") as TextBox).Text)) { continue; } var portionId = Convert.ToInt32((row.FindControl("hfPortionId") as HiddenField).Value); var percentage = Convert.ToInt32(strPerrcent); db.Execute("addMarkPortion", new Dictionary <string, object>() { { "@TSId", teacherSubjectId }, { "@PId", portionId }, { "@Percentage", percentage } }, true); } } LoadGVDDLExistingSubject(null, null); }
protected void ddlTransact_SelectedIndexChanged(object sender, EventArgs e) { MySQLDatabase db = new MySQLDatabase(); var yearId = new YearTable(db).GetYearId(DateTime.Now.Year); var YCSId = new YearClassSectionTable(db).GetYearClassSectionId(yearId, Convert.ToInt32(ddlClass.SelectedValue), Convert.ToInt32(ddlSection.SelectedValue)); if (ddlTransact.SelectedValue == "1") { db.Execute("addTransactionAccessibility", new Dictionary <string, object>() { { "@Tid", ddlTeacher.SelectedValue }, { "@YCSId", YCSId } }, true); hInfo.InnerText = ddlTeacher.SelectedItem.Text + " now can access class " + ddlClass.SelectedItem.Text + ", section " + ddlSection.SelectedItem.Text; hInfo.Attributes["class"] = "text-success"; hInfo.Visible = true; } else { db.Execute("removeTransactionAccessibility", new Dictionary <string, object>() { { "@TId", ddlTeacher.SelectedValue }, { "@YCSId", YCSId } }, true); hInfo.InnerText = ddlTeacher.SelectedItem.Text + " now cannot access class " + ddlClass.SelectedItem.Text + ", section " + ddlSection.SelectedItem.Text; hInfo.Attributes["class"] = "text-danger"; hInfo.Visible = true; } }
protected void LoadGVDDLExistingSubject(object o, EventArgs e) { if (ddlSection.Items.Count > 0) { var YCSId = new YearClassSectionTable(db).GetYearClassSectionId(ddlYear.SelectedValue, ddlClass.SelectedValue, ddlSection.SelectedValue); gvSubject.Columns[0].Visible = true; var res = new TeacherSubjectTable(db).GetTeacherSubject(YCSId); gvSubject.DataSource = res.Select(x => new { Teacher = x.Teacher.FullName, SubjectId = x.SubjectCode, SubjectName = x.Name, TotalMark = x.TotalMark, TSId = x.TeacherSubjectId }).ToList(); gvSubject.DataBind(); ddlExistingSubject.DataSource = res.Select(x => new TextValuePair { Text = x.Name, Value = x.TeacherSubjectId }).ToList(); ddlExistingSubject.DataBind(); gvSubject.Columns[0].Visible = false; } else { gvSubject.Columns[0].Visible = true; gvSubject.DataSource = new DataTable(); gvSubject.DataBind(); ddlExistingSubject.Items.Clear(); gvSubject.Columns[0].Visible = true; } LoadGVExistingMarkPortion(null, null); }
protected void gvExistingClass_RowDeleting(object sender, GridViewDeleteEventArgs e) { var classId = gvExistingClass.Rows[e.RowIndex].Cells[0].Text; YearClassSectionTable YCSTable = new YearClassSectionTable(db); YCSTable.RemoveClassFromYear(ddlYear.SelectedValue, ddlExistingClass.SelectedValue); LoadGVDDLExistingClass(null, null); }
protected void ddlStudent_SelectedIndexChanged(object sender, EventArgs e) { MySQLDatabase db = new MySQLDatabase(); //ddlToClass.SelectedIndex = ddlClass.SelectedIndex; //ddlToSection.SelectedIndex = ddlSection.SelectedIndex; var value = new YearClassSectionTable(db).GetYearClassSectionId(ddlYear.SelectedValue, ddlClass.SelectedValue, ddlSection.SelectedValue); txtRoll.Text = new StudentYearClassSectionRollTable(db).GetStudentRoll(value, ddlStudent.SelectedValue).ToString(); }
protected void LoadDDLTerm(object sndr, EventArgs e) { var YCSId = new YearClassSectionTable(db).GetYearClassSectionId( new YearTable(db).GetYearId(DateTime.Now.Year).ToString(), ddlClass.SelectedValue, ddlSecion.SelectedValue); ddlTerm.DataSource = new TermYearClassSectionTable(db).GetTermByYearClassSection(YCSId); ddlTerm.DataBind(); }
protected void gvExistingSection_RowDeleting(object sender, GridViewDeleteEventArgs e) { var sectionId = gvExistingSection.Rows[e.RowIndex].Cells[0].Text; // int key=Convert.ToInt32(gvExistingSection.DataKeys[e.RowIndex].Value.ToString()); YearClassSectionTable YCSTable = new YearClassSectionTable(db); YCSTable.RemoveSectionFromYCSId(ddlYear.SelectedValue, ddlExistingClass.SelectedValue, Convert.ToInt32(sectionId)); LoadGVExistingSection(null, null); }
protected void LoadDDLSubject(object sndr, EventArgs e) { var YCSId = new YearClassSectionTable(db).GetYearClassSectionId( new YearTable(db).GetYearId(DateTime.Now.Year).ToString(), ddlClass.SelectedValue, ddlSecion.SelectedValue); ddlSubject.DataSource = new TeacherSubjectTable(db).GetTeacherSubject(User.Identity.Name, YCSId); ddlSubject.DataBind(); }
private void ReloadDDLCanTransact(int yearId) { var YCSId = new YearClassSectionTable(db).GetYearClassSectionId(yearId, Convert.ToInt32(ddlClass.SelectedValue), Convert.ToInt32(ddlSection.SelectedValue)); ddlTransact.SelectedValue = db.Execute( "canTransact", new Dictionary <string, object>() { { "@Tid", Convert.ToInt32(ddlTeacher.SelectedValue) }, { "@YCSId", YCSId } }, true).ToString(); }
protected void BindCheckBoxes(object p1, EventArgs p2) { var YCSId = new YearClassSectionTable(db).GetYearClassSectionId(new YearTable(db).GetYearId(DateTime.Now.Year), ddlClass.SelectedValue, ddlSection.SelectedValue); cbAttendance.DataSource = new TeacherSubjectTable(db).GetStudent(User.Identity.Name, YCSId).Select(x => new TextValuePair { Text = x.ToString(), Value = x.ID }).ToList(); cbAttendance.DataBind(); foreach (ListItem item in cbAttendance.Items) { item.Selected = true; } }
protected void btnAssignSection_Click(object sender, EventArgs e) { YearClassSectionTable YCSTable = new YearClassSectionTable(db); //YCSTable.RemoveClassFromYear(ddlYear.SelectedValue, ddlClass.SelectedValue); foreach (ListItem item in cbSection2.Items) { if (item.Selected) { //If this class is not existed in selected year if (!YCSTable.HasYearClassSection(ddlYear.SelectedValue, ddlExistingClass.SelectedValue, item.Value)) { //If no class exists create a YearClassSection entry YCSTable.AddYearClassSection(ddlYear.SelectedValue, ddlExistingClass.SelectedValue, item.Value); } } } LoadGVExistingSection(null, null); }
protected void LoadGVDDLExistingClass(object obj, EventArgs e) { if (ddlYear.Items.Count > 0) { var res = new YearClassSectionTable(db).GetClassByYear(ddlYear.SelectedValue); gvExistingClass.DataSource = res; gvExistingClass.DataBind(); ddlExistingClass.DataSource = res; ddlExistingClass.DataBind(); } else { gvExistingClass.DataSource = new DataTable(); gvExistingClass.DataBind(); ddlExistingClass.Items.Clear(); } LoadGVExistingSection(null, null); }
protected void LoadGV(object e, EventArgs o) { var YCSId = new YearClassSectionTable(db).GetYearClassSectionId( new YearTable(db).GetYearId(DateTime.Now.Year), ddlClass.SelectedValue, ddlSecion.SelectedValue); var students = new TeacherSubjectTable(db).GetStudent(ddlSubject.SelectedValue); var portions = new MarkPortionTable(db).GetMarkPortion(ddlSubject.SelectedValue); DataTable table = new DataTable(); table.Columns.Add("Student"); table.Columns.Add("StudentId"); foreach (var portion in portions) { table.Columns.Add(portion.Text); table.Columns.Add(portion.Value); } MarkTable markTable = new MarkTable(db); foreach (var student in students) { var row = table.Rows.Add(); foreach (var portion in portions) { var mark = markTable.GetMark(student.RollYearClassSectionId, ddlTerm.SelectedValue, portion.Value); if (mark == null) { row[portion.Text] = "NULL"; row[portion.Value] = portion.Value; } else { row[portion.Text] = mark.Text; row[portion.Value] = mark.Value; } } } }
public SingleValue AddMark(int markPortionId, int studentId, int classId, int sectionId, int termYearClassSectionId, int mark, string teacherId) { MySQLDatabase db = new MySQLDatabase(); var YCSId = new YearClassSectionTable(db).GetYearClassSectionId( new YearTable(db).GetYearId(DateTime.Now.Year), classId, sectionId); var SYCSRId = new StudentYearClassSectionRollTable(db).GetStudentYearClassSectionRollId(YCSId, studentId); return(new SingleValue() { Value = db.QueryValue("addMark", new Dictionary <string, object>() { { "@MPId", markPortionId }, { "@SYCSRId", SYCSRId }, { "@TYCSId", termYearClassSectionId }, { "@mark", mark }, { "@TUId", teacherId } }, true).ToString() }); }
protected void btnSubmint_Click(object obj, EventArgs ea) { //TODO Not checked //TODO add trigger var YCSID = new YearClassSectionTable(db).GetYearClassSectionId(new YearTable(db).GetYearId(DateTime.Now.Year), ddlClass.SelectedValue, ddlSection.SelectedValue); var markPortionId = db.QueryValue("getMarkPortionIdByYCSIdPId", new Dictionary <string, object>() { { "@YCSId", Convert.ToInt32(ViewState["YCSId"]) }, { "@PId", -1 } }, true); foreach (ListItem item in cbAttendance.Items) { db.Execute("addAttendance", new Dictionary <string, object>() { { "@MPId", markPortionId }, { "@SId", item.Value }, { "@isPresent", item.Selected } }, true); } }
protected void LoadDDLStudent(object o, EventArgs e) { MySQLDatabase db = new MySQLDatabase(); int value = new YearClassSectionTable(db).GetYearClassSectionId(ddlYear.SelectedValue, ddlClass.SelectedValue, ddlSection.SelectedValue); ddlStudent.DataSource = db.Query("getStudentByYCSId", new Dictionary <string, object>() { { "@YCSId", value } }, true). Select(x => new TextValuePair { Value = x["studentid"], Text = x["firstname"] + x["lastname"], //Roll = Convert.ToInt32(x["roll"]) }).ToList(); //ddlStudent.DataSource = new StudentYearClassSectionRollTable(db).GetStudents(value); ddlStudent.DataBind(); var value2 = new YearClassSectionTable(db).GetYearClassSectionId(ddlYear.SelectedValue, ddlClass.SelectedValue, ddlSection.SelectedValue); txtRoll.Text = new StudentYearClassSectionRollTable(db).GetStudentRoll(value2, ddlStudent.SelectedValue).ToString(); }
//protected void LoadDDLStudent(object sndr, EventArgs e) { // var YCSId = new YearClassSectionTable(db).GetYearClassSectionId( // new YearTable(db).GetYearId(DateTime.Now.Year), // ddlClass.SelectedValue, // ddlSecion.SelectedValue); // ddlStudent.DataSource = new TeacherSubjectTable(db).GetStudent(User.Identity.Name, YCSId) // .Select(x => new TextValuePair { Text = x.Roll + ". " + x.FullName, Value = x.ID.ToString() }).ToList(); // ddlStudent.DataBind(); // ddlStudent.Items.Insert(0, new ListItem("All", "all")); //} protected void LoadGridView(Object obj, EventArgs e) { var YCSId = new YearClassSectionTable(db).GetYearClassSectionId( new YearTable(db).GetYearId(DateTime.Now.Year), ddlClass.SelectedValue, ddlSecion.SelectedValue); var markTable = new MarkTable(db); var dataSource = markTable.GetMark(ddlSubject.SelectedValue, ddlTerm.SelectedValue); portions = new MarkPortionTable(db).GetMarkPortion(ddlSubject.SelectedValue); var pivotTable = new DataTable(); pivotTable.Columns.Add("Student", typeof(string)); pivotTable.Columns.Add("StudentId", typeof(int)); foreach (var pn in portions) { pivotTable.Columns.Add(pn.Text, typeof(string)); pivotTable.Columns.Add(pn.Text + "id", typeof(string)); } //var students = dataSource.GroupBy(x => x["studentid"]).ToList(); var students = dataSource.GroupBy(x => x.Student.ID).ToList(); List <TextValuePair> studentFromDDL = new List <TextValuePair>(); //List<AspNet.Identity.MySQL.Student> studentFromDDL = new List<AspNet.Identity.MySQL.Student>(); foreach (var item in new TeacherSubjectTable(db).GetStudent(ddlSubject.SelectedValue)) { studentFromDDL.Add(new TextValuePair() { Text = item.ToString(), Value = item.ID.ToString() }); } //if (ddlStudent.SelectedValue == "all") { //} else { // studentFromDDL.Add(new TextValuePair() { Text = ddlStudent.SelectedItem.Text, Value = ddlStudent.SelectedValue }); //} foreach (var student in studentFromDDL) { DataRow newRow = pivotTable.Rows.Add(); newRow["Student"] = student.Text; newRow["StudentId"] = student.Value; //try { // var studentGroup = students.Where(x => x.Key == student.Value).ToList()[0]; // foreach (var row in studentGroup) { // //newRow[row["portionname"]] = row["mark"]; // //newRow[row["portionname"] + "id"] = row["markid"]; // try { // newRow[row.PortionName] = row.Mark; // newRow[row.PortionName + "id"] = row.MarkId; // } catch (Exception) { // newRow[row.PortionName] = "NULL"; // newRow[row.PortionName + "id"] = row.PortionId; // } // } //} catch (Exception ex) { // foreach (var portion in portions) { // newRow[portion.Text] = "NULL"; // newRow[portion.Text + "id"] = portion.Value; // } //} try { var studentGroup = students.Where(x => x.Key == student.Value).ToList()[0]; foreach (var portion in portions) { var studentMark = studentGroup.Where(x => x.PortionName == portion.Text).FirstOrDefault(); if (studentMark == null) { newRow[portion.Text] = "NULL"; newRow[portion.Text + "id"] = portion.Value; } else { newRow[portion.Text] = studentMark.Mark; newRow[portion.Text + "id"] = studentMark.MarkId; } } } catch (Exception) { foreach (var portion in portions) { newRow[portion.Text] = "NULL"; newRow[portion.Text + "id"] = portion.Value; } } } gvMark.Columns.Clear(); TemplateField tfStd = new TemplateField(); tfStd.HeaderText = "Student"; gvMark.Columns.Add(tfStd); foreach (var pn in portions) { TemplateField tf = new TemplateField(); tf.HeaderText = pn.Text; gvMark.Columns.Add(tf); } gvMark.DataSource = pivotTable; gvMark.DataBind(); }