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