public async Task <DataSet> ExecuteAsync(RequestCollection requests)
{
var watch = System.Diagnostics.Stopwatch.StartNew();
// the code that you want to measure comes here
this.LastError = "";
var ds = await DataProvider.ExcuteAsync(requests, SessionID); //await DataService.ExecuteAsync(requests, SessionID);
var table = ds.Tables[0];
if (table != null)
{
if (table.TableName == "Error")
{
var row = table.Rows[0];
var message = row["Message"].ToString();
var source = row["Source"].ToString();
var stackTrace = row["StackTrace"].ToString();
var helpLink = row["HelpLink"].ToString();
this.LastError = message;
ds = null;
}
}
watch.Stop();
var elapsedMs = watch.ElapsedMilliseconds;
Console.WriteLine(DateTime.Now.ToString() + "Total time load data from sql server=" + elapsedMs);
return(ds);
}
public async Task <DataSet> ExecuteAsync(RequestCollection requests)
{
if (clientServices == null)
{
clientServices = new ClientServices("");
}
return(await clientServices.ExecuteAsync(requests));
}
public static DataSet Excute(RequestCollection requests)
{
var session = Guid.NewGuid().ToString();
var response = new DataSet();
SqlTransaction transaction = null;
try
{
string connectString = string.Format(@"Server={0};User Id=sa;
Password=dkcnyh20081992;",QA.QAFunction.ReadFromConfigXMlFile("ServerName"));
using (SqlConnection connection = new SqlConnection(connectString))
{
connection.Open();
transaction = connection.BeginTransaction();
foreach (var request in requests)
{
var category = request["Attributes"]["Category"].Value;
var command = request["Attributes"]["Command"].Value;
var parameters = request["Parameters"];
if (command.StartsWith("ws_"))
{
if (ProcessNative(session, category, command, parameters, response) == false)
{
ProcessSql(connection, transaction, session, category, command, parameters, response);
}
}
}
transaction.Commit();
}
}
catch (Exception e)
{
var table = new DataTable("Error");
table.Columns.Add("Message");
table.Columns.Add("Source");
table.Columns.Add("StackTrace");
table.Columns.Add("HelpLink");
var row = table.NewRow();
row["Message"] = e.Message;
row["Source"] = e.Source;
row["StackTrace"] = e.StackTrace;
row["HelpLink"] = e.HelpLink;
table.Rows.Add(row);
response = new DataSet();
response.Tables.Add(table);
}
return response;
}
//private static string servername = "113.161.97.235,6969\\Kadence";
public DataSet Excute(RequestCollection requests)
{
var session = Guid.NewGuid().ToString();
var response = new DataSet();
SqlTransaction transaction = null;
try
{
using (SqlConnection connection = new SqlConnection(_serverString))
{
connection.Open();
transaction = connection.BeginTransaction();
foreach (var request in requests)
{
var category = request["Attributes"]["Category"].Value;
var command = request["Attributes"]["Command"].Value;
var parameters = request["Parameters"];
if (command.StartsWith("ws_"))
{
if (ProcessNative(session, category, command, parameters, response) == false)
{
ProcessSql(connection, transaction, session, category, command, parameters, response);
}
}
}
transaction.Commit();
}
}
catch (Exception e)
{
var table = new DataTable("Error");
table.Columns.Add("Message");
table.Columns.Add("Source");
table.Columns.Add("StackTrace");
table.Columns.Add("HelpLink");
var row = table.NewRow();
row["Message"] = e.Message;
row["Source"] = e.Source;
row["StackTrace"] = e.StackTrace;
row["HelpLink"] = e.HelpLink;
table.Rows.Add(row);
response = new DataSet();
response.Tables.Add(table);
}
return(response);
}
public static RequestCollection FromXml(string xml)
{
var result = new RequestCollection();
var docX = XDocument.Load(xml);
var requests = docX.Descendants("//Request");
foreach (XElement node in requests)
{
var request = new Request();
//var id = node.Value;
////var id = node.SelectSingleNode("Id").InnerText;
//request.Id = new Guid(id);
//var sections = node.SelectSingleNode("Sections");
//var sections = node.SelectSingleNode("Sections");
//if (sections != null)
//{
// foreach (XNode section_node in sections.ChildNodes)
// {
// var section = section_node.Name;
// foreach (XNode item in section_node.ChildNodes)
// {
// var item_isnull = Convert.ToBoolean(item.SelectSingleNode("IsNull").InnerText);
// var item_name = item.SelectSingleNode("Name").InnerText;
// var item_value = item.SelectSingleNode("Value").InnerText;
// if (item_isnull)
// item_value = null;
// request[section].Add(item_name, item_value);
// }
// }
//}
result += request;
}
return(result);
}
public static RequestCollection FromXml(string xml)
{
var result = new RequestCollection();
var doc = new XmlDocument();
doc.LoadXml(xml);
var requests = doc.SelectNodes("//Request");
foreach (XmlNode node in requests)
{
var request = new Request();
var id = node.SelectSingleNode("Id").InnerText;
request.Id = new Guid(id);
var sections = node.SelectSingleNode("Sections");
if (sections != null)
{
foreach (XmlNode section_node in sections.ChildNodes)
{
var section = section_node.Name;
foreach (XmlNode item in section_node.ChildNodes)
{
var item_isnull = Convert.ToBoolean(item.SelectSingleNode("IsNull").InnerText);
var item_name = item.SelectSingleNode("Name").InnerText;
var item_value = item.SelectSingleNode("Value").InnerText;
if (item_isnull)
{
item_value = null;
}
request[section].Add(item_name, item_value);
}
}
}
result += request;
}
return(result);
}
public DataSet Execute(RequestCollection requests, string sessionID)
{
return(DataProvider.Excute(requests, sessionID));
}
public async Task <DataSet> ExecuteAsync(RequestCollection requests, string sessionID)
{
return(await Task.Run(() => Execute(requests, sessionID)));
}
public static async Task <DataSet> ExcuteAsync(RequestCollection requests, string session)
{
var response = new DataSet();
SqlTransaction transaction = null;
string connectString = string.Format(@"Server={0};User Id=sa;
Password=@Dkcnyh20081992;", servername);
using (SqlConnection connection = new SqlConnection(connectString))
{
try
{
await connection.OpenAsync();
transaction = connection.BeginTransaction();
foreach (var request in requests)
{
var category = request["Attributes"]["Category"].Value;
var command = request["Attributes"]["Command"].Value;
var parameters = request["Parameters"];
if (1 == 1 || command.StartsWith("sp_"))
{
if (ProcessNative(session, category, command, parameters, response) == false)
{
await ProcessSqlAsync(connection, transaction, session, category, command, parameters, response);
}
}
}
transaction.Commit();
connection.Close();
}
catch (Exception e)
{
var table = new DataTable("Error");
table.Columns.Add("Message");
table.Columns.Add("Source");
table.Columns.Add("StackTrace");
table.Columns.Add("HelpLink");
var row = table.NewRow();
row["Message"] = e.Message;
row["Source"] = e.Source;
row["StackTrace"] = e.StackTrace;
row["HelpLink"] = e.HelpLink;
table.Rows.Add(row);
response = new DataSet();
response.Tables.Add(table);
}
finally
{
connection.Close();
}
}
return(response);
}