public DataSet.DsPSMS.ST_TEACHER_DATADataTable getAllTeacherData(out string msg)
{
DataSet.DsPSMS.ST_TEACHER_DATADataTable result = new DataSet.DsPSMS.ST_TEACHER_DATADataTable();
try
{
salaryDB.Open();
result = salaryDB.selectAllTeacherData();
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
{
salaryDB.Close();
}
return(result);
}
public void bindTeacher()
{
msg = "aaa";
DataSet.DsPSMS.ST_TEACHER_DATADataTable grades = timeService.getAllTeacherData(out msg);
ddlTeacherList.DataSource = grades;
ddlTeacherList.DataTextField = "TEACHER_NAME";
ddlTeacherList.DataValueField = "TEACHER_ID";
ddlTeacherList.DataBind();
}
public DataSet.DsPSMS.ST_TEACHER_DATADataTable selectAllTeacherData()
{
string query = "SELECT * FROM ST_TEACHER_DATA ORDER BY TEACHER_ID";
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet.DsPSMS.ST_TEACHER_DATADataTable dt = new DataSet.DsPSMS.ST_TEACHER_DATADataTable();
da.Fill(dt);
return(dt);
}
public void bindRoomTeacher()
{
msg = "aaa";
ddlentryteacherlist.Items.Clear();
DataSet.DsPSMS.ST_TEACHER_DATADataTable teachers = timeService.getAllTeacherData(out msg);
ddlentryteacherlist.DataSource = teachers;
ddlentryteacherlist.DataTextField = "TEACHER_NAME";
ddlentryteacherlist.DataValueField = "TEACHER_ID";
ddlentryteacherlist.DataBind();
ddlentryteacherlist.Items.Insert(0, new ListItem("Select Teacher", "0"));
}
public DataSet.DsPSMS.ST_TEACHER_DATARow selectTeacherByid(int id)
{
//conn.Open();
string query = "SELECT * FROM ST_TEACHER_DATA WHERE TEACHER_ID=" + id;
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet.DsPSMS.ST_TEACHER_DATADataTable dt = new DataSet.DsPSMS.ST_TEACHER_DATADataTable();
da.Fill(dt);
//return single row
return(dt[0]);
}
private void displayTeacherData()
{
DataSet.DsPSMS.ST_TEACHER_DATADataTable teachers = salarySerivce.getAllTeacherData(out msg);
if (gvsalarylist.Columns.Count == 9)
{
gvsalarylist.Columns.Remove(gvsalarylist.Columns[8]);
}
if (teachers != null)
{
gvsalarylist.DataSource = teachers;
((BoundField)gvsalarylist.Columns[0]).DataField = "TEACHER_ID";
((BoundField)gvsalarylist.Columns[1]).DataField = "TEACHER_NAME";
((BoundField)gvsalarylist.Columns[2]).DataField = "SALARY";
gvsalarylist.DataBind();
}
}
public DataSet.DsPSMS.ST_TEACHER_DATARow getTeacherByid(int id)
{
DataSet.DsPSMS.ST_TEACHER_DATARow resultData = new DataSet.DsPSMS.ST_TEACHER_DATADataTable().NewST_TEACHER_DATARow();
try
{
salaryDB.Open();
resultData = salaryDB.selectTeacherByid(id);
}
catch
{
return(null);
}
finally
{
salaryDB.Close();
}
return(resultData);
}
public DataSet.DsPSMS.ST_TEACHER_DATARow getTeacherByid(int id)
{
DataSet.DsPSMS.ST_TEACHER_DATARow resultData = new DataSet.DsPSMS.ST_TEACHER_DATADataTable().NewST_TEACHER_DATARow();
resultData = timedb.selectTeacherByid(id);
return(resultData);
}
