public Response GetDocsByOwnerId(GetDocsByOwnerIdRequest request) { 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); } GetDocsByOwnerIdResponse ret = new GetDocsByOwnerIdResponseOk { Documents = 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 void GetDocsByOwnerIdTest1() { GetDocsByOwnerIdRequest request = new GetDocsByOwnerIdRequest { Owner = "*****@*****.**" }; var ret = _service.GetDocsByOwnerId(request); var responseOk = new GetDocsByOwnerIdResponseOk(); Assert.AreEqual(responseOk.ResponseType, ret.ResponseType); }
public DataSet GetDocsByOwnerId(GetDocsByOwnerIdRequest request) { var cmd = new OracleCommand { Connection = _conn, CommandText = "GetDocsByOwnerId" }; var param1 = _infraDal.GetParameter("Id", OracleDbType.Varchar2, request.Owner); cmd.Parameters.Add(param1); return(_infraDal.ExecSpQuery(cmd)); }
public void GetDocsByOwnerId1() { var request = new GetDocsByOwnerIdRequest { Owner = "*****@*****.**" }; var ret = _dal.GetDocsByOwnerId(request); var ret2 = ret.Tables[0].Rows[0]["docId"].ToString(); var ret3 = ret.Tables[0].Rows[1]["docId"].ToString(); Assert.AreEqual("1", ret2); Assert.AreEqual("2787587f-3571-4c90-ab6e-bb726dda465d", ret3); }
public Response GetAllDocs([FromBody] GetDocsByOwnerIdRequest request) { var ret = _service.GetAllDocs(request); return(ret); }