public async Task <IActionResult> ContentRejectedList(int pageNo, int pageSize) { try { ReportDataAccess _reportAccess = new ReportDataAccess(_iconfiguration); var parameters = HttpUtility.ParseQueryString(Request.QueryString.Value); var paramIsSearch = parameters["search"]; var paramSortType = parameters["sortType"]; var paramSortfield = string.IsNullOrEmpty(parameters["sortField"]) ? 0 : int.Parse(parameters["sortField"]); DatabaseResponse response = await _reportAccess.ContentRejectedList(pageNo, pageSize, paramIsSearch, paramSortType, paramSortfield); if (response.ResponseCode == (int)DbReturnValue.RecordExists) { return(Ok(new OperationResponse { HasSucceeded = true, IsDomainValidationErrors = false, Message = EnumExtensions.GetDescription(DbReturnValue.RecordExists), ReturnedObject = response.Results })); } else { Log.Error(EnumExtensions.GetDescription(DbReturnValue.NoRecords)); return(Ok(new OperationResponse { HasSucceeded = false, IsDomainValidationErrors = false, Message = EnumExtensions.GetDescription(DbReturnValue.NoRecords) })); } } catch (Exception ex) { Log.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); return(Ok(new OperationResponse { HasSucceeded = false, Message = StatusMessages.ServerError, StatusCode = ((int)ResponseStatus.ServerError).ToString(), IsDomainValidationErrors = false })); } }
public async Task <IActionResult> AddVisiter(int?userId) { try { ReportDataAccess _reportAccess = new ReportDataAccess(_iconfiguration); DatabaseResponse response = await _reportAccess.AddVisiter(userId); if (response.ResponseCode == (int)DbReturnValue.CreateSuccess) { return(Ok(new OperationResponse { HasSucceeded = true, IsDomainValidationErrors = false, Message = EnumExtensions.GetDescription(DbReturnValue.CreateSuccess), ReturnedObject = response.Results })); } else { Log.Error(EnumExtensions.GetDescription(DbReturnValue.CreationFailed)); return(Ok(new OperationResponse { HasSucceeded = false, IsDomainValidationErrors = false, Message = EnumExtensions.GetDescription(DbReturnValue.RecordExists), ReturnedObject = response.Results })); } } catch (Exception ex) { Log.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); return(Ok(new OperationResponse { HasSucceeded = false, Message = StatusMessages.ServerError, StatusCode = ((int)ResponseStatus.ServerError).ToString(), IsDomainValidationErrors = false })); } }
/// <summary> /// Gets the report data for average cost by engineer report /// </summary> /// <returns>a list of reportrow to construct a report</returns> public IEnumerable <ReportRow> printAverageCostByEngineer() { return(ReportDataAccess.averageCostByEngineer().Select(c => new ReportRow(c)).ToList()); }
/// <summary> /// Gets the report data for total cost by district report /// </summary> /// <returns>a list of reportrow to construct a report</returns> public IEnumerable <ReportRow> printTotalCostByDistrict() { return(ReportDataAccess.costByDistrict().Select(c => new ReportRow(c)).ToList()); }
/// <summary> /// Gets the report data for monthly cost by district report /// </summary> /// <returns>a list of reportrow to construct a report</returns> public IEnumerable <ReportRow> printMonthlyCostByDistrict(Guid districtId) { return(ReportDataAccess.monthlyCostForDistrict(districtId).Select(c => new ReportRow(c)).ToList()); }
/// <summary> /// Gets the report data for total cost by engineer report /// </summary> /// <returns>a list of reportrow to construct a report</returns> public IEnumerable <ReportRow> printTotalCostByEngineer() { return(ReportDataAccess.totalCostByEngineer((int)UserType.SiteEngineer, (int)InterventionState.Completed).Select(c => new ReportRow(c)).ToList()); }
/// <summary> /// Gets the report data for total cost by district report /// </summary> /// <returns>a list of reportrow to construct a report</returns> public IEnumerable <ReportRow> printTotalCostByDistrict() { return(ReportDataAccess.costByDistrict((int)InterventionState.Completed).Select(c => new ReportRow(c)).ToList()); }
/// <summary> /// Gets the report data for monthly cost by district report /// </summary> /// <returns>a list of reportrow to construct a report</returns> public IEnumerable <ReportRow> printMonthlyCostByDistrict(Guid districtId) { return(ReportDataAccess.monthlyCostForDistrict(districtId, (int)InterventionState.Completed).Select(c => new ReportRow(c)).ToList()); }
public DataTable GetreportDetailsusingmembernamewithdate() { return(ReportDataAccess.GetreportDetailsusingmembernamewithdate(FDate, Todate, Membername)); }
public SqlDataReader GetAmountusingDatenmember() { return(ReportDataAccess.GetAmountusingDatenmember(FDate, Todate, Membername)); }
public SqlDataReader GetAmountusingDate() { return(ReportDataAccess.GetAmountusingDate(FDate, Todate)); }
public DataTable GetreportDetailsusingmembername() { return(ReportDataAccess.GetreportDetailsusingmembername(Membername)); }
public DataTable GetDonationDetailsusingDate() { return(ReportDataAccess.GetDonationDetailsusingDate(FDate, Todate)); }