protected void btnSearch_Click(object sender, EventArgs e)
{
if (checkValidation())
{
//errSelectGrade.Visible = false;
//errSelectRoom.Visible = false;
int gradeId = int.Parse(ddlstugradelist.SelectedItem.Value);
int classId = int.Parse(ddlstuclasslist.SelectedItem.Value);
timetablehed = timeService.searchTimeHedBygradeclassid(gradeId, classId);
if (timetablehed != null)
{
DataSet.DsPSMS.ST_TEACHER_DATARow teacher = timeService.getTeacherByid(int.Parse(timetablehed.ROOM_TEACHER_ID));
if (teacher != null)
{
Panelteacher.Visible = true;
lblroomteachname.Text = teacher.TEACHER_NAME;
}
DisplayTimetable(Convert.ToString(timetablehed.TIMETABLE_ID));
}
else
{
Panelteacher.Visible = false;
gvStuTimetable.Visible = false;
lblNodata.Visible = true;
lblNodata.Text = "There is no data ";
}
}
}
private void displayGridData(int reFlag)
{
string month = ddlmonthList.SelectedItem.Value;
DataSet.DsPSMS.ST_SALARYDataTable salarys = salarySerivce.getSalaryByMonthRemark(month, reFlag);
if (salarys != null)
{
gvsalarylist.DataSource = salarys;
((BoundField)gvsalarylist.Columns[0]).DataField = "SALARY_ID";
((BoundField)gvsalarylist.Columns[1]).DataField = "STAFF_ID";
((BoundField)gvsalarylist.Columns[2]).DataField = "SALARY_AMOUNT";
foreach (DataSet.DsPSMS.ST_SALARYRow row in salarys.Rows)
{
if (reFlag == 0 && row.REMARK == 0)
{
DataSet.DsPSMS.ST_TEACHER_DATARow teacher = salarySerivce.getTeacherByid(int.Parse(row.STAFF_ID));
if (teacher != null)
{
row.STAFF_ID = teacher.TEACHER_NAME;
row.SALARY_AMOUNT = teacher.SALARY;
}
}
else
{
DataSet.DsPSMS.ST_STAFF_DATARow staff = salarySerivce.getStaffIdByid(int.Parse(row.STAFF_ID));
if (staff != null)
{
row.STAFF_ID = staff.STAFF_NAME;
row.SALARY_AMOUNT = staff.SALARY;
}
}
}
if (gvsalarylist.Columns.Count < 9)
{
BoundField bfield = new BoundField();
bfield.HeaderText = "SALARY AMOUNT";
bfield.DataField = "SALARY_AMOUNT";
gvsalarylist.Columns.Add(bfield);
}
else
{
((BoundField)gvsalarylist.Columns[8]).DataField = "SALARY_AMOUNT";
}
gvsalarylist.DataBind();
bindSalaryDatatxt(salarys);
}
}
private void DisplayData()
{
DataSet.DsPSMS.ST_TIMETABLEDataTable resultDt = timeService.getAllTimeTableData(out msg);
if (resultDt != null)
{
// MessageBox.Show(msg);
resultDt.Columns.Remove(resultDt.Columns["CRT_DT_TM"]);
resultDt.Columns.Remove(resultDt.Columns["CRT_USER_ID"]);
resultDt.Columns.Remove(resultDt.Columns["UPD_DT_TM"]);
resultDt.Columns.Remove(resultDt.Columns["UPD_USER_ID"]);
resultDt.Columns.Remove(resultDt.Columns["DEL_FLG"]);
foreach (DataSet.DsPSMS.ST_TIMETABLERow row in resultDt.Rows)
{
int gradeId;
string gradevalue = null;
int teacherId;
string teachervalue = null;
if (row.GRADE_ID != null)
{
gradeId = int.Parse(row.GRADE_ID);
DataSet.DsPSMS.ST_GRADE_MSTRow grade = timeService.getGradeByid(gradeId);
gradevalue = grade.GRADE_NAME;
row.GRADE_ID = gradevalue;
}
if (row.TEACHER_ID != null)
{
teacherId = int.Parse(row.TEACHER_ID);
DataSet.DsPSMS.ST_TEACHER_DATARow teacher = timeService.getTeacherByid(teacherId);
teachervalue = teacher.TEACHER_NAME;
row.TEACHER_ID = teachervalue;
}
}
dvtimetable.DataSource = resultDt;
dvtimetable.DataBind();
dvtimetable.HeaderRow.Cells[1].Text = "Year";
dvtimetable.HeaderRow.Cells[2].Text = "ID";
dvtimetable.HeaderRow.Cells[3].Text = "GRADE";
dvtimetable.HeaderRow.Cells[4].Text = "TEACHER";
}
}
public void DisplayRoomTeacher()
{
DataSet.DsPSMS.ST_TIMETABLE_HEDDataTable resultDt = timeService.getAllTimetableHedData(out msg);
if (resultDt != null)
{
foreach (DataSet.DsPSMS.ST_TIMETABLE_HEDRow row in resultDt.Rows)
{
int gradeId;
string gradevalue = null;
int teacherId;
string teachervalue = null;
if (row.GRADE_ID != null)
{
gradeId = int.Parse(row.GRADE_ID);
DataSet.DsPSMS.ST_GRADE_MSTRow grade = timeService.getGradeByid(gradeId);
gradevalue = grade.GRADE_NAME;
row.GRADE_ID = gradevalue;
}
if (row.ROOM_TEACHER_ID != null)
{
teacherId = int.Parse(row.ROOM_TEACHER_ID);
DataSet.DsPSMS.ST_TEACHER_DATARow teacher = timeService.getTeacherByid(teacherId);
teachervalue = teacher.TEACHER_NAME;
row.ROOM_TEACHER_ID = teachervalue;
}
if (row.ROOM_ID != null)
{
int roomId = int.Parse(row.ROOM_ID);
DataSet.DsPSMS.ST_ROOM_MSTRow room = timeService.getClassByid(roomId);
string roomvalue = room.ROOM_NAME;
row.ROOM_ID = roomvalue;
}
}
gvRoomTeacher.DataSource = resultDt;
gvRoomTeacher.DataBind();
}
}
