public bool updateTimeTable(DataSet.DsPSMS.ST_TIMETABLERow dr, int id, out string msg)
{
bool isOk = true;
if (dr == null)
{
msg = "data is empty ";
return(false);
}
try
{
timedb.Open();
int result = timedb.updateStuTimeTable(dr, id);
msg = "update complete";
}
catch
{
msg = "error occurs when updating data to ST_TIMETABLE table";
return(false);
}
finally
{
timedb.Close();
}
return(isOk);
}
public DataSet.DsPSMS.ST_TIMETABLEDataTable selectTimetable(DataSet.DsPSMS.ST_TIMETABLERow dr)
{
conn.Open();
string query = "SELECT * FROM ST_TIMETABLE WHERE DAY= '" + dr.DAY + "'";
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 int updateStuTimeTable(DataSet.DsPSMS.ST_TIMETABLERow dr, int id)
{
int result;
if (id == 0)
{
return(-1);
}
string query = "UPDATE ST_TIMETABLE SET GRADE_ID='" + dr.GRADE_ID + "',TEACHER_ID='" + dr.TEACHER_ID + "',DAY='" + dr.DAY + "',PERIOD1='" + dr.PERIOD1 + "',PERIOD2='" + dr.PERIOD2 + "',PERIOD3='" + dr.PERIOD3 + "',PERIOD4='" + dr.PERIOD4 + "',PERIOD5='" + dr.PERIOD5 + "',PERIOD6='" + dr.PERIOD6 + "',PERIOD7='" + dr.PERIOD7 + "' WHERE ID=" + id;
string sqlQuery = query;
SqlCommand cmd = new SqlCommand(query, conn);
result = cmd.ExecuteNonQuery();
return(result);
}
public int insertStuTimeTable(DataSet.DsPSMS.ST_TIMETABLERow dr)
{
int result;
if (dr == null)
{
return(-1);
}
int currentYear = DateTime.Now.Year;
string query = "INSERT INTO ST_TIMETABLE (EDU_YEAR, GRADE_ID, TEACHER_ID,DAY,PERIOD1,PERIOD2,PERIOD3,PERIOD4,PERIOD5,PERIOD6,PERIOD7,DEL_FLG) VALUES (" + currentYear + ",'" + dr.GRADE_ID + "','" + dr.TEACHER_ID + "','" + dr.DAY + "','" + dr.PERIOD1 + "','" + dr.PERIOD2 + "','" + dr.PERIOD3 + "','" + dr.PERIOD4 + "','" + dr.PERIOD5 + "','" + dr.PERIOD6 + "','" + dr.PERIOD7 + "'," + dr.DEL_FLG + ")";
string sqlQuery = query;
SqlCommand cmd = new SqlCommand(query, conn);
result = cmd.ExecuteNonQuery();
return(result);
}
protected void Edit(object sender, GridViewSelectEventArgs e)
{
updateId = int.Parse(dvtimetable.DataKeys[e.NewSelectedIndex].Value.ToString());
DataSet.DsPSMS.ST_TIMETABLERow timetable = timeService.getTimeTableByid(updateId);
if (timetable != null)
{
delFlag = (int)timetable.DEL_FLG;
txttimetabledate.Text = timetable.DAY;
ddltimegradelist.SelectedIndex = int.Parse(timetable.GRADE_ID);
ddlTeacherList.SelectedIndex = int.Parse(timetable.TEACHER_ID);
ddlclass1.SelectedIndex = checkClassIndex(timetable.PERIOD1);
ddlclass2.SelectedIndex = checkClassIndex(timetable.PERIOD2);
ddlclass3.SelectedIndex = checkClassIndex(timetable.PERIOD3);
ddlclass4.SelectedIndex = checkClassIndex(timetable.PERIOD4);
ddlclass5.SelectedIndex = checkClassIndex(timetable.PERIOD5);
ddlclass6.SelectedIndex = checkClassIndex(timetable.PERIOD6);
ddlclass7.SelectedIndex = checkClassIndex(timetable.PERIOD7);
Button1.Visible = false;
btnUpdate.Visible = true;
}
}
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);
}
