public DataSet.DsPSMS.ST_TIMETABLEDataTable getAllTimeTableData(out string msg) { DataSet.DsPSMS.ST_TIMETABLEDataTable result = new DataSet.DsPSMS.ST_TIMETABLEDataTable(); try { timedb.Open(); result = timedb.selectAllTimetable(); 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); }
private void DisplayDatabydate(string date) { DataSet.DsPSMS.ST_TIMETABLEDataTable resultDt = timeService.getTimetableBydate(date); if (resultDt != null) { resultDt.Columns.Remove(resultDt.Columns["EDU_YEAR"]); 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"]); resultDt.Columns.Remove(resultDt.Columns["TEACHER_ID"]); foreach (DataSet.DsPSMS.ST_TIMETABLERow row in resultDt.Rows) { int gradeId; string gradevalue = 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; } } gvresultlist.DataSource = resultDt; gvresultlist.DataBind(); gvresultlist.HeaderRow.Cells[0].Text = "NO"; gvresultlist.HeaderRow.Cells[1].Text = "GRADE"; } }
public DataSet.DsPSMS.ST_TIMETABLEDataTable selectAllTimetable() { string query = "SELECT * FROM ST_TIMETABLE WHERE DEL_FLG=0 "; SqlCommand cmd = new SqlCommand(query, conn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet.DsPSMS.ST_TIMETABLEDataTable dt = new DataSet.DsPSMS.ST_TIMETABLEDataTable(); da.Fill(dt); return(dt); }
public DataSet.DsPSMS.ST_TIMETABLEDataTable selectTimetableBygradeid(int id) { //conn.Open(); string query = "SELECT * FROM ST_TIMETABLE WHERE GRADE_ID=" + id; SqlCommand cmd = new SqlCommand(query, conn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet.DsPSMS.ST_TIMETABLEDataTable dt = new DataSet.DsPSMS.ST_TIMETABLEDataTable(); da.Fill(dt); return(dt); }
public DataSet.DsPSMS.ST_TIMETABLEDataTable selectTimetableBydate(string date) { //conn.Open(); string query = "SELECT * FROM ST_TIMETABLE WHERE DAY='" + date + "'"; SqlCommand cmd = new SqlCommand(query, conn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet.DsPSMS.ST_TIMETABLEDataTable dt = new DataSet.DsPSMS.ST_TIMETABLEDataTable(); da.Fill(dt); return(dt); }
public DataSet.DsPSMS.ST_TIMETABLERow selectTimetableByid(int id) { conn.Open(); string query = "SELECT * FROM ST_TIMETABLE WHERE ID=" + id; SqlCommand cmd = new SqlCommand(query, conn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet.DsPSMS.ST_TIMETABLEDataTable dt = new DataSet.DsPSMS.ST_TIMETABLEDataTable(); da.Fill(dt); //return single row return(dt[0]); }
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 bool isExist(DataSet.DsPSMS.ST_TIMETABLERow dr, out string msg) { msg = null; DataSet.DsPSMS.ST_TIMETABLERow userData = new DataSet.DsPSMS.ST_TIMETABLEDataTable().NewST_TIMETABLERow(); DataSet.DsPSMS.ST_TIMETABLEDataTable selectedUser = new DataSet.DsPSMS.ST_TIMETABLEDataTable(); bool existFlag = true; //if (dr == null) //{ // msg = "data is empty "; // return false; //} //try //{ // timedb.Open(); // if (dr.DAY != null) // userData.DAY = dr.DAY; // selectedUser = timedb.selectTimetable(userData); // if (selectedUser != null && selectedUser.Rows.Count > 0) // { // msg = "exist user"; // } // else // { // selectedUser = null; // } //} //catch //{ // msg = "error has occure when insert data"; // return false; //} //finally //{ // timedb.Close(); //} return(existFlag); }
public DataSet.DsPSMS.ST_TIMETABLEDataTable getTimetableBygradeid(int id) { DataSet.DsPSMS.ST_TIMETABLEDataTable resultData = timedb.selectTimetableBygradeid(id); return(resultData); }
public DataSet.DsPSMS.ST_TIMETABLEDataTable getTimetableBydate(string date) { DataSet.DsPSMS.ST_TIMETABLEDataTable resultData = timedb.selectTimetableBydate(date); return(resultData); }
public DataSet.DsPSMS.ST_TIMETABLEDataTable getTimetableByidanddate(int id, string date) { DataSet.DsPSMS.ST_TIMETABLEDataTable resultData = timedb.selectTimetableBydateandid(id, date); return(resultData); }
public DataSet.DsPSMS.ST_TIMETABLERow getTimeTableByid(int id) { DataSet.DsPSMS.ST_TIMETABLERow resultData = new DataSet.DsPSMS.ST_TIMETABLEDataTable().NewST_TIMETABLERow(); resultData = timedb.selectTimetableByid(id); return(resultData); }