public ActionResult SaveQuestion(BEQuestion oQuestion) { int intRes = 0; //OBjeto a Registrar BRQuestion obrQuestion = new BRQuestion(); intRes = obrQuestion.SaveQuestion(oQuestion); if (intRes > 0) return Json(new { idQuestion = intRes }); else return Json(new { success = false }); }
public int SaveQuestion(SqlConnection con, BEQuestion oQuestion) { using (con) { SqlCommand cmd = new SqlCommand("SPI_SaveQuestion", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter parm = new SqlParameter("@idQuestion", SqlDbType.Int); parm.Size = 50; parm.Direction = ParameterDirection.Output; cmd.Parameters.Add(parm); SqlParameter parm1 = new SqlParameter("@idArticle", SqlDbType.Int); parm1.Value = oQuestion.idArticle; parm1.Direction = ParameterDirection.Input; cmd.Parameters.Add(parm1); SqlParameter parm2 = new SqlParameter("@Alias", SqlDbType.NVarChar); parm2.Value = oQuestion.Alias; parm2.Direction = ParameterDirection.Input; cmd.Parameters.Add(parm2); SqlParameter parm3 = new SqlParameter("@Question", SqlDbType.NVarChar); parm3.Value = oQuestion.Question; parm3.Direction = ParameterDirection.Input; cmd.Parameters.Add(parm3); SqlParameter parm4 = new SqlParameter("@Creador", SqlDbType.NVarChar); parm4.Value = oQuestion.Creador; parm4.Direction = ParameterDirection.Input; cmd.Parameters.Add(parm4); SqlParameter parm5 = new SqlParameter("@FechaModificacion", SqlDbType.DateTime); parm5.Value = oQuestion.FechaModificacion; parm5.Direction = ParameterDirection.Input; cmd.Parameters.Add(parm5); SqlParameter parm6 = new SqlParameter("@Modificador", SqlDbType.NVarChar); parm6.Value = oQuestion.Modificador; parm6.Direction = ParameterDirection.Input; cmd.Parameters.Add(parm6); con.Open(); cmd.ExecuteNonQuery(); con.Close(); object intIDQuestion = cmd.Parameters["@idQuestion"].Value; return (int)(intIDQuestion); } }
public List<BEQuestion> GetQuestionbyArticleId(SqlConnection con, int idArticle) { List<BEQuestion> lbeQuestion = null; SqlCommand cmd = new SqlCommand("USP_GetQuestionbyArticleId", con); cmd.CommandType = CommandType.StoredProcedure; //ARGUMENTOS DE PROCEDURE DbParameter param = cmd.CreateParameter(); param.DbType = DbType.Int32; param.ParameterName = "idArticle"; param.Value = idArticle; cmd.Parameters.Add(param); SqlDataReader drd = cmd.ExecuteReader(CommandBehavior.SingleResult); if (drd != null) { lbeQuestion = new List<BEQuestion>(); BEQuestion obeQuestion; while (drd.Read()) { obeQuestion = new BEQuestion(); if (!drd.IsDBNull(0)) { obeQuestion.idQuestion = drd.GetInt32(0); }; if (!drd.IsDBNull(1)) { obeQuestion.idArticle = drd.GetInt32(1); }; if (!drd.IsDBNull(2)) { obeQuestion.Alias = drd.GetString(2); }; if (!drd.IsDBNull(3)) { obeQuestion.Question = drd.GetString(3); }; if (!drd.IsDBNull(4)) { obeQuestion.FechaCreacion = drd.GetDateTime(4); }; if (!drd.IsDBNull(5)) { obeQuestion.Creador = drd.GetString(5); }; if (!drd.IsDBNull(6)) { obeQuestion.FechaModificacion = drd.GetDateTime(6); }; if (!drd.IsDBNull(7)) { obeQuestion.Modificador = drd.GetString(7); }; lbeQuestion.Add(obeQuestion); } drd.Close(); } return lbeQuestion; }
public int SaveQuestion(BEQuestion Question) { DAQuestion data = new DAQuestion(); int Resultado = 0; using (SqlConnection con = new SqlConnection(CadenaConexion)) { try { Resultado = data.SaveQuestion(con, Question); } catch (Exception ex) { //En El Caso de Ocurrir alGun Errror Guardamos la Exepcion GrabarLog(ex); } } return Resultado; }