public async Task <Response> GetDocuments(GetDocumentsRequest request)
{
Response response = new GetDocumentsResponseInvalidUserID(request);
if (_dal.isUserExists(request.UserID))
{
try
{
DataSet ds = _dal.GetDocuments(request.UserID);
List <Document> docs = new List <Document>();
foreach (DataRow row in ds.Tables[0].Rows)
{
var doc = new Document();
doc.DocID = (string)row["DOC_ID"];
doc.UserID = (string)row["USER_ID"];
doc.DocumentName = (string)row["DOCUMENT_NAME"];
doc.ImageURL = (string)row["IMAGE_URL"];
docs.Add(doc);
}
response = new GetDocumentsResponseOK(docs);
}
catch (Exception ex)
{
response = new AppResponseError(ex.Message);
}
}
return(response);
}
public Response GetDocuments(string request)
{
try
{
var docDs = _dal.GetDocuments(request);
GetDocumentsResponseOK retval = new GetDocumentsResponseOK();
if (docDs.Tables.Count > 0)
{
var tbl = docDs.Tables[0];
foreach (DataRow row in tbl.Rows)
{
Document doc = new Document();
doc.Owner = (string)row[0];
if (row[1] is System.DBNull)
{
doc.ImageUrl = "";
}
else
{
doc.ImageUrl = (string)row[1];
}
doc.DocumemtName = (string)row[2];
doc.DocID = (string)row[3];
retval.MyDocuments.Add(doc);
}
}
var sharedDs = _dal.GetSharedDocuments(request);
if (sharedDs.Tables.Count > 0)
{
var tbl = sharedDs.Tables[0];
foreach (DataRow row in tbl.Rows)
{
Document doc = new Document();
doc.Owner = (string)row[0];
if (row[1] is System.DBNull)
{
doc.ImageUrl = "";
}
else
{
doc.ImageUrl = (string)row[1];
}
doc.DocumemtName = (string)row[2];
doc.DocID = (string)row[3];
retval.SharedDocuments.Add(doc);
}
}
return(retval);
}
catch (Exception ex)
{
return(new ResponseError(ex.Message));
}
}
public async Task <Response> GetDocuments(GetDocumentsRequest request)
{
Response retval = new GetDocumentsResponseInvalidUserID(request);
if (_dal.IsUserExists(_conn, request.UserID))
{
List <Document> documents = new List <Document>();
try
{
DataSet ds = _dal.GetDocuments(_conn, request.UserID);
var rows = ds.Tables[0].Rows;
foreach (DataRow row in rows)
{
Document doc = new Document()
{
DocID = (string)row["document_id"], DocumentName = (string)row["document_name"],
ImageURL = (string)row["image_url"], UserID = (string)row["user_id"]
};
documents.Add(doc);
}
var sharedDocsResponse = await GetSharedDocuments(request.UserID);
if (sharedDocsResponse is GetDocumentsResponseOK)
{
documents.AddRange((sharedDocsResponse as GetDocumentsResponseOK).Documents);
}
else if (sharedDocsResponse is AppResponseError)
{
return(sharedDocsResponse);
}
retval = new GetDocumentsResponseOK(documents);
}
catch (Exception ex)
{
retval = new AppResponseError("Error in get documents");
}
}
return(retval);
}
private async Task <Response> GetSharedDocuments(string userId)
{
Response retval;
GetSharedDocumentsRequest shareReq = new GetSharedDocumentsRequest()
{
UserID = userId
};
var jsonRequest = JsonConvert.SerializeObject(shareReq);
var response = await SendRequest(jsonRequest);
if (response.IsSuccessStatusCode)
{
List <Document> documents = new List <Document>();
var content = await response.Content.ReadAsStringAsync();
var codeResponse = JsonConvert.DeserializeObject <GetSharedDocumentsResponseOK>(content);
foreach (string docId in codeResponse.Documents)
{
GetDocumentRequest request = new GetDocumentRequest()
{
DocId = docId
};
Response docResponse = await GetDocument(request);
if (docResponse is GetDocumentResponseOK)
{
Document doc = (docResponse as GetDocumentResponseOK).Document;
documents.Add(doc);
}
else if (docResponse is AppResponseError)
{
return(docResponse);
}
}
retval = new GetDocumentsResponseOK(documents);
}
else
{
retval = new AppResponseError(response.StatusCode.ToString());
}
return(retval);
}
public Response GetDocuments(GetDocumentsRequest request)
{
try
{
List <Documents> dl = new List <Documents>();
List <Documents> sdl = new List <Documents>();
var ds = _dalDoc.GetDocuments(request.Owner);
var sd = _dalShared.GetSharedDocuments(request.Owner);
var tblDocs = ds.Tables[0];
var tblShareDocs = sd.Tables[0];
GetDocumentsResponse retval = new GetDocumentsNotExistsResponse();
if (tblDocs.Rows.Count > 0 || tblShareDocs.Rows.Count > 0)
{
for (int i = 0; i < tblDocs.Rows.Count; i++)
{
if (request.Owner == (string)tblDocs.Rows[i][0])
{
Documents dc = new Documents((string)tblDocs.Rows[i][0], (string)tblDocs.Rows[i][1],
(string)tblDocs.Rows[i][2], (string)tblDocs.Rows[i][3]);
dl.Add(dc);
}
}
for (int i1 = 0; i1 < tblShareDocs.Rows.Count; i1++)
{
if (request.Owner != (string)tblShareDocs.Rows[i1][0])
{
Documents sdc = new Documents((string)tblShareDocs.Rows[i1][0], (string)tblShareDocs.Rows[i1][1],
(string)tblShareDocs.Rows[i1][2], (string)tblShareDocs.Rows[i1][3]);
sdl.Add(sdc);
}
}
retval = new GetDocumentsResponseOK(dl, sdl);
}
return(retval);
}
catch (Exception ex)
{
return(new AppResponseError(ex.Message));
}
}
