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