public int CreateNewsItem(NewsItem newsItem) { int id; SqlCommand cmd = new SqlCommand("CreateNewsItem") { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@Name", newsItem.Name); cmd.Parameters.AddWithValue("@Description", newsItem.Description); cmd.Parameters.AddWithValue("@ImageID", newsItem.ImageID); cmd.Parameters.AddWithValue("@Source", newsItem.Source); cmd.Parameters.AddWithValue("@EndDate", newsItem.EndDate); SqlParameter param = new SqlParameter("@ID", SqlDbType.Int); param.Direction = ParameterDirection.Output; cmd.Parameters.Add(param); try { _repo.ExecuteNonQuery(cmd); id = (int)cmd.Parameters["@ID"].Value; } catch (Exception exc) { throw exc; } return id; }
public ActionResult EditNewsItem(NewsItem item) { string message = ""; string messageClass = ""; if (ModelState.IsValid) { try { ACRepository.UpdateNewsItem(item); message = "Update successful."; messageClass = "success"; } catch (Exception exc) { message = exc.Message; messageClass = "error"; } } else { message = "Not all information was valid. See messages below."; messageClass = "info"; } ViewData["Message"] = message; ViewData["MessageClass"] = messageClass; return View(item); }
public void UpdateNewsItem(NewsItem newsItem) { SqlCommand cmd = new SqlCommand("UpdateNewsItem") { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@ID", newsItem.ID); cmd.Parameters.AddWithValue("@Name", newsItem.Name); cmd.Parameters.AddWithValue("@Description", newsItem.Description); cmd.Parameters.AddWithValue("@ImageID", newsItem.ImageID); cmd.Parameters.AddWithValue("@Source", newsItem.Source); cmd.Parameters.AddWithValue("@EndDate", newsItem.EndDate); cmd.Parameters.AddWithValue("@IsActive", newsItem.IsActive); try { _repo.ExecuteNonQuery(cmd); } catch (Exception exc) { throw exc; } }
public NewsItem GetNewsItem(int ID) { NewsItem item = new NewsItem(); SqlCommand cmd = new SqlCommand("GetNewsItem") { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@ID", ID); using (SqlDataReader rdr = (SqlDataReader)_repo.ExecuteReader(cmd)) { while (rdr.Read()) { item = new NewsItem() { ID = (int)rdr["ID"] , Name = rdr["Name"] != DBNull.Value ? rdr["Name"].ToString() : "" , Description = rdr["Description"] != DBNull.Value ? rdr["Description"].ToString() : "" , ImageID = rdr["ImageID"] != DBNull.Value ? (int)rdr["ImageID"] : 0 , Source = rdr["Source"] != DBNull.Value ? rdr["Source"].ToString() : "" , EndDate = rdr["EndDate"] != DBNull.Value ? (DateTime)rdr["EndDate"] : DateTime.MinValue , DateInserted = (DateTime)rdr["DateInserted"] , DateUpdated = rdr["DateUpdated"] != DBNull.Value ? (DateTime?)rdr["DateUpdated"] : DateTime.MinValue , IsActive = (bool)rdr["IsActive"] }; } } return item; }