protected string GetTagLink(Tag tag)
{
#region arguments
if (tag == null)
{
throw new ArgumentNullException("tag");
}
#endregion
string tagLink = "";
DynamicPage dPage = Page as DynamicPage;
if (dPage != null)
{
RouteValueDictionary rvd = new RouteValueDictionary();
rvd.Add(Constants.PageRouteIdentifier, 1);
if (!string.IsNullOrEmpty(tag.Name))
{
rvd.Add(Constants.SearchRouteIdentifier, tag.Name);
}
tagLink = Page.GetRouteUrl(dPage.RouteName, rvd);
}
return tagLink;
}
public IList<Tag> GetTags(Guid key, long resourceId)
{
#region argument checking
if (key == Guid.Empty)
{
throw new ArgumentException("key");
}
#endregion
List<Tag> tags = new List<Tag>();
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = @"Proc_Ratna_Tags_Get";
AddParameter(command, "@SiteId", SqlDbType.Int, Jardalu.Ratna.Core.WebContext.Current.Site.Id);
AddParameter(command, "@Key", SqlDbType.UniqueIdentifier, key);
AddParameter(command, "@ResourceId", SqlDbType.BigInt, resourceId);
SqlParameter errorCodeParameter = AddOutputParameter(command, "@ErrorCode", SqlDbType.BigInt);
using (SqlConnection sqlConnection = new SqlConnection(ConnectionInformation.Instance.ConnectionString))
{
using (command)
{
command.Connection = sqlConnection;
command.Connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Tag tagCreated = new Tag();
tagCreated.Name = reader["Tag"] as string;
tagCreated.Weight = (int)reader["Weight"];
tags.Add(tagCreated);
}
if (!reader.IsClosed)
{
reader.Close();
}
}
}
//read the error code
long errorCode = (long)errorCodeParameter.Value;
if (errorCode != NoErrorCode)
{
ThrowError(errorCode);
}
return tags;
}
