public List <RegistrationConfigData> getRegistrationConfig()
{
List <RegistrationConfigData> configData = new List <RegistrationConfigData>();
string sql = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
sql = "select * from registration_config Order By DEGREE_CHAR,SECTION,STUDENT_YEAR_ADMISSION";
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
RegistrationConfigData config_data = new RegistrationConfigData();
config_data.StudentYearAdmission = Convert.ToInt16(rowData["STUDENT_YEAR_ADMISSION"].ToString());
config_data.DegreeChar = rowData["DEGREE_CHAR"].ToString();
config_data.Section = rowData["SECTION"].ToString();
config_data.MinCredit = Convert.ToInt16(rowData["MIN_CREDIT"].ToString());
config_data.MaxCredit = Convert.ToInt16(rowData["MAX_CREDIT"].ToString());
config_data.SummerMinCredit = Convert.ToInt16(rowData["SUMMER_MIN_CREDIT"].ToString());
config_data.SummerMaxCredit = Convert.ToInt16(rowData["SUMMER_MAX_CREDIT"].ToString());
config_data.ProMinCredit = Convert.ToInt16(rowData["PRO_MIN_CREDIT"].ToString());
config_data.ProMaxCredit = Convert.ToInt16(rowData["PRO_MAX_CREDIT"].ToString());
configData.Add(config_data);
}
return(configData);
}
public string updateRegistrationConfig(RegistrationConfigData dataUpdate)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "";
sql = "Update REGISTRATION_CONFIG SET MIN_CREDIT=" + dataUpdate.MinCredit + ",MAX_CREDIT=" + dataUpdate.MaxCredit + ",SUMMER_MIN_CREDIT=" + dataUpdate.SummerMinCredit + ",SUMMER_MAX_CREDIT=" + dataUpdate.SummerMaxCredit + ",PRO_MIN_CREDIT=" + dataUpdate.ProMinCredit + ",PRO_MAX_CREDIT=" + dataUpdate.ProMaxCredit + " Where STUDENT_YEAR_ADMISSION=" + dataUpdate.StudentYearAdmission + " AND DEGREE_CHAR='" + dataUpdate.DegreeChar + "' AND SECTION='" + dataUpdate.Section + "'";
oracleObj.UpdateCommand = sql;
try
{
if (oracleObj.Update() == 1)
{
response = "OK";
}
}
catch (Exception e)
{
// response = e.Message.ToString();
HttpContext.Current.Session["response"] = "Unit Test:RegistrationConfig:updateMaxMinCredit" + " ไม่สามารถดำเนินการได้";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(response);
}
public RegistrationConfigData dupRegistrationConfig(int year_admission, string section, string degree_char)
{
RegistrationConfigData config_data = new RegistrationConfigData();
string sql = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
sql = "select * from registration_config Where student_year_admission = " + year_admission + " And SECTION='" + section + "' And degree_char='" + degree_char + "'";
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
if (allData.Count > 0)
{
DataRowView rowData = allData[0];
config_data.StudentYearAdmission = Convert.ToInt16(rowData["STUDENT_YEAR_ADMISSION"].ToString());
config_data.DegreeChar = rowData["DEGREE_CHAR"].ToString();
config_data.Section = rowData["SECTION"].ToString();
config_data.MinCredit = Convert.ToInt16(rowData["MIN_CREDIT"].ToString());
config_data.MaxCredit = Convert.ToInt16(rowData["MAX_CREDIT"].ToString());
config_data.SummerMinCredit = Convert.ToInt16(rowData["SUMMER_MIN_CREDIT"].ToString());
config_data.SummerMaxCredit = Convert.ToInt16(rowData["SUMMER_MAX_CREDIT"].ToString());
config_data.ProMinCredit = Convert.ToInt16(rowData["PRO_MIN_CREDIT"].ToString());
config_data.ProMaxCredit = Convert.ToInt16(rowData["PRO_MAX_CREDIT"].ToString());
}
return(config_data);
}
public string insertRegistrationConfig(RegistrationConfigData dataInsert)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "";
sql = "Insert Into REGISTRATION_CONFIG(STUDENT_YEAR_ADMISSION,DEGREE_CHAR,MIN_CREDIT,MAX_CREDIT,SUMMER_MIN_CREDIT,SUMMER_MAX_CREDIT,PRO_MIN_CREDIT,PRO_MAX_CREDIT,SECTION) Values('" + dataInsert.StudentYearAdmission + "','" + dataInsert.DegreeChar + "','" + dataInsert.MinCredit + "','" + dataInsert.MaxCredit + "','" + dataInsert.SummerMinCredit + "','" + dataInsert.SummerMaxCredit + "','" + dataInsert.ProMinCredit + "','" + dataInsert.ProMaxCredit + "','" + dataInsert.Section + "')";
oracleObj.InsertCommand = sql;
try
{
if (oracleObj.Insert() == 1)
{
response = "OK";
}
}
catch (Exception e)
{
// response = e.Message.ToString();
HttpContext.Current.Session["response"] = "Unit Test:RegistrationConfig:insertMaxMinCredit" + " ไม่สามารถดำเนินการได้";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(response);
}
