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