public List<FbaInventoryQuantity> LoadInventoryFromFile(string fileName)
{
List<FbaInventoryQuantity> fbaQuantities = new List<FbaInventoryQuantity>();
using (StreamReader file = new StreamReader(fileName))
{
string[] headers = file.ReadLine().Split('\t');
int colSku = -1;
int colAsin = -1;
int colFnsku = -1;
int colFulfillable = -1;
int colTotal = -1;
int colInboundShipped = -1;
int colInboundWorking = -1;
int colInboundReceiving = -1;
// Find headers' column indexes
for (int i = 0; i < headers.Length; i++)
{
if (headers[i].Equals("sku"))
colSku = i;
else if (headers[i].Equals("asin"))
colAsin = i;
else if (headers[i].Equals("fnsku"))
colFnsku = i;
else if (headers[i].Equals("afn-fulfillable-quantity"))
colFulfillable = i;
else if (headers[i].Equals("afn-total-quantity"))
colTotal = i;
else if (headers[i].Equals("afn-inbound-working-quantity"))
colInboundWorking = i;
else if (headers[i].Equals("afn-inbound-shipped-quantity"))
colInboundShipped = i;
else if (headers[i].Equals("afn-inbound-receiving-quantity"))
colInboundReceiving = i;
}
string line;
while ((line = file.ReadLine()) != null)
{
FbaInventoryQuantity fbaQuantity = new FbaInventoryQuantity();
string[] delimitedLine = line.Split('\t');
fbaQuantity.Sku = delimitedLine[colSku];
fbaQuantity.Asin = delimitedLine[colAsin];
fbaQuantity.Fnsku = delimitedLine[colFnsku];
fbaQuantity.FulfillableQuantity = int.Parse(delimitedLine[colFulfillable]);
fbaQuantity.TotalQuantity = int.Parse(delimitedLine[colTotal]);
fbaQuantity.InboundWorkingQuantity = int.Parse(delimitedLine[colInboundWorking]);
fbaQuantity.InboundShippedQuantity = int.Parse(delimitedLine[colInboundShipped]);
fbaQuantity.InboundReceivingQuantity = int.Parse(delimitedLine[colInboundReceiving]);
fbaQuantities.Add(fbaQuantity);
}
}
return fbaQuantities;
}
public List <FbaInventoryQuantity> LoadInventoryFromFile(string fileName)
{
List <FbaInventoryQuantity> fbaQuantities = new List <FbaInventoryQuantity>();
using (StreamReader file = new StreamReader(fileName))
{
string[] headers = file.ReadLine().Split('\t');
int colSku = -1;
int colAsin = -1;
int colFnsku = -1;
int colFulfillable = -1;
int colTotal = -1;
int colInboundShipped = -1;
int colInboundWorking = -1;
int colInboundReceiving = -1;
// Find headers' column indexes
for (int i = 0; i < headers.Length; i++)
{
if (headers[i].Equals("sku"))
{
colSku = i;
}
else if (headers[i].Equals("asin"))
{
colAsin = i;
}
else if (headers[i].Equals("fnsku"))
{
colFnsku = i;
}
else if (headers[i].Equals("afn-fulfillable-quantity"))
{
colFulfillable = i;
}
else if (headers[i].Equals("afn-total-quantity"))
{
colTotal = i;
}
else if (headers[i].Equals("afn-inbound-working-quantity"))
{
colInboundWorking = i;
}
else if (headers[i].Equals("afn-inbound-shipped-quantity"))
{
colInboundShipped = i;
}
else if (headers[i].Equals("afn-inbound-receiving-quantity"))
{
colInboundReceiving = i;
}
}
string line;
while ((line = file.ReadLine()) != null)
{
FbaInventoryQuantity fbaQuantity = new FbaInventoryQuantity();
string[] delimitedLine = line.Split('\t');
fbaQuantity.Sku = delimitedLine[colSku];
fbaQuantity.Asin = delimitedLine[colAsin];
fbaQuantity.Fnsku = delimitedLine[colFnsku];
fbaQuantity.FulfillableQuantity = int.Parse(delimitedLine[colFulfillable]);
fbaQuantity.TotalQuantity = int.Parse(delimitedLine[colTotal]);
fbaQuantity.InboundWorkingQuantity = int.Parse(delimitedLine[colInboundWorking]);
fbaQuantity.InboundShippedQuantity = int.Parse(delimitedLine[colInboundShipped]);
fbaQuantity.InboundReceivingQuantity = int.Parse(delimitedLine[colInboundReceiving]);
fbaQuantities.Add(fbaQuantity);
}
}
return(fbaQuantities);
}
