public bool AddNewLink(YoutubeLink link) { string connectionString = ConfigurationManager.ConnectionStrings["DBECSPROJConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("spInsertYoutubeLinks", con); cmd.CommandType = CommandType.StoredProcedure; //SqlDataReader rdr = cmd.ExecuteReader(); SqlParameter paramName = new SqlParameter(); paramName.ParameterName = "@Link"; paramName.Value = link.Link; cmd.Parameters.Add(paramName); paramName = new SqlParameter(); paramName.ParameterName = "@Title"; paramName.Value = link.Title; cmd.Parameters.Add(paramName); con.Open(); cmd.ExecuteNonQuery(); } return(true); }
public List <YoutubeLink> GetAllLinks() { string connectionString = ConfigurationManager.ConnectionStrings["DBECSPROJConnectionString"].ConnectionString; List <YoutubeLink> links = new List <YoutubeLink>(); using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("spGetAllYoutubeLinks", con); cmd.CommandType = CommandType.StoredProcedure; con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { YoutubeLink link = new YoutubeLink(); link.Id = Convert.ToInt32(rdr["Id"]); link.Link = rdr["YoutubeLink"].ToString(); link.Title = rdr["Title"].ToString(); links.Add(link); } } return(links); }