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