void Fill(ConsultaGrid c)
{
int index = 0;
lblTitle.Text = " Actualizar consulta en recepcion";
if (c.IdMutual.HasValue)
{
//index = cmbMutual.Properties.GetDataSourceRowIndex("IdMutual", c.IdMutual);
//cmbMutual.ItemIndex = index;
}
if (c.IdProfecional.HasValue)
{
index = cmbProfecionales.Properties.GetDataSourceRowIndex("IdProfecional", c.IdProfecional);
cmbProfecionales.ItemIndex = index;
}
if (c.IdTipoConsulta.HasValue)
{
index = cmbTipoConsulta.Properties.GetDataSourceRowIndex("IdParamComercial", c.IdTipoConsulta);
cmbTipoConsulta.ItemIndex = index;
}
txtCliente.Text = c.NombreCliente;
txtCoseguro.Text = c.Coseguro.Value.ToString();
txtArancelMutual.Text = c.ArancelMutual.Value.ToString();
txtObservacion.Text = c.Descripcion;
txtNroAfiliado.Text = c.NroAfiliadoMutual;
txtTelefono.Text = c.TelefonoCliente;
chkPresentaOrden.Checked = c.PresentaOrden.Value;
}
public override void Populate(object filter)
{
if (this.DesignMode)
{
return;
}
_Mutuales.AddRange(Controller.MutualList.Where <MutualBE>(p => p.IdMutual != (int)CommonValuesEnum.TodosComboBoxValue));
//cmbMutual.Properties.DataSource = _Mutuales;
_ProfecionalList.AddRange(Controller.ProfecionalList.Where <ProfecionalBE>(p => p.IdProfecional != (int)CommonValuesEnum.TodosComboBoxValue));
cmbProfecionales.Properties.DataSource = _ProfecionalList;
_TipoCons.AddRange(Controller.TipoConsultaList.Where <ParamComercialBE>(p => p.IdParamComercial != (int)CommonValuesEnum.TodosComboBoxValue));
cmbTipoConsulta.Properties.DataSource = _TipoCons;
if (State != Fwk.Bases.EntityUpdateEnum.NEW)
{
_ConsultaGrid_ToUpdate = (ConsultaGrid)filter;
}
}
private void gridView1_RowClick(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e)
{
selectedConsultaGrid = ((ConsultaGrid)gridControl1.FocusedView.GetRow(gridView1.FocusedRowHandle));
}
/// <summary>
/// SearchByParam
/// </summary>
///<param name="pConsulta">Consulta</param>
/// <returns>ConsultaList</returns>
/// <Date>2011-09-23T11:21:03</Date>
/// <Author>marcelo</Author>
public static ConsultaGridList SearchByParams_(ConsultaBE pConsulta)
{
Database wDataBase = null;
DbCommand wCmd = null;
ConsultaGridList wConsultaList = new ConsultaGridList();
ConsultaGrid wConsultaGrid;
try
{
wDataBase = DatabaseFactory.CreateDatabase(CommonDAC.clinica_cnnstring);
wCmd = wDataBase.GetStoredProcCommand("dbo.Consulta_s");
wDataBase.AddInParameter(wCmd, "IdTipoConsulta", System.Data.DbType.Int32, pConsulta.IdTipoConsulta);
wDataBase.AddInParameter(wCmd, "IdProfecional", System.Data.DbType.Int32, pConsulta.IdProfecional);
wDataBase.AddInParameter(wCmd, "IdMutual", System.Data.DbType.Int32, pConsulta.IdMutual);
wDataBase.AddInParameter(wCmd, "FechaDesde", System.Data.DbType.DateTime, pConsulta.Fecha);
wDataBase.AddInParameter(wCmd, "FechaHasta", System.Data.DbType.DateTime, pConsulta.FechaFin);
if (!string.IsNullOrEmpty(pConsulta.NombreCliente))
{
wDataBase.AddInParameter(wCmd, "NombreCliente", System.Data.DbType.String, pConsulta.NombreCliente);
}
wDataBase.AddInParameter(wCmd, "PresentaOrden", System.Data.DbType.Boolean, pConsulta.PresentaOrden);
using (IDataReader reader = wDataBase.ExecuteReader(wCmd))
{
while (reader.Read())
{
wConsultaGrid = new ConsultaGrid();
wConsultaGrid.IdConsulta = Convert.ToInt32(reader["IdConsulta"]);
wConsultaGrid.IdTipoConsulta = Convert.ToInt32(reader["IdTipoConsulta"]);
if (reader["IdProfecional"] != DBNull.Value)
{
wConsultaGrid.IdProfecional = Convert.ToInt32(reader["IdProfecional"]);
}
wConsultaGrid.Descripcion = reader["Descripcion"].ToString();
wConsultaGrid.Coseguro = Convert.ToInt32(reader["Coseguro"]);
wConsultaGrid.Fecha = Convert.ToDateTime(reader["Fecha"]);
if (reader["IdMutual"] != DBNull.Value)
{
wConsultaGrid.IdMutual = Convert.ToInt32(reader["IdMutual"]);
}
wConsultaGrid.MutualNombre = reader["MutualNombre"].ToString();
wConsultaGrid.ProfecionalNombre = reader["ProfecionalNombre"].ToString();
wConsultaGrid.TelefonoCliente = reader["TelefonoCliente"].ToString();
wConsultaGrid.NombreCliente = reader["NombreCliente"].ToString();
wConsultaGrid.NroAfiliadoMutual = reader["NroAfiliadoMutual"].ToString();
if (reader["PresentaOrden"] != DBNull.Value)
{
wConsultaGrid.PresentaOrden = Convert.ToBoolean(reader["PresentaOrden"]);
}
if (reader["ExigeCoseguro"] != DBNull.Value)
{
wConsultaGrid.ExigeCoseguro = Convert.ToBoolean(reader["ExigeCoseguro"]);
}
if (reader["ArancelMutual"] != DBNull.Value)
{
wConsultaGrid.ArancelMutual = Convert.ToDecimal(reader["ArancelMutual"]);
}
wConsultaList.Add(wConsultaGrid);
}
}
return(wConsultaList);
}
catch (Exception ex)
{
throw Fwk.Exceptions.ExceptionHelper.ProcessException(ex);
}
}
