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