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