public string DeleteQNA()
{
UserModel userInfo = SessionExtensionTool.GetObject <UserModel>(HttpContext.Session, "userInfo");
string query = "";
query = "SELECT FILE_ID, A.DOC_ID FROM OP_FILE A "
+ "JOIN OP_BBS B "
+ "ON A.DOC_ID=B.DOC_ID "
+ "AND BBS_ID='" + Request.Form["bbs_id"] + "'";
var removeFiles = _commonDao.SelectList(query);
for (int i = 0; i < removeFiles.Count; ++i)
{
_fileMngTool.removeFile(removeFiles[i]["DOC_ID"]);
}
query = "DELETE FROM OP_BBS WHERE BBS_ID = @bbs_id:NUMBER";
//cud 처리할 때는 트랜잭션 시작해주어야함
using var transaction = _context.Database.BeginTransaction();
string resultCode = "ok";
if (_commonDao.Delete(query, Request.Form) == 0)
{
resultCode = "false";
}
transaction.Commit();
return(resultCode);
}
public string DeleteRecsroom()
{
UserModel userInfo = SessionExtensionTool.GetObject <UserModel>(HttpContext.Session, "userInfo");
if (!userInfo.author.Equals(_codeMngTool.getCode("AUTHOR", "PROFESSOR")))
{
Response.WriteAsync("<script language=\"javascript\">alert('Invalid Author!!');</script>");
Response.WriteAsync("<script language=\"javascript\">window.location=\"/Recsroom/SelectPageListRecsroom\"</script>");
}
string query = "";
query = "SELECT FILE_ID, A.DOC_ID FROM OP_FILE A "
+ "JOIN OP_BBS B "
+ "ON A.DOC_ID=B.DOC_ID "
+ "AND BBS_ID='" + Request.Form["bbs_id"] + "'";
var removeFiles = _commonDao.SelectList(query);
for (int i = 0; i < removeFiles.Count; ++i)
{
_fileMngTool.removeFile(removeFiles[i]["DOC_ID"]);
}
query = "DELETE FROM OP_BBS WHERE BBS_ID = @bbs_id:NUMBER";
//cud 처리할 때는 트랜잭션 시작해주어야함
using var transaction = _context.Database.BeginTransaction();
string resultCode = "ok";
if (_commonDao.Delete(query, Request.Form) == 0)
{
resultCode = "false";
}
transaction.Commit();
return(resultCode);
}