/*********************************************************** * Description: Get the list of: * * Publication (Title,Interpretation,State), * * Image_Publication (imageData), * * Resources (source) * ************************************************************ * Author: Alex Villegas Carranza * ************************************************************* * Parameters: @idSection * ************************************************************/ public static List <ClimaticPublication> getPublicationBySection(int idSection) { Connection(); try { using (SqlCommand cmd = new SqlCommand("sp_getPublicationBySection", _con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@idSection", idSection); _con.Open(); SqlDataReader reader = cmd.ExecuteReader(); List <ClimaticPublication> list = new List <ClimaticPublication>(); ClimaticPublication item; while (reader.Read()) { item = new ClimaticPublication(); item.title = Convert.ToString(reader["title"]); item.source = Convert.ToString(reader["source"]); item.State = Convert.ToByte(reader["pubState"]); item.Scrap = Convert.ToByte(reader["Scrap"]); item.OriginalURL = Convert.ToString(reader["OriginalURL"]); item.interpretation = reader["interpretation"].ToString(); item.img = reader["imageData"].ToString().Replace("\"", ""); item.idPublication = Convert.ToInt32(reader["idPub"]); item.idDisplayMode = Convert.ToInt32(reader["idDisplayMode"]); //IF ScrapSettings has values if (item.Scrap == 1) { int nodeIndex; Int32.TryParse(reader["nodeIndex"].ToString(), out nodeIndex); item.nodeIndex = nodeIndex; item.tagType = Convert.ToString(reader["tagType"]); } list.Add(item); } return(list); } } catch (Exception ex) { throw ex; } finally { if (_con.State == ConnectionState.Open) { _con.Close(); } } }
public static Boolean setPublicationInfo_Source(ClimaticPublication pub) { Connection(); try { using (SqlCommand cmd = new SqlCommand("sp_updateClimaticPublication_source", _con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@idPub", pub.idPublication); cmd.Parameters.AddWithValue("@title", pub.title); cmd.Parameters.AddWithValue("@interpretation", pub.interpretation); cmd.Parameters.AddWithValue("@state", pub.State); cmd.Parameters.AddWithValue("@source", pub.source); // //EMAIL just for test cmd.Parameters.AddWithValue("@email", "ND");//current user, must be fixedd! if (pub.img == null) { cmd.Parameters.Add("@imageData", SqlDbType.VarBinary, -1); cmd.Parameters["@imageData"].Value = DBNull.Value; } else { cmd.Parameters.AddWithValue("@imageData", pub.img); } _con.Open(); int n = cmd.ExecuteNonQuery(); return(n >= 1); } } catch (Exception ex) { throw ex; } finally { if (_con.State == ConnectionState.Open) { _con.Close(); } } }
public static String setInterviewPublicationInfo(ClimaticPublication pub) { return(DBcontext.setInterviewPublicationInfo(pub)); }
public static Boolean setPublicationInfo_Source(ClimaticPublication pub) { return(DBcontext.setPublicationInfo_Source(pub)); }