public ActionResult Regist() { QuestionCategoryServices questionCategoryServices = new QuestionCategoryServices(); questionCategoryServices.addOrderBy("order_number", Constant.ORDER_ASC); List<QuestionCategoryModels> lstQuestionCategory = questionCategoryServices.select(-1, -1); ViewData["lstQuestionCategory"] = lstQuestionCategory; ViewData["questionModel"] = new QuestionModels(); return View(); }
public ActionResult SaveRegist(QuestionModels item, String captcha) { ViewData["questionModel"] = item; if (captcha != null) { string getCaptcha = HttpContext.Session["captcha"].ToString(); if (captcha == getCaptcha) ViewData["captcha"] = "You're right"; else { QuestionCategoryServices questionCategoryServices = new QuestionCategoryServices(); questionCategoryServices.addOrderBy("order_number", Constant.ORDER_ASC); List<QuestionCategoryModels> lstQuestionCategory = questionCategoryServices.select(-1, -1); ViewData["lstQuestionCategory"] = lstQuestionCategory; ViewData["questionModel"] = item; return View("Regist"); } } if (Request.Files.Count > 0) { var fileName = string.Empty; var file = Request.Files[0]; var bytes = new byte[file.ContentLength]; if (bytes.Length > 0) { file.InputStream.Read(bytes, 0, file.ContentLength); item.AttachFileName = fileName = (file.FileName.IndexOf('\\') != -1 ? file.FileName.Substring(file.FileName.LastIndexOf('\\') + 1) : file.FileName); var fileFolder = fileSaveFolder; var fileDir = Server.MapPath("/") + fileFolder; if (!System.IO.Directory.Exists(fileDir)) System.IO.Directory.CreateDirectory(fileDir); var filePath = fileDir + "\\" + fileName.Substring(0, fileName.LastIndexOf(".")) + "_" + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss") + fileName.Substring(fileName.LastIndexOf(".")); System.IO.File.WriteAllBytes(filePath, bytes); item.AttachFilePath = filePath.Replace("\\", "/"); } } item.HiddenFlg = true; item.QuestionDatetime = DateTime.Now; QuestionServices questionServices = new QuestionServices(); questionServices.insert(item); return Redirect("Index"); }
public int insert(QuestionModels item) { StringBuilder sqlBuilder = new StringBuilder(); sqlBuilder.Append("INSERT "); sqlBuilder.Append("INTO "); sqlBuilder.Append("gov_question "); sqlBuilder.Append("( "); sqlBuilder.Append("full_name, "); sqlBuilder.Append("email, "); sqlBuilder.Append("phone, "); sqlBuilder.Append("address, "); sqlBuilder.Append("department, "); sqlBuilder.Append("title, "); sqlBuilder.Append("category_id, "); sqlBuilder.Append("attach_file_name, "); sqlBuilder.Append("attach_file_path, "); sqlBuilder.Append("question_content, "); sqlBuilder.Append("question_datetime, "); sqlBuilder.Append("hidden_flg "); sqlBuilder.Append(") "); sqlBuilder.Append("values("); sqlBuilder.Append("@1, @2, @3, @4, @5, @6, @7, @8, @9, @10, @11, @12"); sqlBuilder.Append(")"); this.Sql = sqlBuilder.ToString(); MySqlCommand objCmd = new MySqlCommand(Sql, getConnection()); objCmd.Parameters.AddWithValue("@1", item.FullName); objCmd.Parameters.AddWithValue("@2", item.Email); objCmd.Parameters.AddWithValue("@3", item.Phone); objCmd.Parameters.AddWithValue("@4", item.Address); objCmd.Parameters.AddWithValue("@5", item.Department); objCmd.Parameters.AddWithValue("@6", item.Title); objCmd.Parameters.AddWithValue("@7", item.CategoryId); objCmd.Parameters.AddWithValue("@8", item.AttachFileName); objCmd.Parameters.AddWithValue("@9", item.AttachFilePath); objCmd.Parameters.AddWithValue("@10", item.QuestionContent); objCmd.Parameters.AddWithValue("@11", item.QuestionDatetime); objCmd.Parameters.AddWithValue("@12", item.HiddenFlg); int rs = objCmd.ExecuteNonQuery(); return rs; }
public int update(QuestionModels item) { StringBuilder sqlBuilder = new StringBuilder(); sqlBuilder.Append("UPDATE "); sqlBuilder.Append("gov_question "); sqlBuilder.Append("SET "); sqlBuilder.Append("full_name = @1, "); sqlBuilder.Append("email = @2, "); sqlBuilder.Append("phone = @3, "); sqlBuilder.Append("address = @4, "); sqlBuilder.Append("department = @5, "); sqlBuilder.Append("title = @6, "); sqlBuilder.Append("category_id = @7, "); sqlBuilder.Append("attach_file_name = @8, "); sqlBuilder.Append("attach_file_path = @9, "); sqlBuilder.Append("question_content = @10, "); sqlBuilder.Append("question_datetime = @11, "); sqlBuilder.Append("hidden_flg = @13 "); sqlBuilder.Append("WHERE "); sqlBuilder.Append("id = @12 "); this.Sql = sqlBuilder.ToString(); MySqlCommand objCmd = new MySqlCommand(Sql, getConnection()); objCmd.Parameters.AddWithValue("@1", item.FullName); objCmd.Parameters.AddWithValue("@2", item.Email); objCmd.Parameters.AddWithValue("@3", item.Phone); objCmd.Parameters.AddWithValue("@4", item.Address); objCmd.Parameters.AddWithValue("@5", item.Department); objCmd.Parameters.AddWithValue("@6", item.Title); objCmd.Parameters.AddWithValue("@7", item.CategoryId); objCmd.Parameters.AddWithValue("@8", item.AttachFileName); objCmd.Parameters.AddWithValue("@9", item.AttachFilePath); objCmd.Parameters.AddWithValue("@10", item.QuestionContent); objCmd.Parameters.AddWithValue("@11", item.QuestionDatetime); objCmd.Parameters.AddWithValue("@13", item.HiddenFlg); objCmd.Parameters.AddWithValue("@12", item.Id); int rs = objCmd.ExecuteNonQuery(); return rs; }
public ActionResult SaveRegist(AnswerModels item) { item.HiddenFlg = false; item.AnswerUsername = "******"; item.AnswerDatetime = DateTime.Now; item.UpdateDatetime = DateTime.Now; item.UpdateUsername = "******"; AnswerServices answerServices = new AnswerServices(); answerServices.insert(item); QuestionServices questionServices = new QuestionServices(); questionServices.Id = item.QuestionId.ToString(); List<QuestionModels> lst = questionServices.select(-1, -1); if(lst != null && lst.Count > 0){ QuestionModels questionInfo = new QuestionModels(); questionInfo = lst.First(); questionInfo.HiddenFlg = false; questionInfo.QuestionDatetime = DateTime.Now; questionServices = new QuestionServices(); questionServices.update(questionInfo); } return Redirect("/admin/question/answer?questionid=" + item.QuestionId.ToString()); }
public List<QuestionModels> select(int page, int limit) { int offset = (page - 1) * limit; StringBuilder sqlBuilder = new StringBuilder(); sqlBuilder.Append("SELECT "); sqlBuilder.Append("* "); sqlBuilder.Append("FROM "); sqlBuilder.Append("gov_question gq"); sqlBuilder.Append(getBaseSQL()); if (page > 0 && limit > 0) { sqlBuilder.Append(" LIMIT @limit "); sqlBuilder.Append(" OFFSET @offset "); } this.Sql = sqlBuilder.ToString(); MySqlCommand objCmd = new MySqlCommand(Sql, getConnection()); if (page > 0 && limit > 0) { objCmd.Parameters.AddWithValue("@limit", limit); objCmd.Parameters.AddWithValue("@offset", offset); } MySqlDataReader dataReader = objCmd.ExecuteReader(); List<QuestionModels> lstDocument = new List<QuestionModels>(); QuestionModels item; while (dataReader.Read()) { item = new QuestionModels(); item.Id = Convert.ToInt32(dataReader["id"]); item.FullName = dataReader["full_name"].ToString(); item.Email = dataReader["email"].ToString(); item.Phone = dataReader["phone"].ToString(); item.Address = dataReader["address"].ToString(); item.Department = dataReader["department"].ToString(); item.Title = dataReader["title"].ToString(); item.CategoryId = Convert.ToInt32(dataReader["category_id"]); item.AttachFileName = dataReader["attach_file_name"].ToString(); item.AttachFilePath = dataReader["attach_file_path"].ToString(); item.QuestionContent = dataReader["question_content"].ToString(); item.QuestionDatetime = Convert.ToDateTime(dataReader["question_datetime"]); item.HiddenFlg = Convert.ToBoolean(dataReader["hidden_flg"]); lstDocument.Add(item); } getConnection().Close(); return lstDocument; }
public ActionResult SaveEdit(QuestionModels item) { QuestionServices serives = new QuestionServices(); int rs = serives.update(item); return Redirect("Index"); }