public DomainStatusCodes GetPersonsRelativesAmountByType(int personId, RequestReportDTO reportData, out ReportDataDTO report)
{
report = null;
if (!CheckIfPersonExists(personId, out _))
{
return(DomainStatusCodes.RecordNotFound);
}
report = new ReportDataDTO {
RelationsAmount = _relatedPersonRepository.PersonsRelativesAmountByType(personId, reportData.RelatedPersonsType)
};
return(DomainStatusCodes.Success);
}
public DTO.ReportDataDTO SearchReportData(int userId, System.Collections.Hashtable filters, int pageSize, int pageIndex, string orderBy, string orderDirection, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success
};
DTO.ReportDataDTO data = new ReportDataDTO();
try
{
int? TypeOfInspectionID = null;
int? StatusID = null;
string CreatedDateStr = null;
string CreatedNM = null;
string ReportDateStr = null;
string ApprovalNM = null;
string ModelUD = null;
string ModelNM = null;
string ArticleCode = null;
if (filters.ContainsKey("typeOfInspectionID") && filters["typeOfInspectionID"] != null)
{
TypeOfInspectionID = Convert.ToInt32(filters["typeOfInspectionID"]);
}
if (filters.ContainsKey("statusID") && filters["statusID"] != null)
{
StatusID = Convert.ToInt32(filters["statusID"]);
}
if (filters.ContainsKey("createdDate") && !string.IsNullOrEmpty(filters["createdDate"].ToString()))
{
CreatedDateStr = filters["createdDate"].ToString().Replace("'", "''");
}
if (filters.ContainsKey("createdNM") && !string.IsNullOrEmpty(filters["createdNM"].ToString()))
{
CreatedNM = filters["createdNM"].ToString().Replace("'", "''");
}
if (filters.ContainsKey("reportDate") && !string.IsNullOrEmpty(filters["reportDate"].ToString()))
{
ReportDateStr = filters["reportDate"].ToString().Replace("'", "''");
}
if (filters.ContainsKey("approvalNM") && !string.IsNullOrEmpty(filters["approvalNM"].ToString()))
{
ApprovalNM = filters["approvalNM"].ToString().Replace("'", "''");
}
if (filters.ContainsKey("modelUD") && !string.IsNullOrEmpty(filters["modelUD"].ToString()))
{
ModelUD = filters["modelUD"].ToString().Replace("'", "''");
}
if (filters.ContainsKey("modelNM") && !string.IsNullOrEmpty(filters["modelNM"].ToString()))
{
ModelNM = filters["modelNM"].ToString().Replace("'", "''");
}
if (filters.ContainsKey("articleCode") && !string.IsNullOrEmpty(filters["articleCode"].ToString()))
{
ArticleCode = filters["articleCode"].ToString().Replace("'", "''");
}
DateTime?CreatedDate = CreatedDateStr.ConvertStringToDateTime();
DateTime?ReportDate = ReportDateStr.ConvertStringToDateTime();
using (var context = CreateContext()) {
data.totalRows = context.ReportQAQCMng_Function_SearchResult(userId, TypeOfInspectionID, StatusID, CreatedDate, CreatedNM, ReportDate, ApprovalNM, ModelUD, ModelNM, ArticleCode, orderBy, orderDirection).Count();
var result = context.ReportQAQCMng_Function_SearchResult(userId, TypeOfInspectionID, StatusID, CreatedDate, CreatedNM, ReportDate, ApprovalNM, ModelUD, ModelNM, ArticleCode, orderBy, orderDirection);
data.reportQAQCSearchDTOs = converter.DB2DTO_ReportSearch(result.Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList());
return(data);
}
}
catch (Exception ex)
{
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Error
};
notification.Message = Library.Helper.GetInnerException(ex).Message;
return(data);
}
}
