public virtual ProductView UpdateProductView(ProductView entity)
{
if (entity.IsTransient())
{
return(entity);
}
ProductView other = GetProductView(entity.ViewId);
if (entity.Equals(other))
{
return(entity);
}
string sql = @"Update ProductView set [CustomerViewID]=@CustomerViewID
, [ProductID]=@ProductID
, [ViewDate]=@ViewDate
where ViewID=@ViewID" ;
SqlParameter[] parameterArray = new SqlParameter[] {
new SqlParameter("@ViewID", entity.ViewId)
, new SqlParameter("@CustomerViewID", entity.CustomerViewId)
, new SqlParameter("@ProductID", entity.ProductId)
, new SqlParameter("@ViewDate", entity.ViewDate)
};
SqlHelper.ExecuteNonQuery(this.ConnectionString, CommandType.Text, sql, parameterArray);
return(GetProductView(entity.ViewId));
}