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)); }