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); }