public MarkerRsponse AddMarker(MarkerRequestAdd request) { MarkerRsponse response = default; //------------ try { var con = _SQLdal.Connect("Server=LAPTOP-B6F4SVRM;Database=DocumentProject;" + "Trusted_Connection=True;"); var parameters = _paramConverter.ConvertToParameters(request.MarkerDTO); var dataset = _SQLdal.ExecSPQuery("CreateMarker", con, parameters); if (dataset.Tables[0].Rows.Count != 0) { var markers = new List <MarkerDTO>(); markers.Add(new MarkerDTO() { BackColor = request.MarkerDTO.BackColor, CenterX = request.MarkerDTO.CenterX, CenterY = request.MarkerDTO.CenterY, DocID = request.MarkerDTO.DocID, ForeColor = request.MarkerDTO.ForeColor, MarkerID = dataset.Tables[0].Rows[0].Field <Guid>("MarkerID"), MarkerType = request.MarkerDTO.MarkerType, RadiusX = request.MarkerDTO.RadiusX, RadiusY = request.MarkerDTO.RadiusY, userId = request.MarkerDTO.userId }); response = new MarkersResponseAddOK() { Markers = markers }; } } catch (Exception e) { response = new MarkerRsponseDontAdd(); throw; } return(response); }
public MarkerRsponse AddMarker(MarkerRequestAdd request) { MarkerRsponse response = default; //------------ try { var con = _SQLdal.Connect("Server=LAPTOP-B6F4SVRM;Database=DocumentProject;" + "Trusted_Connection=True;"); var parameters = _paramConverter.ConvertToParameters(request.MarkerDTO); var dataset = _SQLdal.ExecSPQuery("CreateMarker", con, parameters); if (dataset != null) { response = new MarkersResponseAddOK(); } } catch (Exception e) { response = new MarkerRsponseDontAdd(); throw; } return(response); }