public void Populate(ConsultaBE filter)
{
using (WaitCursorHelper whait = new WaitCursorHelper(this))
{
if (filter.GetType().Equals(typeof(ConsultaBE)))
{
_ConsultaGridList = Controller.SearchByParams(filter);
}
this.gridControl1.DataSource = _ConsultaGridList;
this.gridControl1.Refresh();
}
}
public static ConsultaGridList SearchByParams(ConsultaBE param)
{
ConsultaGridList list = new ConsultaGridList();
using (ClinicaEntities dc = new ClinicaEntities())
{
var x = from c in dc.ConsultaView
where
(param.IdProfecional.Equals(null) || c.IdProfecional == param.IdProfecional)
&&
(c.IdTipoConsulta == 200)
&&
(param.IdMutual.Equals(null) || c.IdMutual.Value == param.IdMutual.Value)
&&
(string.IsNullOrEmpty(param.NombreCliente) || c.NombreCliente.Contains(param.NombreCliente))
&&
(param.PresentaOrden.Equals(null) || c.PresentaOrden.Value == param.PresentaOrden.Value)
&&
(param.IdTipoConsulta.Equals(null) || c.IdTipoConsulta.Value == param.IdTipoConsulta.Value)
&&
(param.Fecha.Equals(null) || (c.Fecha >= param.Fecha && c.Fecha <= param.FechaFin))
select new ConsultaGrid
{
Descripcion = c.Descripcion,
Coseguro = c.Coseguro,
Fecha = c.Fecha,
IdConsulta = c.IdConsulta,
IdMutual = c.IdMutual,
IdProfecional = c.IdProfecional,
MutualNombre = c.NombreMutual,
NombreCliente = c.NombreCliente,
ProfecionalNombre = c.NombreProfesional,
TipoConsultaNombre = c.NombreTipoConsulta,
TelefonoCliente = c.TelefonoCliente,
NroAfiliadoMutual = c.NroAfiliadoMutual,
IdTipoConsulta = c.IdTipoConsulta,
PresentaOrden = c.PresentaOrden,
ExigeCoseguro = c.ExigeCoseguro,
ArancelMutual = c.ArancelMutual
};
if (x.Count <ConsultaGrid>() == 0)
{
return(list);
}
list.AddRange(x.ToArray <ConsultaGrid>());
}
return(list);
}
public static ConsultaGridList SearchByDay(DateTime fecha)
{
ConsultaGridList list = new ConsultaGridList();
using (ClinicaEntities dc = new ClinicaEntities())
{
var x = from c in dc.ConsultaView
where
c.Fecha.Day.Equals(fecha.Day) &&
c.Fecha.Month.Equals(fecha.Month) &&
c.Fecha.Year.Equals(fecha.Year)
select new ConsultaGrid
{
Descripcion = c.Descripcion,
Coseguro = c.Coseguro,
Fecha = c.Fecha,
IdConsulta = c.IdConsulta,
IdMutual = c.IdMutual,
IdProfecional = c.IdProfecional,
MutualNombre = c.NombreMutual,
NombreCliente = c.NombreCliente,
ProfecionalNombre = c.NombreProfesional,
TipoConsultaNombre = c.NombreTipoConsulta,
TelefonoCliente = c.TelefonoCliente,
NroAfiliadoMutual = c.NroAfiliadoMutual,
IdTipoConsulta = c.IdTipoConsulta,
PresentaOrden = c.PresentaOrden,
ExigeCoseguro = c.ExigeCoseguro,
ArancelMutual = c.ArancelMutual
};
list.AddRange(x.ToArray <ConsultaGrid>());
}
return(list);
}
public override void Populate(object filter)
{
if (this.DesignMode)
{
return;
}
using (WaitCursorHelper whait = new WaitCursorHelper(this))
{
if (filter.GetType().Equals(typeof(ConsultaBE)))
{
_ConsultaGridList = Controller.SearchByParams(((ConsultaBE)filter));
}
if (filter.GetType().Equals(typeof(DateTime)))
{
_ConsultaGridList = Controller.SearchByParams(((DateTime)filter));
}
this.gridControl1.DataSource = _ConsultaGridList;
this.gridControl1.Refresh();
}
}
/// <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);
}
}
