public override void Refresh()
{
ConsultaBE filter = this.uC_FitroConsultaHorizontal1.GetFilter();
Pupulate(filter.Fecha, filter.FechaFin.Value, null);
base.Refresh();
}
public override void Refresh()
{
ConsultaBE filter = uC_FitroConsultaHorizontal1.GetFilter();
rptconsultasmestipoBindingSource.DataSource = Controller.rpt_consultas_total_diario(uC_TipoList1.GetChecked().GetListOfId(), filter.Fecha, filter.FechaFin);
this.chartControl1.RefreshData();
base.Refresh();
}
/// <summary>
///
/// </summary>
/// <param name="pConsultaBE"></param>
public static void Create(ConsultaBE pConsultaBE)
{
Consulta c = pConsultaBE.GetConsultaEF();
using (ClinicaEntities dc = new ClinicaEntities())
{
pConsultaBE.UserName = Environment.UserName;
dc.Consulta.AddObject(c);
dc.SaveChanges();
}
}
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 void Populate()
{
ConsultaBE wConsultaBE = uC_FitroConsultaHorizontal1.GetFilter();
using (WaitCursorHelper whait = new WaitCursorHelper(this))
{
_Rpt_Consulta_FullList = Controller.Search_Consulta_FullView_ByParams(wConsultaBE);
this.pivotGridControl1.DataSource = _Rpt_Consulta_FullList;
this.pivotGridControl1.Refresh();
}
}
/// <summary>
/// Insert
/// </summary>
///<param name="pConsulta">Consulta</param>
/// <returns>void</returns>
/// <Date>2011-09-23T15:48:36</Date>
/// <Author>marcelo</Author>
public static void Update(ConsultaBE pConsulta)
{
Database wDataBase = null;
DbCommand wCmd = null;
try
{
wDataBase = DatabaseFactory.CreateDatabase(CommonDAC.clinica_cnnstring);
wCmd = wDataBase.GetStoredProcCommand("Consulta_u");
/// IdConsulta
wDataBase.AddInParameter(wCmd, "IdConsulta", System.Data.DbType.Int32, pConsulta.IdConsulta);
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, "NroAfiliadoMutual", System.Data.DbType.String, pConsulta.NroAfiliadoMutual);
//wDataBase.AddInParameter(wCmd, "Fecha", System.Data.DbType.DateTime, pConsulta.Fecha);
wDataBase.AddInParameter(wCmd, "Descripcion", System.Data.DbType.String, pConsulta.Descripcion);
wDataBase.AddInParameter(wCmd, "NombreCliente", System.Data.DbType.String, pConsulta.NombreCliente);
wDataBase.AddInParameter(wCmd, "PresentaOrden", System.Data.DbType.Boolean, pConsulta.PresentaOrden);
wDataBase.AddInParameter(wCmd, "TelefonoCliente", System.Data.DbType.String, pConsulta.TelefonoCliente);
wDataBase.AddInParameter(wCmd, "Coseguro", System.Data.DbType.Decimal, pConsulta.Coseguro);
wDataBase.AddInParameter(wCmd, "ExigeCoseguro", System.Data.DbType.Boolean, pConsulta.ExigeCoseguro);
wDataBase.AddInParameter(wCmd, "UserName", System.Data.DbType.Decimal, pConsulta.UserName);
wDataBase.AddInParameter(wCmd, "ArancelMutual", System.Data.DbType.Decimal, pConsulta.ArancelMutual);
wDataBase.ExecuteNonQuery(wCmd);
pConsulta.IdConsulta = (System.Int32)wDataBase.GetParameterValue(wCmd, "IdConsulta");
}
catch (Exception ex)
{
throw Fwk.Exceptions.ExceptionHelper.ProcessException(ex);
}
}
public ConsultaBE GetData()
{
ConsultaBE wConsultaBE = new ConsultaBE();
//if (Convert.ToInt32(cmbMutual.EditValue) != (int)CommonValuesEnum.Ninguno)
//{
// //wConsultaBE.IdMutual = Convert.ToInt32(cmbMutual.EditValue);
// wConsultaBE.PresentaOrden = chkPresentaOrden.Checked;
// wConsultaBE.NroAfiliadoMutual = txtNroAfiliado.Text.Trim();
// //wConsultaBE.ExigeCoseguro = Convert.ToBoolean(cmbMutual.GetColumnValue("ExigeCoseguro"));
//}
//else
//{
// wConsultaBE.IdMutual = null;
// wConsultaBE.PresentaOrden = false;
// wConsultaBE.NroAfiliadoMutual = string.Empty;
//}
if ((int)cmbProfecionales.EditValue != (int)CommonValuesEnum.Ninguno)
{
wConsultaBE.IdProfecional = Convert.ToInt32(cmbProfecionales.EditValue);
}
wConsultaBE.NombreCliente = txtCliente.Text.Trim();
wConsultaBE.Descripcion = txtObservacion.Text.Trim();
wConsultaBE.TelefonoCliente = txtTelefono.Text.Trim();
wConsultaBE.IdTipoConsulta = (int)cmbTipoConsulta.EditValue;
wConsultaBE.Fecha = DateTime.Now;
wConsultaBE.ArancelMutual = Convert.ToDecimal(txtArancelMutual.EditValue);
wConsultaBE.Coseguro = Convert.ToDecimal(txtCoseguro.EditValue);
if (_ConsultaGrid_ToUpdate != null)
{
wConsultaBE.IdConsulta = _ConsultaGrid_ToUpdate.IdConsulta;
}
return(wConsultaBE);
}
//public static Rpt_Consulta_FullList SearchByParams_(ConsultaBE param, DateTime? fechaFin)
//{
// Rpt_Consulta_FullList list = new Rpt_Consulta_FullList();
// using (ClinicaEntities dc = new ClinicaEntities())
// {
// var x = from c in dc.Rpt_Consulta_Full
// where
// (param.IdProfecional.Equals(null) || c.IdProfecional.Value == param.IdProfecional.Value)
// &&
// (c.IdTipoConsulta.Value == 200)
// &&
// (param.IdMutual.Equals(null) || c.IdMutual.Value == param.IdMutual.Value)
// &&
// (param.Fecha.Equals(null) || (c.Fecha >= param.Fecha && c.Fecha <= fechaFin))
// select c;
// foreach (Rpt_Consulta_Full i in x)
// {
// list.Add(new Rpt_Consulta_FullBE(i));
// }
// }
// return list;
//}
/// <summary>
///
/// </summary>
/// <param name="param"></param>
/// <param name="fechaFin"></param>
/// <returns></returns>
public static Rpt_Consulta_FullList SearchByParams(ConsultaBE param)
{
Rpt_Consulta_FullList list = new Rpt_Consulta_FullList();
using (ClinicaEntities dc = new ClinicaEntities())
{
var x = from c in dc.Rpt_Consulta_Full
where
(param.IdProfecional.Equals(null) || c.IdProfecional.Value == param.IdProfecional.Value)
&&
(param.IdTipoConsulta.Equals(null) || c.IdTipoConsulta.Value == param.IdTipoConsulta.Value)
&&
(param.IdMutual.Equals(null) || c.IdMutual.Value == param.IdMutual.Value)
&&
(param.Fecha.Equals(null) || (c.Fecha >= param.Fecha && c.Fecha <= param.FechaFin))
select new Rpt_Consulta_FullBE
{
IdProfecional = c.IdProfecional,
IdMutual = c.IdMutual,
Fecha = c.Fecha,
PresentaOrden = c.PresentaOrden,
Coseguro = c.Coseguro,
ExigeCoseguro = c.ExigeCoseguro,
ArancelMutual = c.ArancelMutual,
IdTipoConsulta = c.IdTipoConsulta,
TipoConsulta = c.TipoConsulta,
Profecional = c.Profecional,
Mutual = c.Mutual,
};
if (x.Count <Rpt_Consulta_FullBE>() == 0)
{
return(list);
}
list.AddRange(x.ToArray <Rpt_Consulta_FullBE>());
}
return(list);
}
public ConsultaBE GetFilter()
{
ConsultaBE wConsultaBE = new ConsultaBE();
if (rndPorMes.Checked)
{
int month = (int)(Enum.Parse(typeof(Meses), cmbMonths.EditValue.ToString()));
wConsultaBE.Fecha = new DateTime(DateTime.Now.Year, month, 1);
int day = DateTime.DaysInMonth(DateTime.Now.Year, month);
wConsultaBE.FechaFin = new DateTime(DateTime.Now.Year, month, day);
}
else
{
wConsultaBE.Fecha = new DateTime(dtPickerFechaInicio.Value.Year, dtPickerFechaInicio.Value.Month, dtPickerFechaInicio.Value.Day, 0, 0, 0);
wConsultaBE.FechaFin = new DateTime(dtPickerFechaFin.Value.Year, dtPickerFechaFin.Value.Month, dtPickerFechaFin.Value.Day, 23, 59, 59);
}
if (grpCombos.Visible && grpCombos.Enabled)
{
if ((int)cmbProfecionales.EditValue != (int)CommonValuesEnum.TodosComboBoxValue)
{
wConsultaBE.IdProfecional = Convert.ToInt32(cmbProfecionales.EditValue);
}
if ((int)cmbTipoConsulta.EditValue != (int)CommonValuesEnum.TodosComboBoxValue)
{
wConsultaBE.IdTipoConsulta = Convert.ToInt32(cmbTipoConsulta.EditValue);
}
if ((int)cmb_Mutual.EditValue != (int)CommonValuesEnum.TodosComboBoxValue)
{
wConsultaBE.IdMutual = Convert.ToInt32(cmb_Mutual.EditValue);
}
}
return(wConsultaBE);
}
internal static ConsultaGridList SearchByParams(ConsultaBE param)
{
return(ConsultaDAC.SearchByParams(param));
}
internal static Rpt_Consulta_FullList Search_Consulta_FullView_ByParams(ConsultaBE param)
{
return(ConsultaViewDAC.SearchByParams(param));
}
internal static void UpdateConsulta(ConsultaBE param)
{
ConsultaDAC.Update(param);
}
internal static int CreateConsulta(ConsultaBE param)
{
ConsultaDAC.Create(param);
return(param.IdConsulta);
}
/// <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);
}
}
void SetFilter()
{
ConsultaBE wConsultaBE = uC_FitroConsultaHorizontal1.GetFilter();
Populate(wConsultaBE);
}
private void btnRefresh_Click(object sender, EventArgs e)
{
ConsultaBE filter = this.uC_FitroConsultaHorizontal1.GetFilter();
Pupulate(filter.Fecha, filter.FechaFin.Value, null);
}
