public string insertAcademicCalendar(AcademicCalendarData insertData)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "";
try
{
sql = "Insert Into Academic_Calendar(ACADEMIC_YEAR,SEMESTER,DEGREE_CHAR,NRL_START_DATE,NRL_END_DATE,AD_START_DATE,AD_END_DATE,CH_START_DATE,CH_END_DATE,WT_START_DATE,WT_END_DATE,PP_START_DATE,PP_END_DATE,PPL_START_DATE,PPL_END_DATE,PT_START_DATE,PT_END_DATE,PTL_START_DATE,PTL_END_DATE,PR_START_DATE,PR_END_DATE,PRL_START_DATE,PRL_END_DATE,RE_START_DATE,RE_END_DATE,PS_START_DATE,PS_END_DATE,PSL_START_DATE,PSL_END_DATE) Values('" + insertData.academic_year + "','" + insertData.semester + "','" + insertData.degree + "','" + insertData.nrl_start_date + "','" + insertData.nrl_end_date + "','" + insertData.ad_start_date + "','" + insertData.ad_end_date + "','" + insertData.ch_start_date + "','" + insertData.ch_end_date + "','" + insertData.wt_start_date + "','" + insertData.wt_end_date + "','" + insertData.pp_start_date + "','" + insertData.pp_end_date + "','" + insertData.ppl_start_date + "','" + insertData.ppl_end_date + "','" + insertData.pt_start_date + "','" + insertData.pt_end_date + "','" + insertData.ptl_start_date + "','" + insertData.ptl_end_date + "','" + insertData.pr_start_date + "','" + insertData.pr_end_date + "','" + insertData.prl_start_date + "','" + insertData.prl_end_date + "','" + insertData.re_start_date + "','" + insertData.re_end_date + "','" + insertData.ps_start_date + "','" + insertData.ps_end_date + "','" + insertData.psl_start_date + "','" + insertData.psl_end_date + "')";
oracleObj.InsertCommand = sql;
if (oracleObj.Insert() == 1)
{
response = "OK";
}
}
catch
{
HttpContext.Current.Session["response"] = "Unit Test:AcademicCalendar:insertAcademicCalender" + " ไม่สามารถดำเนินการได้ " + sql;
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(response);
}
public AcademicCalendarData getAcademicCalendar(string academic_year, string semester, string degree_char)
{
AcademicCalendarData calender_data = new AcademicCalendarData();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "";
try
{
sql = "Select * From Academic_Calendar Where ACADEMIC_YEAR='" + academic_year + "' AND SEMESTER='" + semester + "' AND DEGREE_CHAR='" + degree_char + "'";
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
calender_data.academic_year = rowData["ACADEMIC_YEAR"].ToString();
calender_data.semester = rowData["SEMESTER"].ToString();
calender_data.degree = rowData["DEGREE_CHAR"].ToString();
calender_data.nrl_start_date = rowData["NRL_START_DATE"].ToString();
calender_data.nrl_end_date = rowData["NRL_END_DATE"].ToString();
calender_data.ad_start_date = rowData["AD_START_DATE"].ToString();
calender_data.ad_end_date = rowData["AD_END_DATE"].ToString();
calender_data.ch_start_date = rowData["CH_START_DATE"].ToString();
calender_data.ch_end_date = rowData["CH_END_DATE"].ToString();
calender_data.wt_start_date = rowData["WT_START_DATE"].ToString();
calender_data.wt_end_date = rowData["WT_END_DATE"].ToString();
calender_data.pp_start_date = rowData["PP_START_DATE"].ToString();
calender_data.pp_end_date = rowData["PP_END_DATE"].ToString();
calender_data.ppl_start_date = rowData["PPL_START_DATE"].ToString();
calender_data.ppl_end_date = rowData["PPL_END_DATE"].ToString();
calender_data.pt_start_date = rowData["PT_START_DATE"].ToString();
calender_data.pt_end_date = rowData["PT_END_DATE"].ToString();
calender_data.ptl_start_date = rowData["PTL_START_DATE"].ToString();
calender_data.ptl_end_date = rowData["PTL_END_DATE"].ToString();
calender_data.pr_start_date = rowData["PR_START_DATE"].ToString();
calender_data.pr_end_date = rowData["PR_END_DATE"].ToString();
calender_data.prl_start_date = rowData["PRL_START_DATE"].ToString();
calender_data.prl_end_date = rowData["PRL_END_DATE"].ToString();
calender_data.re_start_date = rowData["RE_START_DATE"].ToString();
calender_data.re_end_date = rowData["RE_END_DATE"].ToString();
calender_data.ps_start_date = rowData["PS_START_DATE"].ToString();
calender_data.ps_end_date = rowData["PS_END_DATE"].ToString();
calender_data.psl_start_date = rowData["PSL_START_DATE"].ToString();
calender_data.psl_end_date = rowData["PSL_END_DATE"].ToString();
}
}
catch
{
HttpContext.Current.Session["response"] = "Unit Test:AcademicCalendar:getAcademicCalendar" + " ไม่สามารถดำเนินการได้" + sql;
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(calender_data);
}
