protected void btnSearch_Click(object sender, EventArgs e)
{
if (checkValidation())
{
//errSelectGrade.Visible = false;
//errSelectRoom.Visible = false;
int gradeId = int.Parse(ddlstugradelist.SelectedItem.Value);
int classId = int.Parse(ddlstuclasslist.SelectedItem.Value);
timetablehed = timeService.searchTimeHedBygradeclassid(gradeId, classId);
if (timetablehed != null)
{
DataSet.DsPSMS.ST_TEACHER_DATARow teacher = timeService.getTeacherByid(int.Parse(timetablehed.ROOM_TEACHER_ID));
if (teacher != null)
{
Panelteacher.Visible = true;
lblroomteachname.Text = teacher.TEACHER_NAME;
}
DisplayTimetable(Convert.ToString(timetablehed.TIMETABLE_ID));
}
else
{
Panelteacher.Visible = false;
gvStuTimetable.Visible = false;
lblNodata.Visible = true;
lblNodata.Text = "There is no data ";
}
}
}
public DataSet.DsPSMS.ST_TIMETABLE_HEDDataTable isExistTimeHed(DataSet.DsPSMS.ST_TIMETABLE_HEDRow dr)
{
if (dr == null)
{
return(null);
}
try
{
timedb.Open();
DataSet.DsPSMS.ST_TIMETABLE_HEDDataTable dt = timedb.isExitTimeHedData(dr);
if (dt != null && (dt.Rows.Count > 0))
{
return(dt);
}
else
{
return(null);
}
}
catch
{
return(null);
}
finally
{
timedb.Close();
}
}
public bool updateTimeTableHed(DataSet.DsPSMS.ST_TIMETABLE_HEDRow dr, int id, out string msg)
{
bool isOk = true;
if (dr == null)
{
msg = "data is empty ";
return(false);
}
try
{
timedb.Open();
int result = timedb.updateTimeTableHed(dr, id);
msg = "update complete";
}
catch
{
msg = "error occurs when updating data to ST_TIMETABLE_HED table";
return(false);
}
finally
{
timedb.Close();
}
return(isOk);
}
public bool saveTimetableHedData(DataSet.DsPSMS.ST_TIMETABLE_HEDRow dr, out string msg)
{
bool isOk = true;
if (dr == null)
{
msg = "data is empty ";
return(false);
}
try
{
timedb.Open();
int result = timedb.insertTimetableHed(dr);
msg = "insert complete";
}
catch
{
msg = "error occurs when inserting data to ST_TIMETABLE_HED table";
return(false);
}
finally
{
timedb.Close();
}
return(isOk);
}
public int updateTimeTableHed(DataSet.DsPSMS.ST_TIMETABLE_HEDRow dr, int id)
{
int result;
if (id == 0)
{
return(-1);
}
string query = "UPDATE ST_TIMETABLE_HED SET GRADE_ID='" + dr.GRADE_ID + "',ROOM_TEACHER_ID='" + dr.ROOM_TEACHER_ID + "',ROOM_ID='" + dr.ROOM_ID + "' WHERE TIMETABLE_ID=" + id;
string sqlQuery = query;
SqlCommand cmd = new SqlCommand(query, conn);
result = cmd.ExecuteNonQuery();
return(result);
}
protected void btnRoomTeaUpdate_Click(object sender, EventArgs e)
{
LinkButton btn = (LinkButton)(sender);
string timetablrHedId = btn.CommandName;
if (timetablrHedId != null)
{
updateTimeHedId = int.Parse(timetablrHedId);
DataSet.DsPSMS.ST_TIMETABLE_HEDRow timetableHed = timeService.getTimetableHedByid(updateTimeHedId);
ddlentrygradelist.SelectedIndex = ddlentrygradelist.Items.IndexOf(ddlentrygradelist.Items.FindByValue(timetableHed.GRADE_ID));
ddlentryteacherlist.SelectedIndex = ddlentryteacherlist.Items.IndexOf(ddlentrygradelist.Items.FindByValue(timetableHed.ROOM_TEACHER_ID));
ddlentryclasslist.SelectedIndex = ddlentryclasslist.Items.IndexOf(ddlentrygradelist.Items.FindByValue(timetableHed.ROOM_ID));
btnRoomteaSave.Text = "UPDATE";
}
}
public int insertTimetableHed(DataSet.DsPSMS.ST_TIMETABLE_HEDRow dr)
{
int result;
if (dr == null)
{
return(-1);
}
int currentYear = DateTime.Now.Year;
string query = "INSERT INTO ST_TIMETABLE_HED (EDU_YEAR, ROOM_TEACHER_ID, GRADE_ID,ROOM_ID,DEL_FLG) VALUES (" + currentYear + ",'" + dr.ROOM_TEACHER_ID + "','" + dr.GRADE_ID + "','" + dr.ROOM_ID + "'," + dr.DEL_FLG + ")";
string sqlQuery = query;
SqlCommand cmd = new SqlCommand(query, conn);
result = cmd.ExecuteNonQuery();
return(result);
}
private bool checkAldyRecord(DataSet.DsPSMS.ST_TIMETABLE_HEDRow drr)
{
bool alreadyExist = false;
for (int i = 0; i < gvRoomTeacher.Rows.Count; i++)
{
DataSet.DsPSMS.ST_TIMETABLE_HEDDataTable result = timeService.isExistTimeHed(drr);
if (result != null && result.Rows.Count > 0)
{
alreadyExist = true;
}
else
{
alreadyExist = false;
}
}
return(alreadyExist);
}
public DataSet.DsPSMS.ST_TIMETABLE_HEDDataTable isExitTimeHedData(DataSet.DsPSMS.ST_TIMETABLE_HEDRow dr)
{
if (dr == null)
{
return(null);
}
string query = "SELECT * FROM ST_TIMETABLE_HED ";
string where = "";
if (dr.GRADE_ID != null)
{
where += " GRADE_ID = '" + dr.GRADE_ID + "'";
}
if (dr.ROOM_ID != null)
{
if (where.Length > 0)
{
where += " AND ROOM_ID= '" + dr.ROOM_ID + "'";
}
}
if (dr.ROOM_TEACHER_ID != null)
{
if (where.Length > 0)
{
where += " AND ROOM_TEACHER_ID= '" + dr.ROOM_TEACHER_ID + "'";
}
}
if (where.Length > 0)
{
query += " WHERE " + where;
}
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet.DsPSMS.ST_TIMETABLE_HEDDataTable dt = new DataSet.DsPSMS.ST_TIMETABLE_HEDDataTable();
da.Fill(dt);
return(dt);
}
