public Response AddSharing(DocumentSharingRequest request)
{
Response response = default;
try
{
IDBParameter p1 = new SqlParameterAdapter();
IDBParameter p2 = new SqlParameterAdapter();
p1.ParameterName = "DocId";
p1.Value = request.DocID;
p2.ParameterName = "userId";
p2.Value = request.UserId;
var con = dal.Connect("Server=LAPTOP-B6F4SVRM;Database=DocumentProject;" +
"Trusted_Connection=True;");
var dataset = dal.ExecSPQuery("CreateShare", con, p1, p2);
if (dataset != null)
{
response = new DocumentSharingResponseAddOK();
}
}
catch (Exception e)
{
response = new ResponseError();
}
return(response);
}
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))
{
_dal.AddSharing(request);
retval = new DocumentSharingResponseAddOK();
}
else
{
retval = new DocumentSharingResponseDontAdd();
}
}
catch (Exception e)
{
// Console.log(e)
retval = new DocumentSharingResponseDontAdd();
}
return(retval);
}
