public string insertFilesData(NewsFilesData dataInsert)
{
string response = "";
utility utlObj = new utility();
Status_Variable status_var = new Status_Variable();
/* เพิ่มข้อมูลไฟล์ */
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "";
sql = "Insert Into NEWS_FILES(FILES_ID,FILES_NAME,FILES_EXT,FILES_SIZE) Values('" + dataInsert.Files_ID + "','" + dataInsert.Files_Name + "','" + dataInsert.Files_Ext + "'," + dataInsert.Files_Size + ")";
oracleObj.InsertCommand = sql;
UserLoginData login_data = (UserLoginData)HttpContext.Current.Session["login_data"];
// ======== Log ========
LogData log_data = new LogData();
log_data.ModuleCode = new LogData().Module_News;
log_data.Username = login_data.User_ID;
log_data.Message = "Add FileData with:" + dataInsert.Files_ID;
// =====================
try
{
if (oracleObj.Insert() == 1)
{
response = "OK";
// === Log ===
log_data.StatusCode = log_data.LogStatus_SUCCESS;
// ===========
}
else
{
// === Log ===
log_data.StatusCode = log_data.LogStatus_FAILED;
// ===========
}
}
catch (Exception e)
{
// === Log ===
log_data.StatusCode = log_data.LogStatus_ERROR;
log_data.Message += " [" + e.ToString() + "]";
// ===========
HttpContext.Current.Session["response"] = "Unit Test:News:insertFilesData" + " ไม่สามารถดำเนินการได้";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
/* ========= */
new Log().WriteLog(log_data);
return(response);
}
public BankData getErrBankData(string payment_id, string payment_date, string payment_time, string degree_char)
{
Status_Variable status_var = new Status_Variable();
BankData bank_data = new BankData();
string TableName = getTableName(degree_char);
string sql = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
sql = "Select * From " + TableName + " Where PAYMENT_ID = '" + payment_id + "' And PAYMENT_DATE='" + payment_date + "' And PAYMENT_TIME = '" + payment_time + "'";
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
DegreeData degree_data = new DegreeData();
bank_data.Amount = rowData["AMOUNT"].ToString().ToCharArray();
bank_data.BankCode = rowData["BANK_CODE"].ToString().ToCharArray();
bankcode_data = bankcodeObj.getBankCode(new string(bank_data.BankCode));
bank_data.Bank_ShortName = bankcode_data.Bank_ShortName;
bank_data.Bank_ThaiName = bankcode_data.Bank_ThaiName;
bank_data.TrancCode = rowData["TRANSACTION_CODE"].ToString().ToCharArray();
bank_data.Student_Name = rowData["STUDENT_NAME"].ToString();
bank_data.Student_ID = rowData["STUDENT_ID"].ToString();
bank_data.Nation_Passport_ID = rowData["NATION_PASSPORT_ID"].ToString();
bank_data.AcademicYear = rowData["ACADEMIC_YEAR"].ToString();
bank_data.Semester = rowData["SEMESTER"].ToString();
bank_data.Paymenty_ID = rowData["PAYMENT_ID"].ToString();
bank_data.Payment_Date = rowData["PAYMENT_DATE"].ToString();
bank_data.Payment_Time = rowData["PAYMENT_TIME"].ToString();
bank_data.ThaiPayment_Date = new utility().getThaiBirthDay(bank_data.Payment_Date);
bank_data.Degree_Level = bank_data.Paymenty_ID.Substring(0, 1);
degree_data = new DegreeAdmission().getDegreeAdmission(bank_data.Degree_Level);
bank_data.Degree_Char = degree_data.Degree_Char;
bank_data.Degree_ThaiName = degree_data.Degree_Thai;
bank_data.DueDate = rowData["DUE_DATE"].ToString();
bank_data.ThaiDueDate = new utility().getThaiBirthDay(bank_data.DueDate);
bank_data.SumDate = rowData["BANK_SUMDATE"].ToString();
bank_data.ThaiSumDate = new utility().getThaiBirthDay(bank_data.SumDate);
bank_data.Status = rowData["STATUS"].ToString();
}
return(bank_data);
}
// V. 1.0.0
public int getNumStudent(string academic_year, string semester, string course_code, int sec_num, int subsec_num, string degree_char)
{
string TableName = getTableName(degree_char);
Status_Variable statusVar = new Status_Variable();
int num = 0;
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From " + TableName + " Where ACADEMIC_YEAR='" + academic_year + "' And SEMESTER='" + semester + "' And COURSE_CODE='" + course_code + "' And SEC_NO=" + sec_num + " And SUBSEC_NO=" + subsec_num + " And (REG_STATUS = '" + statusVar.Complete + "' )";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
num = allData.Count;
return(num);
}
// V. 1.0.0
public List <RegistrationData> getRegistrationByStudentID(string student_id, string degree_char)
{
string TableName = getTableName(degree_char);
Status_Variable statusVar = new Status_Variable();
List <RegistrationData> registrationData = new List <RegistrationData>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From " + TableName + " Where STUDENT_ID = '" + student_id + "' And REG_STATUS != '" + statusVar.Cancel_Registration_Coz_Round + "' Order By COURSE_CODE, SEC_NO, SUBSEC_NO";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
RegistrationData registration_data = new RegistrationData();
registration_data.Academic_Year = rowData["ACADEMIC_YEAR"].ToString();
registration_data.Semester = rowData["SEMESTER"].ToString();
registration_data.Course_Code = rowData["COURSE_CODE"].ToString();
registration_data.Project_Code = rowData["PROJECT_CODE"].ToString();
registration_data.Curr_Code = rowData["CURR_CODE"].ToString();
registration_data.Student_ID = rowData["STUDENT_ID"].ToString();
registration_data.Nation_ID = rowData["NATION_ID"].ToString();
registration_data.Passport_ID = rowData["PASSPORT_ID"].ToString();
registration_data.First_Thainame = rowData["FIRST_THAINAME"].ToString();
registration_data.Family_Thainame = rowData["FAMILY_THAINAME"].ToString();
registration_data.First_Engname = rowData["FIRST_ENGNAME"].ToString();
registration_data.Family_Engname = rowData["FAMILY_ENGNAME"].ToString();
registration_data.Faculty_Code = rowData["FACULITY_CODE"].ToString();
registration_data.Department_Code = rowData["DEPARTMENT_CODE"].ToString();
registration_data.Major_Code = rowData["MAJOR_CODE"].ToString();
registration_data.Spec_Field_Code = rowData["SPEC_FIELD_CODE"].ToString();
registration_data.Reg_Type = rowData["REG_TYPE"].ToString();
registration_data.Credit = Convert.ToInt16(rowData["CREDIT"].ToString());
registration_data.Sec_No = Convert.ToInt16(rowData["SEC_NO"].ToString());
registration_data.SubSec_No = Convert.ToInt16(rowData["SUBSEC_NO"].ToString());
registration_data.Sec_Comment = rowData["SEC_COMMENT"].ToString();
registration_data.Theory_Fee = Convert.ToInt16(rowData["THEORY_FEE"].ToString());
registration_data.Practice_Fee = Convert.ToInt16(rowData["PRACTICE_FEE"].ToString());
registration_data.Thesis_Project_Fee = Convert.ToInt16(rowData["THESIS_PROJ_FEE"].ToString());
registration_data.Course_Type = rowData["COURSE_TYPE"].ToString();
registration_data.Payment_ID = rowData["PAYMENT_ID"].ToString();
registration_data.Registration_Date = rowData["REGISTRATION_DATE"].ToString();
registration_data.Status = rowData["REG_STATUS"].ToString();
registrationData.Add(registration_data);
}
return(registrationData);
}
public List <StudentGroupData> getStudentGroupByDepartment(string department_code, string degree_char)
{
string tableName = getTableName(degree_char);
SystemConfigData system_config = new SystemConfigData();
system_config = new SystemConfig().getConfig();
Status_Variable status_var = new Status_Variable();
List <StudentGroupData> studentGroup = new List <StudentGroupData>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
try
{
string sql = "Select CURR_CODE,STD_CATEGORY_CODE,STD_GROUP_CODE,SECTION_CODE From " + tableName + " Where ACADEMIC_YEAR='" + system_config.AcademicYear + "' AND SEMESTER='" + system_config.Semester + "' AND STD_CATEGORY_CODE!='-' Group By CURR_CODE, STD_CATEGORY_CODE,STD_GROUP_CODE,SECTION_CODE";
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
StudentGroupData student_group = new StudentGroupData();
student_group.curri_code = rowData["CURR_CODE"].ToString();
student_group.std_category = rowData["STD_CATEGORY_CODE"].ToString();
student_group.std_group = rowData["STD_GROUP_CODE"].ToString();
student_group.section = rowData["SECTION_CODE"].ToString();
string curr_department = new Curriculum().getCurriculum(student_group.curri_code).Department_Code;
if (curr_department == department_code)
{
studentGroup.Add(student_group);
}
}
}
catch
{
HttpContext.Current.Session["response"] = "Unit Test:StudentGroup:getStudentGroupByDepartment" + " ไม่สามารถดำเนินการได้";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(studentGroup);
}
// V 1.0.0
public string updateRegistrationStudentID(string academic_year, string semester, string nation_id, string passport_id, string curr_code, string project_code, string student_id, string degree_char)
{
string TableName = getTableName(degree_char);
string response = "";
Status_Variable status_var = new Status_Variable();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.UpdateCommand = "Update " + TableName + " SET STUDENT_ID='" + student_id + "' Where ACADEMIC_YEAR='" + academic_year + "' And SEMESTER='" + semester + "' And NATION_ID='" + nation_id + "' And PASSPORT_ID='" + passport_id + "' And CURR_CODE='" + curr_code + "' And PROJECT_CODE='" + project_code + "' AND STUDENT_ID IS NULL";
try
{
if (oracleObj.Update() == 1)
{
response = "OK";
}
}
catch (Exception e)
{
response = e.Message.ToString();
}
return(response);
}
// V 1.0.0
public string[] insertQualifiedSTD_BankData(BankHead bank_head, List <BankData> bankData)
{
string TableName = "";
string[] response = new string[bankData.Count];
string comp_account = new string(bank_head.CompAccount);
string comp_name = new string(bank_head.CompName).Replace("'", "`");
string summary_date = bank_head.Bank_SummaryDate;
Status_Variable status_var = new Status_Variable();
SystemConfigData system_config = new SystemConfigData();
system_config = new SystemConfig().getConfig();
int i = 0;
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
foreach (BankData field in bankData)
{
TableName = getTableName(field.Degree_Char);
int bank_amount = Convert.ToInt32(new string(field.Amount));
bank_amount = bank_amount / 100;
string regis_type = new Student_Payment().getPayment(field.Paymenty_ID, field.Degree_Char).Reg_Type;
if (regis_type == "NW")
{
oracleObj.InsertCommand = "Insert Into " + TableName + " (PAYMENT_ID,PAYMENT_DATE,COMPANY_AC,COMPANY_NAME,BANK_CODE,BRANCH_CODE,TELLER_NO,NATION_PASSPORT_ID,STUDENT_NAME,ACADEMIC_YEAR,SEMESTER,AMOUNT,KIND_TRANSACTION,TRANSACTION_CODE,DUE_DATE,IMPORT_DATE,STATUS,PAYMENT_TIME,BANK_SUMDATE) Values('" + field.Paymenty_ID + "','" + field.Payment_Date + "','" + comp_account + "','" + comp_name + "','" + new string(field.BankCode) + "','" + new string(field.BranNo) + "','" + new string(field.TellerNo) + "','" + field.Student_ID + "','" + new string(field.CustomerName) + "','" + field.AcademicYear + "','" + field.Semester + "'," + Convert.ToSingle(bank_amount) + ",'" + new string(field.KindTranc) + "','" + new string(field.TrancCode) + "','" + field.DueDate + "','" + field.ImportDate + "','" + field.Status + "','" + new string(field.PayTime) + "','" + summary_date + "')";
}
else
{
oracleObj.InsertCommand = "Insert Into " + TableName + " (PAYMENT_ID,PAYMENT_DATE,COMPANY_AC,COMPANY_NAME,BANK_CODE,BRANCH_CODE,TELLER_NO,STUDENT_ID,STUDENT_NAME,ACADEMIC_YEAR,SEMESTER,AMOUNT,KIND_TRANSACTION,TRANSACTION_CODE,DUE_DATE,IMPORT_DATE,STATUS,PAYMENT_TIME,BANK_SUMDATE) Values('" + field.Paymenty_ID + "','" + field.Payment_Date + "','" + comp_account + "','" + comp_name + "','" + new string(field.BankCode) + "','" + new string(field.BranNo) + "','" + new string(field.TellerNo) + "','" + field.Student_ID + "','" + new string(field.CustomerName) + "','" + field.AcademicYear + "','" + field.Semester + "'," + Convert.ToSingle(bank_amount) + ",'" + new string(field.KindTranc) + "','" + new string(field.TrancCode) + "','" + field.DueDate + "','" + field.ImportDate + "','" + field.Status + "','" + new string(field.PayTime) + "','" + summary_date + "')";
}
try
{
if (oracleObj.Insert() == 1)
{
response[i] = "OK";
// อัพเดทตาราง Payment
if ((field.Status == status_var.BankData_Accurate) || (field.Status == status_var.BankData_Accurate_OverPaid))
{
//นักศึกษาใหม่
if (regis_type == "NW")
{
Qualified_Student_Payment std_payment = new Qualified_Student_Payment();
string res_update = std_payment.updatePayment(field.Paymenty_ID, field.Payment_Date, status_var.QualifiedStudent_PaymentComplete, field.Degree_Char);
// Generate Student_ID
if (res_update == "OK")
{
GenStudentID gen_student_id = new GenStudentID();
PaymentData payment_data = std_payment.getPayment(field.Paymenty_ID, field.Degree_Char);
// List<StudentIDConfigData> configData = new List<StudentIDConfigData>();
Qualified_Student student_data = new Qualified_Student().getQualifiedStudent(payment_data.Academic_Year, payment_data.Semester, payment_data.Nation_ID, payment_data.Passport_ID, payment_data.Curr_Code, payment_data.Round_Paid, field.Degree_Char);
if (payment_data.Reg_Type == "NW")
{
string academic_year = student_data.Year_Admission.Substring(2, 2);
string faculty_code = student_data.Faculty_Code;
string department_code = student_data.Department_Code_StudentID;
string major_code = student_data.Major_Code_StudentID;
string degree_code = student_data.Degree_Admission;
string admission_type = student_data.Admission_Type;
string project_code = student_data.Project_Code;
string new_student_id = gen_student_id.getStudentID(student_data);
if (new_student_id.Length == 13)
{
// Update Student ID ตารางนักศึกษาใหม่
string update_status = new Qualified_Student().updateQualifiedStudent_ID(student_data.Year_Admission, student_data.Semester_Admission, student_data.Nation_ID, student_data.Passport_ID, student_data.Curri_Code, student_data.Round_Paid, new_student_id, field.Degree_Char);
// Update ตารางลงทะเบียน
new Qualified_Student_Registration().updateRegistrationStudentID(system_config.AcademicYear, system_config.Semester, student_data.Nation_ID, student_data.Passport_ID, student_data.Curri_Code, student_data.Project_Code, new_student_id, field.Degree_Char);
// Update ตารางประวัติการลงทะเบียน
new HistoryUpdate().update_HisRegistrationStudentID(system_config.AcademicYear, system_config.Semester, student_data.Nation_ID, student_data.Passport_ID, new_student_id, field.Degree_Char);
// Update ตารางใบชำระเงิน
std_payment.updatePayment_StudentID(field.Paymenty_ID, new_student_id, field.Degree_Char);
}
}
}
}
// นักศึกษาปัจจุบันท์
else
{
Student_Payment std_payment = new Student_Payment();
string res_update = std_payment.updatePayment(field.Paymenty_ID, field.Payment_Date, status_var.PaymentComplete, field.Degree_Char);
}
}
}
}
catch (Exception e)
{
response[i] = e.Message.ToString();
}
i++;
} // end foreach
return(response);
}
public List <BankData> getErrBankData(string academic_year, string semester)
{
Status_Variable status_var = new Status_Variable();
List <BankData> bank_Data = new List <BankData>();
string sql = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
sql = "Select * From BANK_DATA Where ACADEMIC_YEAR = '" + academic_year + "' And SEMESTER='" + semester + "' And STATUS != '" + status_var.BankData_Accurate + "' And STATUS != '" + status_var.BankData_Accurate_OverPaid + "' ";
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
BankData bank_data = new BankData();
DegreeData degree_data = new DegreeData();
bank_data.Amount = rowData["AMOUNT"].ToString().ToCharArray();
bank_data.BankCode = rowData["BANK_CODE"].ToString().ToCharArray();
bankcode_data = bankcodeObj.getBankCode(new string(bank_data.BankCode));
bank_data.Bank_ShortName = bankcode_data.Bank_ShortName;
bank_data.Bank_ThaiName = bankcode_data.Bank_ThaiName;
bank_data.TrancCode = rowData["TRANSACTION_CODE"].ToString().ToCharArray();
bank_data.Student_Name = rowData["STUDENT_NAME"].ToString();
bank_data.Student_ID = rowData["STUDENT_ID"].ToString();
bank_data.Nation_Passport_ID = rowData["NATION_PASSPORT_ID"].ToString();
bank_data.AcademicYear = rowData["ACADEMIC_YEAR"].ToString();
bank_data.Semester = rowData["SEMESTER"].ToString();
bank_data.Paymenty_ID = rowData["PAYMENT_ID"].ToString();
bank_data.Payment_Date = rowData["PAYMENT_DATE"].ToString();
bank_data.Payment_Time = rowData["PAYMENT_TIME"].ToString();
bank_data.ThaiPayment_Date = new utility().getThaiBirthDay(bank_data.Payment_Date);
bank_data.Degree_Level = bank_data.Paymenty_ID.Substring(0, 1);
degree_data = new DegreeAdmission().getDegreeAdmission(bank_data.Degree_Level);
bank_data.Degree_Char = degree_data.Degree_Char;
bank_data.Degree_ThaiName = degree_data.Degree_Thai;
bank_data.DueDate = rowData["DUE_DATE"].ToString();
bank_data.ThaiDueDate = new utility().getThaiBirthDay(bank_data.DueDate);
bank_data.SumDate = rowData["BANK_SUMDATE"].ToString();
bank_data.ThaiSumDate = new utility().getThaiBirthDay(bank_data.SumDate);
bank_data.Status = rowData["STATUS"].ToString();
bank_Data.Add(bank_data);
}
sql = "Select * From GRAD_BANK_DATA Where ACADEMIC_YEAR = '" + academic_year + "' And SEMESTER='" + semester + "' And STATUS != '" + status_var.BankData_Accurate + "'";
oracleObj.SelectCommand = sql;
allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
BankData bank_data = new BankData();
DegreeData degree_data = new DegreeData();
bank_data.Amount = rowData["AMOUNT"].ToString().ToCharArray();
bank_data.BankCode = rowData["BANK_CODE"].ToString().ToCharArray();
bankcode_data = bankcodeObj.getBankCode(new string(bank_data.BankCode));
bank_data.Bank_ShortName = bankcode_data.Bank_ShortName;
bank_data.Bank_ThaiName = bankcode_data.Bank_ThaiName;
bank_data.TrancCode = rowData["TRANSACTION_CODE"].ToString().ToCharArray();
bank_data.Student_Name = rowData["STUDENT_NAME"].ToString();
bank_data.Student_ID = rowData["STUDENT_ID"].ToString();
bank_data.Nation_Passport_ID = rowData["NATION_PASSPORT_ID"].ToString();
bank_data.AcademicYear = rowData["ACADEMIC_YEAR"].ToString();
bank_data.Semester = rowData["SEMESTER"].ToString();
bank_data.Paymenty_ID = rowData["PAYMENT_ID"].ToString();
bank_data.Payment_Date = rowData["PAYMENT_DATE"].ToString();
bank_data.Payment_Time = rowData["PAYMENT_TIME"].ToString();
bank_data.ThaiPayment_Date = new utility().getThaiBirthDay(bank_data.Payment_Date);
bank_data.Degree_Level = bank_data.Paymenty_ID.Substring(0, 1);
degree_data = new DegreeAdmission().getDegreeAdmission(bank_data.Degree_Level);
bank_data.Degree_Char = degree_data.Degree_Char;
bank_data.Degree_ThaiName = degree_data.Degree_Thai;
bank_data.DueDate = rowData["DUE_DATE"].ToString();
bank_data.ThaiDueDate = new utility().getThaiBirthDay(bank_data.DueDate);
bank_data.SumDate = rowData["BANK_SUMDATE"].ToString();
bank_data.ThaiSumDate = new utility().getThaiBirthDay(bank_data.SumDate);
bank_data.Status = rowData["STATUS"].ToString();
bank_Data.Add(bank_data);
}
return(bank_Data);
}
public string insertNews(NewsData dataInsert, FileUpload upload_files)
{
string response = "";
List <string> AllFiles_ID = new List <string>();
utility utlObj = new utility();
Status_Variable status_var = new Status_Variable();
if (upload_files.HasFiles)
{
foreach (HttpPostedFile postedFile in upload_files.PostedFiles)
{
string files_id = "";
files_id = uploadFiles(postedFile);
if (files_id != "")
{
AllFiles_ID.Add(files_id);
}
}
}
else
{
AllFiles_ID.Add("-");
}
if (AllFiles_ID.Count > 0)
{
/* เพิ่มข้อมูลข่าว */
string news_table = "News";
string news_field = "News_ID";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "";
int sleeptime = 5000;
string news_id = utlObj.getNewsID(news_table, news_field);
for (int i = 0; i < 10; i++)
{
if (getNews(news_id).news_id != null)
{
System.Threading.Thread.Sleep(sleeptime);
news_id = utlObj.getNewsID(news_table, news_field);
sleeptime += 5000;
}
else
{
break;
}
}
UserLoginData login_data = (UserLoginData)HttpContext.Current.Session["login_data"];
sql = "Insert Into NEWS(NEWS_ID,NEWS_TOPIC,NEWS_DETAIL,NEWS_TYPE,NEWS_DATETIME,NEWS_POSTBY,NEWS_READ) Values('" + news_id + "','" + dataInsert.news_topic + "','" + dataInsert.news_detail + "','" + dataInsert.news_type + "','" + DateTime.Now.ToString() + "','" + login_data.User_ID + "'," + 0 + ")";
oracleObj.InsertCommand = sql;
// ======== Log ========
LogData log_data = new LogData();
log_data.ModuleCode = new LogData().Module_News;
log_data.Username = login_data.User_ID;
log_data.Message = "Add News with:" + news_id + "," + dataInsert.news_type;
// =====================
try
{
if (oracleObj.Insert() == 1)
{
response = "OK";
// === Log ===
log_data.StatusCode = log_data.LogStatus_SUCCESS;
// ===========
}
else
{
// === Log ===
log_data.StatusCode = log_data.LogStatus_FAILED;
// ===========
}
}
catch (Exception e)
{
// === Log ===
log_data.StatusCode = log_data.LogStatus_ERROR;
log_data.Message += " [" + e.ToString() + "]";
// ===========
response = e.Message.ToString();
HttpContext.Current.Session["response"] = "Unit Test:News:insertNews" + " ไม่สามารถดำเนินการได้";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
/* ========= */
new Log().WriteLog(log_data);
if (response == "OK" && AllFiles_ID.Count > 0)
{
foreach (string files_id in AllFiles_ID)
{
if (files_id != "-")
{
setNewsID_to_FilesData(files_id, news_id);
}
}
}
}
return(response);
}