public IEnumerable<MxFormularDetail> GetFormularDetail(int formularId) { using (var _db = new MixingEntities()) { var mxFormularDetails = _db.mx_FormularDetail.Where(f => f.Formular_Ref == formularId).ToList(); return mxFormularDetails.Select(Mapper.Map<MxFormularDetail>).ToList(); } }
public IEnumerable<MxFormular> GetFormularByObject(int objectId) { using (var _db = new MixingEntities()) { var mxFormulars = _db.mx_Formular.Where(f => f.Object_Ref == objectId).ToList(); return mxFormulars.Select(Mapper.Map<MxFormular>); } }
public IEnumerable<MxElement> GetElements() { using (var _db = new MixingEntities()) { var mxElements = _db.mx_Element.ToList(); return mxElements.Select(Mapper.Map<MxElement>); } }
public IEnumerable<MxObject> GetObjects() { using (var _db = new MixingEntities()) { var mxObjects = _db.mx_Object.ToList(); return mxObjects.Select(Mapper.Map<MxObject>); } }
public IEnumerable<MxSubstance> GetSubstances(bool getAll, int objectId) { using (var _db = new MixingEntities()) { var mxSubstancesList = new List<mx_Substance>(); if (getAll) { mxSubstancesList = _db.mx_Substance.ToList(); } else { var mxSubstanceUsedDefaults = _db.mx_SubstanceUsedDefault.Where(sud => sud.Object_Ref == objectId || sud.Object_Ref == 0).Select(sub => sub.Substance_Ref).ToList(); mxSubstancesList = _db.mx_Substance.Where(s => mxSubstanceUsedDefaults.Contains(s.ID)).ToList(); } var mxSubstances = mxSubstancesList.Select(Mapper.Map<MxSubstance>).ToList(); return mxSubstances; } }
public IEnumerable<mx_Setting> GetSettings() { using (var _db = new MixingEntities()) { var mxSettings = _db.mx_Setting.ToList(); return mxSettings; } }