public void RemoveSelectedListItems()
{
var selectedList = new ArrayList(SpecailSelected);
foreach (var o in selectedList.ToArray())
{
SpecailOrders.Remove(o as SpecailOrders);
Cordners.Add(o as SpecailOrders);
}
}
public void GenerateSpecailOrders(object sender, DoWorkEventArgs e)
{
try
{
GenerateButton = "Generating...";
var count = 0;
var csv = new StringBuilder();
var headers = $"{"sku"},{"special_price"},{"euro_special_price"},{"usd_special_price"},{"special_from_date"},{"special_to_date"},{"special_price-no"},{"special_to_date-no"},{"special_from_date-no"},{"euro_special_price-no"},{"usd_special_price-no"},{"RRP"},{"RRP_Euro"}";
csv.AppendLine(headers);
var stamp = DateTime.Now.Millisecond;
var skuData = _specailOrdersService.RetrieveAllSkuData();
if (SpecailOrders.Count() == 0)
{
MessageBox.Show("No Stock Items have been selected. \n Please move columns to the right for processing.");
return;
}
//for (int i = 0; i < 2; i ++)
//{
// if(i == 1)
// {
//File.AppendAllText(System.Configuration.ConfigurationManager.AppSettings["SalesPriceOutput"] + stamp + ".csv", csv.ToString());
//foreach (var specailOrder in SpecailOrders)
//{
// if (count >= 100)
// {
// count = 1;
// }
// count++;
// List<DataRow> dataRows = skuData.Tables[0].AsEnumerable().Where(x => (string)x["SKU"] == specailOrder.SKU).Distinct().ToList();
// _specailOrdersService.GenerateCSVAsync(StartDate.ToString("yyyy-MM-dd"), EndDate.ToString("yyyy-MM-dd"),
// stamp,
// dataRows,
// Convert.ToDecimal(AdjustPrice), AdjustPricePercentage);
// worker.ReportProgress(count);
//}
//}
//else
//{
File.AppendAllText(System.Configuration.ConfigurationManager.AppSettings["SalesPriceOutput"] + stamp + ".csv", csv.ToString());
var euro_price = _specailOrdersService.GetEuroPrice();
foreach (var specailOrder in SpecailOrders)
{
if (count >= 100)
{
count = 1;
}
count++;
List <DataRow> dataRows = skuData.Tables[0].AsEnumerable().Where(x => (string)x["NEWSTYLE"] == specailOrder.SKU).Distinct().ToList();
_specailOrdersService.GenerateCSVAsync(StartDate.ToString("yyyy-MM-dd"), EndDate.ToString("yyyy-MM-dd"),
stamp,
dataRows,
Convert.ToDecimal(AdjustPrice), AdjustPricePercentage, euro_price);
worker.ReportProgress(count);
}
//}
csv = new StringBuilder();
csv.AppendLine(headers);
//}
worker.ReportProgress(100);
AdjustPrice = 0;
GenerateButton = "Generate";
MessageBox.Show("Sales Price CSV Generated to Input/Output Folder");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
