private void GenerateAnexo7C(string pathFile, string ServicioId, string PacienteId, string EmpresaCliente)
{
var _DataService = _serviceBL.GetServiceReport(ServicioId);
var _listMedicoPersonales = _historyBL.GetPersonMedicalHistoryReport(PacienteId);
var _listaPatologicosFamiliares = _historyBL.GetFamilyMedicalAntecedentsReport(PacienteId);
var _Valores = _serviceBL.GetServiceComponentsReport(ServicioId);
var _listaHabitoNocivos = _historyBL.GetNoxiousHabitsReport(PacienteId);
var _PiezasCaries = _serviceBL.GetCantidadCaries(ServicioId, Constants.ODONTOGRAMA_ID, Constants.ODONTOGRAMA_PIEZAS_CARIES_ID);
var _PiezasAusentes = _serviceBL.GetCantidadAusentes(ServicioId, Constants.ODONTOGRAMA_ID, Constants.ODONTOGRAMA_PIEZAS_AUSENTES_ID);
//var CuadroVacio = Sigesoft.Common.Utils.FileToByteArray(@"D:\RepSIGSO_v1.0\dev\src\server\webclientadmin\ui\images\icons\CuadradoVacio.png"); // Sigesoft.Common.Utils.BitmapToByteArray(Sigesoft.Server.WebClientAdmin.UI.Common.);
//var CuadroCheck = Sigesoft.Common.Utils.FileToByteArray(@"D:\RepSIGSO_v1.0\dev\src\server\webclientadmin\ui\images\icons\CuadradoCheck.png");//Sigesoft.Common.Utils.BitmapToByteArray(Sigesoft.Node.WinClient.UI.Resources.CuadradoCheck);
var CuadroVacio = Sigesoft.Common.Utils.FileToByteArray(Server.MapPath(@"~\images\icons\CuadradoVacio.png"));
var CuadroCheck = Sigesoft.Common.Utils.FileToByteArray(Server.MapPath(@"~\images\icons\CuadradoCheck.png"));
var Pulmones = Sigesoft.Common.Utils.FileToByteArray(Server.MapPath(@"~\images\icons\MisPulmones.jpg"));
//var Pulmones = Sigesoft.Common.Utils.FileToByteArray(@"D:\RepSIGSO_v1.0\dev\src\server\webclientadmin\ui\images\icons\MisPulmones.jpg"); //Sigesoft.Common.Utils.BitmapToByteArray(Sigesoft.Node.WinClient.UI.Resources.MisPulmones);
var Audiometria = _serviceBL.ValoresComponenteOdontogramaValue1(ServicioId, Constants.AUDIOMETRIA_ID);
var diagnosticRepository = _serviceBL.GetServiceComponentConclusionesDxServiceIdReport(ServicioId);
var MedicalCenter = _serviceBL.GetInfoMedicalCenter();
ReportPDF.CreateAnexo7C(_DataService, _Valores, _listMedicoPersonales,
_listaPatologicosFamiliares, _listaHabitoNocivos,
CuadroVacio, CuadroCheck, Pulmones, _PiezasCaries,
_PiezasAusentes, Audiometria, diagnosticRepository, MedicalCenter,
pathFile);
}
private void GenerateInformeExamenClinico(string pathFile, string ServicioId, string PacienteId, string EmpresaCliente)
{
var filiationData = _pacientBL.GetPacientReportEPS(ServicioId);
var personMedicalHistory = _historyBL.GetPersonMedicalHistoryReport(PacienteId);
var noxiousHabit = _historyBL.GetNoxiousHabitsReport(PacienteId);
var familyMedicalAntecedent = _historyBL.GetFamilyMedicalAntecedentsReport(PacienteId);
var anamnesis = _serviceBL.GetAnamnesisReport(ServicioId);
var serviceComponents = _serviceBL.GetServiceComponentsReport(ServicioId);
var diagnosticRepository = _serviceBL.GetServiceComponentConclusionesDxServiceIdReport(ServicioId);
var doctoPhisicalExam = _serviceBL.GetDoctoPhisicalExam(ServicioId);
var MedicalCenter = _serviceBL.GetInfoMedicalCenter();
ReportPDF.CreateMedicalReportForExamenClinico(filiationData,
personMedicalHistory,
noxiousHabit,
familyMedicalAntecedent,
anamnesis,
serviceComponents,
diagnosticRepository,
EmpresaCliente,
MedicalCenter,
pathFile,
doctoPhisicalExam);
}
public void ReportPicture()
{
if (_pictureBL.CurrentPicture != null)
{
ReportPDF.ReportPicture(_pictureBL.CurrentPicture);
}
}
private void button3_Click(object sender, EventArgs e)
{
saveFileDialog3.FileName = string.Format("{0} 7C", "Alberto Merchan Cosme");
saveFileDialog3.Filter = "Files (*.pdf;)|*.pdf;";
_serviceId = txtServicio.Text.Trim();
_pacientId = txtPersona.Text.Trim();
if (saveFileDialog3.ShowDialog() == DialogResult.OK)
{
using (new LoadingClass.PleaseWait(this.Location, "Generando..."))
{
var _Valores = _serviceBL.GetServiceComponentsReport(_serviceId);
var filiationData = _pacientBL.GetPacientReportEPS(_serviceId);
var _DataService = _serviceBL.GetServiceReport(_serviceId);
var _listMedicoPersonales = _historyBL.GetPersonMedicalHistoryReport(_pacientId);
var _listaPatologicosFamiliares = _historyBL.GetFamilyMedicalAntecedentsReport(_pacientId);
var _listaHabitoNocivos = _historyBL.GetNoxiousHabitsReport(_pacientId);
var _PiezasCaries = _serviceBL.GetCantidadCaries(_serviceId, Constants.ODONTOGRAMA_ID, Constants.ODONTOGRAMA_PIEZAS_CARIES_ID);
var _PiezasAusentes = _serviceBL.GetCantidadAusentes(_serviceId, Constants.ODONTOGRAMA_ID, Constants.ODONTOGRAMA_PIEZAS_AUSENTES_ID);
var CuadroVacio = Common.Utils.BitmapToByteArray(Resources.CuadradoVacio);
var CuadroCheck = Common.Utils.BitmapToByteArray(Resources.CuadradoCheck);
var Pulmones = Common.Utils.BitmapToByteArray(Resources.MisPulmones);
var Audiometria = _serviceBL.ValoresComponenteOdontogramaValue1(_serviceId, Constants.AUDIOMETRIA_ID);
var diagnosticRepository = _serviceBL.GetServiceComponentConclusionesDxServiceIdReport(_serviceId);
var MedicalCenter = _serviceBL.GetInfoMedicalCenter();
ReportPDF.CreateAnexo7C(_DataService, filiationData, _Valores, _listMedicoPersonales, _listaPatologicosFamiliares, _listaHabitoNocivos, CuadroVacio, CuadroCheck, Pulmones, _PiezasCaries, _PiezasAusentes, Audiometria, diagnosticRepository, MedicalCenter, saveFileDialog3.FileName);
this.Enabled = true;
}
}
}
public void ExportPrint()
{
if (_pictureBL.CurrentPicture != null)
{
ReportPDF.ReportPictureList(_pictures);
}
}
public IActionResult GetReportUsers(DateTime?dateWith = null, DateTime?dateTo = null)
{
try
{
string currentEmail = this.User.FindFirst(ClaimTypes.Name).Value;
string myUserId = _userHelper.GetUserId(currentEmail);
if (myUserId == null)
{
return(NotFound("User not found"));
}
List <List <string> > reportUsersDTOs = null;
string title = "";
if (dateWith != null && dateTo == null)
{
reportUsersDTOs = _reportService.GetReportUsers(dateWith.Value);
title = $"Отчёт по всем пользователям за {dateWith.Value.ToString("dd.MM.yyyy")}";
_logger.LogInformation($"[{DateTime.Now.ToString()}]:[report/users/{dateWith.Value.Date.ToShortDateString()}]:" +
$"[info:create report by all users for {dateWith.Value.Date.ToShortDateString()}]:[user:{myUserId}]");
}
else if (dateWith != null && dateTo != null)
{
reportUsersDTOs = _reportService.GetReportUsers(dateWith.Value, dateTo.Value);
title = $"Отчёт по всем пользователям с {dateWith.Value.ToString("dd.MM.yyyy")} \nпо {dateTo.Value.ToString("dd.MM.yyyy")}";
_logger.LogInformation($"[{DateTime.Now.ToString()}]:[report/users/{dateWith.Value.Date.ToShortDateString()}/{dateTo.Value.Date.ToShortDateString()}]:" +
$"[info:create report by all users with {dateWith.Value.Date.ToShortDateString()} to {dateTo.Value.Date.ToShortDateString()}]:[user:{myUserId}]");
}
else
{
reportUsersDTOs = _reportService.GetReportUsers();
title = "Отчёт по всем пользователям за всё время";
_logger.LogInformation($"[{DateTime.Now.ToString()}]:[report/users]:[info:create report by all users]:[user:{myUserId}]");
}
ReportPDF reportUsers = new ReportPDF(_webHostEnvironment);
return(File(reportUsers.Report(reportUsersDTOs, title), "application/pdf"));
}
catch (ValidationException ex)
{
_logger.LogError($"[{DateTime.Now.ToString()}]:[[report/users/{dateWith}/{dateTo}]:[error:{ex.Property}, {ex.Message}]");
return(BadRequest(ex.Message));
}
catch (Exception ex)
{
_logger.LogError($"[{DateTime.Now.ToString()}]:[report/users/{dateWith}/{dateTo}]:[error:{ex}]");
return(BadRequest());
}
}
private void btnInformeMedicoTrabajador_Click(object sender, EventArgs e)
{
saveFileDialog1.FileName = string.Format("{0} Informe Resumen", _personFullName);
saveFileDialog1.Filter = "Files (*.pdf;)|*.pdf;";
//try
//{
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
using (new LoadingClass.PleaseWait(this.Location, "Generando..."))
{
this.Enabled = false;
var filiationData = _pacientBL.GetPacientReportEPS(_serviceId);
var personMedicalHistory = _historyBL.GetPersonMedicalHistoryReport(_pacientId);
var noxiousHabit = _historyBL.GetNoxiousHabitsReport(_pacientId);
var familyMedicalAntecedent = _historyBL.GetFamilyMedicalAntecedentsReport(_pacientId);
var anamnesis = _serviceBL.GetAnamnesisReport(_serviceId);
var serviceComponents = _serviceBL.GetServiceComponentsReport(_serviceId);
var diagnosticRepository = _serviceBL.GetServiceComponentConclusionesDxServiceIdReport(_serviceId);
var MedicalCenter = _serviceBL.GetInfoMedicalCenter();
ReportPDF.CreateMedicalReportForTheWorker(filiationData,
personMedicalHistory,
noxiousHabit,
familyMedicalAntecedent,
anamnesis,
serviceComponents,
diagnosticRepository,
_customerOrganizationName,
MedicalCenter,
saveFileDialog1.FileName);
this.Enabled = true;
}
}
//}
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message, "ERROR!", MessageBoxButtons.OK, MessageBoxIcon.Error);
// this.Enabled = true;
//}
}
static void Main(string[] args)
{
clsReport objReport;
clsDirector objDirector = new clsDirector();
ReportPDF objRptPdf = new ReportPDF();
objReport = objDirector.MakeReport(objRptPdf);
objReport.displayReport();
ReportExcel objRptExcel = new ReportExcel();
objReport = objDirector.MakeReport(objRptExcel);
objReport.displayReport();
Console.ReadLine();
}
public IActionResult GetReportProvider(int?providerId, DateTime?dateWith = null, DateTime?dateTo = null)
{
_logger.LogInformation($"{DateTime.Now.ToString()}: Processing request Report/GetReportProvider");
try
{
var provider = _providerService.GetProvider(providerId);
if (provider == null)
{
throw new ValidationException(_sharedLocalizer["ProviderNoFind"], "");
}
List <List <string> > reportList;
string title = "";
if (dateWith != null && dateTo == null)
{
reportList = _reportService.GetReportProvider(providerId, dateWith.Value);
title = $"{_sharedLocalizer["ReportByProvider"]} ({provider.Name}) {_sharedLocalizer["Per"]} {dateWith.Value.ToString("dd.MM.yyyy")}";
}
else if (dateWith != null && dateTo != null)
{
reportList = _reportService.GetReportProvider(providerId, dateWith.Value, dateTo.Value);
title = $"{_sharedLocalizer["ReportByProvider"]} ({provider.Name}) {_sharedLocalizer["With"]} {dateWith.Value.ToString("dd.MM.yyyy")} \n {_sharedLocalizer["By"]} {dateTo.Value.ToString("dd.MM.yyyy")}";
}
else
{
reportList = _reportService.GetReportProvider(providerId);
title = $"{_sharedLocalizer["ReportByProvider"]} ({provider.Name}) {_sharedLocalizer["ForAllTime_"]} ";
}
ReportPDF reportProvider = new ReportPDF(_webHostEnvironment);
_logger.LogInformation($"{DateTime.Now.ToString()}: Created report by provider {providerId.ToString()}");
return(File(reportProvider.Report(reportList, title), "application/pdf"));
}
catch (ValidationException ex)
{
ModelState.AddModelError(ex.Property, ex.Message);
_logger.LogError($"{DateTime.Now.ToString()}: {ex.Property}, {ex.Message}");
}
return(BadRequest(_sharedLocalizer["BadRequest"]));
}
private void btnImprimirInformeMedicoEPS_Click(object sender, EventArgs e)
{
saveFileDialog1.FileName = "Informe Médico EPS";
saveFileDialog1.Filter = "Files (*.pdf;)|*.pdf;";
try
{
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
using (new LoadingClass.PleaseWait(this.Location, "Generando..."))
{
this.Enabled = false;
var filiationData = _pacientBL.GetPacientReportEPS(_serviceId);
var personMedicalHistory = _historyBL.GetPersonMedicalHistoryReport(_pacientId);
var noxiousHabit = _historyBL.GetNoxiousHabitsReport(_pacientId);
var familyMedicalAntecedent = _historyBL.GetFamilyMedicalAntecedentsReport(_pacientId);
var anamnesis = _serviceBL.GetAnamnesisReport(_serviceId);
var serviceComponents = _serviceBL.GetServiceComponentsReport(_serviceId);
var diagnosticRepository = _serviceBL.GetServiceComponentConclusionesDxServiceIdReport(_serviceId);
ReportPDF.CreateMedicalReportEPS(filiationData,
personMedicalHistory,
noxiousHabit,
familyMedicalAntecedent,
anamnesis,
serviceComponents,
diagnosticRepository,
saveFileDialog1.FileName);
this.Enabled = true;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ERROR!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public IActionResult GetReportUser(string userId, DateTime?dateWith = null, DateTime?dateTo = null)
{
_logger.LogInformation($"{DateTime.Now.ToString()}: Processing request Report/GetReportUser");
try
{
var user = _userManager.Users.Where(p => p.Id == userId).FirstOrDefault();
if (user == null)
{
throw new ValidationException(_sharedLocalizer["UserNotFound"], "");
}
List <List <string> > reportUserDTOs = null;
string title = "";
if (dateWith != null && dateTo == null)
{
reportUserDTOs = _reportService.GetReportUser(userId, dateWith.Value);
title = $"{_sharedLocalizer["ReportByUser"]} ({user.Email}) {_sharedLocalizer["Per"]} {dateWith.Value.ToString("dd.MM.yyyy")}";
}
else if (dateWith != null && dateTo != null)
{
reportUserDTOs = _reportService.GetReportUser(userId, dateWith.Value, dateTo.Value);
title = $"{_sharedLocalizer["ReportByUser"]} ({user.Email}) {_sharedLocalizer["With"]} {dateWith.Value.ToString("dd.MM.yyyy")} \n {_sharedLocalizer["By_"]} {dateTo.Value.ToString("dd.MM.yyyy")}";
}
else
{
reportUserDTOs = _reportService.GetReportUser(userId);
title = $"{_sharedLocalizer["ReportByUser"]} ({user.Id}) {_sharedLocalizer["ForAllTime_"]}";
}
ReportPDF reportUser = new ReportPDF(_webHostEnvironment);
_logger.LogInformation($"{DateTime.Now.ToString()}: Created report by user {userId.ToString()}");
return(File(reportUser.Report(reportUserDTOs, title), "application/pdf"));
}
catch (ValidationException ex)
{
ModelState.AddModelError(ex.Property, ex.Message);
_logger.LogError($"{DateTime.Now.ToString()}: {ex.Property}, {ex.Message}");
}
return(BadRequest(_sharedLocalizer["BadRequest"]));
}
public IActionResult GetReportProviders(DateTime?dateWith = null, DateTime?dateTo = null)
{
_logger.LogInformation($"{DateTime.Now.ToString()}: Processing request Report/GetReportProviders");
try
{
List <List <string> > reportProvidersDTOs;
string title = "";
if (dateWith != null && dateTo == null)
{
reportProvidersDTOs = _reportService.GetReportProviders(dateWith.Value);
title = $"{_sharedLocalizer["ReportByProvidersPer"]} {dateWith.Value.ToString("dd.MM.yyyy")}";
}
else if (dateWith != null && dateTo != null)
{
reportProvidersDTOs = _reportService.GetReportProviders(dateWith.Value, dateTo.Value);
title = $"{_sharedLocalizer["ReportByProvidersWith"]} {dateWith.Value.ToString("dd.MM.yyyy")} \n {_sharedLocalizer["By_"]} {dateTo.Value.ToString("dd.MM.yyyy")}";
}
else
{
reportProvidersDTOs = _reportService.GetReportProviders();
title = _sharedLocalizer["ReportByProviderForAllTime"];
}
ReportPDF reportProviders = new ReportPDF(_webHostEnvironment);
_logger.LogInformation($"{DateTime.Now.ToString()}: Created report by providers");
return(File(reportProviders.Report(reportProvidersDTOs, title), "application/pdf"));
}
catch (ValidationException ex)
{
ModelState.AddModelError(ex.Property, ex.Message);
_logger.LogError($"{DateTime.Now.ToString()}: {ex.Property}, {ex.Message}");
}
return(BadRequest(_sharedLocalizer["BadRequest"]));
}
public IActionResult GetReportProvider(int providerId, DateTime?dateWith = null, DateTime?dateTo = null)
{
try
{
var provider = _providerService.GetProvider(providerId);
if (provider == null)
{
return(NotFound("Provider not found"));
}
string currentEmail = this.User.FindFirst(ClaimTypes.Name).Value;
string userId = _userHelper.GetUserId(currentEmail);
if (userId == null)
{
return(NotFound("User not found"));
}
List <List <string> > reportList;
string title = "";
if (dateWith != null && dateTo == null)
{
reportList = _reportService.GetReportProvider(providerId, dateWith.Value);
title = $"Отчёт по поставщику ({provider.Name}) за {dateWith.Value.ToString("dd.MM.yyyy")}";
_logger.LogInformation($"[{DateTime.Now.ToString()}]:[report/provider/{providerId}/{dateWith.Value.Date.ToShortDateString()}]:[info:create report by provider {providerId} for {dateWith.Value.Date.ToShortDateString()}]:[user:{userId}]");
}
else if (dateWith != null && dateTo != null)
{
reportList = _reportService.GetReportProvider(providerId, dateWith.Value, dateTo.Value);
title = $"Отчёт по поставщику ({provider.Name}) с {dateWith.Value.ToString("dd.MM.yyyy")} \nпо {dateTo.Value.ToString("dd.MM.yyyy")}";
_logger.LogInformation($"[{DateTime.Now.ToString()}]:[report/provider/{providerId}/{dateWith.Value.Date.ToShortDateString()}/{dateTo.Value.Date.ToShortDateString()}]:[info:create report by provider {providerId} with {dateWith.Value.Date.ToShortDateString()} to {dateTo.Value.Date.ToShortDateString()}]:[user:{userId}]");
}
else
{
reportList = _reportService.GetReportProvider(providerId);
title = $"Отчёт по поставщику ({provider.Name}) за всё время";
_logger.LogInformation($"[{DateTime.Now.ToString()}]:[report/provider/{providerId}]:[info:create report by provider {providerId}]:[user:{userId}]");
}
ReportPDF reportProvider = new ReportPDF(_webHostEnvironment);
return(File(reportProvider.Report(reportList, title), "application/pdf"));
}
catch (ValidationException ex)
{
_logger.LogError($"[{DateTime.Now.ToString()}]:[report/provider/{providerId}/{dateWith}/{dateTo}]:[error:{ex.Property}, {ex.Message}]");
return(BadRequest(ex.Message));
}
catch (Exception ex)
{
_logger.LogError($"[{DateTime.Now.ToString()}]:[report/provider/{providerId}/{dateWith}/{dateTo}]:[error:{ex}]");
return(BadRequest());
}
}
public bool CheckExistsReportPDF(string singleProjectID, string reportCode)
{
return(ReportPDF.CheckExistsReportPDF(singleProjectID, reportCode));
}
public string ReportExportPDF(string singleProjectID, string reportCode, bool delOldReportPDF)
{
return(ReportPDF.ReportExportPDF(singleProjectID, reportCode, delOldReportPDF));
}
public string ReportExportPDF(string archiveId, string reportCode, bool delOldReportPDF)
{
return(ReportPDF.ReportExportPDF(archiveId, reportCode, delOldReportPDF));
}
