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 DeleteTask() { UserModel userInfo = SessionExtensionTool.GetObject <UserModel>(HttpContext.Session, "userInfo"); //cud 처리할 때는 트랜잭션 시작해주어야함 using var transaction = _context.Database.BeginTransaction(); string resultCode = "ok"; string query = ""; if (userInfo.author.Equals(_codeMngTool.getCode("AUTHOR", "PROFESSOR"))) { if (!userInfo.author.Equals(_codeMngTool.getCode("AUTHOR", "PROFESSOR"))) { Response.WriteAsync("<script language=\"javascript\">alert('Invalid Author!!');</script>"); Response.WriteAsync("<script language=\"javascript\">window.location=\"/Task/SelectPageListTask\"</script>"); } query = $"DELETE FROM OP_TASK_PRSENTR WHERE TASK_SEQ = @task_id:NUMBER"; // 과제에 딸려 있는 제출 내역들을 먼저 삭제하고 if (_commonDao.Delete(query, Request.Form) <= 0) { resultCode = "false"; } // 과제를 삭제한다. query = "DELETE FROM OP_TASK WHERE TASK_SEQ = @task_id:NUMBER"; } else { query = $"DELETE FROM OP_TASK_PRSENTR WHERE REGISTER = '{userInfo.user_id}' AND TASK_SEQ = @task_id:NUMBER"; } if (_commonDao.Delete(query, Request.Form) <= 0) { resultCode = "false"; } if (resultCode.Equals("false")) { transaction.Rollback(); } else { transaction.Commit(); } return(resultCode); }
public void removeFile(string docId) { string query = "SELECT FILE_ID FROM OP_FILE " + "WHERE DOC_ID='" + docId + "'"; string uploadFolder = System.IO.Directory.GetCurrentDirectory() + @"\wwwroot\upload"; string fName; var willDeleteList = _commonDao.SelectList(query); for (int i = 0; i < willDeleteList.Count; ++i) { if (willDeleteList[i]["FILE_ID"].Equals("")) { continue; } fName = Path.Combine(uploadFolder, willDeleteList[i]["FILE_ID"]); File.Delete(fName); } query = "DELETE FROM OP_FILE" + " WHERE DOC_ID='" + docId + "'"; using var transaction2 = _context.Database.BeginTransaction(); _commonDao.Delete(query); transaction2.Commit(); }
public int Delete() { string query = "DELETE FROM OP_CODE " + "WHERE GROUP_ID=@group_id:NUMBER, " + "OR GROUP_NM=@group_nm:VARCHAR2"; int resultRowCnt = _commonDao.Delete(query); return(resultRowCnt); }
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); }
public IActionResult DeleteData() { using var transaction = _context.Database.BeginTransaction(); string query = "DELETE FROM PERSONS WHERE PERSON_ID = @person_id:NUMBER"; _commonDao.Delete(query, Request.Form); transaction.Commit(); return(Redirect("Index")); }