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); }