public void GetShareTest2() { var request = new GetShareByDocIdRequest { DocId = "*****@*****.**" }; var ret = _dal.GetShareByDocId(request); Assert.AreEqual(0, ret.Tables[0].Rows.Count); }
public DataSet GetShareByDocId(GetShareByDocIdRequest request) { var cmd = new OracleCommand { Connection = _conn, CommandText = "GetShareByDocId" }; var param1 = _infraDal.GetParameter("Id", OracleDbType.Varchar2, request.DocId); cmd.Parameters.Add(param1); return(_infraDal.ExecSpQuery(cmd)); }
public Response GetShareByDocId(GetShareByDocIdRequest request) { List <string> usersList = new List <string>(); try { var dataSet = _dal.GetShareByDocId(request); var table = dataSet.Tables[0]; for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++) { usersList.Add(table.Rows[i]["UserId"].ToString()); } var ret = new GetShareByDocIdResponseOk { UsersIds = usersList.ToArray() }; return(ret); } catch (Exception ex) { return(new AppResponseError(ex.Message)); } }
public Response GetShareByDocId([FromBody] GetShareByDocIdRequest request) { var ret = _service.GetShareByDocId(request); return(ret); }