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 NewsFilesData getFiles(string files_id)
{
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From News_Files Where Files_ID ='" + files_id + "'";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
NewsFilesData files_data = new NewsFilesData();
foreach (DataRowView rowData in allData)
{
files_data.News_ID = rowData["NEWS_ID"].ToString();
files_data.Files_ID = rowData["FILES_ID"].ToString();
files_data.Files_Name = rowData["FILES_NAME"].ToString();
files_data.Files_Ext = rowData["FILES_EXT"].ToString();
files_data.Files_Size = Convert.ToDouble(rowData["FILES_SIZE"].ToString());
}
return(files_data);
}
public List <NewsFilesData> getFilesWithNewsID(string news_id)
{
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From News_Files Where News_ID ='" + news_id + "' Order By FILES_ID DESC";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
List <NewsFilesData> files_Data = new List <NewsFilesData>();
foreach (DataRowView rowData in allData)
{
NewsFilesData files_data = new NewsFilesData();
files_data.News_ID = rowData["NEWS_ID"].ToString();
files_data.Files_ID = rowData["FILES_ID"].ToString();
files_data.Files_Name = rowData["FILES_NAME"].ToString();
files_data.Files_Ext = rowData["FILES_EXT"].ToString();
files_data.Files_Size = Convert.ToDouble(rowData["FILES_SIZE"].ToString());
files_Data.Add(files_data);
}
return(files_Data);
}
public string uploadFiles(HttpPostedFile upload_files)
{
string response = "";
int sleeptime = 5000;
string files_id = "";
double file_size = (double)upload_files.InputStream.Length / 1000000;
utility utlObj = new utility();
// ======== Log ========
UserLoginData login_data = (UserLoginData)HttpContext.Current.Session["login_data"];
LogData log_data = new LogData();
log_data.ModuleCode = new LogData().Module_News;
log_data.Username = login_data.User_ID;
// =====================
if (file_size > 0)
{
files_id = utlObj.getNewsID("News_Files", "FILES_ID");
for (int i = 0; i < 10; i++)
{
if (getFiles(files_id).Files_ID != null)
{
System.Threading.Thread.Sleep(sleeptime);
files_id = utlObj.getNewsID("News_Files", "FILES_ID");
sleeptime += 5000;
}
else
{
break;
}
}
string Extension = Path.GetExtension(upload_files.FileName);
string FileName = files_id + Extension;
string FolderPath = ConfigurationManager.AppSettings["NewsUploadFiles"];
string FilePath = HttpContext.Current.Server.MapPath(FolderPath + (FileName));
// ======== Log ========
log_data.Message = "Upload Files with:" + FileName + "," + file_size;
// =====================
try
{
upload_files.SaveAs(FilePath);
// === Log ===
log_data.StatusCode = log_data.LogStatus_SUCCESS;
// ===========
}
catch (Exception e)
{
// === Log ===
log_data.StatusCode = log_data.LogStatus_ERROR;
log_data.Message += " [" + e.ToString() + "]";
// ===========
}
NewsFilesData files_data = new NewsFilesData();
files_data.Files_ID = files_id;
files_data.Files_Name = FileName;
files_data.Files_Ext = Extension;
files_data.Files_Size = file_size;
if (insertFilesData(files_data) == "OK")
{
response = files_id;
}
}
else
{
// === Log ===
log_data.StatusCode = log_data.LogStatus_FAILED;
log_data.Message += " [Size is Zero]";
// ===========
}
new Log().WriteLog(log_data);
return(response);
}
