public virtual KitGroup InsertKitGroup(KitGroup entity)
{
KitGroup other = new KitGroup();
other = entity;
if (entity.IsTransient())
{
string sql = @"Insert into KitGroup ( [KitGroupGUID]
,[Name]
,[Description]
,[Summary]
,[ProductID]
,[DisplayOrder]
,[KitGroupTypeID]
,[IsRequired]
,[ExtensionData]
,[CreatedOn]
,[IsReadOnly] )
Values
( @KitGroupGUID
, @Name
, @Description
, @Summary
, @ProductID
, @DisplayOrder
, @KitGroupTypeID
, @IsRequired
, @ExtensionData
, @CreatedOn
, @IsReadOnly );
Select scope_identity()" ;
SqlParameter[] parameterArray = new SqlParameter[] {
new SqlParameter("@KitGroupID", entity.KitGroupId)
, new SqlParameter("@KitGroupGUID", entity.KitGroupGuid)
, new SqlParameter("@Name", entity.Name)
, new SqlParameter("@Description", entity.Description ?? (object)DBNull.Value)
, new SqlParameter("@Summary", entity.Summary ?? (object)DBNull.Value)
, new SqlParameter("@ProductID", entity.ProductId)
, new SqlParameter("@DisplayOrder", entity.DisplayOrder)
, new SqlParameter("@KitGroupTypeID", entity.KitGroupTypeId)
, new SqlParameter("@IsRequired", entity.IsRequired)
, new SqlParameter("@ExtensionData", entity.ExtensionData ?? (object)DBNull.Value)
, new SqlParameter("@CreatedOn", entity.CreatedOn)
, new SqlParameter("@IsReadOnly", entity.IsReadOnly)
};
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(GetKitGroup(Convert.ToInt32(identity)));
}
return(entity);
}
public virtual KitGroup UpdateKitGroup(KitGroup entity)
{
if (entity.IsTransient())
{
return(entity);
}
KitGroup other = GetKitGroup(entity.KitGroupId);
if (entity.Equals(other))
{
return(entity);
}
string sql = @"Update KitGroup set [KitGroupGUID]=@KitGroupGUID
, [Name]=@Name
, [Description]=@Description
, [Summary]=@Summary
, [ProductID]=@ProductID
, [DisplayOrder]=@DisplayOrder
, [KitGroupTypeID]=@KitGroupTypeID
, [IsRequired]=@IsRequired
, [ExtensionData]=@ExtensionData
, [CreatedOn]=@CreatedOn
, [IsReadOnly]=@IsReadOnly
where KitGroupID=@KitGroupID" ;
SqlParameter[] parameterArray = new SqlParameter[] {
new SqlParameter("@KitGroupID", entity.KitGroupId)
, new SqlParameter("@KitGroupGUID", entity.KitGroupGuid)
, new SqlParameter("@Name", entity.Name)
, new SqlParameter("@Description", entity.Description ?? (object)DBNull.Value)
, new SqlParameter("@Summary", entity.Summary ?? (object)DBNull.Value)
, new SqlParameter("@ProductID", entity.ProductId)
, new SqlParameter("@DisplayOrder", entity.DisplayOrder)
, new SqlParameter("@KitGroupTypeID", entity.KitGroupTypeId)
, new SqlParameter("@IsRequired", entity.IsRequired)
, new SqlParameter("@ExtensionData", entity.ExtensionData ?? (object)DBNull.Value)
, new SqlParameter("@CreatedOn", entity.CreatedOn)
, new SqlParameter("@IsReadOnly", entity.IsReadOnly)
};
SqlHelper.ExecuteNonQuery(this.ConnectionString, CommandType.Text, sql, parameterArray);
return(GetKitGroup(entity.KitGroupId));
}
