void EndAsync(IAsyncResult ar)
{
if (ar is ImportCompletedSyncResult)
{
return;
}
try
{
_Import = false;
_IsImportWork = false;
importCommand.EndExecuteNonQuery(ar);
}
catch
{
if (importConnection != null)
{
importConnection.Close();
}
UnSuccessfulImportMessageBox.Show();
}
}
protected void ImportButton_Click(object sender, EventArgs e)
{
if (!Frame.ImportUpload.HasFile)
{
NoFileMessageBox.Show();
return;
}
var savePath = Server.MapPath(@"~\Import\");
if (!Directory.Exists(savePath))
{
Directory.CreateDirectory(savePath);
}
var newPath = _Path = Path.Combine(savePath, Path.GetFileName(Frame.ImportUpload.FileName));
Frame.ImportUpload.SaveAs(newPath);
_Import = true;
this.Page.AddOnPreRenderCompleteAsync(new BeginEventHandler(BeginAsync), new EndEventHandler(EndAsync));
#if truef
try
{
using (var conn = new SqlConnection(Global.ConnectionString))
using (var cmd = new SqlCommand("EXEC [Import].[ImportData] @personID, @fileName, @add", conn))
{
cmd.CommandTimeout = 600;
cmd.Parameters.Add(
new SqlParameter
{
ParameterName = "personID",
DbType = System.Data.DbType.Int32,
Value = this.GetSystemUser()
});
cmd.Parameters.Add(
new SqlParameter
{
ParameterName = "fileName",
DbType = System.Data.DbType.String,
Value = newPath
});
cmd.Parameters.Add(
new SqlParameter
{
ParameterName = "add",
DbType = System.Data.DbType.String,
Value = int.Parse(ImportModeList.SelectedValue)
});
conn.Open();
cmd.ExecuteNonQuery();
SuccessfulImportMessageBox.Show();
}
}
catch
{
UnSuccessfulImportMessageBox.Show();
return;
}
#endif
}