public Response Exec(IDBConnection con, string SP, params IDBParameter[] parameters)
{
Response response = default;
try
{
var dataset = dal.ExecSPQuery(SP, con, parameters);
if (dataset != null)
{
response = new ResponseOK();
}
//IDBParameter p1 = new SqlParameterAdapter();
//IDBParameter p2 = new SqlParameterAdapter();
//IDBParameter p3 = new SqlParameterAdapter();
//IDBParameter p4 = new SqlParameterAdapter();
//IDBParameter p5 = new SqlParameterAdapter();
//IDBParameter p6 = new SqlParameterAdapter();
//IDBParameter p7 = new SqlParameterAdapter();
//IDBParameter p8 = new SqlParameterAdapter();
//p1.ParameterName = "DocID";
//p1.Value = request.DocID;
//p2.ParameterName = "MarkerType";
//p2.Value = request.MarkerType;
//p3.ParameterName = "MarkerLocation1X";
//p3.Value = request.MarkerLocation1X;
//p4.ParameterName = "MarkerLocation1Y";
//p4.Value = request.MarkerLocation1Y;
//p5.ParameterName = "MarkerLocation2X";
//p5.Value = request.MarkerLocation2X;
//p6.ParameterName = "MarkerLocation2Y";
//p6.Value = request.MarkerLocation2Y;
//p7.ParameterName = "Fore_backColor";
//p7.Value = request.Fore_backColor;
//p8.ParameterName = "userId";
//p8.Value = request.userId;
//con = dal.Connect("Server=LAPTOP-B6F4SVRM;Database=DocumentProject;" +
// "Trusted_Connection=True;");
//var dataset = dal.ExecSPQuery("CreateMarker", con, p1, p2, p3, p4, p5, p6, p7, p8);
//if (dataset != null)
//{
// response = new MarkersResponseAddOK();
//}
}
catch (Exception e)
{
response = new ResponseError();
}
return(response);
}
public void Post(string apiRoute, ApiRequestContext context, int timeout)
{
var request = System.Net.WebRequest.Create(_domain + '/' + apiRoute);
request.Method = "POST";
request.ContentType = "application/json";
request.Timeout = timeout;
using (var sw = new System.IO.StreamWriter(request.GetRequestStream()))
{
var serializer = new JsonSerializer();
serializer.Serialize(sw, context);
}
var ts = new System.Threading.ThreadStart(() => {
try
{
var response = request.GetResponse() as System.Net.HttpWebResponse;
using (var stream = response.GetResponseStream())
{
using (var reader = new System.IO.StreamReader(stream, Encoding.UTF8))
{
var responseString = reader.ReadToEnd();
var responseObject = JObject.Parse(responseString);
Code = responseObject.Get <int>("Code");
Message = responseObject.Get <string>("Message");
if (Code >= 0)
{
Value = responseObject.SelectToken("Value");
}
}
}
}
catch (Exception e)
{
Code = -505;
Message = e.Message;
}
finally
{
Responsed?.Invoke(this);
}
if (Code < 0)
{
ResponseError?.Invoke(this);
}
else
{
ResponseOK?.Invoke(this);
}
});
new System.Threading.Thread(ts).Start();
}
/// <summary>
/// Verarbeitung
/// </summary>
/// <param name="request">Die Anfrage</param>
/// <returns>Die Antwort</returns>
public override Response Process(Request request)
{
var response = new ResponseOK();
response.HeaderFields.ContentLength = Data.Length;
response.HeaderFields.ContentType = "binary/octet-stream";
response.Content = Data;
return(response);
}
/// <summary>
/// Verarbeitung
/// </summary>
/// <param name="request">Die Anfrage</param>
/// <returns>Die Antwort</returns>
public override Response Process(Request request)
{
Process();
var response = new ResponseOK();
response.HeaderFields.ContentLength = Content.Length;
response.Content = Content;
return(response);
}
public void Execute()
{
try
{
using (var sw = new System.IO.StreamWriter(_request.GetRequestStream()))
{
var serializer = new JsonSerializer();
serializer.Serialize(sw, _context);
}
var response = _request.GetResponse() as System.Net.HttpWebResponse;
using (var stream = response.GetResponseStream())
{
using (var reader = new System.IO.StreamReader(stream, Encoding.UTF8))
{
var responseString = reader.ReadToEnd();
var responseObject = JObject.Parse(responseString);
Code = responseObject.Get <int>("Code");
Message = responseObject.Get <string>("Message");
if (Code >= 0)
{
Value = responseObject.SelectToken("Value");
}
}
}
}
catch (Exception e)
{
Code = -505;
Message = e.Message;
}
finally
{
Responsed?.Invoke(this);
}
if (Code < 0)
{
ResponseError?.Invoke(this);
}
else
{
ResponseOK?.Invoke(this);
}
}
