/// <summary>
/// Bind Yanhoo Shops to ComboBox
/// </summary>
private void BindCombo()
{
PETC0301I_bl = new PETC0301I_BL();
DataTable dt = new DataTable();
dt = PETC0301I_bl.YahooShop_Combo();
cbo_YahooShop.DisplayMember = "Char1";
cbo_YahooShop.ValueMember = "Key";
cbo_YahooShop.DataSource = dt;
}
/// <summary>
/// Export CSV file
/// </summary>
private void F12()
{
if (ErrorCheck())
{
ShopId = cbo_YahooShop.SelectedValue.ToString();
startdate = txtStartDate.Text.Replace("/", "-");
enddate = txtEndDate.Text.Replace("/", "-");
DataTable dtYahoo = new DataTable();
PETC0301I_bl = new PETC0301I_BL();
dtYahoo = PETC0301I_bl.PECT0301I_Select(ShopId, startdate, enddate);
if (dtYahoo.Rows.Count > 0)
{
PETC0301I_bl = new PETC0301I_BL();
DataTable dtFolder = new DataTable();
dtFolder = PETC0301I_bl.GetFolder(ShopId);
string Folderpath = dtFolder.Rows[0]["Char2"].ToString();
if (!string.IsNullOrWhiteSpace(Folderpath))
{
if (!Directory.Exists(Folderpath))
{
Directory.CreateDirectory(Folderpath);
}
#region CSV create and save
SaveFileDialog savedialog = new SaveFileDialog();
savedialog.Filter = "CSV|*.csv";
savedialog.Title = "Save";
savedialog.FileName = dtFolder.Rows[0]["Char3"].ToString();
savedialog.InitialDirectory = dtFolder.Rows[0]["Char2"].ToString();
savedialog.RestoreDirectory = true;
if (savedialog.ShowDialog() == DialogResult.OK)
{
if (Path.GetExtension(savedialog.FileName).Contains("csv"))
{
CsvWriter csvwriter = new CsvWriter();
csvwriter.WriteCsv(dtYahoo, savedialog.FileName, Encoding.GetEncoding(932));
}
Process.Start(Path.GetDirectoryName(savedialog.FileName));
}
#endregion
}
}
else
{
MessageBox.Show("There's no data to export!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
