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));
}
public virtual ProductView InsertProductView(ProductView entity)
{
ProductView other = new ProductView();
other = entity;
if (entity.IsTransient())
{
string sql = @"Insert into ProductView ( [CustomerViewID]
,[ProductID]
,[ViewDate] )
Values
( @CustomerViewID
, @ProductID
, @ViewDate );
Select scope_identity()" ;
SqlParameter[] parameterArray = new SqlParameter[] {
new SqlParameter("@ViewID", entity.ViewId)
, new SqlParameter("@CustomerViewID", entity.CustomerViewId)
, new SqlParameter("@ProductID", entity.ProductId)
, new SqlParameter("@ViewDate", entity.ViewDate)
};
var identity = SqlHelper.ExecuteScalar(this.ConnectionString, CommandType.Text, sql, parameterArray);
if (identity == DBNull.Value)
{
throw new DataException("Identity column was null as a result of the insert operation.");
}
return(GetProductView(Convert.ToInt32(identity)));
}
return(entity);
}