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 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 GetShareForUser(DocumentSharingRequestGetForUser request)
{
DocumentsharingResponse retval = new DcumentSharingResponseEmpty();
var param = _paramConverter.ConvertToParameter(request, "userID");
var dataset = _SQLDAL.ExecSPQuery("GetShareForUser", con, param);
try
{
if (dataset.Tables[0].Rows.Count != 0)
{
retval = new DocumentsharingResponse()
{
DocumentSharingDTO = new List <DocumentSharingDTO>()
};
var docShareList = dataset.Tables[0].AsEnumerable().Select(dataRow => new DocumentSharingDTO
{
DocID = dataRow.Field <Guid>("DocID"),
UserId = dataRow.Field <string>("userId")
}).ToList();
retval.DocumentSharingDTO = docShareList;
}
}
catch (Exception e)
{
throw;
}
return(retval);
}
public DocumentsharingResponse RemoveSharing(DocumentSharingRequest request)
{
DocumentsharingResponse retval = default;
try
{
retval = _dal.RemoveSharing(request);
}
catch (Exception e)
{
retval = new DocumentSharingResponseDontRemove();
throw;
}
return(retval);
}
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);
}
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);
}
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);
}
