public DataSet.DsPSMS.ST_TIMETABLE_DETAILRow searchTimeDetailByTimeHedId(int id) { DataSet.DsPSMS.ST_TIMETABLE_DETAILRow resultData = new DataSet.DsPSMS.ST_TIMETABLE_DETAILDataTable().NewST_TIMETABLE_DETAILRow(); try { timedb.Open(); resultData = timedb.selectTimeDetailBytimeHedId(id); //if (resultData != null && resultData.Rows.Count > 0) //{ // //msg = resultData.Rows.Count + " user found"; //} //else //{ // resultData = null; // //msg = "user not found"; //} } catch { // msg = "error has occure when insert data"; return(null); } finally { timedb.Close(); } return(resultData); }
public DataSet.DsPSMS.ST_TIMETABLE_DETAILDataTable getAllTimeDetailData(string id, out string msg) { DataSet.DsPSMS.ST_TIMETABLE_DETAILDataTable result = new DataSet.DsPSMS.ST_TIMETABLE_DETAILDataTable(); try { timedb.Open(); result = timedb.selectAllTimeDetail(id); if (result != null && result.Rows.Count > 0) { msg = result.Rows.Count + " user found"; } else { result = null; msg = "user not found"; } } catch { msg = "error has occure when insert data"; return(null); } finally { timedb.Close(); } return(result); }
public void DisplayTimeDetail(string id) { DataSet.DsPSMS.ST_TIMETABLE_DETAILDataTable resultDt = timeService.getAllTimeDetailData(id, out msg); if (resultDt != null) { foreach (DataSet.DsPSMS.ST_TIMETABLE_DETAILRow row in resultDt.Rows) { int subjectId; string subvalue = null; if (row.MONDAY != null) { subjectId = int.Parse(row.MONDAY); DataSet.DsPSMS.ST_SUBJECT_MSTRow subject = timeService.getSubjectByid(subjectId); subvalue = subject.SUBJECT_NAME; row.MONDAY = subvalue; } if (row.TUESDAY != null) { subjectId = int.Parse(row.TUESDAY); DataSet.DsPSMS.ST_SUBJECT_MSTRow subject = timeService.getSubjectByid(subjectId); subvalue = subject.SUBJECT_NAME; row.TUESDAY = subvalue; } if (row.WEDNESDAY != null) { subjectId = int.Parse(row.WEDNESDAY); DataSet.DsPSMS.ST_SUBJECT_MSTRow subject = timeService.getSubjectByid(subjectId); subvalue = subject.SUBJECT_NAME; row.WEDNESDAY = subvalue; } if (row.THURSDAY != null) { subjectId = int.Parse(row.THURSDAY); DataSet.DsPSMS.ST_SUBJECT_MSTRow subject = timeService.getSubjectByid(subjectId); subvalue = subject.SUBJECT_NAME; row.THURSDAY = subvalue; } if (row.FRIDAY != null) { subjectId = int.Parse(row.FRIDAY); DataSet.DsPSMS.ST_SUBJECT_MSTRow subject = timeService.getSubjectByid(subjectId); subvalue = subject.SUBJECT_NAME; row.FRIDAY = subvalue; } } gvtimedetail.DataSource = resultDt; gvtimedetail.DataBind(); } }
public DataSet.DsPSMS.ST_TIMETABLE_DETAILDataTable selectAllTimeDetail(string id) { string query = "SELECT * FROM ST_TIMETABLE_DETAIL WHERE DEL_FLG=0 AND TIMETABLE_ID=" + id; SqlCommand cmd = new SqlCommand(query, conn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet.DsPSMS.ST_TIMETABLE_DETAILDataTable dt = new DataSet.DsPSMS.ST_TIMETABLE_DETAILDataTable(); da.Fill(dt); return(dt); }
public DataSet.DsPSMS.ST_TIMETABLE_DETAILRow selectTimeDetailBytimeHedId(int id) { //conn.Open(); string query = "SELECT * FROM ST_TIMETABLE_DETAIL WHERE TIMETABLE_ID=" + id; SqlCommand cmd = new SqlCommand(query, conn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet.DsPSMS.ST_TIMETABLE_DETAILDataTable dt = new DataSet.DsPSMS.ST_TIMETABLE_DETAILDataTable(); da.Fill(dt); return(dt[0]); }
protected void DisplayTimetable(string timeHedId) { DataSet.DsPSMS.ST_TIMETABLE_DETAILDataTable resultDt = timeService.getAllTimeDetailData(timeHedId, out msg); if (resultDt != null) { gvStuTimetable.Visible = true; lblNodata.Visible = false; foreach (DataSet.DsPSMS.ST_TIMETABLE_DETAILRow row in resultDt.Rows) { int subjectId; string subvalue = null; if (row.MONDAY != null) { subjectId = int.Parse(row.MONDAY); DataSet.DsPSMS.ST_SUBJECT_MSTRow subject = timeService.getSubjectByid(subjectId); subvalue = subject.SUBJECT_NAME; row.MONDAY = subvalue; } if (row.TUESDAY != null) { subjectId = int.Parse(row.TUESDAY); DataSet.DsPSMS.ST_SUBJECT_MSTRow subject = timeService.getSubjectByid(subjectId); subvalue = subject.SUBJECT_NAME; row.TUESDAY = subvalue; } if (row.WEDNESDAY != null) { subjectId = int.Parse(row.WEDNESDAY); DataSet.DsPSMS.ST_SUBJECT_MSTRow subject = timeService.getSubjectByid(subjectId); subvalue = subject.SUBJECT_NAME; row.WEDNESDAY = subvalue; } if (row.THURSDAY != null) { subjectId = int.Parse(row.THURSDAY); DataSet.DsPSMS.ST_SUBJECT_MSTRow subject = timeService.getSubjectByid(subjectId); subvalue = subject.SUBJECT_NAME; row.THURSDAY = subvalue; } if (row.FRIDAY != null) { subjectId = int.Parse(row.FRIDAY); DataSet.DsPSMS.ST_SUBJECT_MSTRow subject = timeService.getSubjectByid(subjectId); subvalue = subject.SUBJECT_NAME; row.FRIDAY = subvalue; } } gvStuTimetable.DataSource = resultDt; gvStuTimetable.DataBind(); } else { Panelteacher.Visible = false; gvStuTimetable.Visible = false; lblNodata.Visible = true; lblNodata.Text = "There is no data "; } }