static Controller() { _MutualList = EstablesIndependientesDAC.Search_MutualList_All(); _MutualList.Add(new MutualBE { Nombre = "Todos", IdMutual = (int)CommonValuesEnum.TodosComboBoxValue }); _MutualList.Add(new MutualBE { Nombre = Enum.GetName(typeof(CommonValuesEnum), CommonValuesEnum.Ninguno), IdMutual = (int)CommonValuesEnum.Ninguno }); _ProfecionalList = EstablesIndependientesDAC.Search_ProfecionalList_ByParams(new ProfecionalBE()); _ProfecionalList.Add(new ProfecionalBE { Nombre = "Todos", IdProfecional = (int)CommonValuesEnum.TodosComboBoxValue }); _ProfecionalList.Add(new ProfecionalBE { Nombre = Enum.GetName(typeof(CommonValuesEnum), CommonValuesEnum.Ninguno), IdProfecional = (int)CommonValuesEnum.Ninguno }); _TipoConsultaList = ParamComercialDAC.GetByParams(200, null, true, string.Empty); _TipoConsultaList.Add(new ParamComercialBE { Nombre = "Todos", IdParamComercial = (int)CommonValuesEnum.TodosComboBoxValue }); _TipoConsultaList.Add(new ParamComercialBE { Nombre = Enum.GetName(typeof(CommonValuesEnum), CommonValuesEnum.Ninguno), IdParamComercial = (int)CommonValuesEnum.Ninguno }); }
public static MutualList RetriveAll() { MutualList list = new MutualList(); MutualBE wMutualBE ; using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { foreach (Mutual m_db in dc.Mutuals) { wMutualBE = (MutualBE)m_db; list.Add( wMutualBE); } } return list; }
public static MutualList RetriveAll() { MutualList list = new MutualList(); MutualBE wMutualBE; using (Health.Back.BE.HealthEntities dc = new Health.Back.BE.HealthEntities(Common.CnnString_Entities)) { foreach (Mutual m_db in dc.Mutuals) { wMutualBE = (MutualBE)m_db; list.Add(wMutualBE); } } return(list); }
/// <summary> /// /// </summary> /// <returns></returns> public static MutualList Search_MutualList_All() { try { MutualList list = new MutualList(); using (ClinicaEntities dc = new ClinicaEntities()) { //var x = from c in dc.Mutual select new MutualBE(c); Only parameterless constructors and initializers are supported in LINQ to Entities. var x = from c in dc.Mutual select new MutualBE { IdMutual = c.IdMutual, Nombre = c.Nombre, ExigeCoseguro = c.ExigeCoseguro }; list.AddRange(x.ToArray <MutualBE>()); } return(list); } catch (Exception ex) { throw Fwk.Exceptions.ExceptionHelper.ProcessException(ex); } }