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