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); }