protected void txtNroDocumento_TextChanged(object sender, EventArgs e)
{
if (txtNroDocumento.Text.Trim() != "")
{
Sigesoft.Node.WinClient.BE.PacientList objpacientDto = new Sigesoft.Node.WinClient.BE.PacientList();
OperationResult objOperationResult = new OperationResult();
PacientBL _objPacientBL = new PacientBL();
objpacientDto = _objPacientBL.GetPacient(ref objOperationResult, null, txtNroDocumento.Text.Trim());
if (objpacientDto == null)
{
txtNombres.Text = "";
txtApellidoPaterno.Text = "";
txtApellidoMaterno.Text = "";
ddlGenero.SelectedValue = "-1";
dpFechaNacimiento.SelectedDate = null;
txtPuesto.Text = "";
}
else
{
txtNombres.Text = objpacientDto.v_FirstName;
txtApellidoPaterno.Text = objpacientDto.v_FirstLastName;
txtApellidoMaterno.Text = objpacientDto.v_SecondLastName;
ddlGenero.SelectedValue = objpacientDto.i_SexTypeId.ToString();
dpFechaNacimiento.SelectedDate = objpacientDto.d_Birthdate;
txtPuesto.Text = objpacientDto.v_DocNumber;
}
}
}
private void frmClonServicio_Load(object sender, EventArgs e)
{
OperationResult objOperationResult = new OperationResult();
PacientBL _objPacientBL = new PacientBL();
var clientOrganization = BLL.Utils.GetJoinOrganizationAndLocation(ref objOperationResult, Globals.ClientSession.i_CurrentExecutionNodeId);
Utils.LoadDropDownList(ddlCustomerOrganization, "Value1", "Id", clientOrganization, DropDownListAction.Select);
Utils.LoadDropDownList(ddlProtocolId, "Value1", "Id", BLL.Utils.GetProtocolsByOrganizationForCombo(ref objOperationResult, "-1", "-1", null), DropDownListAction.Select);
var lista = _objPacientBL.GetAllCCosto();
txtCCosto.DataSource = lista;
txtCCosto.DisplayMember = "Puesto";
txtCCosto.ValueMember = "Puesto";
txtCCosto.AutoCompleteMode = Infragistics.Win.AutoCompleteMode.Suggest;
txtCCosto.AutoSuggestFilterMode = Infragistics.Win.AutoSuggestFilterMode.Contains;
this.txtCCosto.DropDownWidth = 250;
txtCCosto.DisplayLayout.Bands[0].Columns[0].Width = 10;
txtCCosto.DisplayLayout.Bands[0].Columns[1].Width = 250;
//if (!string.IsNullOrEmpty(objpacientDto.v_CurrentOccupation))
//{
// txtCCosto.Value = objpacientDto.v_CurrentOccupation;
//}
}
private string GetChangesPerson()
{
string cadena = new PacientBL().GetComentaryUpdateByPersonId(_PersonId);
string oldComentary = cadena;
cadena += "<FechaActualiza:" + DateTime.Now.ToString() + "|UsuarioActualiza:" + Globals.ClientSession.v_UserName + "|";
bool change = false;
foreach (var item in nombreCamposPersona)
{
var fields = this.Controls.Find(item, true);
string keyTagControl;
string value1;
if (fields.Length > 0)
{
keyTagControl = fields[0].GetType().Name;
value1 = GetValueControl(keyTagControl, fields[0]);
var ValorCampo = ListValuesCampoPersona.Find(x => x.NombreCampo == item).ValorCampo;
if (ValorCampo != value1)
{
cadena += item + ":" + ValorCampo + "|";
change = true;
}
}
}
if (change)
{
return(cadena);
}
return(oldComentary);
}
public frmOccupationalHistory(string pstrMode, string pstrHistoryId, string pstrPacientId, bool Validation)
{
OperationResult objOperationResult = new OperationResult();
PacientBL objPacientBL = new PacientBL();
PacientList objpersonDto = new PacientList();
InitializeComponent();
objpersonDto = objPacientBL.GetPacient(ref objOperationResult, pstrPacientId, null);
this.Text = this.Text + " (" + objpersonDto.v_FirstName + " " + objpersonDto.v_FirstLastName + " " + objpersonDto.v_SecondLastName + ")";
_Mode = pstrMode;
_HistoryId = pstrHistoryId;
_PacientId = pstrPacientId;
Utils.LoadDropDownList(ddlTypeOperationId, "Value1", "Id", BLL.Utils.GetSystemParameterForCombo(ref objOperationResult, 204, null), DropDownListAction.Select);
//frmHistory frm = new frmHistory(_PacientId);
//bool ResultValidation = false;
//ResultValidation = frm._Validation;
//if (Validation)
//{
// btnSave.Enabled = true;
//}
//else
//{
// btnSave.Enabled = false;
//}
}
public BoardGenerales GetDataGeneralEtario(string personId)
{
DatabaseContext ctx = new DatabaseContext();
var objPacient = ctx.Person.Where(x => x.v_PersonId == personId).FirstOrDefault();
int Edad = new PacientBL().GetEdad(objPacient.d_Birthdate.Value);
//int grupoEtario = ObtenerIdGrupoEtarioDePaciente(Edad);
BoardGenerales _BoardGenerales = new BoardGenerales();
if (Edad < 13)
{
_BoardGenerales.DataNinioCustom = new EsoAntecedentesDal().GetNinio(personId);
}
else if (13 <= Edad && Edad <= 17)
{
_BoardGenerales.DataAdolescenteCustom = new EsoAntecedentesDal().GetAdolescente(personId);
}
else if (18 <= Edad && Edad <= 64)
{
_BoardGenerales.DataAdultoCustom = new EsoAntecedentesDal().GetAdulto(personId);
}
else
{
_BoardGenerales.DataAdultoCustom = new EsoAntecedentesDal().GetAdultoMayor(personId);
}
return(_BoardGenerales);
}
private void GenerateLaboratorioReport(string pathFile, string pstrServiceId)
{
var MedicalCenter = new ServiceBL().GetInfoMedicalCenter();
var filiationData = new PacientBL().GetPacientReportEPS(pstrServiceId);
var serviceComponents = new ServiceBL().GetServiceComponentsReport(pstrServiceId);
LaboratorioReport.CreateLaboratorioReport(filiationData, serviceComponents, MedicalCenter, pathFile);
}
private void BindGrid()
{
CalendarBL objCalendarBL = new CalendarBL();
calendarDto objcalendarDto = new calendarDto();
PacientBL objPacientBL = new PacientBL();
PacientList objPacientDto = new PacientList();
OperationResult objOperationResult = new OperationResult();
var objData = GetData(0, null, "", strFilterExpression);
//Validar que el trabajador exista en el sistema
objPacientDto = objPacientBL.GetPacient(ref objOperationResult, null, txtDocNumber.Text.Trim());
//_CalendarId = objData[0].v_CalendarId;
if (objPacientDto == null)
{
MessageBox.Show("Este Trabajador no está ingresado en el sistema SIGESOFT.", "NO SE ENCONTRÓ TRABAJADOR!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
string Pacient = objPacientDto.v_FirstName + " " + objPacientDto.v_FirstLastName + " " + objPacientDto.v_SecondLastName;
if (objData.Count == 0)
{
MessageBox.Show("El trabajado " + Pacient + " no está agendado. Comuníquese con el área de Recepción.", "NO SE ENCONTRÓ CITA!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (objData[0].i_CalendarStatusId == (int)CalendarStatus.Cancelado)
{
MessageBox.Show("La cita del trabajor " + Pacient + " ha sido cancelada. Comuníquese con el área de recepción.", "¡INFORMACIÓN!", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (objData[0].i_CalendarStatusId != (int)CalendarStatus.Agendado)
{
MessageBox.Show("El trabajor " + Pacient + " ya está dentro del Centro Médico.", "¡INFORMACIÓN!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
DialogResult Result = MessageBox.Show("¿Desea registar el ingreso de " + Pacient + " al centro médico?", "TRABAJADOR AGENDADO!", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (Result == System.Windows.Forms.DialogResult.Yes)
{
foreach (var item in objData)
{
objcalendarDto = objCalendarBL.GetCalendar(ref objOperationResult, item.v_CalendarId);
objcalendarDto.d_EntryTimeCM = DateTime.Now;
objcalendarDto.i_CalendarStatusId = (int)CalendarStatus.Ingreso;
objCalendarBL.UpdateCalendar(ref objOperationResult, objcalendarDto, Globals.ClientSession.GetAsList());
}
}
_objLista = _objCalendarBL.GetCalendarsPagedAndFiltered1(ref objOperationResult, 0, null, "i_CalendarStatusId ASC , d_EntryTimeCM ASC", null, DateTime.Now.Date, DateTime.Now.Date.AddDays(1));
grdData.DataSource = _objLista;
lblRecordCountTotal.Text = "Total : " + _objLista.Count.ToString();
lblRecordCountPendiente.Text = "Pendientes : " + _objLista.FindAll(p => p.i_CalendarStatusId == (int)CalendarStatus.Agendado).Count();
}
}
public BoardEsoAntecedentes ObtenerEsoAntecedentesPorGrupoId(string PersonId)
{
BoardEsoAntecedentes _BoardEsoAntecedentes = new BoardEsoAntecedentes();
DatabaseContext ctx = new DatabaseContext();
DateTime BirthDatePacient = ctx.Person.Where(x => x.v_PersonId == PersonId).FirstOrDefault().d_Birthdate.Value;
int Edad = new PacientBL().GetEdad(BirthDatePacient);
int GrupoEtario = ObtenerIdGrupoEtarioDePaciente(Edad);
int GrupoBase = 282; //Antecedentes
int Grupo = int.Parse(GrupoBase.ToString() + GrupoEtario.ToString());
var Actual = new EsoAntecedentesDal().ObtenerEsoAntecedentesPorGrupoId(Grupo, GrupoEtario, PersonId);
int GrupoEtarioAnterior = 0;
switch (GrupoEtario)
{
case 1:
{
GrupoEtarioAnterior = 2;
break;
}
case 2:
{
GrupoEtarioAnterior = 4;
break;
}
case 3:
{
GrupoEtarioAnterior = 1;
break;
}
case 4:
{
GrupoEtarioAnterior = 4;
break;
}
default:
{
GrupoEtarioAnterior = 0;
break;
}
}
var Anterior = new EsoAntecedentesDal().ObtenerEsoAntecedentesPorGrupoId(Grupo, GrupoEtarioAnterior, PersonId);
_BoardEsoAntecedentes.AntecedenteActual = Actual;
_BoardEsoAntecedentes.AntecedenteAnterior = Anterior;
return(_BoardEsoAntecedentes);
}
private DataSet GetReportOftalmologiaAntiguo()
{
var dataListForReport = new PacientBL().GetReportOftalmologiaAntiguo(_serviceId, Constants.OFTALMOLOGIA_ID);
dsGetRepo = new DataSet();
DataTable dt = Sigesoft.Node.WinClient.BLL.Utils.ConvertToDatatable(dataListForReport);
dt.TableName = "dtOftalmologiaAntiguo";
dsGetRepo.Tables.Add(dt);
return(dsGetRepo);
}
private DataSet GetReportAlturaFisica()
{
var dataListForReport = new PacientBL().GetAlturaEstructural(_serviceId, Constants.ALTURA_ESTRUCTURAL_ID);
dsGetRepo = new DataSet();
DataTable dt = Sigesoft.Node.WinClient.BLL.Utils.ConvertToDatatable(dataListForReport);
dt.TableName = "dtAlturaEstructural";
dsGetRepo.Tables.Add(dt);
return(dsGetRepo);
}
private DataSet GetReportPsicologia()
{
var dataListForReport = new PacientBL().GetFichaPsicologicaOcupacional(_serviceId);
dsGetRepo = new DataSet();
DataTable dt = Sigesoft.Node.WinClient.BLL.Utils.ConvertToDatatable(dataListForReport);
dt.TableName = "InformePsico";
dsGetRepo.Tables.Add(dt);
return(dsGetRepo);
}
private DataSet GetReportOsteomuscular2()
{
var dataListForReport = new PacientBL().GetMusculoEsqueletico(_serviceId, Constants.OSTEO_MUSCULAR_ID_1);
dsGetRepo = new DataSet();
DataTable dt = Sigesoft.Node.WinClient.BLL.Utils.ConvertToDatatable(dataListForReport);
dt.TableName = "dtMusculoEsqueletico";
dsGetRepo.Tables.Add(dt);
return dsGetRepo;
}
private void btnFilter_Click(object sender, EventArgs e)
{
using (new LoadingClass.PleaseWait(this.Location, "Generando..."))
{
var MedicalCenter = new ServiceBL().GetInfoMedicalCenter();
List <string> Filters = new List <string>();
DateTime? pdatBeginDate = dtpDateTimeStar.Value.Date;
DateTime? pdatEndDate = dptDateTimeEnd.Value.Date.AddDays(1);
if (ddlCustomerOrganization.SelectedValue.ToString() != "-1")
{
var id3 = ddlCustomerOrganization.SelectedValue.ToString().Split('|');
Filters.Add("v_CustomerOrganizationId==" + "\"" + id3[0] + "\"&&v_CustomerLocationId==" + "\"" + id3[1] + "\"");
}
if (ddlProtocolId.SelectedValue.ToString() != "-1")
{
Filters.Add("IdProtocolId==" + "\"" + ddlProtocolId.SelectedValue + "\"");
}
// Create the Filter Expression
strFilterExpression = null;
if (Filters.Count > 0)
{
foreach (string item in Filters)
{
strFilterExpression = strFilterExpression + item + " && ";
}
strFilterExpression = strFilterExpression.Substring(0, strFilterExpression.Length - 4);
}
if (MedicalCenter.v_IdentificationNumber == "20505518145")
{
var objData = new PacientBL().ReporteMatrizExcelSanJoaquin(pdatBeginDate, pdatEndDate, ddlCustomerOrganization.SelectedValue.ToString(), strFilterExpression);
grdData.DataSource = objData;
lblRecordCount.Text = string.Format("Se encontraron {0} registros.", objData.Count());
}
else
{
//var objData = new PacientBL().ReporteMatrizExcel(pdatBeginDate, pdatEndDate, ddlCustomerOrganization.SelectedValue.ToString(), strFilterExpression);
var objData = new PacientBL().ReporteMatrizExcel(pdatBeginDate, pdatEndDate, ddlCustomerOrganization.SelectedValue.ToString(), strFilterExpression);
grdData.DataSource = objData;
lblRecordCount.Text = string.Format("Se encontraron {0} registros.", objData.Count());
}
}
}
private void frmConsentimientoHojaRuta_Load(object sender, EventArgs e)
{
using (new LoadingClass.PleaseWait(this.Location, "Generando..."))
{
crConsentimientoHojaRuta rp = null;
rp = new Reports.crConsentimientoHojaRuta();
//Hoja de Ruta
OperationResult objOperationResult = new OperationResult();
// Cabecera
var headerRoadMap = _calendarBL.GetHeaderRoadMap(_calendarId);
// Detalle
var detailRoadMap = _serviceBL.GetServiceComponentsByCategoryExceptLab(ref objOperationResult, _serviceId);
DataSet ds = new DataSet();
DataTable dtHeader = Sigesoft.Node.WinClient.BLL.Utils.ConvertToDatatable(headerRoadMap);
DataTable dtDetail = Sigesoft.Node.WinClient.BLL.Utils.ConvertToDatatable(detailRoadMap);
dtHeader.TableName = "dtHeaderRoadMap";
dtDetail.TableName = "dtDetailRoadMap";
ds.Tables.Add(dtHeader);
ds.Tables.Add(dtDetail);
rp.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Landscape;
rp.Subreports["crRoadMap.rpt"].SetDataSource(ds);
rp.DetailSection1.SectionFormat.EnableSuppress = false;
////Consentimiento
var aptitudeCertificate = new PacientBL().GetReportConsentimiento(_serviceId);
DataSet ds1 = new DataSet();
DataTable dt = Sigesoft.Node.WinClient.BLL.Utils.ConvertToDatatable(aptitudeCertificate);
dt.TableName = "dtConsentimiento";
ds1.Tables.Add(dt);
rp.Subreports["crConsentimiento.rpt"].SetDataSource(ds1);
rp.Section3.SectionFormat.EnableSuppress = false;
crystalReportViewer1.EnableDrillDown = false;
var Path = Application.StartupPath;
rp.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Path + @"\Temp\Reporte.pdf");
crystalReportViewer1.ReportSource = rp;
crystalReportViewer1.Show();
}
}
public frmTramasSusalud()
{
InitializeComponent();
OperationResult objOperationResult = new OperationResult();
PacientBL _PacientBL = new PacientBL();
using (new LoadingClass.PleaseWait(this.Location, "Data CIE10..."))
{
lista = _PacientBL.LlenarDxsTramas(ref objOperationResult);
};
using (new LoadingClass.PleaseWait(this.Location, "Data UPS..."))
{
listaUps = _PacientBL.LlenarListaUps(ref objOperationResult);
};
using (new LoadingClass.PleaseWait(this.Location, "Data Procedimientos..."))
{
listaproc = _PacientBL.LlenarListaProc(ref objOperationResult);
};
}
private void LoadPerson()
{
PacientList objpacientDto = new PacientList();
PacientBL _objPacientBL = new PacientBL();
OperationResult objOperationResult = new OperationResult();
objpacientDto = _objPacientBL.GetPacient(ref objOperationResult, _PersonId, null);
NumberDocument = objpacientDto.v_DocNumber;
txtName.Text = objpacientDto.v_FirstName;
txtFirstLastName.Text = objpacientDto.v_FirstLastName;
txtSecondLastName.Text = objpacientDto.v_SecondLastName;
ddlDocTypeId.SelectedValue = objpacientDto.i_DocTypeId.ToString();
ddlSexTypeId.SelectedValue = objpacientDto.i_SexTypeId.ToString();
ddlMaritalStatusId.SelectedValue = objpacientDto.i_MaritalStatusId.ToString();
ddlLevelOfId.SelectedValue = objpacientDto.i_LevelOfId.ToString();
txtDocNumber.Text = objpacientDto.v_DocNumber;
txtTelephoneNumber.Text = objpacientDto.v_TelephoneNumber;
txtMail.Text = objpacientDto.v_Mail;
}
public MessageCustom UpdateDataAdultoMayor(BoardGenerales data, int userId, int nodeId)
{
MessageCustom _MessageCustom = new MessageCustom();
try
{
using (var ts = new TransactionScope())
{
DatabaseContext ctx = new DatabaseContext();
var objPacient = ctx.Person.Where(x => x.v_PersonId == data.DataAdultoMayorCustom.v_PersonId).FirstOrDefault();
int Edad = new PacientBL().GetEdad(objPacient.d_Birthdate.Value);
int GrupoEtario = ObtenerIdGrupoEtarioDePaciente(Edad);
bool resultado = new EsoAntecedentesDal().GuardarAntecedenteAsistencial(data.EsoAntecedentesPadre, userId, data.DataAdultoMayorCustom.v_PersonId, GrupoEtario, nodeId);
var result = new EsoAntecedentesDal().UpdateDataAdultoMayor(data.DataAdultoMayorCustom, userId);
if (result == null)
{
throw new Exception("");
}
else
{
_MessageCustom.Error = false;
_MessageCustom.Status = (int)StatusHttp.Ok;
_MessageCustom.Id = result;
_MessageCustom.Message = "Los datos se actualizaron correctamente.";
}
ts.Complete();
}
return(_MessageCustom);
}
catch (Exception ex)
{
_MessageCustom.Error = true;
_MessageCustom.Status = (int)StatusHttp.BadRequest;
_MessageCustom.Message = "Sucedió un error al actualizar, por favor vuelva a intentar.";
return(_MessageCustom);
}
}
private void ShowReport()
{
OperationResult objOperationResult = new OperationResult();
var rp = new Reports.crAlturaMayor();
var aptitudeCertificate = new PacientBL().GetAlturaEstructural(_serviceId, _ComponentId);
DataSet ds1 = new DataSet();
DataTable dt = Sigesoft.Node.WinClient.BLL.Utils.ConvertToDatatable(aptitudeCertificate);
dt.TableName = "dtAlturaEstructural";
ds1.Tables.Add(dt);
rp.SetDataSource(ds1);
crystalReportViewer1.ReportSource = rp;
crystalReportViewer1.Show();
}
private DataSet GetReportAlturaFisica()
{
var servicesId8 = new List <string>();
servicesId8.Add(_serviceId);
var componentReportId8 = new ServiceBL().ObtenerIdsParaImportacionExcel(servicesId8, 11);
var dataListForReport = new PacientBL().GetAlturaEstructural(_serviceId, Constants.ALTURA_ESTRUCTURAL_ID, componentReportId8[0].ComponentId);
//var dataListForReport = new PacientBL().GetAlturaEstructural(_serviceId, Constants.ALTURA_ESTRUCTURAL_ID);
dsGetRepo = new DataSet();
DataTable dt = Sigesoft.Node.WinClient.BLL.Utils.ConvertToDatatable(dataListForReport);
dt.TableName = "dtAlturaEstructural";
dsGetRepo.Tables.Add(dt);
return(dsGetRepo);
}
private void ShowReport()
{
OperationResult objOperationResult = new OperationResult();
var rp = new Reports.InformePsicologicoOcupacional();
var aptitudeCertificate = new PacientBL().GetFichaPsicologicaOcupacional(_serviceId);
DataSet ds1 = new DataSet();
DataTable dt = Sigesoft.Node.WinClient.BLL.Utils.ConvertToDatatable(aptitudeCertificate);
dt.TableName = "InformePsico";
ds1.Tables.Add(dt);
rp.SetDataSource(ds1);
crystalReportViewer1.ReportSource = rp;
crystalReportViewer1.Show();
}
private void bgwSendEmail(string PersonId, string Nombre, string ApePaterno, string ApeMaterno, string Pass, string Email)
{
OperationResult objOperationResult = new OperationResult();
try
{
//Obtener el nuevo Pass
string decimalNumber = Pass;
int number = int.Parse(decimalNumber);
string hex = number.ToString("x");
string NuevoPAss = hex.ToString();
//Actualizar nuevo Pass
PacientBL oPacientBL = new PacientBL();
oPacientBL.ActualizarContraseniaPaciente(ref objOperationResult, PersonId, NuevoPAss);
// Obtener los Parametros necesarios para el envio de notificación
var configEmail = _objSystemParameterBL.GetSystemParameterForComboOrder(ref objOperationResult, 161, "i_ParameterId");
string smtp = configEmail[0].Value1.ToLower();
int port = int.Parse(configEmail[1].Value1);
string from = configEmail[2].Value1.ToLower();
string fromPassword = configEmail[4].Value1;
string subject = configEmail[6].Value1;
bool enableSsl = Convert.ToBoolean(int.Parse(configEmail[3].Value1));
string personName = string.Format("{0} {1} {2}", Nombre, ApePaterno, ApeMaterno);
string message = string.Format(configEmail[5].Value1, personName, email.Value.Trim(), NuevoPAss);
// Enviar notificación de usuario y clave via email
Sigesoft.Common.Utils.SendMessage(smtp, port, enableSsl, true, from, fromPassword, Email, "", subject, message, null);
}
catch (Exception ex)
{}
}
private void grdDataCalendar_AfterSelectChange(object sender, Infragistics.Win.UltraWinGrid.AfterSelectChangeEventArgs e)
{
btnConsentimiento.Enabled = btnExportExcel.Enabled = btnExportPdf.Enabled = (grdDataCalendar.Selected.Rows.Count > 0);
btnSendEmail.Enabled = (grdDataCalendar.Selected.Rows.Count > 0 && _sendEmailEnabled);
if (grdDataCalendar.Selected.Rows.Count != 0)
{
OperationResult objOperationResult = new OperationResult();
ServiceBL objServiceBL = new ServiceBL();
PacientBL objPacientBL = new PacientBL();
personDto objpersonDto = new personDto();
List <ServiceComponentList> ListServiceComponent = new List <ServiceComponentList>();
//string strServicelId = grdDataCalendar.Selected.Rows[0].Cells[5].Value.ToString();
_strServicelId = grdDataCalendar.Selected.Rows[0].Cells[5].Value.ToString();
ListServiceComponent = objServiceBL.GetServiceComponents(ref objOperationResult, _strServicelId);
grdDataServiceComponent.DataSource = ListServiceComponent;
txtTrabajador.Text = grdDataCalendar.Selected.Rows[0].Cells["v_Pacient"].Value.ToString();
_PacientId = grdDataCalendar.Selected.Rows[0].Cells["v_PersonId"].Value.ToString();
_serviceId = grdDataCalendar.Selected.Rows[0].Cells["v_ServiceId"].Value.ToString();
_calendarId = grdDataCalendar.Selected.Rows[0].Cells["v_CalendarId"].Value.ToString();
if (grdDataCalendar.Selected.Rows[0].Cells["v_WorkingOrganizationName"].Value != null)
{
WorkingOrganization.Text = grdDataCalendar.Selected.Rows[0].Cells["v_WorkingOrganizationName"].Value.ToString();
}
txtProtocol.Text = grdDataCalendar.Selected.Rows[0].Cells["v_ProtocolName"].Value == null ? "" : grdDataCalendar.Selected.Rows[0].Cells["v_ProtocolName"].Value.ToString();
txtService.Text = grdDataCalendar.Selected.Rows[0].Cells["v_ServiceName"].Value.ToString();
if (grdDataCalendar.Selected.Rows[0].Cells["v_ProtocolId"].Value != null)
{
if (grdDataCalendar.Selected.Rows[0].Cells["v_ProtocolId"].Value.ToString() == Constants.CONSULTAMEDICA)
{
txtTypeESO.Text = "";
}
else
{
txtTypeESO.Text = grdDataCalendar.Selected.Rows[0].Cells["v_EsoTypeName"].Value.ToString();
}
}
objpersonDto = objPacientBL.GetPerson(ref objOperationResult, _PacientId);
//Byte[] ooo = (byte[])grdDataCalendar.Selected.Rows[0].Cells["b_PersonImage"].Value;
Byte[] ooo = objpersonDto.b_PersonImage;
if (ooo == null)
{
//pbImage.SizeMode = PictureBoxSizeMode.CenterImage;
pbImage.Image = Resources.nofoto;
_personImage = null;
}
else
{
//pbImage.SizeMode = PictureBoxSizeMode.Zoom;
pbImage.Image = Common.Utils.BytesArrayToImageOficce(ooo, pbImage);
_personImage = ooo;
}
// Huella y Firma
if (objpersonDto.b_FingerPrintImage == null)
{
txtExisteHuella.Text = "NO REGISTRADO";
txtExisteHuella.ForeColor = Color.Red;
}
else
{
txtExisteHuella.Text = "REGISTRADO";
txtExisteHuella.ForeColor = Color.DarkBlue;
}
// Firma
if (objpersonDto.b_RubricImage == null)
{
txtExisteFirma.Text = "NO REGISTRADO";
txtExisteFirma.ForeColor = Color.Red;
}
else
{
txtExisteFirma.Text = "REGISTRADO";
txtExisteFirma.ForeColor = Color.DarkBlue;
}
}
btnImprimirHojaRuta.Enabled = (grdDataServiceComponent.Rows.Count > 0);
}
private void btnOK_Click(object sender, EventArgs e)
{
//if (_auxiliaryExams == null)
// _auxiliaryExams = new List<ServiceComponentList>();
try
{
var ruta = Common.Utils.GetApplicationConfigValue("rutaExamenesAdicionales").ToString();
var rutaBasura = Common.Utils.GetApplicationConfigValue("rutaReportesBasura").ToString();
string pathFile = "";
string CMP = "";
var openFile = false;
using (new LoadingClass.PleaseWait(this.Location, "Cargando..."))
{
OperationResult objOperationResult = new OperationResult();
List <AdditionalExamCustom> ListAdditionalExam = new List <AdditionalExamCustom>();
foreach (ListViewItem item in lvExamenesSeleccionados.Items)
{
AdditionalExamCustom _additionalExam = new AdditionalExamCustom();
var fields = item.SubItems;
_additionalExam.ComponentId = fields[1].Text;
_additionalExam.IsProcessed = int.Parse(fields[2].Text);
_additionalExam.IsNewService = int.Parse(fields[3].Text);
_additionalExam.Commentary = txtCommentary.Text;
_additionalExam.ServiceId = _serviceId;
_additionalExam.PersonId = _personId;
_additionalExam.ProtocolId = "";
if (_additionalExam.IsNewService == 1)
{
_additionalExam.ProtocolId = Constants.Prot_Hospi_Adic;
}
ListAdditionalExam.Add(_additionalExam);
}
var datosGrabo = objServiceBL.DevolverDatosUsuarioFirma(Globals.ClientSession.i_SystemUserId);
if (datosGrabo != null)
{
if (datosGrabo.CMP != null)
{
CMP = datosGrabo.CMP;
pathFile = string.Format("{0}.pdf", Path.Combine(ruta, _serviceId + "-" + "ORDEN-EX-MED-ADICI-" + datosGrabo.CMP));
}
}
using (var ts = new TransactionScope())
{
var success = _additionalExamBl.AddAdditionalExam(ListAdditionalExam, Globals.ClientSession.GetAsList());
if (!success)
{
throw new Exception("Sucedió un error, por favor vuelva a intentarlo");
}
ts.Complete();
}
List <Categoria> AdditionalExam = new List <Categoria>();
List <Categoria> DataSource = new List <Categoria>();
List <string> ComponentList = new List <string>();
var ListadditExam = new AdditionalExamBL().GetAdditionalExamByServiceId_all(_serviceId, Globals.ClientSession.i_SystemUserId);
foreach (var componenyId in ListadditExam)
{
ComponentList.Add(componenyId.ComponentId);
}
foreach (var componentId in ComponentList)
{
var ListServiceComponent = new ServiceBL().GetAllComponents(ref objOperationResult, (int)TipoBusqueda.ComponentId, componentId);
Categoria categoria = DataSource.Find(x => x.i_CategoryId == ListServiceComponent[0].i_CategoryId);
if (categoria != null)
{
List <ComponentDetailList> componentDetail = new List <ComponentDetailList>();
componentDetail = ListServiceComponent[0].Componentes;
DataSource.Find(x => x.i_CategoryId == ListServiceComponent[0].i_CategoryId).Componentes.AddRange(componentDetail);
}
else
{
DataSource.AddRange(ListServiceComponent);
}
}
var MedicalCenter = objServiceBL.GetInfoMedicalCenter();
var DatosPaciente = new PacientBL().DevolverDatosPaciente(_serviceId);
new PrintAdditionalExam().GenerateAdditionalexam(pathFile, MedicalCenter, DatosPaciente, datosGrabo, txtCommentary.Text, DataSource, ListadditExam);
}
List <string> pdfList = new List <string>();
pdfList.Add(pathFile);
_mergeExPDF.FilesName = pdfList;
_mergeExPDF.DestinationFile = string.Format("{0}.pdf", Path.Combine(rutaBasura, _serviceId + "-" + "ORDEN-EX-MED-ADICI-" + CMP));
_mergeExPDF.Execute();
_mergeExPDF.RunFile();
this.Close();
}
catch (Exception ex)
{
MessageBox.Show("ERROR:" + ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
public List <EsoCuidadosPreventivosFechas> ObtenerFechasCuidadosPreventivos(string PersonId)
{
try
{
DatabaseContext ctx = new DatabaseContext();
var objPacient = ctx.Person.Where(x => x.v_PersonId == PersonId).FirstOrDefault();
int Edad = new PacientBL().GetEdad(objPacient.d_Birthdate.Value);
int _GrupoEtario = ObtenerIdGrupoEtarioDePaciente(Edad);
int GrupoBase = 0;
switch (_GrupoEtario)
{
case (int)GrupoEtario.Ninio:
{
GrupoBase = 292;
break;
}
case (int)GrupoEtario.Adolecente:
{
GrupoBase = 285;
break;
}
case (int)GrupoEtario.Adulto:
{
if (objPacient.i_SexTypeId == 1)
{
GrupoBase = 284;
break;
}
else
{
GrupoBase = 283;
break;
}
}
case (int)GrupoEtario.AdultoMayor:
{
GrupoBase = 286;
break;
}
default:
{
GrupoBase = 0;
break;
}
}
var data = new EsoAntecedentesDal().ObtenerFechasCuidadosPreventivos(PersonId);
var Comentarios = new EsoAntecedentesDal().ObtenerComentariosCuidadosPreventivos(PersonId);
foreach (var F in data)
{
F.Listado = new EsoAntecedentesDal().ObtenerListadoCuidadosPreventivos(GrupoBase, PersonId, F.FechaServicio);
foreach (var obj in F.Listado)
{
var newGrupo = obj.GrupoId.ToString() + obj.ParameterId.ToString();
int Group = int.Parse(newGrupo);
var find = Comentarios.Find(x => x.GrupoId == Group && x.ParametroId == obj.ParameterId);
if (find != null)
{
obj.DataComentario = find;
}
}
}
return(data);
}
catch (Exception e)
{
return(new List <EsoCuidadosPreventivosFechas>());
}
}
private void grdDataCalendar_MouseDown(object sender, MouseEventArgs e)
{
Point point = new System.Drawing.Point(e.X, e.Y);
Infragistics.Win.UIElement uiElement = ((Infragistics.Win.UltraWinGrid.UltraGridBase)sender).DisplayLayout.UIElement.ElementFromPoint(point);
if (uiElement == null || uiElement.Parent == null)
{
return;
}
Infragistics.Win.UltraWinGrid.UltraGridRow row = (Infragistics.Win.UltraWinGrid.UltraGridRow)uiElement.GetContext(typeof(Infragistics.Win.UltraWinGrid.UltraGridRow));
if (e.Button == MouseButtons.Right)
{
if (row != null)
{
_RowIndexgrdDataCalendar = row.Index;
grdDataCalendar.Rows[row.Index].Selected = true;
int CalendarStatusId = int.Parse(grdDataCalendar.Selected.Rows[0].Cells["i_CalendarStatusId"].Value.ToString());
int LineStatusId = int.Parse(grdDataCalendar.Selected.Rows[0].Cells["i_LineStatusId"].Value.ToString());
int ServiceStatusId = int.Parse(grdDataCalendar.Selected.Rows[0].Cells["i_ServiceStatusId"].Value.ToString());
_PacientId = grdDataCalendar.Selected.Rows[0].Cells["v_PersonId"].Value.ToString();
if (CalendarStatusId == (int)Common.CalendarStatus.Agendado)
{
contextMenuStrip1.Items["mnuCancelCalendar"].Enabled = true;
contextMenuStrip1.Items["mnuFinCircuito"].Enabled = false;
contextMenuStrip1.Items["mnuComenzarCircuito"].Enabled = true;
contextMenuStrip1.Items["mnuReagendarCita"].Enabled = true;
}
else if (CalendarStatusId == (int)Common.CalendarStatus.Atendido)
{
contextMenuStrip1.Items["mnuCancelCalendar"].Enabled = false;
contextMenuStrip1.Items["mnuFinCircuito"].Enabled = true;
contextMenuStrip1.Items["mnuComenzarCircuito"].Enabled = false;
contextMenuStrip1.Items["mnuReagendarCita"].Enabled = false;
}
else if (CalendarStatusId == (int)Common.CalendarStatus.Cancelado)
{
contextMenuStrip1.Items["mnuCancelCalendar"].Enabled = false;
contextMenuStrip1.Items["mnuFinCircuito"].Enabled = false;
contextMenuStrip1.Items["mnuComenzarCircuito"].Enabled = false;
contextMenuStrip1.Items["mnuReagendarCita"].Enabled = true;
}
if (LineStatusId == (int)Common.LineStatus.FueraCircuito && CalendarStatusId == (int)Common.CalendarStatus.Atendido)
{
contextMenuStrip1.Items["mnuCancelCalendar"].Enabled = false;
contextMenuStrip1.Items["mnuFinCircuito"].Enabled = false;
contextMenuStrip1.Items["mnuComenzarCircuito"].Enabled = false;
contextMenuStrip1.Items["mnuReagendarCita"].Enabled = false;
}
OperationResult objOperationResult = new OperationResult();
ServiceBL objServiceBL = new ServiceBL();
List <ServiceComponentList> ListServiceComponent = new List <ServiceComponentList>();
_strServicelId = grdDataCalendar.Selected.Rows[0].Cells[5].Value.ToString();
ListServiceComponent = objServiceBL.GetServiceComponents(ref objOperationResult, _strServicelId);
grdDataServiceComponent.DataSource = ListServiceComponent;
}
else
{
contextMenuStrip1.Items["mnuCancelCalendar"].Enabled = false;
contextMenuStrip1.Items["mnuFinCircuito"].Enabled = false;
contextMenuStrip1.Items["mnuComenzarCircuito"].Enabled = false;
contextMenuStrip1.Items["mnuReagendarCita"].Enabled = false;
}
}
if (e.Button == MouseButtons.Left)
{
if (row != null)
{
OperationResult objOperationResult = new OperationResult();
ServiceBL objServiceBL = new ServiceBL();
List <ServiceComponentList> ListServiceComponent = new List <ServiceComponentList>();
PacientBL objPacientBL = new PacientBL();
personDto objpersonDto = new personDto();
_PacientId = grdDataCalendar.Selected.Rows[0].Cells["v_PersonId"].Value.ToString();
//string strServicelId = grdDataCalendar.Selected.Rows[0].Cells[5].Value.ToString();
_strServicelId = grdDataCalendar.Selected.Rows[0].Cells[5].Value.ToString();
ListServiceComponent = objServiceBL.GetServiceComponents(ref objOperationResult, _strServicelId);
grdDataServiceComponent.DataSource = ListServiceComponent;
txtTrabajador.Text = grdDataCalendar.Selected.Rows[0].Cells["v_Pacient"].Value.ToString();
if (grdDataCalendar.Selected.Rows[0].Cells["v_WorkingOrganizationName"].Value != null)
{
WorkingOrganization.Text = grdDataCalendar.Selected.Rows[0].Cells["v_WorkingOrganizationName"].Value.ToString();
}
txtProtocol.Text = grdDataCalendar.Selected.Rows[0].Cells["v_ProtocolName"].Value == null ? "" : grdDataCalendar.Selected.Rows[0].Cells["v_ProtocolName"].Value.ToString();
txtService.Text = grdDataCalendar.Selected.Rows[0].Cells["v_ServiceName"].Value.ToString();
if (grdDataCalendar.Selected.Rows[0].Cells["v_ProtocolId"].Value != null)
{
if (grdDataCalendar.Selected.Rows[0].Cells["v_ProtocolId"].Value.ToString() == Constants.CONSULTAMEDICA)
{
txtTypeESO.Text = "";
}
else
{
txtTypeESO.Text = grdDataCalendar.Selected.Rows[0].Cells["v_EsoTypeName"].Value.ToString();
}
}
_personName = grdDataCalendar.Selected.Rows[0].Cells["v_Pacient"].Value.ToString();
objpersonDto = objPacientBL.GetPerson(ref objOperationResult, _PacientId);
Byte[] ooo = objpersonDto.b_PersonImage;
if (ooo == null)
{
pbImage.Image = Resources.nofoto;
}
else
{
pbImage.Image = Common.Utils.BytesArrayToImageOficce(ooo, pbImage);
_personImage = ooo;
}
// Huella y Firma
if (objpersonDto.b_FingerPrintImage == null)
{
txtExisteHuella.Text = "NO REGISTRADO";
txtExisteHuella.ForeColor = Color.Red;
}
else
{
txtExisteHuella.Text = "REGISTRADO";
txtExisteHuella.ForeColor = Color.DarkBlue;
}
// Firma
if (objpersonDto.b_RubricImage == null)
{
txtExisteFirma.Text = "NO REGISTRADO";
txtExisteFirma.ForeColor = Color.Red;
}
else
{
txtExisteFirma.Text = "REGISTRADO";
txtExisteFirma.ForeColor = Color.DarkBlue;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
ReportDocument rp = new ReportDocument();
OperationResult objOperationResult = new OperationResult();
List <string> _filesNameToMerge = new List <string>();
string ServiceId = null;
//setear dato de aptitud
if (Request.QueryString["v_ServiceId"] != null)
{
ServiceId = Request.QueryString["v_ServiceId"].ToString();
}
if (Session["ConsultorioId"] == null)
{
_tempSourcePath = Path.Combine(Server.MapPath("/TempMerge"));
List <MyListWeb> ListaServicios = (List <MyListWeb>)Session["objLista"];
foreach (var item in ListaServicios)
{
var aptitudeCertificate = new ServiceBL().GetAptitudeCertificate(ref objOperationResult, item.IdServicio).ToList();
DataSet ds = new DataSet();
DataTable dt = Sigesoft.Server.WebClientAdmin.UI.Utils.ConvertToDatatable(aptitudeCertificate);
dt.TableName = "AptitudeCertificate";
ds.Tables.Add(dt);
if (aptitudeCertificate[0].i_NumberQuotasMen == (int)EmpresaDx.ConDx)
{
if (aptitudeCertificate[0].i_EsoTypeId == ((int)TypeESO.Retiro).ToString())
{
rp.Load(Server.MapPath("crOccupationalMedicalAptitudeCertificateRetiros.rpt"));
}
else
{
if (aptitudeCertificate[0].i_AptitudeStatusId == (int)AptitudeStatus.AptoObs)
{
rp.Load(Server.MapPath("cr.CertficadoObservado.rpt"));
}
else
{
rp.Load(Server.MapPath("crOccupationalMedicalAptitudeCertificate.rpt"));
}
}
}
else
{
if (aptitudeCertificate[0].i_EsoTypeId == ((int)TypeESO.Retiro).ToString())
{
rp.Load(Server.MapPath("crOccupationalRetirosSinDx.rpt"));
}
else
{
if (aptitudeCertificate[0].i_AptitudeStatusId == (int)AptitudeStatus.AptoObs)
{
rp.Load(Server.MapPath("cr.CertficadoObservadoSinDx.rpt"));
}
else
{
rp.Load(Server.MapPath("crOccupationalMedicalAptitudeCertificateSinDx.rpt"));
}
}
}
//rp.Load(Server.MapPath("crOccupationalMedicalAptitudeCertificate.rpt"));
rp.SetDataSource(ds);
rp.SetDataSource(ds);
var ruta = Server.MapPath("files/CM" + item.IdServicio.ToString() + ".pdf");
_filesNameToMerge.Add(ruta);
rp.ExportToDisk(ExportFormatType.PortableDocFormat, ruta);
}
_mergeExPDF.FilesName = _filesNameToMerge;
string Dif = Guid.NewGuid().ToString();
string NewPath = Server.MapPath("files/" + Dif + ".pdf");
_mergeExPDF.DestinationFile = NewPath;
_mergeExPDF.Execute();
ShowPdf1.FilePath = "files/" + Dif + ".pdf";
}
else if (Session["ConsultorioId"].ToString() == "6") // RX
{
var RX_TORAX_ID = new ServiceBL().ReportRadiologico(ServiceId, Constants.RX_TORAX_ID);
DataSet ds = new DataSet();
DataTable dt = Sigesoft.Server.WebClientAdmin.UI.Utils.ConvertToDatatable(RX_TORAX_ID);
dt.TableName = "dtRadiologico";
ds.Tables.Add(dt);
rp.Load(Server.MapPath("crInformeRadiologico.rpt"));
rp.SetDataSource(ds);
rp.SetDataSource(ds);
var ruta = Server.MapPath("files/CM" + ServiceId + ".pdf");
_filesNameToMerge.Add(ruta);
var OIT_ID = new ServiceBL().ReportInformeRadiografico(ServiceId, Constants.OIT_ID);
if (OIT_ID.Count != 0)
{
DataSet dsOIT_ID = new DataSet();
DataTable dtOIT_ID = Sigesoft.Server.WebClientAdmin.UI.Utils.ConvertToDatatable(OIT_ID);
dtOIT_ID.TableName = "dtInformeRadiografico";
dsOIT_ID.Tables.Add(dt);
rp.Load(Server.MapPath("crInformeRadiograficoOIT.rpt"));
rp.SetDataSource(ds);
rp.SetDataSource(ds);
var ruta1 = Server.MapPath("files/CM" + ServiceId + ".pdf");
_filesNameToMerge.Add(ruta1);
}
rp.ExportToDisk(ExportFormatType.PortableDocFormat, ruta);
_mergeExPDF.FilesName = _filesNameToMerge;
string Dif = Guid.NewGuid().ToString();
string NewPath = Server.MapPath("files/" + Dif + ".pdf");
_mergeExPDF.DestinationFile = NewPath;
_mergeExPDF.Execute();
ShowPdf1.FilePath = "files/" + Dif + ".pdf";
}
else if (Session["ConsultorioId"].ToString() == "5") // CARDIO
{
var ELECTROCARDIOGRAMA_ID = new ServiceBL().GetReportEstudioElectrocardiografico(ServiceId, Constants.ELECTROCARDIOGRAMA_ID);
DataSet ds = new DataSet();
DataTable dt = Sigesoft.Server.WebClientAdmin.UI.Utils.ConvertToDatatable(ELECTROCARDIOGRAMA_ID);
dt.TableName = "dtEstudioElectrocardiografico";
ds.Tables.Add(dt);
rp.Load(Server.MapPath("crEstudioElectrocardiografico.rpt"));
rp.SetDataSource(ds);
rp.SetDataSource(ds);
var ruta = Server.MapPath("files/CM" + ServiceId + ".pdf");
_filesNameToMerge.Add(ruta);
rp.ExportToDisk(ExportFormatType.PortableDocFormat, ruta);
_mergeExPDF.FilesName = _filesNameToMerge;
string Dif = Guid.NewGuid().ToString();
string NewPath = Server.MapPath("files/" + Dif + ".pdf");
_mergeExPDF.DestinationFile = NewPath;
_mergeExPDF.Execute();
ShowPdf1.FilePath = "files/" + Dif + ".pdf";
}
else if (Session["ConsultorioId"].ToString() == "15") // AUDIO
{
DataSet dsAudiometria = new DataSet();
var dxList = new ServiceBL().GetDiagnosticRepositoryByComponent(ServiceId, Constants.AUDIOMETRIA_ID);
if (dxList.Count == 0)
{
DiagnosticRepositoryList oDiagnosticRepositoryList = new DiagnosticRepositoryList();
List <DiagnosticRepositoryList> Lista = new List <DiagnosticRepositoryList>();
oDiagnosticRepositoryList.v_ServiceId = "Sin Id";
oDiagnosticRepositoryList.v_DiseasesName = "Sin Alteración";
oDiagnosticRepositoryList.v_DiagnosticRepositoryId = "Sin Id";
Lista.Add(oDiagnosticRepositoryList);
var dtDx = Sigesoft.Node.WinClient.BLL.Utils.ConvertToDatatable(Lista);
dtDx.TableName = "dtDiagnostic";
dsAudiometria.Tables.Add(dtDx);
}
else
{
var dtDx = Sigesoft.Node.WinClient.BLL.Utils.ConvertToDatatable(dxList);
dtDx.TableName = "dtDiagnostic";
dsAudiometria.Tables.Add(dtDx);
}
var recom = dxList.SelectMany(s1 => s1.Recomendations).ToList();
if (recom.Count == 0)
{
Sigesoft.Node.WinClient.BE.RecomendationList oRecomendationList = new Sigesoft.Node.WinClient.BE.RecomendationList();
List <Sigesoft.Node.WinClient.BE.RecomendationList> Lista = new List <Sigesoft.Node.WinClient.BE.RecomendationList>();
oRecomendationList.v_ServiceId = "Sin Id";
oRecomendationList.v_RecommendationName = "Sin Recomendaciones";
oRecomendationList.v_DiagnosticRepositoryId = "Sin Id";
Lista.Add(oRecomendationList);
var dtReco = Sigesoft.Node.WinClient.BLL.Utils.ConvertToDatatable(Lista);
dtReco.TableName = "dtRecomendation";
dsAudiometria.Tables.Add(dtReco);
}
else
{
var dtReco = Sigesoft.Node.WinClient.BLL.Utils.ConvertToDatatable(recom);
dtReco.TableName = "dtRecomendation";
dsAudiometria.Tables.Add(dtReco);
}
var audioUserControlList = new ServiceBL().ReportAudiometriaUserControl(ServiceId, Constants.AUDIOMETRIA_ID);
var audioCabeceraList = new ServiceBL().ReportAudiometria(ServiceId, Constants.AUDIOMETRIA_ID);
var dtAudiometriaUserControl = Sigesoft.Node.WinClient.BLL.Utils.ConvertToDatatable(audioUserControlList);
var dtCabecera = Sigesoft.Node.WinClient.BLL.Utils.ConvertToDatatable(audioCabeceraList);
dtCabecera.TableName = "dtAudiometria";
dtAudiometriaUserControl.TableName = "dtAudiometriaUserControl";
dsAudiometria.Tables.Add(dtCabecera);
dsAudiometria.Tables.Add(dtAudiometriaUserControl);
rp.Load(Server.MapPath("crFichaAudiometria.rpt"));
rp.SetDataSource(dsAudiometria);
var ruta = Server.MapPath("files/AU" + ServiceId + ".pdf");
_filesNameToMerge.Add(ruta);
rp.ExportToDisk(ExportFormatType.PortableDocFormat, ruta);
//HISTORIA OCUPACIONAL AUDIOMETRÍA
var dataListForReport_1 = new ServiceBL().ReportHistoriaOcupacionalAudiometria(ServiceId);
DataSet ds = new DataSet();
DataTable dt = Sigesoft.Server.WebClientAdmin.UI.Utils.ConvertToDatatable(dataListForReport_1);
dt.TableName = "dtHistoriaOcupacional";
ds.Tables.Add(dt);
rp.Load(Server.MapPath("crHistoriaOcupacionalAudiometria.rpt"));
rp.SetDataSource(ds);
rp.SetDataSource(ds);
var ruta1 = Server.MapPath("files/CM" + ServiceId + ".pdf");
_filesNameToMerge.Add(ruta1);
rp.ExportToDisk(ExportFormatType.PortableDocFormat, ruta1);
_mergeExPDF.FilesName = _filesNameToMerge;
string Dif = Guid.NewGuid().ToString();
string NewPath = Server.MapPath("files/" + Dif + ".pdf");
_mergeExPDF.DestinationFile = NewPath;
_mergeExPDF.Execute();
ShowPdf1.FilePath = "files/" + Dif + ".pdf";
}
else if (Session["ConsultorioId"].ToString() == "1") // LAB
{
var ruta = Server.MapPath("files/INFLAB" + ServiceId + ".pdf");
GenerateLaboratorioReport(ruta, ServiceId);
_filesNameToMerge.Add(ruta);
_mergeExPDF.FilesName = _filesNameToMerge;
string Dif = Guid.NewGuid().ToString();
string NewPath = Server.MapPath("files/" + Dif + ".pdf");
_mergeExPDF.DestinationFile = NewPath;
_mergeExPDF.Execute();
ShowPdf1.FilePath = "files/" + Dif + ".pdf";
}
else if (Session["ConsultorioId"].ToString() == "14") // OFTALMO
{
var OFTALMOLOGIA_ID = new PacientBL().GetOftalmologia(ServiceId, Constants.OFTALMOLOGIA_ID);
DataSet ds = new DataSet();
DataTable dt = Sigesoft.Server.WebClientAdmin.UI.Utils.ConvertToDatatable(OFTALMOLOGIA_ID);
dt.TableName = "dtOftalmologia";
ds.Tables.Add(dt);
rp.Load(Server.MapPath("crOftalmologia.rpt"));
rp.SetDataSource(ds);
rp.SetDataSource(ds);
var ruta = Server.MapPath("files/CM" + ServiceId + ".pdf");
_filesNameToMerge.Add(ruta);
rp.ExportToDisk(ExportFormatType.PortableDocFormat, ruta);
_mergeExPDF.FilesName = _filesNameToMerge;
string Dif = Guid.NewGuid().ToString();
string NewPath = Server.MapPath("files/" + Dif + ".pdf");
_mergeExPDF.DestinationFile = NewPath;
_mergeExPDF.Execute();
ShowPdf1.FilePath = "files/" + Dif + ".pdf";
}
}
protected void btnSubir_Click(object sender, EventArgs e)
{
OperationResult objOperationResult = new OperationResult();
CalendarBL objCalendarBL = new CalendarBL();
calendarDto objCalendarDto = new calendarDto();
PacientBL objPacientBL = new PacientBL();
pacientDto objPacientDto = new pacientDto();
PacientList PacientList = new PacientList();
if (dpFechaInicio.SelectedDate.Value < DateTime.Now.Date)
{
Alert.ShowInTop("No se permite agendar con una fecha anterior a la actual.", "Error de validación");
return;
}
string CalendarId;
string PacientId = "";
StringBuilder sbDatos = new StringBuilder();
var ListaGrilla = (List <Sigesoft.Node.WinClient.BE.PacientList>)Session["_TempPacientList"];
foreach (var item in ListaGrilla)
{
personDto objPersonDto = new personDto();
//Validar si el trabajador existe
objPersonDto = objPacientBL.GetPersonByNroDocument(ref objOperationResult, item.v_DocNumber);
if (objPersonDto != null)
{
objPersonDto.v_FirstName = item.v_FirstName.Trim();
objPersonDto.v_FirstLastName = item.v_FirstLastName.Trim();
objPersonDto.v_SecondLastName = item.v_SecondLastName.Trim();
objPersonDto.i_DocTypeId = item.i_DocTypeId;
objPersonDto.v_DocNumber = item.v_DocNumber;
objPersonDto.i_SexTypeId = item.i_SexTypeId;
objPersonDto.d_Birthdate = item.d_Birthdate;
objPersonDto.i_LevelOfId = -1;
objPersonDto.i_MaritalStatusId = -1;
objPersonDto.i_BloodGroupId = -1;
objPersonDto.i_BloodFactorId = -1;
objPersonDto.i_DepartmentId = -1;
objPersonDto.i_ProvinceId = -1;
objPersonDto.i_DistrictId = -1;
objPersonDto.i_ResidenceInWorkplaceId = -1;
objPersonDto.i_TypeOfInsuranceId = -1;
objPersonDto.i_OccupationTypeId = -1;
objPersonDto.i_AltitudeWorkId = -1;
objPersonDto.i_PlaceWorkId = -1;
objPersonDto.i_Relationship = -1;
objPersonDto.v_CurrentOccupation = item.v_CurrentOccupation;
objPacientBL.UpdatePacient(ref objOperationResult, objPersonDto, ((ClientSession)Session["objClientSession"]).GetAsList(), objPersonDto.v_DocNumber, objPersonDto.v_DocNumber);
PacientId = objPersonDto.v_PersonId;
}
else
{
objPersonDto = new personDto();
objPersonDto.v_FirstName = item.v_FirstName.Trim();
objPersonDto.v_FirstLastName = item.v_FirstLastName.Trim();
objPersonDto.v_SecondLastName = item.v_SecondLastName.Trim();
objPersonDto.i_DocTypeId = item.i_DocTypeId;
objPersonDto.v_DocNumber = item.v_DocNumber;
objPersonDto.i_SexTypeId = item.i_SexTypeId;
objPersonDto.d_Birthdate = item.d_Birthdate;
objPersonDto.i_LevelOfId = -1;
objPersonDto.i_MaritalStatusId = -1;
objPersonDto.i_BloodGroupId = -1;
objPersonDto.i_BloodFactorId = -1;
objPersonDto.i_DepartmentId = -1;
objPersonDto.i_ProvinceId = -1;
objPersonDto.i_DistrictId = -1;
objPersonDto.i_ResidenceInWorkplaceId = -1;
objPersonDto.i_TypeOfInsuranceId = -1;
objPersonDto.i_OccupationTypeId = -1;
objPersonDto.i_AltitudeWorkId = -1;
objPersonDto.i_PlaceWorkId = -1;
objPersonDto.i_Relationship = -1;
objPersonDto.v_Deducible = 0;
//objPersonDto.v_Password = item.v_DocNumber;
objPersonDto.v_CurrentOccupation = item.v_CurrentOccupation;
PacientId = objPacientBL.AddPacient(ref objOperationResult, objPersonDto, ((ClientSession)Session["objClientSession"]).GetAsList());
}
var Verificar = objPacientBL.GetBlackList(ref objOperationResult, objPersonDto.v_PersonId);
if (PacientId != null && Verificar == null) // Se grabo el paciente y se lo agenda
{
objCalendarDto.v_PersonId = PacientId;
objCalendarDto.d_DateTimeCalendar = dpFechaInicio.SelectedDate.Value;
objCalendarDto.i_ServiceTypeId = (int)ServiceType.Empresarial;
objCalendarDto.i_CalendarStatusId = (int)CalendarStatus.Agendado;
objCalendarDto.i_ServiceId = (int)MasterService.Eso;
//objCalendarDto.v_ProtocolId = _ProtocolId;
//Obtener Id de Protocolo por medio del código del protocolo
var ProtocolId = oProtocolBL.ObtenerProtocoloIdPorCodigoProtocolo(ddlProtocoloId.SelectedText);
if (ProtocolId == null)
{
Alert.ShowInTop("El protocolo no existe en el sistema.", "ERRROR!");
return;
}
objCalendarDto.v_ProtocolId = ProtocolId;
objCalendarDto.i_NewContinuationId = (int)modality.NuevoServicio;
objCalendarDto.i_LineStatusId = (int)LineStatus.FueraCircuito;
objCalendarDto.i_IsVipId = (int)SiNo.NO;
CalendarId = objPacientBL.AddShedule(ref objOperationResult, objCalendarDto, ((ClientSession)Session["objClientSession"]).GetAsList(), ProtocolId, PacientId, (int)MasterService.Eso, "Nuevo");
}
else // no se grabro el paciente
{
sbDatos.Append("PACIENTE : ");
sbDatos.Append(objPersonDto.v_FirstName + " " + objPersonDto.v_FirstLastName + " " + objPersonDto.v_SecondLastName);
sbDatos.Append(" DOCUMENTO : ");
sbDatos.Append(objPersonDto.v_DocNumber);
sbDatos.Append("\n");
}
}
//iniciar circuitos
if (objOperationResult.Success == 1) // Operación sin error
{
Alert.Show("Se agendó correctamente.");
}
else // Operación con error
{
Alert.ShowInTop("Error al agendar, por favor comuníquese con su proveedor", "ERROR!");
}
}
private void btnFilter_Click(object sender, EventArgs e)
{
using (new LoadingClass.PleaseWait(this.Location, "Generando..."))
{
var MedicalCenter = new ServiceBL().GetInfoMedicalCenter();
List <string> Filters = new List <string>();
DateTime? pdatBeginDate = dtpDateTimeStar.Value.Date;
DateTime? pdatEndDate = dptDateTimeEnd.Value.Date.AddDays(1);
if (ddlCustomerOrganization.SelectedValue.ToString() != "-1")
{
var id3 = ddlCustomerOrganization.SelectedValue.ToString().Split('|');
Filters.Add("v_CustomerOrganizationId==" + "\"" + id3[0] + "\"&&v_CustomerLocationId==" + "\"" + id3[1] + "\"");
}
if (ddlEmployerOrganization.SelectedValue.ToString() != "-1")
{
var id3 = ddlEmployerOrganization.SelectedValue.ToString().Split('|');
Filters.Add("v_EmployerOrganizationId==" + "\"" + id3[0] + "\"&&v_EmployerLocationId==" + "\"" + id3[1] + "\"");
}
if (ddlWorkingOrganization.SelectedValue.ToString() != "-1")
{
var id3 = ddlWorkingOrganization.SelectedValue.ToString().Split('|');
Filters.Add("v_WorkingOrganizationId==" + "\"" + id3[0] + "\"&&v_WorkingLocationId==" + "\"" + id3[1] + "\"");
}
if (ddlProtocolId.SelectedValue.ToString() != "-1")
{
Filters.Add("ProtocolId==" + "\"" + ddlProtocolId.SelectedValue + "\"");
}
// Create the Filter Expression
strFilterExpression = null;
if (Filters.Count > 0)
{
foreach (string item in Filters)
{
strFilterExpression = strFilterExpression + item + " && ";
}
strFilterExpression = strFilterExpression.Substring(0, strFilterExpression.Length - 4);
}
if (tabControl1.SelectedTab.Name == "tpShauindo")
{
var objData = new PacientBL().ReporteMatrizShauindo(pdatBeginDate, pdatEndDate, ddlCustomerOrganization.SelectedValue.ToString(), strFilterExpression);
grdShauindo.DataSource = objData;
lblRecordCount.Text = string.Format("Se encontraron {0} registros.", objData.Count());
btnExportShauindo.Enabled = true;
}
else if (tabControl1.SelectedTab.Name == "tpLaZanja")
{
var objData = new PacientBL().ReporteMatrizLaZanja(pdatBeginDate, pdatEndDate, ddlCustomerOrganization.SelectedValue.ToString(), strFilterExpression);
grdLaZanja.DataSource = objData;
lblRecordCount.Text = string.Format("Se encontraron {0} registros.", objData.Count());
btnExportLaZanja.Enabled = true;
}
else if (tabControl1.SelectedTab.Name == "tpGoldFields")
{
var objData = new PacientBL().ReporteMatrizGoldFields(pdatBeginDate, pdatEndDate, ddlCustomerOrganization.SelectedValue.ToString(), strFilterExpression);
grdGolFields.DataSource = objData;
lblRecordCount.Text = string.Format("Se encontraron {0} registros.", objData.Count());
btnExportGolFields.Enabled = true;
}
else if (tabControl1.SelectedTab.Name == "tpSolucManteIntegra")
{
var objData = new PacientBL().ReporteMatrizSolucManteIntegra(pdatBeginDate, pdatEndDate, ddlCustomerOrganization.SelectedValue.ToString(), strFilterExpression);
grdSoluc.DataSource = objData;
lblRecordCount.Text = string.Format("Se encontraron {0} registros.", objData.Count());
btnExportSoluc.Enabled = true;
}
else if (tabControl1.SelectedTab.Name == "tpMiBanco")
{
var objData = new PacientBL().ReporteMatrizMiBanco(pdatBeginDate, pdatEndDate, ddlCustomerOrganization.SelectedValue.ToString(), strFilterExpression);
grdMiBanco.DataSource = objData;
lblRecordCount.Text = string.Format("Se encontraron {0} registros.", objData.Count());
btnExportMiBanco.Enabled = true;
}
}
}
private void btnImprimir_Click(object sender, EventArgs e)
{
if (grdDataAdditionalExam.Rows.Count == 0)
{
MessageBox.Show("No hay exámenes para imprimir", "VALIDACIÓN", MessageBoxButtons.OK,
MessageBoxIcon.Information);
return;
}
var ruta = Common.Utils.GetApplicationConfigValue("rutaExamenesAdicionales").ToString();
var rutaBasura = Common.Utils.GetApplicationConfigValue("rutaReportesBasura").ToString();
string pathFile = "";
string CMP = "";
var openFile = false;
using (new LoadingClass.PleaseWait(this.Location, "Cargando..."))
{
OperationResult objOperationResult = new OperationResult();
var datosGrabo = new ServiceBL().DevolverDatosUsuarioFirma(Globals.ClientSession.i_SystemUserId);
CMP = datosGrabo.CMP;
pathFile = string.Format("{0}.pdf", Path.Combine(ruta, _serviceId + "-" + "ORDEN-EX-MED-ADICI-" + datosGrabo.CMP));
List <Categoria> AdditionalExam = new List <Categoria>();
List <Categoria> DataSource = new List <Categoria>();
List <string> ComponentList = new List <string>();
var ListadditExam = new AdditionalExamBL().GetAdditionalExamByServiceId_all(_serviceId, Globals.ClientSession.i_SystemUserId);
foreach (var componenyId in ListadditExam)
{
ComponentList.Add(componenyId.ComponentId);
}
foreach (var componentId in ComponentList)
{
var ListServiceComponent = new ServiceBL().GetAllComponents(ref objOperationResult, (int)TipoBusqueda.ComponentId, componentId);
Categoria categoria = DataSource.Find(x => x.i_CategoryId == ListServiceComponent[0].i_CategoryId);
if (categoria != null)
{
List <ComponentDetailList> componentDetail = new List <ComponentDetailList>();
componentDetail = ListServiceComponent[0].Componentes;
DataSource.Find(x => x.i_CategoryId == ListServiceComponent[0].i_CategoryId).Componentes.AddRange(componentDetail);
}
else
{
DataSource.AddRange(ListServiceComponent);
}
}
var MedicalCenter = new ServiceBL().GetInfoMedicalCenter();
var DatosPaciente = new PacientBL().DevolverDatosPaciente(_serviceId);
new PrintAdditionalExam().GenerateAdditionalexam(pathFile, MedicalCenter, DatosPaciente, datosGrabo, txtComentario.Text, DataSource, ListadditExam);
}
List <string> pdfList = new List <string>();
pdfList.Add(pathFile);
_mergeExPDF.FilesName = pdfList;
_mergeExPDF.DestinationFile = string.Format("{0}.pdf", Path.Combine(rutaBasura, _serviceId + "-" + "ORDEN-EX-MED-ADICI-" + CMP));
_mergeExPDF.Execute();
_mergeExPDF.RunFile();
}
private void btnschedule_Click(object sender, EventArgs e)
{
OperationResult objOperationResult = new OperationResult();
CalendarBL objCalendarBL = new CalendarBL();
calendarDto objCalendarDto = new calendarDto();
PacientBL objPacientBL = new PacientBL();
pacientDto objPacientDto = new pacientDto();
PacientList PacientList = new PacientList();
BlackListBL objBlackListBL = new BlackListBL();
if (dtpDateTimeCalendar.Value < DateTime.Now.Date)
{
MessageBox.Show("No se permite agendar con una fecha anterior a la actual.", "Error de validación", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
string CalendarId;
string PacientId = "";
string ProtocoloId = "";
StringBuilder sbDatos = new StringBuilder();
if (uvschedule.Validate(true, false).IsValid)
{
foreach (var item in _TempPacientList)
{
personDto objPersonDto = new personDto();
//Validar si el trabajador existe
objPersonDto = objPacientBL.GetPersonByNroDocument(ref objOperationResult, item.v_DocNumber);
if (objPersonDto != null)
{
objPersonDto.v_FirstName = item.v_FirstName.Trim();
objPersonDto.v_FirstLastName = item.v_FirstLastName.Trim();
objPersonDto.v_SecondLastName = item.v_SecondLastName.Trim();
objPersonDto.i_DocTypeId = item.i_DocTypeId;
objPersonDto.v_DocNumber = item.v_DocNumber;
objPersonDto.i_SexTypeId = item.i_SexTypeId;
objPersonDto.d_Birthdate = item.d_Birthdate;
objPersonDto.i_LevelOfId = -1;
objPersonDto.i_MaritalStatusId = -1;
objPersonDto.i_BloodGroupId = -1;
objPersonDto.i_BloodFactorId = -1;
objPersonDto.i_DepartmentId = -1;
objPersonDto.i_ProvinceId = -1;
objPersonDto.i_DistrictId = -1;
objPersonDto.i_ResidenceInWorkplaceId = -1;
objPersonDto.i_TypeOfInsuranceId = -1;
objPersonDto.i_OccupationTypeId = -1;
objPersonDto.i_AltitudeWorkId = -1;
objPersonDto.i_PlaceWorkId = -1;
objPersonDto.i_Relationship = -1;
objPersonDto.v_CurrentOccupation = item.v_CurrentOccupation;
objPacientBL.UpdatePacient(ref objOperationResult, objPersonDto, Globals.ClientSession.GetAsList(), objPersonDto.v_DocNumber, "");
PacientId = objPersonDto.v_PersonId;
}
else
{
objPersonDto = new personDto();
objPersonDto.v_FirstName = item.v_FirstName.Trim();
objPersonDto.v_FirstLastName = item.v_FirstLastName.Trim();
objPersonDto.v_SecondLastName = item.v_SecondLastName.Trim();
objPersonDto.i_DocTypeId = item.i_DocTypeId;
objPersonDto.v_DocNumber = item.v_DocNumber;
objPersonDto.i_SexTypeId = item.i_SexTypeId;
objPersonDto.d_Birthdate = item.d_Birthdate;
objPersonDto.i_LevelOfId = -1;
objPersonDto.i_MaritalStatusId = -1;
objPersonDto.i_BloodGroupId = -1;
objPersonDto.i_BloodFactorId = -1;
objPersonDto.i_DepartmentId = -1;
objPersonDto.i_ProvinceId = -1;
objPersonDto.i_DistrictId = -1;
objPersonDto.i_ResidenceInWorkplaceId = -1;
objPersonDto.i_TypeOfInsuranceId = -1;
objPersonDto.i_OccupationTypeId = -1;
objPersonDto.i_AltitudeWorkId = -1;
objPersonDto.i_PlaceWorkId = -1;
objPersonDto.i_Relationship = -1;
objPersonDto.v_Password = item.v_DocNumber;
objPersonDto.v_CurrentOccupation = item.v_CurrentOccupation;
PacientId = objPacientBL.AddPacient(ref objOperationResult, objPersonDto, Globals.ClientSession.GetAsList());
}
var Verificar = objBlackListBL.GetBlackList(ref objOperationResult, objPersonDto.v_PersonId);
if (PacientId != null && Verificar == null) // Se grabo el paciente y se lo agenda
{
objCalendarDto.v_PersonId = PacientId;
objCalendarDto.d_DateTimeCalendar = dtpDateTimeCalendar.Value;
objCalendarDto.i_ServiceTypeId = Int32.Parse(ddlServiceTypeId.SelectedValue.ToString());
objCalendarDto.i_CalendarStatusId = Int32.Parse(ddlCalendarStatusId.SelectedValue.ToString());
objCalendarDto.i_ServiceId = Int32.Parse(ddlMasterServiceId.SelectedValue.ToString());
//objCalendarDto.v_ProtocolId = _ProtocolId;
objCalendarDto.v_ProtocolId = item.v_ProtocoloId;
objCalendarDto.i_NewContinuationId = Int32.Parse(ddlNewContinuationId.SelectedValue.ToString());
objCalendarDto.i_LineStatusId = Int32.Parse(ddlLineStatusId.SelectedValue.ToString());
objCalendarDto.i_IsVipId = Int32.Parse(ddlVipId.SelectedValue.ToString());
CalendarId = objCalendarBL.AddShedule(ref objOperationResult, objCalendarDto, Globals.ClientSession.GetAsList(), item.v_ProtocoloId, PacientId, Int32.Parse(ddlMasterServiceId.SelectedValue.ToString()), "Nuevo", chkIsCampania.Checked ? 1 : 0);
}
else // no se grabro el paciente
{
sbDatos.Append("PACIENTE : ");
sbDatos.Append(objPersonDto.v_FirstName + " " + objPersonDto.v_FirstLastName + " " + objPersonDto.v_SecondLastName);
sbDatos.Append(" DOCUMENTO : ");
sbDatos.Append(objPersonDto.v_DocNumber);
sbDatos.Append("\n");
}
}
if (objOperationResult.Success == 1) // Operación sin error
{
if (sbDatos.ToString() != "")
{
MessageBox.Show(sbDatos.ToString(), "Estos pacientes no fueron agendados", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
this.DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
}
}
else// Operación con error
{
if (objOperationResult.ErrorMessage != null)
{
MessageBox.Show(objOperationResult.ErrorMessage, "ERROR!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show(sbDatos.ToString(), "Estos pacientes no fueron agendados", MessageBoxButtons.OK, MessageBoxIcon.Warning);
// Se queda en el formulario.
}
}
}
}
