public DocumentsharingResponse AddSharing(DocumentSharingRequest request)
        {
            DocumentsharingResponse retval = default;

            try
            {
                var con        = _SQLDAL.Connect("Server=LAPTOP-B6F4SVRM;Database=DocumentProject;" + "Trusted_Connection=True;");
                var parameters = _paramConverter.ConvertToParameters(request.sharingDTO);
                var dataset    = _SQLDAL.ExecSPQuery("CreateShare", con, parameters);

                if (dataset.Tables[0].Rows.Count != 0)
                {
                    retval = new DocumentSharingResponseAddOK();
                    retval.DocumentSharingDTO = new List <DocumentSharingDTO>();
                    retval.DocumentSharingDTO.Add(new DocumentSharingDTO()
                    {
                        DocID = request.sharingDTO.DocID, UserId = request.sharingDTO.UserId
                    });
                }
            }
            catch (Exception e)
            {
                retval = new DocumentSharingResponseDontAdd();
                //log
            }
            return(retval);
        }
        public DocumentsharingResponse AddSharing(DocumentSharingRequest request)
        {
            DocumentsharingResponse retval = default;

            try
            {
                var con        = _SQLDAL.Connect("Server=LAPTOP-B6F4SVRM;Database=DocumentProject;" + "Trusted_Connection=True;");
                var parameters = _paramConverter.ConvertToParameters(request.sharingDTO);
                var dataset    = _SQLDAL.ExecSPQuery("CreateShare", con, parameters);

                if (dataset != null)
                {
                    retval = new DocumentSharingResponseAddOK();
                }
            }
            catch (Exception e)
            {
                retval = new DocumentSharingResponseDontAdd();
                //log
            }
            return(retval);
        }
        public DocumentsharingResponse AddSharing(DocumentSharingRequest request)
        {
            DocumentsharingResponse retval = default;

            try
            {
                if (SharingAvailable(request))
                {
                    retval = _dal.AddSharing(request);
                }
                else
                {
                    retval = new DocumentSharingResponseDontAdd();
                }
            }
            catch (Exception e)
            {
                //  Console.log(e)
                retval = new DocumentSharingResponseDontAdd();
            }
            return(retval);
        }