public bool saveTimetableDetailData(DataSet.DsPSMS.ST_TIMETABLE_DETAILRow dr, out string msg) { bool isOk = true; if (dr == null) { msg = "data is empty "; return(false); } try { timedb.Open(); int result = timedb.insertTimetableDetail(dr); msg = "insert complete"; } catch { msg = "error occurs when inserting data to ST_TIMETABLE_DETAIL table"; return(false); } finally { timedb.Close(); } return(isOk); }
public bool updateTimeTableDetail(DataSet.DsPSMS.ST_TIMETABLE_DETAILRow dr, int id, out string msg) { bool isOk = true; if (dr == null) { msg = "data is empty "; return(false); } try { timedb.Open(); int result = timedb.updateTimeTableDetail(dr, id); msg = "update complete"; } catch { msg = "error occurs when updating data to ST_TIMETABLE_DETAIL table"; return(false); } finally { timedb.Close(); } return(isOk); }
public int updateTimeTableDetail(DataSet.DsPSMS.ST_TIMETABLE_DETAILRow dr, int id) { int result; if (id == 0) { return(-1); } string query = "UPDATE ST_TIMETABLE_DETAIL SET TIMETABLE_ID='" + dr.TIMETABLE_ID + "',TIMETABLE_TIME='" + dr.TIMETABLE_TIME + "',MONDAY='" + dr.MONDAY + "',TUESDAY='" + dr.TUESDAY + "',WEDNESDAY='" + dr.WEDNESDAY + "',THURSDAY='" + dr.THURSDAY + "',FRIDAY='" + dr.FRIDAY + "' WHERE ID=" + id; string sqlQuery = query; SqlCommand cmd = new SqlCommand(query, conn); result = cmd.ExecuteNonQuery(); return(result); }
public int insertTimetableDetail(DataSet.DsPSMS.ST_TIMETABLE_DETAILRow dr) { int result; if (dr == null) { return(-1); } int currentYear = DateTime.Now.Year; string query = "INSERT INTO ST_TIMETABLE_DETAIL (TIMETABLE_ID, TIMETABLE_TIME,MONDAY,TUESDAY,WEDNESDAY,THURSDAY,FRIDAY,DEL_FLG) VALUES ('" + dr.TIMETABLE_ID + "','" + dr.TIMETABLE_TIME + "','" + dr.MONDAY + "','" + dr.TUESDAY + "','" + dr.WEDNESDAY + "','" + dr.THURSDAY + "','" + dr.FRIDAY + "'," + dr.DEL_FLG + ")"; string sqlQuery = query; SqlCommand cmd = new SqlCommand(query, conn); result = cmd.ExecuteNonQuery(); return(result); }
protected void btnTimeDetailUpdate_Click(object sender, EventArgs e) { LinkButton btn = (LinkButton)(sender); string detailId = btn.CommandName; if (detailId != null) { timeDetailId = int.Parse(detailId); DataSet.DsPSMS.ST_TIMETABLE_DETAILRow timetableDetail = timeService.getTimetableDetailByid(timeDetailId); ddlmonsublist.SelectedIndex = ddlmonsublist.Items.IndexOf(ddlmonsublist.Items.FindByValue(timetableDetail.MONDAY)); ddltuesublist.SelectedIndex = ddltuesublist.Items.IndexOf(ddltuesublist.Items.FindByValue(timetableDetail.TUESDAY)); ddlwedsublist.SelectedIndex = ddlwedsublist.Items.IndexOf(ddlwedsublist.Items.FindByValue(timetableDetail.WEDNESDAY)); ddlthusublist.SelectedIndex = ddlthusublist.Items.IndexOf(ddlthusublist.Items.FindByValue(timetableDetail.THURSDAY)); ddlfrisublist.SelectedIndex = ddlfrisublist.Items.IndexOf(ddlthusublist.Items.FindByValue(timetableDetail.FRIDAY)); btntimedetailAdd.Text = "UPDATE"; } }