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