예제 #1
0
        public ShipMethodDto GetSimple(int id)
        {
            using (AdventureWorks2014Entities dbContext = new AdventureWorks2014Entities())
            {
                ShipMethod shipMethodEf = dbContext.ShipMethods.Find(id);
                if (shipMethodEf == null)
                {
                    throw new ArgumentException("Not found id");
                }

                ShipMethodDto shipMethodDto = new ShipMethodDto();
                shipMethodDto.ModifiedDate = shipMethodEf.ModifiedDate;
                shipMethodDto.Name = shipMethodEf.Name;
                shipMethodDto.rowguid = shipMethodEf.rowguid;
                shipMethodDto.ShipBase = shipMethodEf.ShipBase;
                shipMethodDto.ShipMethodID = shipMethodEf.ShipMethodID;
                shipMethodDto.ShipRate = shipMethodEf.ShipRate;

                return shipMethodDto;
            }
        }
예제 #2
0
        public List<PersonInfoDto> GetAllPersons()
        {
            using (AdventureWorks2014Entities dbContext = new AdventureWorks2014Entities())
            {
                IEnumerable<PersonInfoDto> projection =
                    dbContext.People.OrderBy(t => t.ModifiedDate)
                    .Select(t => new PersonInfoDto()
                    {
                        BusinessEntityID = t.BusinessEntityID,
                        FirstName = t.FirstName,
                        LastName = t.LastName,
                        PersonType = t.PersonType,
                        Title = t.Title,
                        EmployeeBrithDate = t.Employee.BirthDate,
                        EmployeeGender = t.Employee.Gender
                    });


                List<PersonInfoDto> rezult = projection.ToList();
                return rezult;
            }
        }
 public void Relase()
 {
     this.dbContext?.Dispose();
     this.dbContext = null;
 }
 public VanilaEfAdapter()
 {
     this.dbContext = null;
 }
 public void Prepare()
 {
     this.dbContext = new AdventureWorks2014Entities();
 }
 public TinyMapperAdapter()
 {
     this.dbContext = null;
 }
 public ValueInjecterAdapter()
 {
     this.mapper = new MapperInstance();
     this.MapperConfigure(this.mapper);
     this.dbContext = null;
 }
예제 #8
0
        public Product2Dto GetProduct2(int id)
        {
            using (AdventureWorks2014Entities dbContext = new AdventureWorks2014Entities())
            {
                Product product = 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 AutoMapperAdapter()
 {
     InitialAutomapper();
     this.dbContext = null;
 }