public SharedReportResponse GetSharedReportByToken(string token)
{
var response = new SharedReportResponse();
try
{
var sharedReportRepository = new SharedReportRepository();
var sharedReport = sharedReportRepository.Query().FirstOrDefault(x => x.Token == token);
if (sharedReport != null)
{
response.SharedResponse = new SharedReportDto()
{
URL = sharedReport.URL
};
}
sharedReportRepository.Dispose();
response.Acknowledgment = true;
response.Message = "Success";
}
catch (Exception ex)
{
response.Acknowledgment = false;
response.Message = "Error getting the shared Report: " + ex.Message;
}
return(response);
}
public SharedReportResponse AddSharedReport(SharedReportDto sharedReportDto)
{
var response = new SharedReportResponse();
try
{
var sharedReportRepository = new SharedReportRepository();
var sharedReport = new SharedReport()
{
CreatedBy = sharedReportDto.CreatedBy,
Comments = sharedReportDto.Comments,
CreatedDate = sharedReportDto.CreatedDate,
ExpiredDate = sharedReportDto.ExpiredDate,
SharedWith = sharedReportDto.SharedWith,
Token = sharedReportDto.Token,
URL = sharedReportDto.URL,
TinyUrl = sharedReportDto.TinyUrl,
SmartReportId = sharedReportDto.SmartReportId,
IsActive = true
};
sharedReportRepository.Add(sharedReport);
sharedReportRepository.SaveChanges();
sharedReportDto.IdSharedReports = sharedReport.IdSharedReports;
response.SharedResponse = sharedReportDto;
response.Acknowledgment = true;
response.Message = "Success";
sharedReportRepository.Dispose();
}
catch (Exception ex)
{
response.Acknowledgment = false;
response.Message = "Error creating the shared Report: " + ex.Message;
}
return(response);
}
public BaseResponse DeleteSharedReport(int idSharedReport)
{
var response = new SharedReportsResponse();
try
{
var sharedReportRepository = new SharedReportRepository();
var sharedReport = sharedReportRepository.Query().FirstOrDefault(x => x.IdSharedReports == idSharedReport);
sharedReport.IsActive = false;
sharedReportRepository.SaveChanges();
sharedReportRepository.Dispose();
response.Acknowledgment = true;
response.Message = "Success";
}
catch (Exception ex)
{
response.Acknowledgment = false;
response.Message = "Error deleting the shared Report: " + ex.Message;
}
return(response);
}
public SharedReportsResponse GetSharedReportsByUser(int userId)
{
var response = new SharedReportsResponse();
try
{
var sharedReportRepository = new SharedReportRepository();
var userProfileRepository = new UserProfileRepository();
var sharedReports = sharedReportRepository.Query().Where(x => x.CreatedBy == userId);
var sharedWithMeReports = sharedReportRepository.Query().Where(x => x.SharedWith == userId);
response.SharedByMeReports = new List <SharedReportDto>();
response.SharedWithMeReports = new List <SharedReportDto>();
foreach (var sharedReport in sharedReports)
{
if (sharedReport.IsActive)
{
var sharedWith = userProfileRepository.Query().FirstOrDefault(x => x.UserId == sharedReport.SharedWith).UserName;
response.SharedByMeReports.Add(new SharedReportDto()
{
IdSharedReports = sharedReport.IdSharedReports,
CreatedBy = sharedReport.CreatedBy,
Comments = sharedReport.Comments,
CreatorName = sharedReport.UserProfile.UserName,
ShareWithName = sharedWith,
CreatedDate = sharedReport.CreatedDate,
ExpiredDate = sharedReport.ExpiredDate,
SharedWith = sharedReport.SharedWith,
Token = sharedReport.Token,
URL = sharedReport.URL,
TinyUrl = sharedReport.TinyUrl,
SmartReportId = sharedReport.SmartReportId,
IsActive = true,
SubscriptionName = sharedReport.SmartReport.ServiceDelivery.ServiceSubscription.SubscriptionName,
ReportName = sharedReport.SmartReport.ReportName
});
}
}
foreach (var sharedReport in sharedWithMeReports)
{
if (sharedReport.IsActive)
{
var sharedWith = userProfileRepository.Query().FirstOrDefault(x => x.UserId == sharedReport.SharedWith).UserName;
response.SharedWithMeReports.Add(new SharedReportDto()
{
IdSharedReports = sharedReport.IdSharedReports,
CreatedBy = sharedReport.CreatedBy,
Comments = sharedReport.Comments,
CreatorName = sharedReport.UserProfile.UserName,
ShareWithName = userProfileRepository.Query().FirstOrDefault(x => x.UserId == sharedReport.SharedWith).UserName,
CreatedDate = sharedReport.CreatedDate,
ExpiredDate = sharedReport.ExpiredDate,
SharedWith = sharedReport.SharedWith,
Token = sharedReport.Token,
URL = sharedReport.URL,
TinyUrl = sharedReport.TinyUrl,
SmartReportId = sharedReport.SmartReportId,
IsActive = true,
SubscriptionName = sharedReport.SmartReport.ServiceDelivery.ServiceSubscription.SubscriptionName,
ReportName = sharedReport.SmartReport.ReportName
});
}
}
sharedReportRepository.Dispose();
response.Acknowledgment = true;
response.Message = "Success";
}
catch (Exception ex)
{
response.Acknowledgment = false;
response.Message = "Error getting the shared Report: " + ex.Message;
}
return(response);
}