public BulkMaterialParseResult ParseMaterialPricesBulk(
int manufacturerId,
int supplierId,
DateTime date,
AlloyType alloyType,
RollType rollType,
bool remove,
string raw)
{
var materials = new List<RawMaterial>();
var errors = new List<string>();
try
{
using (var storage = new Storage())
{
if (remove)
{
var allThickness = storage.RawMaterials
.Where(
rm => rm.ManufacturerId == supplierId
&& (alloyType == AlloyType.Undefined || rm.RawMaterialType.AlloyType == alloyType)
&& (rollType == RollType.Undefined || rm.RawMaterialType.RollType == rollType)
)
.Select(rm => rm.RawMaterialType.Thickness.ToString(CultureInfo.InvariantCulture))
.ToList();
raw = string.Join("\t", allThickness)
+ "\n"
+ string.Join("\t", allThickness.Select(p => ""));
}
var lines = raw.Split('\n');
var headers = lines[0].Split('\t');
var prices = lines[1].Split('\t');
for (int i = 0; i < headers.Length; i++)
{
var thickness = Convert.ToDecimal(headers[i].FixDecimalSeparator());
if (!string.IsNullOrEmpty(prices[i]))
{
var rawMaterial = storage
.RawMaterials
.Where(
rm => rm.ManufacturerId == supplierId
&& rm.RawMaterialType.AlloyType == alloyType
&& rm.RawMaterialType.RollType == rollType
&& rm.RawMaterialType.Thickness == thickness)
.ToList();
if (!rawMaterial.Any())
{
errors.Add($"Выбранный поставщик не производит материала с такими параметрами и толщиной {thickness}");
continue;
}
if (rawMaterial.Count > 1)
{
errors.Add(
$"Выбранный поставщик производит более 1 материала с такими параметрами и толщиной {thickness}, невозможно определить нужный.");
continue;
}
var priceItem = new PriceItem
{
RawMaterialId = rawMaterial[0].RawMaterialId,
OwnerId = manufacturerId,
Date = date,
Price = remove
? null
: (decimal?)Convert.ToDecimal(prices[i].FixDecimalSeparator())
};
rawMaterial[0].PriceItems = new[]
{
priceItem
};
materials.Add(rawMaterial[0]);
}
}
}
}
catch (Exception ex)
{
_logger.Error(ex);
errors.Add("Ошибка синтаксического разбора строки.");
}
return new BulkMaterialParseResult
{
Errors = errors.ToArray(),
Materials = errors.Any()
? new RawMaterial[0]
: materials.ToArray()
};
}
public BulkProductParseResult ParseExtraPricesBulk(
int manufacturerId,
int supplierId,
DateTime date,
AlloyType alloyType,
RollType rollType,
int priceExtraCategoryId,
bool remove,
string raw)
{
var products = new List<Product>();
var errors = new List<string>();
if (remove)
{
raw = "0";
}
try
{
var lines = raw.Split(new [] {'\n'}, StringSplitOptions.RemoveEmptyEntries);
var headers = lines[0].Split('\t');
using (var storage = new Storage())
{
if (lines.Length == 1 && headers.Length == 1)
{
var price = Convert.ToDecimal(raw.Trim().FixDecimalSeparator());
return new BulkProductParseResult
{
Errors = new string[0],
Products = storage
.Products
.Where(
p =>
p.ManufacturerId == manufacturerId
&& p.RawMaterial.ManufacturerId == supplierId
&& (alloyType == AlloyType.Undefined || p.RawMaterial.RawMaterialType.AlloyType == alloyType)
&& (rollType == RollType.Undefined || p.RawMaterial.RawMaterialType.RollType == rollType)
)
.ToList()
.Select(
p =>
{
p.PriceExtras = new[]
{
new PriceExtra
{
PriceExtraCategoryId = priceExtraCategoryId,
PriceItems = new[]
{
new PriceItem
{
Date = date,
OwnerId = manufacturerId,
Price = price,
}
}
}
};
return p;
})
.ToArray()
};
}
for (int lineId = 1; lineId < lines.Length; lineId++)
{
var prices = lines[lineId].Split('\t');
var productName = prices[0].Trim();
for (int colId = 1; colId < headers.Length; colId++)
{
var thickness = Convert.ToDecimal(headers[colId].FixDecimalSeparator());
var query = storage
.RawMaterials
.LoadWith(rm => rm.RawMaterialType)
.Where(
rm => rm.ManufacturerId == supplierId
&& rm.RawMaterialType.Thickness == thickness);
if (alloyType != AlloyType.Undefined)
{
query = query.Where(rm => rm.RawMaterialType.AlloyType == alloyType);
}
if (rollType != RollType.Undefined)
{
query = query.Where(rm => rm.RawMaterialType.RollType == rollType);
}
var rawMaterials = query.ToList();
if (!rawMaterials.Any())
{
errors.Add($"Выбранный поставщик не производит материала с такими параметрами и толщиной {thickness}");
continue;
}
foreach (var rawMaterial in rawMaterials)
{
var product = storage
.Products
.SingleOrDefault(
p => p.ManufacturerId == manufacturerId
&& p.RawMaterialId == rawMaterial.RawMaterialId
&& p.Name == productName);
if (null == product)
{
product = new Product
{
ManufacturerId = manufacturerId,
RawMaterialId = rawMaterial.RawMaterialId,
Thickness = rawMaterial.RawMaterialType.Thickness,
Name = productName,
};
}
var priceExtra = new PriceExtra
{
PriceExtraCategoryId = priceExtraCategoryId,
ProductId = product.ProductId,
};
var price = string.IsNullOrEmpty(prices[colId])
? null
: (decimal?)Convert.ToDecimal(prices[colId].FixDecimalSeparator());
var priceItem = new PriceItem
{
OwnerId = manufacturerId,
Date = date,
Price = remove ? null : price,
};
priceExtra.PriceItems = new[]
{
priceItem
};
product.PriceExtras = new[]
{
priceExtra
};
products.Add(product);
if (!string.IsNullOrEmpty(prices[colId]))
{
}
}
}
}
}
}
catch (Exception ex)
{
_logger.Error(ex);
errors.Add("Ошибка синтаксического разбора строки.");
}
return new BulkProductParseResult
{
Errors = errors.ToArray(),
Products = errors.Any()
? new Product[0]
: products.ToArray()
};
}
public void SetRetailPrice(int productId, DateTime date, decimal? price)
{
Argument.Require(productId > 0, "Price extra id is required.");
Argument.Require(date > DateTime.MinValue, "Price date is required.");
Argument.Require(null == price || price.Value >= 0, "Price should be >= 0");
using (var storage = new Storage())
{
var product = storage
.Products
.LoadWith(p => p.RawMaterial.RawMaterialType)
.SingleOrDefault(pe => pe.ProductId == productId);
if (null == product)
throw new InvalidOperationException($"Product with id {productId} not found.");
var alloyType = product.RawMaterial.RawMaterialType.AlloyType;
var rollType = product.RawMaterial.RawMaterialType.RollType;
if (alloyType == AlloyType.Undefined
|| rollType == RollType.Undefined)
{
throw new InvalidOperationException("Для сохранения цен поля Тип проката и Тип продукта обязательны.");
}
var existingPriceItem = storage
.PriceItems
.SingleOrDefault(
pi =>
pi.PriceType == PriceType.RetailPrice
&& pi.Product.RawMaterial.RawMaterialType.AlloyType == alloyType
&& pi.Product.RawMaterial.RawMaterialType.RollType == rollType
&& pi.Product.Thickness == product.Thickness
&& pi.Product.Name == product.Name
);
if (null != existingPriceItem)
{
existingPriceItem.Price = price;
storage.Update(existingPriceItem);
}
else
{
var priceItem = new PriceItem
{
PriceType = PriceType.RetailPrice,
ProductId = productId,
Date = date,
Price = price,
};
storage.Insert(priceItem);
}
UpdatePriceCache(storage, productId, date);
}
}
public void SetExtraPrice(int priceExtraId, int ownerId, DateTime date, decimal? price)
{
Argument.Require(priceExtraId > 0, "Price extra id is required.");
Argument.Require(ownerId > 0, "Owner id is required.");
Argument.Require(date > DateTime.MinValue, "Price date is required.");
Argument.Require(null == price || price.Value >= 0, "Price should be >= 0");
using (var storage = new Storage())
{
var priceExtra = storage
.PriceExtras
.SingleOrDefault(pe => pe.PriceExtraId == priceExtraId);
if(null == priceExtra)
throw new InvalidOperationException($"Price extra with id {priceExtraId} not found.");
var existingPriceItem = storage
.PriceItems
.SingleOrDefault(pi => pi.PriceExtraId == priceExtraId && pi.OwnerId == ownerId && pi.Date == date);
if (null != existingPriceItem)
{
existingPriceItem.Price = price;
storage.Update(existingPriceItem);
}
else
{
var priceItem = new PriceItem
{
ProductId = priceExtra.ProductId,
PriceType = PriceType.PriceExtra,
PriceExtraId = priceExtraId,
Date = date,
OwnerId = ownerId,
Price = price,
};
storage.Insert(priceItem);
}
UpdatePriceCache(storage, priceExtra.ProductId, date);
}
}
public void SetMaterialPrice(int rawMaterialId, int ownerId, DateTime date, decimal? price)
{
Argument.Require(rawMaterialId > 0, "Raw material identifier is required.");
Argument.Require(ownerId > 0, "Owner identifier is required.");
Argument.Require(date > DateTime.MinValue, "Date is required.");
Argument.Require(null == price || price.Value >= 0, "Price should be >= 0.");
using (var storage = new Storage())
{
var priceExtra = storage
.RawMaterials
.SingleOrDefault(pe => pe.RawMaterialId == rawMaterialId);
if (null == priceExtra)
throw new InvalidOperationException($"Raw material with id {rawMaterialId} not found.");
var existingPriceItem = storage
.PriceItems
.SingleOrDefault(pi => pi.RawMaterialId == rawMaterialId && pi.OwnerId == ownerId && pi.Date == date);
if (null != existingPriceItem)
{
existingPriceItem.Price = price;
storage.Update(existingPriceItem);
}
else
{
var priceItem = new PriceItem
{
PriceType = PriceType.RawMaterial,
RawMaterialId = rawMaterialId,
Date = date,
OwnerId = ownerId,
Price = price,
};
storage.Insert(priceItem);
}
var products = storage
.Products
.Where(product => product.ManufacturerId == ownerId && product.RawMaterialId == rawMaterialId)
.Select(p => p.ProductId)
.ToList();
foreach (var productId in products)
{
UpdatePriceCache(storage, productId, date);
}
}
}
