private List <ShoppingLink> ReadTextFile(string filePath)
{
try
{
var lines = FileHelper.GetDataFromFile(filePath);
if (lines == null || lines.Count <= 0)
{
return(null);
}
var lst = new List <ShoppingLink>();
for (var i = 0; i < lines.Count - 1; i = i + 2)
{
if (string.IsNullOrEmpty(DataUtil.StringForNull(lines[i])))
{
continue;
}
var url = DataUtil.StringForNull(lines[i]).Trim();
var size = DataUtil.StringForNull(lines[i + 1]).Trim();
if (string.IsNullOrEmpty(url))
{
continue;
}
var item = new ShoppingLink {
OrderNo = i, Url = url, Size = size
};
lst.Add(item);
}
return(lst);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(null);
}
}
private void SetShoppingLink(ShoppingLink link)
{
var sizes = SizeSource.Data;
if (string.IsNullOrEmpty(link.Url))
{
return;
}
var url = link.Url;
var importedSize = "03.5";
if (sizes.Contains(link.Size))
{
importedSize = link.Size;
}
else if (sizes.Contains(link.Size1))
{
importedSize = link.Size1;
}
else if (sizes.Contains(link.Size2))
{
importedSize = link.Size2;
}
else if (sizes.Contains(link.Size3))
{
importedSize = link.Size3;
}
if (url.StartsWith(MockData.ChampsSportsHost))
{
txtChampUrl.Text = url;
cboChampSize.SelectedIndex = sizes.IndexOf(importedSize);
return;
}
if (url.StartsWith(MockData.EastbayViewHost))
{
txtEastbayUrl.Text = url;
cboEastbaySize.SelectedIndex = sizes.IndexOf(importedSize);
return;
}
if (url.StartsWith(MockData.FootactioHost))
{
txtFootactionUrl.Text = url;
cboFootactionSize.SelectedIndex = sizes.IndexOf(importedSize);
return;
}
if (url.StartsWith(MockData.FootLockerHost))
{
txtFootLockerUrl.Text = url;
cboFootLockerSize.SelectedIndex = sizes.IndexOf(importedSize);
}
}
//private void UpdateProgessBarValue(int value)
//{
// if (value < 0)
// {
// progressBarAll.Value = 0;
// return;
// }
// if (value > 100)
// {
// progressBarAll.Value = 100;
// return;
// }
// progressBarAll.Value = value;
//}
//private int GetTrackingProgess()
//{
// if (_dictStopTracking == null ) return 0;
// var remain = _dictStopTracking.Count - _dictStopTracking.Count(p => p.Value);
// if (remain <= 0) return 0;
// var progressBarValueRemaining = progressBarAll.Maximum - progressBarAll.Value;
// if (progressBarValueRemaining <= 0) return 100;
// return progressBarAll.Value + progressBarValueRemaining/remain;
//}
#endregion
#region import data
private List <ShoppingLink> ReadExcelFile(string filePath)
{
try
{
var stream = File.Open(filePath, FileMode.Open, FileAccess.Read);
var excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
excelReader.IsFirstRowAsColumnNames = true;
var dataSet = excelReader.AsDataSet();
var dt = dataSet.Tables[0];
if (dt == null || dt.Rows.Count <= 0)
{
return(null);
}
var lst = new List <ShoppingLink>();
for (var i = 0; i < dt.Rows.Count; i++)
{
if (string.IsNullOrEmpty(DataUtil.StringForNull(dt.Rows[i][0])))
{
continue;
}
var url = DataUtil.StringForNull(dt.Rows[i][0]).Trim();
var size = DataUtil.StringForNull(dt.Rows[i][1]).Trim();
if (string.IsNullOrEmpty(url))
{
continue;
}
var item = new ShoppingLink {
OrderNo = i, Url = url, Size = size
};
lst.Add(item);
}
return(lst);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(null);
}
}
