public DataSet.DsPSMS.ST_ROOM_MSTDataTable getAllRoomData(out string msg)
{
DataSet.DsPSMS.ST_ROOM_MSTDataTable result = new DataSet.DsPSMS.ST_ROOM_MSTDataTable();
try
{
timedb.Open();
result = timedb.selectAllRoomData();
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 DataSet.DsPSMS.ST_ROOM_MSTDataTable selectAllRoomData()
{
string query = "SELECT * FROM ST_ROOM_MST ORDER BY ROOM_ID ";
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet.DsPSMS.ST_ROOM_MSTDataTable dt = new DataSet.DsPSMS.ST_ROOM_MSTDataTable();
da.Fill(dt);
return(dt);
}
public void bindClass()
{
msg = "aaa";
ddlstuclasslist.Items.Clear();
DataSet.DsPSMS.ST_ROOM_MSTDataTable rooms = timeService.getAllRoomData(out msg);
ddlstuclasslist.DataSource = rooms;
ddlstuclasslist.DataTextField = "ROOM_NAME";
ddlstuclasslist.DataValueField = "ROOM_ID";
ddlstuclasslist.DataBind();
ddlstuclasslist.Items.Insert(0, new ListItem("Select Class", "0"));
}
public DataSet.DsPSMS.ST_ROOM_MSTRow selectClassByid(int id)
{
//conn.Open();
string query = "SELECT * FROM ST_ROOM_MST WHERE ROOM_ID=" + id;
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet.DsPSMS.ST_ROOM_MSTDataTable dt = new DataSet.DsPSMS.ST_ROOM_MSTDataTable();
da.Fill(dt);
//return single row
return(dt[0]);
}
public DataSet.DsPSMS.ST_ROOM_MSTRow getClassByid(int id)
{
DataSet.DsPSMS.ST_ROOM_MSTRow resultData = new DataSet.DsPSMS.ST_ROOM_MSTDataTable().NewST_ROOM_MSTRow();
resultData = timedb.selectClassByid(id);
return(resultData);
}
