public static async Task <ResponseBase <ReportConfigAddEdit> > EditReport(TeamHttpContext teamHttpContext, int reportId)
{
List <ReportConfig> objReportConfig = new List <ReportConfig>();
using (TeamDbContext dbContext = new TeamDbContext())
{
objReportConfig = dbContext.ReportConfigs.Where(x => x.Id == reportId).ToList();
}
if (objReportConfig.Count != 0)
{
foreach (var item in objReportConfig)
{
ReportConfigAddEdit objReportConfigAddEdit = new ReportConfigAddEdit
{
ReportId = item.Id,
ReportName = item.ReportName,
ReportConnectionString = item.ReportConnectionString,
ReportQuery = item.ReportQuery,
ReportEmail = item.ReportEmail,
ReportFormat = item.ReportFileFormat,
IsActive = !(item.Deleted),
ReportDeliveryMode = item.ReportDeliveryOption,
ReportSMSPhoneNumber = item.ReportSMSPhNo,
ReportDefaultSMSMSG = item.ReportDefaultSMSMsg,
ReportSchedulerName = item.ReportSchedulerName
};
return(GetTypedResponse(teamHttpContext, objReportConfigAddEdit));
}
}
return(null);
}
internal static async Task <ResponseBase> editReport(TeamHttpContext httpContext, ReportConfigAddEdit report)
{
try
{
List <ReportConfig> objReportConfig = new List <ReportConfig>();
using (TeamDbContext dbContext = new TeamDbContext())
{
if (dbContext.ReportConfigs.AsNoTracking().FirstOrDefault(e => e.Id == report.ReportId) != null)
{
objReportConfig = dbContext.ReportConfigs.Where(x => x.Id == report.ReportId).ToList();
}
}
if (objReportConfig.Count != 0)
{
EditReport(new ReportConfig
{
Id = report.ReportId,
ReportReqUserId = httpContext.ContextUserId,
//ReportReqUserId = "Admin",
ReportName = report.ReportName,
ReportConnectionString = report.ReportConnectionString,
ReportQuery = report.ReportQuery,
ReportEmail = report.ReportEmail,
ReportFileFormat = report.ReportFormat,
CreatedBy = objReportConfig[0].CreatedBy,
CreatedOn = objReportConfig[0].CreatedOn,
ModifiedBy = httpContext.ContextUserId,
//ModifiedBy = "Admin",
ModifiedOn = DateTime.Now,
ReportModifiedOn = DateTime.Now,
Deleted = !(report.IsActive),
ReportDeliveryOption = report.ReportDeliveryMode,
ReportSMSPhNo = report.ReportSMSPhoneNumber,
ReportDefaultSMSMsg = report.ReportDefaultSMSMSG,
ReportSchedulerName = report.ReportSchedulerName
});
return(GetResponse(httpContext, HttpStatusCode.OK, "Available"));
}
return(null);
}
catch (Exception ex)
{
return(GetResponse(httpContext, HttpStatusCode.BadRequest, ex.Message.ToString()));
}
}
internal static async Task <ResponseBase> addReport(TeamHttpContext httpContext, ReportConfigAddEdit report)
{
try
{
AddReport(new ReportConfig
{
ReportReqUserId = httpContext.ContextUserId,
//ReportReqUserId = "Admin",
ReportName = report.ReportName,
ReportConnectionString = report.ReportConnectionString,
ReportQuery = report.ReportQuery,
ReportEmail = report.ReportEmail,
ReportFileFormat = report.ReportFormat,
CreatedBy = httpContext.ContextUserId,
//CreatedBy = "Admin",
CreatedOn = DateTime.Now,
Deleted = !(report.IsActive),
ReportDeliveryOption = report.ReportDeliveryMode,
ReportSMSPhNo = report.ReportSMSPhoneNumber,
ReportDefaultSMSMsg = report.ReportDefaultSMSMSG,
ReportSchedulerName = report.ReportSchedulerName
});
return(GetResponse(httpContext, HttpStatusCode.OK, "Available"));
}
catch (Exception ex)
{
return(GetResponse(httpContext, HttpStatusCode.BadRequest, ex.Message.ToString()));
}
}
public static async Task <ResponseBase> AddEditReport(TeamHttpContext teamHttpContext, ReportConfigAddEdit report)
{
if (teamHttpContext == null)
{
throw new ArgumentNullException(nameof(teamHttpContext));
}
if (report.ReportId == -1)
{
ResponseBase response = await addReport(teamHttpContext, report).ConfigureAwait(false);
if (response.Code == HttpStatusCode.OK)
{
return(GetResponse(teamHttpContext));
}
}
else
{
ResponseBase response = await editReport(teamHttpContext, report).ConfigureAwait(false);
if (response.Code == HttpStatusCode.OK)
{
return(GetResponse(teamHttpContext));
}
}
return(null);
}
public async Task <ResponseBase> AddEditReport([FromBody] ReportConfigAddEdit report)
{
return(await ReportService.AddEditReport(new TeamHttpContext(HttpContext), report).ConfigureAwait(false));
}