public void Delete(Site site)
{
using (DbCommand cmd = _db.GetSqlStringCommand(SiteQueries.DeleteSite))
{
_db.AddInParameter(cmd, "@SiteId", DbType.Int32, site.Id);
_db.AddInParameter(cmd, "@UpdatedBy", DbType.Int32, site.UpdatedBy);
_db.ExecuteNonQuery(cmd);
}
}
public Site Add(Site site)
{
using (DbCommand cmd = _db.GetSqlStringCommand(SiteQueries.AddSite))
{
_db.AddInParameter(cmd, "@Name", DbType.String, site.Name);
_db.AddInParameter(cmd, "@CreatedBy", DbType.String, site.CreatedBy);
using (IDataReader reader = _db.ExecuteReader(cmd))
{
while (reader.Read())
{
return ReadertoSite(reader);
}
}
}
return site;
}
public ActionResult Add(Site site)
{
try
{
if (ModelState.IsValid)
{
site.CreatedBy = HttpContext.User.Identity.Name;
site = siteRepository.Add(site);
return Redirect("/Sites/");
}
else
{
ViewBag.ErrorMessage = "There is a problem with one of your response.";
}
}
catch (Exception ex)
{
ViewBag.ErrorMessage = "An Error Occurred while attempting to save that site.";
}
return View(site);
}
protected Site ReadertoSite(IDataReader reader)
{
var site = new Site();
if (reader["Id"] != DBNull.Value)
{
site.Id = Convert.ToInt32(reader["Id"]);
}
if (reader["Name"] != DBNull.Value)
{
site.Name = reader["Name"].ToString();
}
if (reader["CreatedBy"] != DBNull.Value)
{
site.CreatedBy = reader["CreatedBy"].ToString();
}
if (reader["UpdatedBy"] != DBNull.Value)
{
site.UpdatedBy = reader["UpdatedBy"].ToString();
}
if (reader["Created"] != DBNull.Value)
{
site.Created = Convert.ToDateTime(reader["Created"]);
}
if (reader["Updated"] != DBNull.Value)
{
site.Updated = Convert.ToDateTime(reader["Updated"]);
}
site.Urls = new List<SiteUrl>();
return site;
}
public Site Update(Site site)
{
using (DbCommand cmd = _db.GetSqlStringCommand(SiteQueries.UpdateSite))
{
_db.AddInParameter(cmd, "@Name", DbType.String, site.Name);
_db.AddInParameter(cmd, "@UpdatedBy", DbType.String, site.UpdatedBy);
_db.AddInParameter(cmd, "@SiteId", DbType.Int32, site.Id);
_db.ExecuteNonQuery(cmd);
}
return site;
}
public ActionResult Add()
{
var site = new Site();
return View(site);
}
