private void MapperConfigure(MapperInstance cfd)
{
cfd.AddMap<Person, PersonInfoDto>(src =>
{
PersonInfoDto dst = new PersonInfoDto();
dst.InjectFrom(src);
dst.EmployeeBrithDate = src.Employee?.BirthDate;
return dst;
});
cfd.AddMap<EmailAddress, EmailDto>(src =>
{
EmailDto dst = new EmailDto();
dst.InjectFrom(src);
dst.EmailAddress = src.EmailAddress1;
return dst;
});
cfd.AddMap<ShipMethod, ShipMethodDto>(src =>
{
ShipMethodDto dst = new ShipMethodDto();
dst.InjectFrom(src);
return dst;
});
cfd.AddMap<ProductListPriceHistory, ProductListPriceHistoryDto>(src =>
{
ProductListPriceHistoryDto dst = new ProductListPriceHistoryDto();
dst.InjectFrom(src);
return dst;
});
cfd.AddMap<Product, ProductDto>(src =>
{
ProductDto dst = new ProductDto();
dst.InjectFrom(src);
dst.ProductListPriceHistories = new List<ProductListPriceHistoryDto>();
foreach (ProductListPriceHistory item in src.ProductListPriceHistories)
{
ProductListPriceHistoryDto itemDto = new ProductListPriceHistoryDto();
itemDto.InjectFrom(item);
dst.ProductListPriceHistories.Add(itemDto);
}
return dst;
});
cfd.AddMap<ProductModel, ProductModelDto>(src =>
{
ProductModelDto dst = new ProductModelDto();
dst.InjectFrom(src);
return dst;
});
cfd.AddMap<Product, Product2Dto>(src =>
{
Product2Dto dst = new Product2Dto();
dst.InjectFrom(src);
dst.ProductModel = new ProductModelDto();
dst.ProductModel.InjectFrom(src.ProductModel);
dst.ProductModelID = src.ProductModel?.ProductModelID;
return dst;
});
}
public Product2Dto GetProduct2(int id)
{
Product product = this.dbContext.Products.Find(id);
if (product == null)
{
throw new ArgumentException("id");
}
Product2Dto productDto = new Product2Dto();
productDto.ProductID = product.ProductID;
productDto.Name = product.Name;
productDto.ProductNumber = product.ProductNumber;
productDto.MakeFlag = product.MakeFlag;
productDto.FinishedGoodsFlag = product.FinishedGoodsFlag;
productDto.Color = product.Color;
productDto.SafetyStockLevel = product.SafetyStockLevel;
productDto.ReorderPoint = product.ReorderPoint;
productDto.StandardCost = product.StandardCost;
productDto.ListPrice = product.ListPrice;
productDto.Size = product.Size;
productDto.SizeUnitMeasureCode = product.SizeUnitMeasureCode;
productDto.WeightUnitMeasureCode = product.WeightUnitMeasureCode;
productDto.Weight = product.Weight;
productDto.DaysToManufacture = product.DaysToManufacture;
productDto.ProductLine = product.ProductLine;
productDto.Class = product.Class;
productDto.Style = product.Style;
productDto.ProductSubcategoryID = product.ProductSubcategoryID;
productDto.ProductModelID = product.ProductModelID;
productDto.SellStartDate = product.SellStartDate;
productDto.SellEndDate = product.SellEndDate;
productDto.DiscontinuedDate = product.DiscontinuedDate;
productDto.rowguid = product.rowguid;
productDto.ModifiedDate = product.ModifiedDate;
if (product.ProductModel != null)
{
productDto.ProductModel = new ProductModelDto();
productDto.ProductModel.CatalogDescription = product.ProductModel.CatalogDescription;
productDto.ProductModel.Instructions = product.ProductModel.Instructions;
productDto.ProductModel.ModifiedDate = product.ProductModel.ModifiedDate;
productDto.ProductModel.Name = product.ProductModel.Name;
productDto.ProductModel.ProductModelID = product.ProductModel.ProductModelID;
productDto.ProductModel.rowguid = product.ProductModel.rowguid;
}
return productDto;
}
public Product2Dto GetProduct2(int id)
{
string sql = @"SELECT TOP 1
[p].[ProductID]
,[p].[Name]
,[p].[ProductNumber]
,[p].[MakeFlag]
,[p].[FinishedGoodsFlag]
,[p].[Color]
,[p].[SafetyStockLevel]
,[p].[ReorderPoint]
,[p].[StandardCost]
,[p].[ListPrice]
,[p].[Size]
,[p].[SizeUnitMeasureCode]
,[p].[WeightUnitMeasureCode]
,[p].[Weight]
,[p].[DaysToManufacture]
,[p].[ProductLine]
,[p].[Class]
,[p].[Style]
,[p].[ProductSubcategoryID]
,[p].[ProductModelID]
,[p].[SellStartDate]
,[p].[SellEndDate]
,[p].[DiscontinuedDate]
,[p].[rowguid]
,[p].[ModifiedDate]
,[pm].[CatalogDescription]
,[pm].[Instructions]
,[pm].[ModifiedDate] AS [ProductModelNameModifiedDate]
,[pm].[Name] AS [ProductModelName]
,[pm].[rowguid] AS [ProductModelRowguid]
FROM [AdventureWorks2014].[Production].[Product] [p]
LEFT JOIN [AdventureWorks2014].[Production].[ProductModel] [pm]
ON [p].[ProductModelID] = [pm].[ProductModelID]
WHERE [p].[ProductID] = @Id;";
using (SqlConnection connection = new SqlConnection(this.connectionString))
{
SqlCommand cmd = connection.CreateCommand();
cmd.CommandText = sql;
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@Id", id);
bool isFirst = true;
Product2Dto productDto = new Product2Dto();
if (connection.State != System.Data.ConnectionState.Open)
{
connection.Open();
}
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
if (isFirst)
{
productDto.ProductID = (int)reader["ProductID"];
productDto.Name = this.MapToString(reader, "Name");
productDto.ProductNumber = this.MapToString(reader, "ProductNumber");
productDto.MakeFlag = (bool)reader["MakeFlag"];
productDto.FinishedGoodsFlag = (bool)reader["FinishedGoodsFlag"];
productDto.Color = this.MapToString(reader, "Color");
productDto.SafetyStockLevel = (short)reader["SafetyStockLevel"];
productDto.ReorderPoint = (short)reader["ReorderPoint"];
productDto.StandardCost = (decimal)reader["StandardCost"];
productDto.ListPrice = (decimal)reader["ListPrice"];
productDto.Size = this.MapToString(reader, "Size");
productDto.SizeUnitMeasureCode = this.MapToString(reader, "SizeUnitMeasureCode");
productDto.WeightUnitMeasureCode = this.MapToString(reader, "WeightUnitMeasureCode");
productDto.Weight = this.MapToDecimal(reader, "Weight");
productDto.DaysToManufacture = (int)reader["DaysToManufacture"];
productDto.ProductLine = this.MapToString(reader, "ProductLine");
productDto.Class = this.MapToString(reader, "Class");
productDto.Style = this.MapToString(reader, "Style");
productDto.ProductSubcategoryID = this.MapToInt(reader, "ProductSubcategoryID");
productDto.ProductModelID = this.MapToInt(reader, "ProductModelID");
productDto.SellStartDate = (DateTime)reader["SellStartDate"];
productDto.SellEndDate = this.MapToDateTime(reader, "SellEndDate");
productDto.DiscontinuedDate = this.MapToDateTime(reader, "DiscontinuedDate");
productDto.rowguid = (Guid)reader["rowguid"];
productDto.ModifiedDate = (DateTime)reader["ModifiedDate"];
isFirst = false;
}
if (productDto.ProductModelID.HasValue)
{
productDto.ProductModel = new ProductModelDto();
productDto.ProductModel.ProductModelID = productDto.ProductModelID.Value;
productDto.ProductModel.CatalogDescription = this.MapToString(reader, "CatalogDescription");
productDto.ProductModel.Instructions = this.MapToString(reader, "Instructions");
productDto.ProductModel.ModifiedDate = (DateTime)reader["ProductModelNameModifiedDate"];
productDto.ProductModel.Name = this.MapToString(reader, "ProductModelName");
productDto.ProductModel.rowguid = (Guid)reader["ProductModelRowguid"];
}
}
}
if (isFirst)
{
throw new ArgumentException("id");
}
return productDto;
}
}