public HttpResponseMessage<News> PostNews(News news, HttpRequestMessage<News> request) { if (news.EarthwatcherId != 0 && news.NewsItem!= String.Empty) newsRepository.PostNews(news); return null; }
public News PostNews(News news) { connection.Open(); var cmd = connection.CreateCommand() as SqlCommand; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "News_PostNews"; cmd.Parameters.Add(new SqlParameter("@userid", news.EarthwatcherId)); cmd.Parameters.Add(new SqlParameter("@NewsItem", news.NewsItem)); cmd.Parameters.Add(new SqlParameter("@Published", DateTime.Now.ToUniversalTime())); cmd.Parameters.Add(new SqlParameter("@shape", SqlGeography.STGeomFromText(new SqlChars(news.Wkt), 4326)) { UdtTypeName = "Geography" }); var idParameter = new SqlParameter("@ID", SqlDbType.Int) {Direction = ParameterDirection.Output}; cmd.Parameters.Add(idParameter); cmd.ExecuteNonQuery(); connection.Close(); return news; }
public NewsControl(News news) { InitializeComponent(); this.news = news; Init(); }