private void Apply_Click(object sender, RoutedEventArgs e)
{
#if DEBUG
List <string> titleList = new List <string>();
List <string> contentList = new List <string>();
foreach (var item in Histories)
{
titleList.Add(item.Title);
contentList.Add(item.Description);
}
IExcel excel = ExcelFactory.GetExcel();
excel.SaveHistory(CharToIntColumnName(ConfigExcelFormat.TitleColumn), CharToIntColumnName(ConfigExcelFormat.ContentColumn), titleList, contentList);
#endif
}
private void Refresh_Click(object sender, RoutedEventArgs e)
{
Histories = new ObservableCollection <HistoryGridModel>();
List <string> titleList = new List <string>();
List <string> contentList = new List <string>();
var instance = ExcelFactory.GetExcel();
instance.ReadHistory(CharToIntColumnName(ConfigExcelFormat.TitleColumn), CharToIntColumnName(ConfigExcelFormat.ContentColumn), titleList, contentList);
for (int i = 0; i < titleList.Count; i++)
{
Histories.Add(new HistoryGridModel()
{
Title = titleList[i], Description = contentList[i]
});
}
((System.Windows.Controls.Grid) this.Parent).Children.Add(new UserControlHistory());
}
private void Bt_Apply_Click(object sender, RoutedEventArgs e)
{
if (System.IO.File.Exists(TB_Excel_Path.Text))
{
try
{
using (FileStream fs = File.OpenRead(TB_Excel_Path.Text)) { }
}
catch (IOException)
{
MessageBox.Show("The file is opened by another application");
return;
}
var instance = ExcelFactory.GetExcel();
instance.GetPath(TB_Excel_Path.Text);
}
else
{
try
{
if (!Directory.Exists(TB_Work_Path.Text))
{
Directory.CreateDirectory(TB_Work_Path.Text);
}
}
catch
{
Error_Info.Content = "Please enter the correct work path";
return;
}
if (!(System.IO.Path.GetExtension(TB_Excel_Path.Text) == ".xlsx"))
{
Error_Info.Content = "The Excel Path is not a valid Excel file";
return;
}
try
{
var instance = ExcelFactory.GetExcel();
instance.GetPath(TB_Excel_Path.Text);
}
catch (DirectoryNotFoundException err)
{
Error_Info.Content = $"Can't create excel at {TB_Excel_Path.Text}, {err.Message}";
return;
}
catch (NotSupportedException err)
{
Error_Info.Content = $"The format for path is invalid, {err.Message}";
return;
}
catch (Exception err)
{
Error_Info.Content = $"{err.Message}";
return;
}
}
try
{
if (!Directory.Exists(TB_Work_Path.Text))
{
Directory.CreateDirectory(TB_Work_Path.Text);
}
WorkPath.DefalutWorkPath = TB_Work_Path.Text;
}
catch
{
Error_Info.Content = "Please enter the correct work path";
return;
}
this.Close();
}