private OrdenesHistoria GetByPK(int id)
{
DbConnection connection = this.instance.CreateConnection();
OrdenesHistoria objToLoad = new OrdenesHistoria();
try
{
connection.Open();
DbCommand storedProcCommand = this.instance.GetStoredProcCommand("PA_GET_ORDENES_HISTORIA_BY_PK");
storedProcCommand.Connection = connection;
this.instance.AddInParameter(storedProcCommand, "@ID", DbType.Int32, (object)id);
DbDataAdapter dataAdapter = this.instance.GetDataAdapter();
DataTable dataTable = new DataTable();
dataAdapter.SelectCommand = storedProcCommand;
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0)
{
this.LoadFromDataRow(ref objToLoad, dataTable.Rows[0]);
}
}
catch (Exception ex)
{
this.error = ex.InnerException != null ? ex.InnerException.Message : ex.Message;
}
finally
{
connection.Close();
}
return(objToLoad);
}
public bool Delete(OrdenesHistoria objToProcess)
{
bool flag = false;
try
{
DbConnection connection = this.instance.CreateConnection();
try
{
connection.Open();
DbCommand storedProcCommand = this.instance.GetStoredProcCommand("PA_ORDENES_HISTORIA_DELETE");
storedProcCommand.Connection = connection;
this.instance.AddInParameter(storedProcCommand, "@ID", DbType.Int32, (object)objToProcess.Id);
this.instance.ExecuteNonQuery(storedProcCommand);
flag = true;
}
catch (Exception ex)
{
this.error = ex.InnerException != null ? ex.InnerException.Message : ex.Message;
}
finally
{
connection.Close();
}
}
catch (Exception ex)
{
this.error = ex.InnerException != null ? ex.InnerException.Message : ex.Message;
}
return(flag);
}
public bool Update(OrdenesHistoria objToProcess)
{
bool flag = false;
try
{
DbConnection connection = this.instance.CreateConnection();
try
{
connection.Open();
DbCommand storedProcCommand = this.instance.GetStoredProcCommand("PA_ORDENES_HISTORIA_UPDATE");
storedProcCommand.Connection = connection;
this.instance.AddInParameter(storedProcCommand, "@ID", DbType.Int32, (object)objToProcess.Id);
this.instance.AddInParameter(storedProcCommand, "@ID_HISTORIA", DbType.Int32, (object)objToProcess.IdHistoria);
this.instance.AddInParameter(storedProcCommand, "@DESCRIPCION", DbType.String, (object)objToProcess.Descripcion);
this.instance.AddInParameter(storedProcCommand, "@MEDICO_TRATANTE", DbType.String, (object)objToProcess.MedicoTratante);
this.instance.AddInParameter(storedProcCommand, "@ID_ULTIMA_MODIFICACION", DbType.Int32, (object)objToProcess.IdUltimaModificacion);
this.instance.ExecuteNonQuery(storedProcCommand);
flag = true;
}
catch (Exception ex)
{
this.error = ex.InnerException != null ? ex.InnerException.Message : ex.Message;
}
finally
{
connection.Close();
}
}
catch (Exception ex)
{
this.error = ex.InnerException != null ? ex.InnerException.Message : ex.Message;
}
return(flag);
}
protected void rgOrdenes_InsertCommand(object sender, GridCommandEventArgs e)
{
OrdenesHistoriaBll objBll = new OrdenesHistoriaBll();
GridEditableItem editColumn = (GridEditableItem)e.Item;
Hashtable newValues = new Hashtable();
e.Item.OwnerTableView.ExtractValuesFromItem(newValues, editColumn);
OrdenesHistoria objEnt = new OrdenesHistoria();
objEnt.Descripcion = newValues["DESCRIPCION"].ToString();
objEnt.MedicoTratante = newValues["MEDICO_TRATANTE"].ToString();
objEnt.IdHistoria = this.IdHist;
objEnt.IdCreacion = objEnt.IdUltimaModificacion = this.IdUserCurrent;
objEnt.FechaCreacion = objEnt.FechaUltimaModificacion = DateTime.Now;
if (objBll.Save(objEnt))
{
RadScriptManager.RegisterClientScriptBlock(this, this.GetType(), "okOrdSav", "alert('Se ha almacenado la orden correctamente');", true);
}
else
{
RadScriptManager.RegisterClientScriptBlock(this, this.GetType(), "errOrdSav", "alert('Se ha presentado el siguiente error al cargar la nueva orden al sistema\\n\\n" + Utilidades.AjustarMensajeError(objBll.Error) + "');", true);
}
}
public bool Delete(OrdenesHistoria objToProcess)
{
OrdenesHistoriaDao ordenesHistoriaDao = new OrdenesHistoriaDao();
bool flag = ordenesHistoriaDao.Delete(objToProcess);
this.error = ordenesHistoriaDao.Error;
return(flag);
}
public bool Save(OrdenesHistoria objEnt)
{
OrdenesHistoriaDao ordenesHistoriaDao = new OrdenesHistoriaDao();
bool flag = objEnt.Id == int.MinValue ? ordenesHistoriaDao.Create(objEnt) : ordenesHistoriaDao.Update(objEnt);
this.error = ordenesHistoriaDao.Error;
return(flag);
}
public OrdenesHistoria Load(int id)
{
OrdenesHistoriaDao ordenesHistoriaDao = new OrdenesHistoriaDao();
OrdenesHistoria ordenesHistoria = ordenesHistoriaDao.Load(id);
this.error = ordenesHistoriaDao.Error;
return(ordenesHistoria);
}
private void LoadFromDataRow(ref OrdenesHistoria objToLoad, DataRow drData)
{
try
{
objToLoad.Id = Convert.ToInt32(drData["ID"]);
objToLoad.IdHistoria = Convert.ToInt32(drData["ID_HISTORIA"]);
objToLoad.Descripcion = drData["DESCRIPCION"].ToString();
objToLoad.MedicoTratante = drData["MEDICO_TRATANTE"].ToString();
objToLoad.IdCreacion = Convert.ToInt32(drData["ID_CREACION"]);
objToLoad.FechaCreacion = Convert.ToDateTime(drData["FECHA_CREACION"]);
objToLoad.IdUltimaModificacion = Convert.ToInt32(drData["ID_ULTIMA_MODIFICACION"]);
objToLoad.FechaUltimaModificacion = Convert.ToDateTime(drData["FECHA_ULTIMA_MODIFICACION"]);
}
catch (Exception ex)
{
objToLoad = new OrdenesHistoria();
this.error = ex.InnerException != null ? ex.InnerException.Message : ex.Message;
}
}
public List <OrdenesHistoria> GetOrdenesHistorias(
int idHistoria,
string descripcion)
{
List <OrdenesHistoria> ordenesHistoriaList = new List <OrdenesHistoria>();
try
{
foreach (DataRow row in (InternalDataCollectionBase)this.GetList(idHistoria, descripcion).Rows)
{
OrdenesHistoria objToLoad = new OrdenesHistoria();
this.LoadFromDataRow(ref objToLoad, row);
ordenesHistoriaList.Add(objToLoad);
}
}
catch (Exception ex)
{
this.error = ex.InnerException != null ? ex.InnerException.Message : ex.Message;
}
return(ordenesHistoriaList);
}
private void LoadInfoOrden(int idOrden)
{
OrdenesHistoriaBll objBllOrdHis = new OrdenesHistoriaBll();
OrdenesHistoria objEntOrden = objBllOrdHis.Load(idOrden);
HistoriaMedicaBll objBllHisMed = new HistoriaMedicaBll();
HistoriaMedica objEntHisMed = objBllHisMed.Load(objEntOrden.IdHistoria);
PacienteBll objBllPac = new PacienteBll();
Paciente objEntPac = objBllPac.Load(objEntHisMed.IdPaciente);
TipoVisaBll objBllTipvis = new TipoVisaBll();
TipoVisa objEnttipVis = objBllTipvis.Load(objEntHisMed.IdTipoVisa);
string emba = string.Empty;
switch (objEnttipVis.IdEmbajada)
{
case Constants.Embajadas.Canada:
emba = "Canada";
break;
case Constants.Embajadas.Australia:
emba = "Australia";
break;
case Constants.Embajadas.NuevaZelanda:
emba = "Nueva Zelanda";
break;
}
this.lblEmbajada.Text = emba;
this.lblNomPac.Text = objEntPac.Nombres + " " + objEntPac.Apellidos;
this.lblinfoOrden.Text = objEntOrden.Descripcion;
this.lblMedtrantante.Text = objEntOrden.MedicoTratante;
}
