// Get product details
public static ArctilesDetails GetArticleDetails(string ID)
{
// get a configured DbCommand object
DbCommand comm = GenericDataAccess.CreateCommand();
// set the stored procedure name
comm.CommandText = "GetArticleDetails";
// create a new parameter
DbParameter param = comm.CreateParameter();
param.ParameterName = "@ID";
param.Value = ID;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
// execute the stored procedure
DataTable table = GenericDataAccess.ExecuteSelectCommand(comm);
// wrap retrieved data into a ProductDetails object
ArctilesDetails details = new ArctilesDetails();
if (table.Rows.Count > 0)
{
// get the first table row
DataRow dr = table.Rows[0];
// get product details
details.ID = int.Parse(ID);
details.Title = dr["Title"].ToString();
details.Summary = dr["Summary"].ToString();
details.Author = dr["Author"].ToString();
details.ViewTimes = dr["ViewTimes"].ToString();
details.CDT = dr["CDT"].ToString();
}
// return department details
return(details);
}
// Get product details
public static ArctilesDetails GetArticleDetails(string ID)
{
// get a configured DbCommand object
DbCommand comm = GenericDataAccess.CreateCommand();
// set the stored procedure name
comm.CommandText = "GetArticleDetails";
// create a new parameter
DbParameter param = comm.CreateParameter();
param.ParameterName = "@ID";
param.Value = ID;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
// execute the stored procedure
DataTable table = GenericDataAccess.ExecuteSelectCommand(comm);
// wrap retrieved data into a ProductDetails object
ArctilesDetails details = new ArctilesDetails();
if (table.Rows.Count > 0)
{
// get the first table row
DataRow dr = table.Rows[0];
// get product details
details.ID = int.Parse(ID);
details.Title = dr["Title"].ToString();
details.Summary = dr["Summary"].ToString();
details.Author = dr["Author"].ToString();
details.ViewTimes = dr["ViewTimes"].ToString();
details.CDT = dr["CDT"].ToString();
}
// return department details
return details;
}
public static string ToArticles(string ID)
{
// prepare product URL name
ArctilesDetails p = Search_Access.GetArticleDetails(ID.ToString());
string prodUrlName = PrepareUrlText(p.Title);
// build product URL
return(BuildAbsolute(String.Format("{0}-p{1}/", prodUrlName, ID)));
}
