public Response GetShareByUserId(GetShareByUserIdRequest request)
{
//DocumentDto[] docs;
List <string> docsList = new List <string>();
try
{
var dataSet = _dal.GetShareByUserId(request);
var table = dataSet.Tables[0];
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
docsList.Add(table.Rows[i]["DocId"].ToString());
}
var ret = new GetShareByUserIdResponseOk
{
DocsIds = docsList.ToArray()
};
return(ret);
}
catch (Exception ex)
{
return(new AppResponseError(ex.Message));
}
}
public Response GetAllDocs(GetDocsByOwnerIdRequest request)
{
//DocumentDto[] docs;
List <DocumentDto> docsList = new List <DocumentDto>();
try
{
var dataSet = _docDal.GetDocsByOwnerId(request);
var table = dataSet.Tables[0];
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
DocumentDto temp = new DocumentDto()
{
DocId = table.Rows[i]["DocId"].ToString(),
DocumentName = table.Rows[i]["DocumentName"].ToString(),
ImageUrl = table.Rows[i]["ImageUrl"].ToString(),
Owner = table.Rows[i]["Owner"].ToString()
};
docsList.Add(temp);
}
GetShareByUserIdRequest sharedRequest = new GetShareByUserIdRequest
{
UserId = request.Owner
};
dataSet = _shareDal.GetShareByUserId(sharedRequest);
table = dataSet.Tables[0];
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
GetDocByDocIdRequest docIdRequest = new GetDocByDocIdRequest
{
DocId = table.Rows[i]["DocId"].ToString()
};
var dataSetDocId = _docDal.GetDocByDocId(docIdRequest);
var docIdTable = dataSetDocId.Tables[0];
DocumentDto doc = new DocumentDto()
{
DocId = docIdTable.Rows[0]["DocId"].ToString(),
DocumentName = docIdTable.Rows[0]["DocumentName"].ToString(),
ImageUrl = docIdTable.Rows[0]["ImageUrl"].ToString(),
Owner = docIdTable.Rows[0]["Owner"].ToString()
};
docsList.Add(doc);
}
GetDocsByOwnerIdResponse ret = new GetDocsByOwnerIdResponseOk
{
Documents = docsList.ToArray()
};
return(ret);
}
catch (Exception ex)
{
return(new AppResponseError(ex.Message));
}
}
public DataSet GetShareByUserId(GetShareByUserIdRequest request)
{
var cmd = new OracleCommand
{
Connection = _conn,
CommandText = "GetShareByUserId"
};
var param1 = _infraDal.GetParameter("Id", OracleDbType.Varchar2, request.UserId);
cmd.Parameters.Add(param1);
return(_infraDal.ExecSpQuery(cmd));
}
