public IEnumerable <TEProjectUnitModel> GetByProjectNTowerId(int projectId, int towerId) { db.Configuration.ProxyCreationEnabled = false; List <TEProjects_UNIT> list = db.TEProjects_UNIT.Where(x => (x.IsDeleted == false) && (x.PROJECT_ID == projectId) && (x.TOWERID == towerId) ).ToList(); List <TEProjectUnitModel> result = new List <TEProjectUnitModel>(); foreach (var item in list) { TEProjectUnitModel model = new TEProjectUnitModel(); TETransformEntityNModel translator = new TETransformEntityNModel(); model = translator.TransformAtoB(item, model); #region Commented due to entity change //if (item.PROJECT_ID.Value > 0) //{ // TEProject pro = db.TEProjects.Find(item.PROJECT_ID.Value); // if (pro != null) // model.Project = new TEProject // { // Uniqueid = pro.Uniqueid, // ProjectCode = pro.ProjectCode, // ProjectName = pro.ProjectName, // ProjectShortName = pro.ProjectShortName, // ProjectStatus = pro.ProjectStatus, // IsNewProject = pro.IsNewProject, // City = pro.City, // COLOURCODE = pro.COLOURCODE, // }; //} #endregion if (item.TOWERID != null) { TEProjects_TOWER tower = db.TEProjects_TOWER.Find(item.TOWERID); if (tower != null) { model.Tower = new TEProjects_TOWER { Uniqueid = tower.Uniqueid, TOWERNAME = tower.TOWERNAME, TOWERCODE = tower.TOWERCODE, DESCRIPTION = tower.DESCRIPTION } } ; } result.Add(model); } return(result); }
public TEProjectUnitModel Get(int id) { TEProjects_UNIT item = db.TEProjects_UNIT.Find(id); TEProjectUnitModel model = new TEProjectUnitModel(); TETransformEntityNModel translator = new TETransformEntityNModel(); model = translator.TransformAtoB(item, model); #region Commented due to entity change //if (item.PROJECT_ID.Value > 0) //{ // TEProject pro = db.TEProjects.Find(item.PROJECT_ID.Value); // if (pro != null) // model.Project = new TEProject // { // Uniqueid = pro.Uniqueid, // ProjectCode = pro.ProjectCode, // ProjectName = pro.ProjectName, // ProjectShortName = pro.ProjectShortName, // ProjectStatus = pro.ProjectStatus, // IsNewProject = pro.IsNewProject, // City = pro.City, // COLOURCODE = pro.COLOURCODE, // }; //} #endregion if (item.TOWERID != null) { TEProjects_TOWER tower = db.TEProjects_TOWER.Find(item.TOWERID); if (tower != null) { model.Tower = new TEProjects_TOWER { Uniqueid = tower.Uniqueid, TOWERNAME = tower.TOWERNAME, TOWERCODE = tower.TOWERCODE, DESCRIPTION = tower.DESCRIPTION } } ; } return(model); }