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