public ActionResult SaveRegist(QuestionCategoryModels item)
{
if (Session.getCurrentUser() == null)
return Redirect("/admin/account/logon");
if (!SercurityServices.HasPermission((int)TypeModule.MODULE_HOIDAP, Session.getCurrentUser().username, TypeAudit.QuestionCategory))
{
return Redirect("/admin/error/error403");
}
QuestionCategoryServices serives = new QuestionCategoryServices();
item.UpdateUsername = "******";
item.UpdateDatetime = DateTime.Now;
int rs = serives.insert(item);
return RedirectToAction("Regist");
}
public int update(QuestionCategoryModels item)
{
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder.Append("UPDATE ");
sqlBuilder.Append("gov_question_category ");
sqlBuilder.Append("SET ");
sqlBuilder.Append("category_name = @1, ");
sqlBuilder.Append("order_number = @2, ");
sqlBuilder.Append("update_username = @3, ");
sqlBuilder.Append("update_datetime = @4, ");
sqlBuilder.Append("description = @6 ");
sqlBuilder.Append("WHERE ");
sqlBuilder.Append("id = @5 ");
this.Sql = sqlBuilder.ToString();
MySqlCommand objCmd = new MySqlCommand(Sql, getConnection());
objCmd.Parameters.AddWithValue("@1", item.Name);
objCmd.Parameters.AddWithValue("@2", item.OrderNumber);
objCmd.Parameters.AddWithValue("@3", item.UpdateUsername);
objCmd.Parameters.AddWithValue("@4", item.UpdateDatetime);
objCmd.Parameters.AddWithValue("@5", item.Id);
objCmd.Parameters.AddWithValue("@6", item.Description);
int rs = objCmd.ExecuteNonQuery();
return rs;
}
public int insert(QuestionCategoryModels item)
{
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder.Append("INSERT ");
sqlBuilder.Append("INTO ");
sqlBuilder.Append("gov_question_category ");
sqlBuilder.Append("( ");
sqlBuilder.Append("category_name, ");
sqlBuilder.Append("order_number, ");
sqlBuilder.Append("update_username, ");
sqlBuilder.Append("update_datetime ");
sqlBuilder.Append(") ");
sqlBuilder.Append("values(");
sqlBuilder.Append("@1, @2, @3, @4");
sqlBuilder.Append(")");
this.Sql = sqlBuilder.ToString();
MySqlCommand objCmd = new MySqlCommand(Sql, getConnection());
objCmd.Parameters.AddWithValue("@1", item.Name);
objCmd.Parameters.AddWithValue("@2", item.OrderNumber);
objCmd.Parameters.AddWithValue("@3", item.UpdateUsername);
objCmd.Parameters.AddWithValue("@4", item.UpdateDatetime);
int rs = objCmd.ExecuteNonQuery();
return rs;
}
public List<QuestionCategoryModels> 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_category gqc ");
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<QuestionCategoryModels> lstDocument = new List<QuestionCategoryModels>();
QuestionCategoryModels item;
while (dataReader.Read())
{
item = new QuestionCategoryModels();
item.Id = Convert.ToInt32(dataReader["id"]);
item.Name = dataReader["category_name"].ToString();
item.OrderNumber = Convert.ToInt32(dataReader["order_number"]);
item.UpdateUsername = dataReader["update_username"].ToString();
item.UpdateDatetime = Convert.ToDateTime(dataReader["update_datetime"]);
item.Description = dataReader["description"].ToString();
lstDocument.Add(item);
}
getConnection().Close();
return lstDocument;
}