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