public Response GetDocByDocId(GetDocByDocIdRequest request)
{
DocumentDto doc;
try
{
var dataSet = _docDal.GetDocByDocId(request);
var table = dataSet.Tables[0];
doc = new DocumentDto()
{
DocId = table.Rows[0]["DocId"].ToString(),
DocumentName = table.Rows[0]["DocumentName"].ToString(),
ImageUrl = table.Rows[0]["ImageUrl"].ToString(),
Owner = table.Rows[0]["Owner"].ToString()
};
GetDocByDocIdResponse ret = new GetDocByDocIdResponseOk()
{
Document = doc
};
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 GetDocByDocId1()
{
var request = new GetDocByDocIdRequest
{
DocId = "2787587f-3571-4c90-ab6e-bb726dda465d"
};
var ret = _dal.GetDocByDocId(request);
var ret2 = ret.Tables[0].Rows[0]["Owner"].ToString();
Assert.AreEqual("*****@*****.**", ret2);
}
public DataSet GetDocByDocId(GetDocByDocIdRequest request)
{
var cmd = new OracleCommand
{
Connection = _conn,
CommandText = "GetDocByDocId"
};
var param1 = _infraDal.GetParameter("Id", OracleDbType.Varchar2, request.DocId);
cmd.Parameters.Add(param1);
return(_infraDal.ExecSpQuery(cmd));
}
public void GetDocByDocIdTest1()
{
GetDocByDocIdRequest request = new GetDocByDocIdRequest()
{
DocId = "1"
};
var ret = _service.GetDocByDocId(request);
var responseOk = new GetDocByDocIdResponseOk
{
Document = new DocumentDto()
{
DocId = "1",
ImageUrl = "XXX",
DocumentName = "XXX",
Owner = "*****@*****.**"
}
};
//Assert.AreEqual(responseOk, ret);
Assert.AreEqual(responseOk.ResponseType, ret.ResponseType);
}
public Response GetDocByDocId([FromBody] GetDocByDocIdRequest request)
{
var ret = _service.GetDocByDocId(request);
return(ret);
}
