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