protected override Order GetModel(FirebirdSql.Data.FirebirdClient.FbDataReader reader) { return(new Order { OrderDate = reader.GetDateTime(0), OrderTime = reader.GetDateTime(1), SaleType = reader.GetString(2), Ticket = reader.GetString(3), Line = reader.GetInt32(4), ArticleCode = reader.GetString(5), ColorCode = reader.GetString(6), SizeCode = reader.GetString(7), Quantity = reader.GetInt32(8), PurchasePrice = reader.GetDecimal(9), SalePrice = reader.GetDecimal(10), BrutoPrice = reader.GetDecimal(11), VAT = reader.GetDecimal(12), NettoPrice = reader.GetDecimal(13), DiscountPercentage = reader.GetDecimal(14), DiscountValue = reader.GetDecimal(15), ShopCode = reader.GetString(16), SalesPerson = reader.GetString(17), Client = reader.GetString(18) }); }
protected override Statistic GetModel(FirebirdSql.Data.FirebirdClient.FbDataReader reader) { return new Statistic { Atmosphere = reader.GetString(0), Context = reader.GetString(1), DateTime = reader.GetDateTime(2), ShopCode = reader.GetString(3), TotalSales = reader.GetDecimal(4), ClientSales = reader.GetDecimal(5), GeneralSales = reader.GetDecimal(6), UnitsSold = reader.GetDecimal(7), UnitsPerClient = reader.GetDecimal(8), TotalAmount = reader.GetDecimal(9), SalesPerClient = reader.GetDecimal(10), VisitorCount = reader.Get<Int32?>(11), VisitorsWithNoSales = reader.Get<Int32?>(12) }; }
protected override Stock GetModel(FirebirdSql.Data.FirebirdClient.FbDataReader reader) { return(new Stock { DateTime = reader.GetDateTime(0), ShopCode = reader.GetString(1), ArticleCode = reader.GetString(2), ColorCode = reader.GetString(3), SizeCode = reader.GetString(4), InStock = reader.GetInt32(5), Maximum = reader.GetInt32(6), Minimum = reader.GetInt32(7), Reserved = reader.GetInt32(8), Ordered = reader.GetInt32(9), Delivered = reader.GetInt32(10), Available = reader.GetInt32(11), TotalIn = reader.GetInt32(12), TotalOut = reader.GetInt32(13), WAC = reader.Get <Decimal?>(14) }); }
protected override Item GetModel(FirebirdSql.Data.FirebirdClient.FbDataReader reader) { return(new Item { DateTime = reader.GetDateTime(0), ArticleCode = reader.GetString(1), ColorCode = reader.GetString(2), ColorName = reader.GetString(3), SizeCode = reader.GetString(4), Barcode = reader.GetString(5), DescriptionLong = reader.GetString(6), DescriptionShort = reader.GetString(7), Price = reader.GetDecimal(8), OriginCode = reader.GetString(9), OriginName = reader.GetString(10), LabelCode = reader.GetString(11), LabelName = reader.GetString(12), SegmentCode = reader.GetString(13), SegmentName = reader.GetString(14), GroupCode = reader.GetString(15), GroupName = reader.GetString(16) }); }
protected override Movement GetModel(FirebirdSql.Data.FirebirdClient.FbDataReader reader) { return(new Movement { ShopCode = reader.GetString(0), MovementNumber = reader.GetInt32(1), MovementType = reader.GetString(2), MovementDescription = reader.GetString(3), ArticleCode = reader.GetString(4), ColorCode = reader.GetString(5), SizeCode = reader.GetString(6), MovementDirection = reader.GetString(7), MovementTime = reader.GetDateTime(9), MovementDate = reader.GetDateTime(8), SalesPerson = reader.GetString(10), CostPrice = reader.Get <Decimal?>(11), UnitPrice = reader.Get <Decimal?>(12), DocumentLine = reader.GetString(13), DocumentNumber = reader.GetString(14), LocationFrom = reader.GetString(15), LocationTo = reader.GetString(16), Quantity = reader.GetInt32(17), TransactionNumber = reader.GetString(18), LotNumber = reader.GetString(19) }); }
protected override Customer GetModel(FirebirdSql.Data.FirebirdClient.FbDataReader reader) { return(new Customer { ShopCode = reader.GetString(0), Client = reader.GetInt32(1), Name = reader.GetString(2), FirstName = reader.GetString(3), Address1 = reader.GetString(4), Address2 = reader.GetString(5), Address3 = reader.GetString(6), Email = reader.GetString(7), PostCode = reader.GetString(8), City = reader.GetString(9), TelephonePersonal = reader.GetString(10), TelephoneBusiness = reader.GetString(11), BirthDay = reader.GetDateTime(12), CreditCard = reader.GetString(13), TotalAmountSpend = reader.GetDecimal(14), FirstBuy = reader.GetDateTime(15), LastBuy = reader.GetDateTime(16), CreationTime = reader.GetDateTime(17), LastModificationTime = reader.GetDateTime(18) }); }