public async Task <Response> GetMarkers(GetMarkersRequest request)
{
//TODO test
Response retval = new GetMarkersResponseInvalidDocID(request);
if (_dal.IsDocumentExists(_conn, request.DocID))
{
try
{
List <Marker> markers = new List <Marker>();
DataSet ds = _dal.GetMarkers(_conn, request.DocID);
foreach (DataRow row in ds.Tables[0].Rows)
{
markers.Add(CreateMarkerFromRow(row));
}
retval = new GetMarkersResponseOk(markers);
}
catch (Exception ex)
{
retval = new AppResponseError("Error in get markers");
}
}
return(retval);
}
public Response GetMarkers(GetMarkersRequest request)
{
try
{
var docDs = _dal.GetMarkers(request.DocId);
GetMarkersResponseOK retval = new GetMarkersResponseOK();
if (docDs.Tables.Count > 0)
{
var tbl = docDs.Tables[0];
foreach (DataRow row in tbl.Rows)
{
Marker marker = new Marker();
marker.MarkerId = (string)row[0];
marker.DocId = (string)row[1];
marker.UserID = (string)row[2];
marker.MarkerType = (string)row[3];
marker.CenterX = (decimal)row[4];
marker.CenterY = (decimal)row[5];
marker.RadiusX = (decimal)row[6];
marker.RadiusY = (decimal)row[7];
marker.ForeColor = (string)row[8];
marker.BackColor = (string)row[9];
retval.Markers.Add(marker);
}
}
return(retval);
}
catch (Exception ex)
{
return(new ResponseError(ex.Message));
}
}
public void GetMarkerTestInvalid()
{
GetMarkersRequest request = new GetMarkersRequest()
{
DocID = "2"
};
Response response = _service.GetMarkers(request).Result;
Assert.IsInstanceOf(typeof(GetMarkersResponseInvalidDocID), response);
}
public void GetMarkersTestOK()
{
GetMarkersRequest request = new GetMarkersRequest()
{
DocID = "1"
};
Response response = _service.GetMarkers(request).Result;
Assert.IsInstanceOf(typeof(GetMarkersResponseOk), response);
}
public DataSet GetMarkers(GetMarkersRequest request)
{
var cmd = new OracleCommand
{
Connection = _conn,
CommandText = "GetMarkers"
};
var param1 = _infraDal.GetParameter("Id", OracleDbType.Varchar2, request.DocId);
cmd.Parameters.Add(param1);
return(_infraDal.ExecSpQuery(cmd));
}
public Response GetMarkers(GetMarkersRequest request)
{
List <MarkerDto> markersList = new List <MarkerDto>();
try
{
var dataSet = _dal.GetMarkers(request);
var table = dataSet.Tables[0];
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
MarkerDto temp = new MarkerDto()
{
DocId = table.Rows[i]["DocId"].ToString(),
MarkerId = table.Rows[i]["MarkerId"].ToString(),
MarkerType = table.Rows[i]["MarkerType"].ToString(),
ForColor = table.Rows[i]["ForColor"].ToString(),
BackColor = table.Rows[i]["BackColor"].ToString(),
UserId = table.Rows[i]["UserId"].ToString(),
LocationX = Convert.ToDouble(table.Rows[i]["LocationX"].ToString()),
LocationY = Convert.ToDouble(table.Rows[i]["LocationY"].ToString()),
Height = Convert.ToDouble(table.Rows[i]["Height"].ToString()),
Width = Convert.ToDouble(table.Rows[i]["Width"].ToString())
/*
* LocationX = Convert.ToInt32((decimal)table.Rows[i]["LocationX"]),
* LocationY = Convert.ToInt32((decimal)table.Rows[i]["LocationY"]),
* Height = Convert.ToInt32((decimal)table.Rows[i]["Height"]),
* Width= Convert.ToInt32((decimal)table.Rows[i]["Width"])
*/
};
markersList.Add(temp);
}
GetMarkersResponseOk ret = new GetMarkersResponseOk
{
Markers = markersList.ToArray()
};
return(ret);
}
catch (Exception ex)
{
return(new AppResponseError(ex.Message));
}
}
public async Task <Response> GetMarkers(GetMarkersRequest request)
{
Response response = new GetMarkersResponseInvalidDocID(request);
if (_dal.isDocExists(request.DocID))
{
try
{
List <Marker> markers = new List <Marker>();
DataSet ds = _dal.GetMarkers(request.DocID);
foreach (DataRow row in ds.Tables[0].Rows)
{
var marker = new Marker();
marker.DocID = (string)row["DOC_ID"];
marker.MarkerID = (string)row["MARKER_ID"];
marker.UserID = (string)row["USER_ID"];
marker.MarkerType = (string)row["MARKER_TYPE"];
marker.StrokeColor = (string)row["STROKE_COLOR"];
marker.BackgroundColor = (string)row["BACKGROUND_COLOR"];
marker.X = (string)row["X"];
marker.Y = (string)row["Y"];
marker.XRadius = (string)row["XRADIUS"];
marker.YRadius = (string)row["YRADIUS"];
markers.Add(marker);
}
response = new GetMarkersResponseOK(markers);
}
catch (Exception ex)
{
response = new AppResponseError(ex.Message);
}
}
return(response);
}
public Response GetMarkers([FromBody] GetMarkersRequest request)
{
var ret = _service.GetMarkers(request);
return(ret);
}
public Response GetMarkers(GetMarkersRequest request)
{
return(_service.GetMarkers(request));
}
public async Task <Response> GetMarkers(GetMarkersRequest request)
{
return(await _markerService.GetMarkers(request));
}
