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