public ActionResult SaveArticle(BEArticle oArticulo) { int intRes = 0; string strModificador = "AMIGO"; string idLinea = ConfigurationManager.AppSettings["idLinea"]; DateTime FechaRegistro = DateTime.Now; //OBjeto a Registrar BRArticle oBRArticle = new BRArticle(); oArticulo.FechaModificacion = DateTime.Now; oArticulo.idLine = Int32.Parse(idLinea); intRes = oBRArticle.SaveArticle(oArticulo); if (intRes > 0) return Json(new { idArticle = intRes}); else return Json(new { success = false }); }
public List<BEArticle> GetPostArticlesByLine(SqlConnection con,int idLine) { List<BEArticle> lbeArticle = null; SqlCommand cmd = new SqlCommand("USP_GetArticleListByLine", con); cmd.CommandType = CommandType.StoredProcedure; //ARGUMENTOS DE PROCEDURE DbParameter param = cmd.CreateParameter(); param.DbType = DbType.Int32; param.ParameterName = "idLine"; param.Value = idLine; cmd.Parameters.Add(param); SqlDataReader drd = cmd.ExecuteReader(CommandBehavior.SingleResult); if (drd != null) { lbeArticle = new List<BEArticle>(); BEArticle obeArticle; while (drd.Read()) { obeArticle = new BEArticle(); if (!drd.IsDBNull(0)) { obeArticle.idArticle = drd.GetInt32(0); }; if (!drd.IsDBNull(1)) { obeArticle.idLine = drd.GetInt32(1); }; if (!drd.IsDBNull(2)) { obeArticle.Titulo= drd.GetString(2); }; if (!drd.IsDBNull(3)) { obeArticle.SubTitulo= drd.GetString(3); }; if (!drd.IsDBNull(4)) { obeArticle.Descripcion = drd.GetString(4); }; if (!drd.IsDBNull(5)) { obeArticle.Contenido = drd.GetString(5); }; if (!drd.IsDBNull(6)) { obeArticle.imgArticle= drd.GetString(6); }; if (!drd.IsDBNull(7)) { obeArticle.Fecha = drd.GetDateTime(7); }; if (!drd.IsDBNull(8)) { obeArticle.Creador= drd.GetString(8); }; if (!drd.IsDBNull(9)) { obeArticle.FechaCreacion= drd.GetDateTime(9); }; if (!drd.IsDBNull(10)) { obeArticle.Modificador= drd.GetString(10); }; if (!drd.IsDBNull(11)) { obeArticle.FechaModificacion = drd.GetDateTime(11); }; lbeArticle.Add(obeArticle); } drd.Close(); } return lbeArticle; }
public int SaveArticle(BEArticle Articulo){ DCArticle data = new DCArticle(); int Resultado = 0; using (SqlConnection con = new SqlConnection(CadenaConexion)) { try { Resultado = data.SaveArticle(con,Articulo); } catch (Exception ex) { //En El Caso de Ocurrir alGun Errror Guardamos la Exepcion GrabarLog(ex); } } return Resultado; }
public BEArticle GetArticleById(int idArticle) { BEArticle oArticle = new BEArticle(); using (SqlConnection con = new SqlConnection(CadenaConexion)) { try { con.Open(); DCArticle odArticle = new DCArticle(); oArticle = odArticle.GetArticlebyId(con, idArticle); } catch (Exception ex) { GrabarLog(ex); } return oArticle; } }
public int SaveArticle (SqlConnection con, BEArticle oArticulo) { using (con) { SqlCommand cmd = new SqlCommand("SPI_SaveArticle", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter parm0 = new SqlParameter("@idArticle", SqlDbType.Int); parm0.Size = 50; parm0.Direction = ParameterDirection.Output; cmd.Parameters.Add(parm0); SqlParameter parm = new SqlParameter("@idLine", SqlDbType.Int); parm.Value = oArticulo.idLine; parm.Direction = ParameterDirection.Input; cmd.Parameters.Add(parm); SqlParameter parm2 = new SqlParameter("@titulo", SqlDbType.NVarChar); parm2.Value = oArticulo.Titulo; parm2.Direction = ParameterDirection.Input; cmd.Parameters.Add(parm2); SqlParameter parm3 = new SqlParameter("@subTitulo", SqlDbType.NVarChar); parm3.Value = oArticulo.SubTitulo; parm3.Direction = ParameterDirection.Input; cmd.Parameters.Add(parm3); SqlParameter parm4 = new SqlParameter("@Descripcion", SqlDbType.NVarChar); parm4.Value = oArticulo.Descripcion; parm4.Direction = ParameterDirection.Input; cmd.Parameters.Add(parm4); SqlParameter parm5 = new SqlParameter("@Contenido", SqlDbType.Text); parm5.Value = oArticulo.Contenido; parm5.Direction = ParameterDirection.Input; cmd.Parameters.Add(parm5); SqlParameter parm6 = new SqlParameter("@imgArticle", SqlDbType.NVarChar); parm6.Value = oArticulo.imgArticle; parm6.Direction = ParameterDirection.Input; cmd.Parameters.Add(parm6); SqlParameter parm7 = new SqlParameter("@creador", SqlDbType.NVarChar); parm7.Value = oArticulo.Creador; parm7.Direction = ParameterDirection.Input; cmd.Parameters.Add(parm7); SqlParameter parm8 = new SqlParameter("@Modificador", SqlDbType.NVarChar); parm8.Value = oArticulo.Modificador; parm8.Direction = ParameterDirection.Input; cmd.Parameters.Add(parm8); SqlParameter parm9 = new SqlParameter("@dtmFechaModificacion", SqlDbType.DateTime); parm9.Value = oArticulo.FechaModificacion; parm9.Direction = ParameterDirection.Input; cmd.Parameters.Add(parm9); con.Open(); cmd.ExecuteNonQuery(); con.Close(); object intIdArticle = cmd.Parameters["@idArticle"].Value; return (int)(intIdArticle); } //DbParameter Param1 = BaseData.DbProvider.CreateParameter(); //Param1.Value = oArticulo.idLine; //Param1.ParameterName = "@idLine"; //Parametros.Add(Param1); //DbParameter Param2 = BaseData.DbProvider.CreateParameter(); //Param2.Value = oArticulo.Titulo; //Param2.ParameterName = "@titulo"; //Parametros.Add(Param2); //DbParameter Param3 = BaseData.DbProvider.CreateParameter(); //Param3.Value = oArticulo.SubTitulo; //Param3.ParameterName = "@subTitulo"; //Parametros.Add(Param3); //DbParameter Param4 = BaseData.DbProvider.CreateParameter(); //Param4.Value = oArticulo.Descripcion; //Param4.ParameterName = "@Descripcion"; //Parametros.Add(Param4); //DbParameter Param5 = BaseData.DbProvider.CreateParameter(); //Param5.Value = oArticulo.Contenido; //Param5.ParameterName = "@Contenido"; //Parametros.Add(Param5); //DbParameter Param6 = BaseData.DbProvider.CreateParameter(); //Param6.Value = oArticulo.imgArticle; //Param6.ParameterName = "@imgArticle"; //Parametros.Add(Param6); //DbParameter Param7 = BaseData.DbProvider.CreateParameter(); //Param7.Value = oArticulo.Creador; //Param7.ParameterName = "@Creador"; //Parametros.Add(Param7); //DbParameter Param8 = BaseData.DbProvider.CreateParameter(); //Param8.Value = oArticulo.Modificador; //Param8.ParameterName = "@Modificador"; //Parametros.Add(Param8); //DbParameter Param9 = BaseData.DbProvider.CreateParameter(); //Param9.Value = oArticulo.FechaModificacion; //Param9.ParameterName = "@dtmFechaModificacion"; //Parametros.Add(Param9); //return BaseData.ejecutaNonQuery("SPI_SaveArticle", Parametros); }
public List<BEArticle> GetArticlesbyLinePaging(SqlConnection con, int idLine, int PageIndex, int PageSize) { List<BEArticle> lbeArticle = null; SqlCommand cmd = new SqlCommand("GetArticlesPaging", con); cmd.CommandType = CommandType.StoredProcedure; //ARGUMENTOS DE PROCEDURE DbParameter param = cmd.CreateParameter(); param.DbType = DbType.Int32; param.ParameterName = "@PageIndex"; param.Value = PageIndex; cmd.Parameters.Add(param); DbParameter param2 = cmd.CreateParameter(); param2.DbType = DbType.Int32; param2.ParameterName = "@PageSize"; param2.Value = PageSize; cmd.Parameters.Add(param2); DbParameter param3 = cmd.CreateParameter(); param3.DbType = DbType.Int32; param3.ParameterName = "@RecordCount"; param3.Value = 0; cmd.Parameters.Add(param3); DbParameter param4 = cmd.CreateParameter(); param4.DbType = DbType.Int32; param4.ParameterName = "@idLine"; param4.Value = idLine; cmd.Parameters.Add(param4); SqlDataReader drd = cmd.ExecuteReader(CommandBehavior.SingleResult); if (drd != null) { lbeArticle = new List<BEArticle>(); BEArticle obeArticle; while (drd.Read()) { obeArticle = new BEArticle(); if (!drd.IsDBNull(1)) { obeArticle.idArticle = drd.GetInt32(1); }; if (!drd.IsDBNull(2)) { obeArticle.idLine = drd.GetInt32(2); }; if (!drd.IsDBNull(3)) { obeArticle.Titulo = drd.GetString(3); }; if (!drd.IsDBNull(4)) { obeArticle.SubTitulo = drd.GetString(4); }; if (!drd.IsDBNull(5)) { obeArticle.Descripcion = drd.GetString(5); }; if (!drd.IsDBNull(6)) { obeArticle.Contenido = drd.GetString(6); }; if (!drd.IsDBNull(7)) { obeArticle.imgArticle = drd.GetString(7); }; if (!drd.IsDBNull(8)) { obeArticle.Fecha = drd.GetDateTime(8); }; if (!drd.IsDBNull(9)) { obeArticle.Creador = drd.GetString(9); }; if (!drd.IsDBNull(10)) { obeArticle.FechaCreacion = drd.GetDateTime(10); }; if (!drd.IsDBNull(11)) { obeArticle.Modificador = drd.GetString(11); }; if (!drd.IsDBNull(12)) { obeArticle.FechaModificacion = drd.GetDateTime(12); }; if (!drd.IsDBNull(13)) { obeArticle.FechaString = drd.GetString(13); }; lbeArticle.Add(obeArticle); } drd.Close(); } return lbeArticle; }