/// <summary>
/// Формирование списка изображений
/// </summary>
/// <param name="__id"></param>
/// <returns></returns>
private List <ImageResource> GetImagesList(int __id)
{
List <ImageResource> imgList = new List <ImageResource>();
// Извлекаем данные из БД
dsParserTableAdapters.tInventImagesTableAdapter ta = new dsParserTableAdapters.tInventImagesTableAdapter();
dsParser.tInventImagesDataTable tbl = ta.GetDataByInventItemId(__id);
foreach (dsParser.tInventImagesRow row in tbl)
{
imgList.Add(new ImageResource(__id, row.Url, ExportFile.FilePath.FullName));
}
return(imgList);
}
/// <summary>
/// Записывает данные товара в БД
/// </summary>
public void RegisterInventItem()
{
if (Url.Length > 0 && Parent != null)
{
dsParserTableAdapters.tInventItemsTableAdapter taInventItems = new dsParserTableAdapters.tInventItemsTableAdapter();
dsParser.tInventItemsDataTable tblInventItems = taInventItems.GetDataByUrl(Url);
dsParser.tInventItemsRow rowInventItems;
if (tblInventItems.Rows.Count > 0)
{
rowInventItems = (dsParser.tInventItemsRow)tblInventItems.Rows[0];
}
else
{
rowInventItems = tblInventItems.NewtInventItemsRow();
rowInventItems.Url = Url;
}
// Обновление данных товара
rowInventItems.ParentId = Parent.Id;
rowInventItems.Name = Name;
rowInventItems.ShortDescr = ShortDescr;
rowInventItems.Descr = Descr;
rowInventItems.OldPrice = (decimal)OldPrice;
rowInventItems.Price = (decimal)Price;
if (rowInventItems.RowState == System.Data.DataRowState.Detached)
{
tblInventItems.Rows.Add(rowInventItems);
}
taInventItems.Update(tblInventItems);
// Сохранение данных о картинках
dsParserTableAdapters.tInventImagesTableAdapter taImages = new dsParserTableAdapters.tInventImagesTableAdapter();
dsParser.tInventImagesDataTable tblImages;
dsParser.tInventImagesRow rowImages;
foreach (string imageUrl in Images)
{
tblImages = taImages.GetDataByUrl(rowInventItems.Id, imageUrl);
if (tblImages.Rows.Count == 0)
{
rowImages = tblImages.NewtInventImagesRow();
rowImages.InventItemId = rowInventItems.Id;
rowImages.Url = imageUrl;
tblImages.Rows.Add(rowImages);
taImages.Update(tblImages);
}
}
// Сохранение данных о характеристиках
dsParserTableAdapters.tInventOptionsTableAdapter taOptions = new dsParserTableAdapters.tInventOptionsTableAdapter();
dsParser.tInventOptionsDataTable tblOptions;
dsParser.tInventOptionsRow rowOptions;
foreach (InventItemOption optionItem in Options)
{
tblOptions = taOptions.GetDataByName(rowInventItems.Id, optionItem.Name);
if (tblOptions.Rows.Count > 0)
{
rowOptions = (dsParser.tInventOptionsRow)tblOptions.Rows[0];
}
else
{
rowOptions = tblOptions.NewtInventOptionsRow();
rowOptions.InventItemId = rowInventItems.Id;
rowOptions.Name = optionItem.Name;
}
rowOptions.Value = optionItem.Value;
if (rowOptions.RowState == System.Data.DataRowState.Detached)
{
tblOptions.Rows.Add(rowOptions);
}
taOptions.Update(tblOptions);
}
}
}
