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