// GET api/<controller>/5
public TEProjectTowerModel Get(int id)
{
TEProjects_TOWER item = db.TEProjects_TOWER.Find(id);
TEProjectTowerModel model = new TEProjectTowerModel();
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.TowerInProject = 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
return(model);
}
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);
}
// POST api/<controller>
public TEProjects_TOWER Post(TEProjects_TOWER value)
{
db.Configuration.ProxyCreationEnabled = false;
TEProjects_TOWER result = value;
if (!(value.Uniqueid + "".Length > 0))
{
//Create
result.CreatedOn = System.DateTime.Now;
result.LastModifiedOn = System.DateTime.Now;
result = db.TEProjects_TOWER.Add(value);
}
else
{
//Edit
db = new TEHRIS_DevEntities();
db.TEProjects_TOWER.Attach(value);
foreach (System.Reflection.PropertyInfo item in result.GetType().GetProperties())
{
string propname = item.Name;
if (propname.ToLower() == "createdon")
{
continue;
}
object propValue = item.GetValue(value);
if (propValue != null || Convert.ToString(propValue).Length != 0)
{
db.Entry(value).Property(propname).IsModified = true;
}
}
value.LastModifiedOn = System.DateTime.Now;
db.Entry(value).Property(x => x.LastModifiedOn).IsModified = true;
}
db.SaveChanges();
return(db.TEProjects_TOWER.Find(value.Uniqueid));
}
