public DocumentsharingResponse GetShareForDoc(DocumentSharingRequestGetForDoc request)
        {
            DocumentsharingResponse res = new DcumentSharingResponseEmpty();

            try
            {
                var con     = _SQLDAL.Connect("Server=LAPTOP-B6F4SVRM;Database=DocumentProject;" + "Trusted_Connection=True;");
                var param   = _paramConverter.ConvertToParameter(request, "DocID");
                var dataset = _SQLDAL.ExecSPQuery("GetShareForDoc", con, param);
                if (dataset.Tables[0].Rows.Count != 0)
                {
                    res = new DocumentsharingResponse()
                    {
                        DocumentSharingDTO = new List <DocumentSharingDTO>()
                    };
                    var sharesList = dataset.Tables[0].AsEnumerable().Select(dataRow => new DocumentSharingDTO
                    {
                        DocID  = dataRow.Field <Guid>("DocID"),
                        UserId = dataRow.Field <string>("UserId")
                    }).ToList();
                    res.DocumentSharingDTO = sharesList;
                }
            }
            catch (Exception e)
            {
                throw;
            }
            return(res);
        }
        public DocumentsharingResponse GetShareForDoc(DocumentSharingRequestGetForDoc request)
        {
            DocumentsharingResponse retval = default;

            try
            {
                if (request.DocID != Guid.Empty && request.DocID != null)
                {
                    retval = _dal.GetShareForDoc(request);
                }
            }
            catch (Exception e)
            {
                throw;
            }
            return(retval);
        }