public Response RemoveSharing(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("DeleteShare", con, p1, p2);
if (dataset != null)//איך יודעים אם הפעולה הצליחה
{
response = new DocumentSharingResponseRemoveOK();
}
}
catch (Exception)
{
response = new ResponseError();
}
return(response);
}
public DocumentsharingResponse RemoveSharing(DocumentSharingRequest request)
{
DocumentsharingResponse retval = default;
try
{
var parameters = _paramConverter.ConvertToParameters(request.sharingDTO);
var dataset = _SQLDAL.ExecSPQuery("DeleteShare", con, parameters);
if (dataset.Tables[0].Rows.Count != 0)
{
retval = new DocumentSharingResponseRemoveOK();
}
}
catch (Exception e)
{
retval = new DocumentSharingResponseDontRemove();
}
return(retval);
}
public DocumentsharingResponse RemoveSharing(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("DeleteShare", con, parameters);
if (dataset != null)
{
retval = new DocumentSharingResponseRemoveOK();
}
}
catch (Exception e)
{
retval = new DocumentSharingResponseDontRemove();
}
return(retval);
}