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;
}
