public void ReloadForm()
{
cmbStatisticsBy.SelectedIndex = 0;
txbYear.Text = DateTime.Now.Year.ToString();
BtnLoad.PerformClick();
}
private async void BtnExport_Click(object sender, EventArgs e)
{
var saveFileDialog = new SaveFileDialog
{
Filter = @"Excel Files (*.xlsx)|*.xlsx",
FilterIndex = 1
};
if (saveFileDialog.ShowDialog() != DialogResult.OK)
{
return;
}
var filename = saveFileDialog.FileName;
lblSaveState.SetPropertyValue(a => a.Text, "Exporting please wait...");
btnExport.SetPropertyValue(a => a.Enabled, false);
BtnLoad.SetPropertyValue(a => a.Enabled, false);
await Task.Run(() =>
{
try
{
using var wb = new XLWorkbook();
wb.Worksheets.Add(_myDataTable, "MTN Billing");
wb.Worksheet(1).ShowRowColHeaders = true;
wb.Worksheet(1).Column(1).DataType = XLDataType.Text;
wb.Worksheet(1).Column(2).DataType = XLDataType.Text;
wb.Worksheet(1).Column(3).DataType = XLDataType.Text;
wb.Worksheet(1).Column(4).DataType = XLDataType.Text;
wb.Worksheet(1).Column(5).DataType = XLDataType.Text;
wb.Worksheet(1).Column(6).DataType = XLDataType.Text;
wb.SaveAs(filename);
}
catch (Exception exception)
{
Console.WriteLine(exception);
}
}).ConfigureAwait(false);
lblSaveState.SetPropertyValue(a => a.Text, "Export completed...");
btnExport.SetPropertyValue(a => a.Enabled, true);
BtnLoad.SetPropertyValue(a => a.Enabled, true);
}
protected override void RegisterUIEvent()
{
BtnIntpuSet.AddCallback(new UnityEngine.Events.UnityAction(() =>
{
UIMgr.OpenPanel <InputSetList>();
}));
BtnStart.AddCallback(new UnityEngine.Events.UnityAction(() =>
{
GlobalManager.Instance.InitMainScene(1);
}));
BtnAudioSet.AddCallback(() =>
{
UIMgr.OpenPanel <AudioSettingPanel>();
});
BtnLoad.AddCallback(() =>
{
UIMgr.OpenPanel <LevelPanel>();
});
}