public virtual LayoutMap UpdateLayoutMap(LayoutMap entity)
{
if (entity.IsTransient())
{
return(entity);
}
LayoutMap other = GetLayoutMap(entity.LayoutMapId);
if (entity.Equals(other))
{
return(entity);
}
string sql = @"Update LayoutMap set [LayoutMapGUID]=@LayoutMapGUID
, [LayoutID]=@LayoutID
, [PageTypeID]=@PageTypeID
, [PageID]=@PageID
, [CreatedOn]=@CreatedOn
where LayoutMapID=@LayoutMapID" ;
SqlParameter[] parameterArray = new SqlParameter[] {
new SqlParameter("@LayoutMapID", entity.LayoutMapId)
, new SqlParameter("@LayoutMapGUID", entity.LayoutMapGuid)
, new SqlParameter("@LayoutID", entity.LayoutId)
, new SqlParameter("@PageTypeID", entity.PageTypeId)
, new SqlParameter("@PageID", entity.PageId)
, new SqlParameter("@CreatedOn", entity.CreatedOn)
};
SqlHelper.ExecuteNonQuery(this.ConnectionString, CommandType.Text, sql, parameterArray);
return(GetLayoutMap(entity.LayoutMapId));
}
public virtual LayoutMap InsertLayoutMap(LayoutMap entity)
{
LayoutMap other = new LayoutMap();
other = entity;
if (entity.IsTransient())
{
string sql = @"Insert into LayoutMap ( [LayoutMapGUID]
,[LayoutID]
,[PageTypeID]
,[PageID]
,[CreatedOn] )
Values
( @LayoutMapGUID
, @LayoutID
, @PageTypeID
, @PageID
, @CreatedOn );
Select scope_identity()" ;
SqlParameter[] parameterArray = new SqlParameter[] {
new SqlParameter("@LayoutMapID", entity.LayoutMapId)
, new SqlParameter("@LayoutMapGUID", entity.LayoutMapGuid)
, new SqlParameter("@LayoutID", entity.LayoutId)
, new SqlParameter("@PageTypeID", entity.PageTypeId)
, new SqlParameter("@PageID", entity.PageId)
, new SqlParameter("@CreatedOn", entity.CreatedOn)
};
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(GetLayoutMap(Convert.ToInt32(identity)));
}
return(entity);
}
