public GetProductVariantsFromFileResult ValidateFile(Stream rawFile)
{
var items = new List <BulkStockUpdateDataTransferObject>();
var errors = new List <string>();
if (rawFile != null)
{
using (var file = new CsvReader(new StreamReader(rawFile)))
{
while (file.Read())
{
if (file.FieldHeaders.Length == 4)
{
return(GetProductVariantsFromFileResult.Failure(new List <string>
{
"You have attempted to import a file in the warehoused stock format into the simple stock updater."
}));
}
string sku = file.GetField <string>(1),
name = file.GetField <string>(0);
string handle = name ?? sku;
var pv = new BulkStockUpdateDataTransferObject
{
Name = name,
SKU = sku
};
if (sku.HasValue())
{
pv.SKU = sku;
}
else
{
errors.Add(string.Format("SKU is required for {0}.", handle));
}
var stockValue = file.GetField <string>(2);
int stockRemaining;
if (int.TryParse(stockValue, out stockRemaining))
{
pv.StockRemaining = stockRemaining;
}
else
{
errors.Add(string.Format("Stock value for {0} is not a valid number.", handle));
}
items.Add(pv);
}
}
}
return(errors.Any()
? GetProductVariantsFromFileResult.Failure(errors)
: GetProductVariantsFromFileResult.Success(items));
}
public List <BulkStockUpdateDataTransferObject> ValidateAndBulkStockUpdateProductVariants(Stream rawFile,
ref Dictionary <string, List <string> > parseErrors)
{
var items = new List <BulkStockUpdateDataTransferObject>();
if (rawFile != null)
{
using (var file = new CsvReader(new StreamReader(rawFile)))
{
while (file.Read())
{
string sku = file.GetField <string>(1),
name = file.GetField <string>(0);
string handle = sku.HasValue() ? sku : SeoHelper.TidyUrl(name);
if (parseErrors.All(x => x.Key != handle))
{
parseErrors.Add(handle, new List <string>());
}
var pv = new BulkStockUpdateDataTransferObject
{
Name = file.GetField <string>(0),
SKU = file.GetField <string>(1)
};
if (file.GetField <string>(1).HasValue())
{
pv.SKU = file.GetField <string>(1);
}
else
{
parseErrors[handle].Add("SKU is required.");
}
if (!GeneralHelper.IsValidInput <int>(file.GetField <string>(2)))
{
parseErrors[handle].Add("Stock value is not a valid number.");
}
else
{
pv.StockRemaining = file.GetField <string>(2).HasValue()
? Int32.Parse(file.GetField <string>(2))
: 0;
}
items.Add(pv);
}
}
}
parseErrors = parseErrors.Where(x => x.Value.Any()).ToDictionary(pair => pair.Key, pair => pair.Value);
return(items);
}