public List <SPSearchListDocument_Result> SearchListDocument(DocumentReceivedQuery query)
{
List <SPSearchListDocument_Result> result = new List <SPSearchListDocument_Result>();
result = _entities.SPSearchListDocument("", query.StartDate, query.EndDate, query.UserId, query.ListSubDepartmentId, query.DepartmentId).ToList();
return(result);
}
public int CountUserDocumentHaventRead(DocumentReceivedQuery query)
{
int count = 0;
int totalRow = 0;
ObjectParameter prTotalRow = new ObjectParameter("total", totalRow);
var temp = _entities.SPCountUserDocumentHaventRead(query.Type, query.StartDate, query.EndDate, query.UserId, query.ListSubDepartmentId, query.DepartmentId, prTotalRow);
count = (prTotalRow.Value == null) ? 0 : Convert.ToInt32(prTotalRow.Value);
return(count);
}
public int CountNewDocument(DocumentReceivedQuery query)
{
int count = 0;
int totalRow = 0;
ObjectParameter prTotalRow = new ObjectParameter("total", totalRow);
var temp = _entities.SPCountNewDocument("0", "", DateTime.Now.AddMonths(-3), DateTime.Now.AddMonths(3), query.UserId, query.ListSubDepartmentId, query.DepartmentId, 0, int.MaxValue, prTotalRow);
count = (prTotalRow.Value == null) ? 0 : Convert.ToInt32(prTotalRow.Value);
return(count);
}
public List <SPGetAddedDocumentBook_Result> FilterAddedDocumentBook(DocumentReceivedQuery query, out int count)
{
int pageNumber = query.PageNumber != 0 ? query.PageNumber : 1;
var keyword = string.IsNullOrEmpty(query.Keyword) != true ? query.Keyword : "";
var start = 0;
var limit = query.PageSize;
start = (pageNumber - 1) * limit;
int totalRow = 0;
List <SPGetAddedDocumentBook_Result> result = new List <SPGetAddedDocumentBook_Result>();
ObjectParameter prTotalRow = new ObjectParameter("total", totalRow);
result = _entities.SPGetAddedDocumentBook(query.DepartmentId, Util.DetecVowel(keyword), query.StartDate, query.EndDate, start, limit, prTotalRow).ToList();
count = (prTotalRow.Value == null) ? 0 : Convert.ToInt32(prTotalRow.Value);
return(result);
}
public List <SPGetTotalDocumentReportList_Result> DownloadTotalDocumentList(DocumentReceivedQuery query, out int count)
{
int pageNumber = query.PageNumber != 0 ? query.PageNumber : 1;
var keyword = string.IsNullOrEmpty(query.Keyword) != true ? query.Keyword : "";
var start = 0;
var limit = query.PageSize;
start = (pageNumber - 1) * limit;
int totalRow = 0;
List <SPGetTotalDocumentReportList_Result> result = new List <SPGetTotalDocumentReportList_Result>();
ObjectParameter prTotalRow = new ObjectParameter("Total", totalRow);
result = _entities.SPGetTotalDocumentReportList(
query.StartDate,
query.EndDate,
query.ListSubDepartmentId,
start,
limit,
prTotalRow).ToList();
count = (prTotalRow.Value == null) ? 0 : Convert.ToInt32(prTotalRow.Value);
return(result);
}
public List <SPGetDocumentAdvance_Result> SearchDocument(DocumentReceivedQuery query, out int count, int pageSize = 10)
{
int pageNumber = query.PageNumber != 0 ? query.PageNumber : 1;
var keyword = string.IsNullOrEmpty(query.Keyword) != true ? query.Keyword : "";
var start = 0;
var limit = pageSize == 10 ? query.PageSize : pageSize;
start = (pageNumber - 1) * limit;
int totalRow = 0;
List <SPGetDocumentAdvance_Result> result = new List <SPGetDocumentAdvance_Result>();
ObjectParameter prTotalRow = new ObjectParameter("Total", totalRow);
result = _entities.SPGetDocumentAdvance(
query.DocumentReceived,
query.DocumentDelivered,
query.LegalDocument,
Util.DetecVowel(keyword),
query.DocumentDateStart,
query.DocumentDateEnd,
query.DocumentDateRDStart,
query.DocumentDateRDEnd,
query.DocumentSigns,
query.DocumentSignsDelivered,
query.DocumentFields,
query.DocumentTypes,
query.DocumentSecretLevels,
query.DocumentUrgencyLevels,
query.DepartmentId,
query.UserId,
query.ListSubDepartmentId,
start,
limit,
prTotalRow).ToList();
count = (prTotalRow.Value == null) ? 0 : Convert.ToInt32(prTotalRow.Value);
return(result);
}
public BaseListResponse <SPGetDocument_Result> Search([FromUri] DocumentReceivedQuery query)
{
return(documentService.FilterDocument(query));
}
public BaseResponse <int> CountNewDocument([FromUri] DocumentReceivedQuery query)
{
return(documentService.CountNewDocument(query));
}
public BaseListResponse <SPGetDocument_Result> GetDocumentUnRead([FromUri] DocumentReceivedQuery query)
{
return(documentService.GetDocumentUnRead(query));
}
public BaseResponse <UserDocumentsAnalystic> CountUserDocument([FromUri] DocumentReceivedQuery query)
{
return(documentService.CountUserDocument(query.NumberOfMonthsOrWeeks, query));
}
public BaseListResponse <SPGetTotalDocumentReportList_Result> DownloadTotalDocumentList([FromUri] DocumentReceivedQuery query)
{
return(documentService.DownloadTotalDocumentList(query));
}
public BaseResponse <string> DownloadDocumentBook([FromUri] DocumentReceivedQuery query)
{
return(documentService.DownloadDocumentBook(query));
}
public BaseListResponse <SPGetDocumentAdvance_Result> SearchDocument([FromUri] DocumentReceivedQuery info)
{
return(documentService.SearchDocument(info));
}
public BaseListResponse <SPGetAddedDocumentBook_Result> SearchAddedDocumentBook([FromUri] DocumentReceivedQuery query)
{
return(documentService.FilterAddedDocumentBook(query));
}