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