private ProductSupplierItemDto FetchProductSupplierItem(SafeDataReader dr)
{
var productSupplierItem = new ProductSupplierItemDto();
// Value properties
productSupplierItem.ProductSupplierId = dr.GetInt32("ProductSupplierId");
productSupplierItem.SupplierId = dr.GetInt32("SupplierId");
return(productSupplierItem);
}
/// <summary>
/// Loads a <see cref="ProductSupplierItem"/> object from the given <see cref="ProductSupplierItemDto"/>.
/// </summary>
/// <param name="data">The ProductSupplierItemDto to use.</param>
private void Child_Fetch(ProductSupplierItemDto data)
{
// Value properties
LoadProperty(ProductSupplierIdProperty, data.ProductSupplierId);
LoadProperty(SupplierIdProperty, data.SupplierId);
var args = new DataPortalHookArgs(data);
OnFetchRead(args);
// check all object rules and property rules
BusinessRules.CheckRules();
}
/// <summary>
/// Inserts a new ProductSupplierItem object in the database.
/// </summary>
/// <param name="productSupplierItem">The Product Supplier Item DTO.</param>
/// <returns>The new <see cref="ProductSupplierItemDto"/>.</returns>
public ProductSupplierItemDto Insert(ProductSupplierItemDto productSupplierItem)
{
using (var ctx = ConnectionManager <FbConnection> .GetManager("Invoices"))
{
using (var cmd = new FbCommand("dbo.AddProductSupplierItem", ctx.Connection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ProductId", productSupplierItem.Parent_ProductId).DbType = DbType.Guid;
cmd.Parameters.AddWithValue("@ProductSupplierId", productSupplierItem.ProductSupplierId).Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@SupplierId", productSupplierItem.SupplierId).DbType = DbType.Int32;
cmd.ExecuteNonQuery();
productSupplierItem.ProductSupplierId = (int)cmd.Parameters["@ProductSupplierId"].Value;
}
}
return(productSupplierItem);
}
/// <summary>
/// Updates in the database all changes made to the ProductSupplierItem object.
/// </summary>
/// <param name="productSupplierItem">The Product Supplier Item DTO.</param>
/// <returns>The updated <see cref="ProductSupplierItemDto"/>.</returns>
public ProductSupplierItemDto Update(ProductSupplierItemDto productSupplierItem)
{
using (var ctx = ConnectionManager <FbConnection> .GetManager("Invoices"))
{
using (var cmd = new FbCommand("dbo.UpdateProductSupplierItem", ctx.Connection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ProductSupplierId", productSupplierItem.ProductSupplierId).DbType = DbType.Int32;
cmd.Parameters.AddWithValue("@SupplierId", productSupplierItem.SupplierId).DbType = DbType.Int32;
var rowsAffected = cmd.ExecuteNonQuery();
if (rowsAffected == 0)
{
throw new DataNotFoundException("ProductSupplierItem");
}
}
}
return(productSupplierItem);
}
private void Child_Insert(ProductEdit parent)
{
var dto = new ProductSupplierItemDto();
dto.Parent_ProductId = parent.ProductId;
dto.SupplierId = SupplierId;
using (var dalManager = DalFactoryInvoices.GetManager())
{
var args = new DataPortalHookArgs(dto);
OnInsertPre(args);
var dal = dalManager.GetProvider <IProductSupplierItemDal>();
using (BypassPropertyChecks)
{
var resultDto = dal.Insert(dto);
LoadProperty(ProductSupplierIdProperty, resultDto.ProductSupplierId);
args = new DataPortalHookArgs(resultDto);
}
OnInsertPost(args);
}
}
private void Child_Update()
{
if (!IsDirty)
{
return;
}
var dto = new ProductSupplierItemDto();
dto.ProductSupplierId = ProductSupplierId;
dto.SupplierId = SupplierId;
using (var dalManager = DalFactoryInvoices.GetManager())
{
var args = new DataPortalHookArgs(dto);
OnUpdatePre(args);
var dal = dalManager.GetProvider <IProductSupplierItemDal>();
using (BypassPropertyChecks)
{
var resultDto = dal.Update(dto);
args = new DataPortalHookArgs(resultDto);
}
OnUpdatePost(args);
}
}
