/* Заносим данные в List<AdvertisingProductsModel> */
private void SetSponsoredProductsToList(IDataRecord record)
{
AdvertisingProductsModel adprModel = new AdvertisingProductsModel();
advprodList.Add(adprModel);
for (int i = 0; i < record.FieldCount; i++)
{
advprodList[advprodList.Count - 1].WriteData(i, record[i]);
}
}
/* Загружаем новые ключи из файла для Sponsored Products */
public void OpenNewFileForSponsoredProducts(string _fileName)
{
advProductsList.Clear();
try
{
FileInfo existingFile = new FileInfo(@_fileName);
using (ExcelPackage package = new ExcelPackage(existingFile))
{
//get the first worksheet in the workbook
ExcelWorksheet worksheet = package.Workbook.Worksheets[1];
int colCount = worksheet.Dimension.End.Column; //get Column Count
int rowCount = worksheet.Dimension.End.Row; //get row count
for (int row = 2; row <= rowCount; row++)
{
AdvertisingProductsModel prModel = new AdvertisingProductsModel();
advProductsList.Add(prModel);
UpdateDate = worksheet.Cells[row, 1].GetValue <DateTime>();
datesList.Add(worksheet.Cells[row, 1].GetValue <DateTime>());
advProductsList[advProductsList.Count - 1].WriteData(0, UpdateDate);
advProductsList[advProductsList.Count - 1].WriteData(1, ChechForNull(worksheet, row, 3)); //[CurrencyCharCode]
advProductsList[advProductsList.Count - 1].WriteData(2, ChechForNull(worksheet, row, 4)); //[CampaignName]
advProductsList[advProductsList.Count - 1].WriteData(3, ChechForNull(worksheet, row, 5)); //[AdGroupName]
advProductsList[advProductsList.Count - 1].WriteData(4, ChechForNull(worksheet, row, 6)); //[Targeting]
advProductsList[advProductsList.Count - 1].WriteData(5, ChechForNull(worksheet, row, 7)); //[MatchType]
advProductsList[advProductsList.Count - 1].WriteData(6, ChechForNull(worksheet, row, 8)); //[Impressions]
advProductsList[advProductsList.Count - 1].WriteData(7, ChechForNull(worksheet, row, 9)); //[Clicks]
advProductsList[advProductsList.Count - 1].WriteData(8, ChechForNull(worksheet, row, 10)); //[CTR]
advProductsList[advProductsList.Count - 1].WriteData(9, ChechForNull(worksheet, row, 11)); //[CPC]
advProductsList[advProductsList.Count - 1].WriteData(10, ChechForNull(worksheet, row, 12)); //[Spend]
advProductsList[advProductsList.Count - 1].WriteData(11, ChechForNull(worksheet, row, 15)); //[Sales]
advProductsList[advProductsList.Count - 1].WriteData(12, ChechForNull(worksheet, row, 13)); //[ACoS]
advProductsList[advProductsList.Count - 1].WriteData(13, ChechForNull(worksheet, row, 14)); //[RoAS]
advProductsList[advProductsList.Count - 1].WriteData(14, ChechForNull(worksheet, row, 16)); //[Orders]
advProductsList[advProductsList.Count - 1].WriteData(15, ChechForNull(worksheet, row, 17)); //[Units]
advProductsList[advProductsList.Count - 1].WriteData(16, ChechForNull(worksheet, row, 18)); //[ConversionRate]
advProductsList[advProductsList.Count - 1].WriteData(17, ChechForNull(worksheet, row, 19)); //[AdvSKUUnits]
advProductsList[advProductsList.Count - 1].WriteData(18, ChechForNull(worksheet, row, 20)); //[OtherSKUUnits]
advProductsList[advProductsList.Count - 1].WriteData(19, ChechForNull(worksheet, row, 21)); //[AdvSKUSales]
advProductsList[advProductsList.Count - 1].WriteData(20, ChechForNull(worksheet, row, 22)); //[OtherSKUSales]
}
}
StartDate = datesList.Min();
EndDate = datesList.Max().AddHours(23).AddMinutes(59).AddSeconds(59);
}
catch (Exception ex)
{
richTextBox2.Text = "Проблема при открытии файла. Убедитесь, что Вы выбрали файл с нужны расширением. Возможно, разметка файла не поддерживается программой.";
advProductsList.Clear();
}
}
private void LoadManyFilesStepByStep_AP(string _filename)
{
advProductsList.Clear();
try
{
FileInfo existingFile = new FileInfo(@_filename);
using (ExcelPackage package = new ExcelPackage(existingFile))
{
//get the first worksheet in the workbook
ExcelWorksheet worksheet = package.Workbook.Worksheets[1];
int colCount = worksheet.Dimension.End.Column; //get Column Count
int rowCount = worksheet.Dimension.End.Row; //get row count
for (int row = 2; row <= rowCount; row++)
{
AdvertisingProductsModel prModel = new AdvertisingProductsModel();
advProductsList.Add(prModel);
advProductsList[advProductsList.Count - 1].WriteData(0, worksheet.Cells[row, 1].GetValue <DateTime>());
advProductsList[advProductsList.Count - 1].WriteData(1, ChechForNull(worksheet, row, 4)); //[CurrencyCharCode]
advProductsList[advProductsList.Count - 1].WriteData(2, ChechForNull(worksheet, row, 5)); //[CampaignName]
advProductsList[advProductsList.Count - 1].WriteData(3, ChechForNull(worksheet, row, 6)); //[AdGroupName]
advProductsList[advProductsList.Count - 1].WriteData(4, ChechForNull(worksheet, row, 7)); //[Targeting]
advProductsList[advProductsList.Count - 1].WriteData(5, ChechForNull(worksheet, row, 8)); //[MatchType]
advProductsList[advProductsList.Count - 1].WriteData(6, ChechForNull(worksheet, row, 9)); //[Impressions]
advProductsList[advProductsList.Count - 1].WriteData(7, ChechForNull(worksheet, row, 10)); //[Clicks]
advProductsList[advProductsList.Count - 1].WriteData(8, ChechForNull(worksheet, row, 11)); //[CTR]
advProductsList[advProductsList.Count - 1].WriteData(9, ChechForNull(worksheet, row, 12)); //[CPC]
advProductsList[advProductsList.Count - 1].WriteData(10, ChechForNull(worksheet, row, 13)); //[Spend]
advProductsList[advProductsList.Count - 1].WriteData(11, ChechForNull(worksheet, row, 16)); //[Sales]
advProductsList[advProductsList.Count - 1].WriteData(12, ChechForNull(worksheet, row, 14)); //[ACoS]
advProductsList[advProductsList.Count - 1].WriteData(13, ChechForNull(worksheet, row, 15)); //[RoAS]
advProductsList[advProductsList.Count - 1].WriteData(14, ChechForNull(worksheet, row, 17)); //[Orders]
advProductsList[advProductsList.Count - 1].WriteData(15, ChechForNull(worksheet, row, 18)); //[Units]
advProductsList[advProductsList.Count - 1].WriteData(16, ChechForNull(worksheet, row, 19)); //[ConversionRate]
advProductsList[advProductsList.Count - 1].WriteData(17, ChechForNull(worksheet, row, 20)); //[AdvSKUUnits]
advProductsList[advProductsList.Count - 1].WriteData(18, ChechForNull(worksheet, row, 21)); //[OtherSKUUnits]
advProductsList[advProductsList.Count - 1].WriteData(19, ChechForNull(worksheet, row, 22)); //[AdvSKUSales]
advProductsList[advProductsList.Count - 1].WriteData(20, ChechForNull(worksheet, row, 23)); //[OtherSKUSales]
//}
}
}
}
catch (Exception ex) { }
}
/* Public метод для занесения товаров, которые потом нужно будет обновить, из AdvertisingController */
public void AddProductForUpdate(AdvertisingProductsModel _apm)
{
advProductsListForUpdate.Add(_apm);
}