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