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); } }