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 "; } } }
public DataSet.DsPSMS.ST_TIMETABLE_HEDDataTable isExistTimeHed(DataSet.DsPSMS.ST_TIMETABLE_HEDRow dr) { if (dr == null) { return(null); } try { timedb.Open(); DataSet.DsPSMS.ST_TIMETABLE_HEDDataTable dt = timedb.isExitTimeHedData(dr); if (dt != null && (dt.Rows.Count > 0)) { return(dt); } else { return(null); } } catch { return(null); } finally { timedb.Close(); } }
public bool updateTimeTableHed(DataSet.DsPSMS.ST_TIMETABLE_HEDRow dr, int id, out string msg) { bool isOk = true; if (dr == null) { msg = "data is empty "; return(false); } try { timedb.Open(); int result = timedb.updateTimeTableHed(dr, id); msg = "update complete"; } catch { msg = "error occurs when updating data to ST_TIMETABLE_HED table"; return(false); } finally { timedb.Close(); } return(isOk); }
public bool saveTimetableHedData(DataSet.DsPSMS.ST_TIMETABLE_HEDRow dr, out string msg) { bool isOk = true; if (dr == null) { msg = "data is empty "; return(false); } try { timedb.Open(); int result = timedb.insertTimetableHed(dr); msg = "insert complete"; } catch { msg = "error occurs when inserting data to ST_TIMETABLE_HED table"; return(false); } finally { timedb.Close(); } return(isOk); }
public int updateTimeTableHed(DataSet.DsPSMS.ST_TIMETABLE_HEDRow dr, int id) { int result; if (id == 0) { return(-1); } string query = "UPDATE ST_TIMETABLE_HED SET GRADE_ID='" + dr.GRADE_ID + "',ROOM_TEACHER_ID='" + dr.ROOM_TEACHER_ID + "',ROOM_ID='" + dr.ROOM_ID + "' WHERE TIMETABLE_ID=" + id; string sqlQuery = query; SqlCommand cmd = new SqlCommand(query, conn); result = cmd.ExecuteNonQuery(); return(result); }
protected void btnRoomTeaUpdate_Click(object sender, EventArgs e) { LinkButton btn = (LinkButton)(sender); string timetablrHedId = btn.CommandName; if (timetablrHedId != null) { updateTimeHedId = int.Parse(timetablrHedId); DataSet.DsPSMS.ST_TIMETABLE_HEDRow timetableHed = timeService.getTimetableHedByid(updateTimeHedId); ddlentrygradelist.SelectedIndex = ddlentrygradelist.Items.IndexOf(ddlentrygradelist.Items.FindByValue(timetableHed.GRADE_ID)); ddlentryteacherlist.SelectedIndex = ddlentryteacherlist.Items.IndexOf(ddlentrygradelist.Items.FindByValue(timetableHed.ROOM_TEACHER_ID)); ddlentryclasslist.SelectedIndex = ddlentryclasslist.Items.IndexOf(ddlentrygradelist.Items.FindByValue(timetableHed.ROOM_ID)); btnRoomteaSave.Text = "UPDATE"; } }
public int insertTimetableHed(DataSet.DsPSMS.ST_TIMETABLE_HEDRow dr) { int result; if (dr == null) { return(-1); } int currentYear = DateTime.Now.Year; string query = "INSERT INTO ST_TIMETABLE_HED (EDU_YEAR, ROOM_TEACHER_ID, GRADE_ID,ROOM_ID,DEL_FLG) VALUES (" + currentYear + ",'" + dr.ROOM_TEACHER_ID + "','" + dr.GRADE_ID + "','" + dr.ROOM_ID + "'," + dr.DEL_FLG + ")"; string sqlQuery = query; SqlCommand cmd = new SqlCommand(query, conn); result = cmd.ExecuteNonQuery(); return(result); }
private bool checkAldyRecord(DataSet.DsPSMS.ST_TIMETABLE_HEDRow drr) { bool alreadyExist = false; for (int i = 0; i < gvRoomTeacher.Rows.Count; i++) { DataSet.DsPSMS.ST_TIMETABLE_HEDDataTable result = timeService.isExistTimeHed(drr); if (result != null && result.Rows.Count > 0) { alreadyExist = true; } else { alreadyExist = false; } } return(alreadyExist); }
public DataSet.DsPSMS.ST_TIMETABLE_HEDDataTable isExitTimeHedData(DataSet.DsPSMS.ST_TIMETABLE_HEDRow dr) { if (dr == null) { return(null); } string query = "SELECT * FROM ST_TIMETABLE_HED "; string where = ""; if (dr.GRADE_ID != null) { where += " GRADE_ID = '" + dr.GRADE_ID + "'"; } if (dr.ROOM_ID != null) { if (where.Length > 0) { where += " AND ROOM_ID= '" + dr.ROOM_ID + "'"; } } if (dr.ROOM_TEACHER_ID != null) { if (where.Length > 0) { where += " AND ROOM_TEACHER_ID= '" + dr.ROOM_TEACHER_ID + "'"; } } if (where.Length > 0) { query += " WHERE " + where; } SqlCommand cmd = new SqlCommand(query, conn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet.DsPSMS.ST_TIMETABLE_HEDDataTable dt = new DataSet.DsPSMS.ST_TIMETABLE_HEDDataTable(); da.Fill(dt); return(dt); }