public void DeleteSiteUrl(SiteUrl url)
{
using (DbCommand cmd = _db.GetSqlStringCommand(SiteQueries.DeleteSiteUrl))
{
_db.AddInParameter(cmd, "@SiteurlId", DbType.Int32, url.Id);
_db.AddInParameter(cmd, "@UpdatedBy", DbType.String, url.UpdatedBy);
_db.ExecuteNonQuery(cmd);
}
}
public ActionResult DeleteUrl(SiteUrl item)
{
try
{
item.UpdatedBy = HttpContext.User.Identity.Name;
siteRepository.DeleteSiteUrl(item);
return Json("success");
}
catch (Exception ex)
{
return Json("failure");
}
}
public ActionResult AddUrl(SiteUrl item)
{
try
{
item.CreatedBy = HttpContext.User.Identity.Name;
var returnUrl = siteRepository.AddSiteUrl(item);
return Json(returnUrl);
}
catch (Exception ex)
{
return Json("failure");
}
}
public SiteUrl AddSiteUrl(SiteUrl url)
{
using (DbCommand cmd = _db.GetSqlStringCommand(SiteQueries.AddSiteUrl))
{
_db.AddInParameter(cmd, "@Url", DbType.String, url.Url);
_db.AddInParameter(cmd, "@SiteId", DbType.Int32, url.SiteId);
_db.AddInParameter(cmd, "@CreatedBy", DbType.String, url.CreatedBy);
using (IDataReader reader = _db.ExecuteReader(cmd))
{
while (reader.Read())
{
return ReadertoSiteUrl(reader);
}
}
}
return url;
}
protected SiteUrl ReadertoSiteUrl(IDataReader reader)
{
var siteUrl = new SiteUrl();
if (reader["Id"] != DBNull.Value)
{
siteUrl.Id = Convert.ToInt32(reader["Id"]);
}
if (reader["SiteId"] != DBNull.Value)
{
siteUrl.SiteId = Convert.ToInt32(reader["SiteId"]);
}
if (reader["Url"] != DBNull.Value)
{
siteUrl.Url = reader["Url"].ToString();
}
if (reader["CreatedBy"] != DBNull.Value)
{
siteUrl.CreatedBy = reader["CreatedBy"].ToString();
}
if (reader["UpdatedBy"] != DBNull.Value)
{
siteUrl.UpdatedBy = reader["UpdatedBy"].ToString();
}
if (reader["Created"] != DBNull.Value)
{
siteUrl.Created = Convert.ToDateTime(reader["Created"]);
}
if (reader["Updated"] != DBNull.Value)
{
siteUrl.Updated = Convert.ToDateTime(reader["Updated"]);
}
return siteUrl;
}
