// 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 <TECategoryModel> Get() { List <TECategory> list = db.TECategories.Where(x => x.IsDeleted == false).ToList(); List <TECategoryModel> result = new List <TECategoryModel>(); foreach (var item in list) { TECategoryModel model = new TECategoryModel(); TETransformEntityNModel translator = new TETransformEntityNModel(); model = translator.TransformAtoB(item, model); if (item.Parent.Value > 0) { TECategory cat = db.TECategories.Find(item.Parent.Value); model.ParentCategory = cat; } if (model.ParentCategory == null) { model.ParentCategory = new TECategory(); } result.Add(model); } return(result); }
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); }
// GET api/<controller>/5 public TEEscalationMatrixModel Get(int id) { TEESCALATIONMATRIX item = db.TEESCALATIONMATRIces.Find(id); TEEscalationMatrixModel model = new TEEscalationMatrixModel(); TETransformEntityNModel translator = new TETransformEntityNModel(); model = translator.TransformAtoB(item, model); if (item.QueueID != null) { TEQueue q = db.TEQueues.Find(item.QueueID.Value); if (q != null) { model.Queue = new TEQueue { Uniqueid = q.Uniqueid, QueueName = q.QueueName, QueueID = q.QueueID, } } ; } if (item.ManagerID != null) { TEEmpBasicInfo mgr = db.TEEmpBasicInfoes.Find(item.ManagerID.Value); if (mgr != null) { model.Manager = new TEEmpBasicInfo { Uniqueid = mgr.Uniqueid, FirstName = mgr.FirstName, LastName = mgr.LastName, Mobile = mgr.Mobile, OfficialEmail = mgr.OfficialEmail, } } ; } if (item.Priority != null) { int picklistid = Convert.ToInt32(item.Priority); TEPickListItem p = db.TEPickListItems.Find(picklistid); if (p != null) { model.PriorityName = p.Description; } } return(model); }
public IEnumerable <TEQueueModel> GetQueueList(int Uniqueid) { //List<TEQueue> listOfQueue = db.TEQueues.Where(x => x.IsDeleted == false).ToList(); int raisedby = (from iss in db.TEIssues where (iss.Uniqueid == Uniqueid) select iss.RaisedBy).FirstOrDefault().Value; var listOfQueue = (from q in db.TEQueues join i in db.TEIssues on q.Uniqueid equals i.QueueID where //(i.RaisedBy == RaisedBy) && (q.IsDeleted == false) && (i.RaisedBy == raisedby) orderby q.PROJECTID descending select new { q.Uniqueid, q.PROJECTID, q.QueueID, q.QueueName }).Distinct().ToList(); List <TEQueueModel> result = new List <TEQueueModel>(); foreach (var item in listOfQueue) { TEQueueModel qModel = new TEQueueModel(); TETransformEntityNModel translator = new TETransformEntityNModel(); qModel = translator.TransformAtoB(item, qModel); #region Commented due to entity change //if (item.PROJECTID != null) //{ // TEProject proj = db.TEProjects.Find(item.PROJECTID.Value); // if (proj != null) // qModel.TEProject = new TEProject() // { // Uniqueid = proj.Uniqueid, // ProjectCode = proj.ProjectCode, // ProjectName = proj.ProjectName, // ProjectShortName = proj.ProjectShortName // }; //} //if (qModel.TEProject == null) //{ // qModel.TEProject = new TEProject(); //} #endregion result.Add(qModel); } return(result); }
public TECategoryModel Get(int id) { TECategory item = db.TECategories.Find(id); TECategoryModel model = new TECategoryModel(); TETransformEntityNModel translator = new TETransformEntityNModel(); model = translator.TransformAtoB(item, model); if (item.Parent.Value > 0) { TECategory cat = db.TECategories.Find(item.Parent.Value); model.ParentCategory = cat; } return(model); }
public IEnumerable <TEQueueModel> GetQueueList() { //db.Configuration.ProxyCreationEnabled = false; List <TEQueue> listOfQueue = db.TEQueues.Where(x => (x.IsDeleted == false)).ToList(); //&& (x.PROJECTID != null)).ToList(); List <TEQueueModel> result = new List <TEQueueModel>(); foreach (var item in listOfQueue) { if (item.Admin != null) { TETransformEntityNModel translator = new TETransformEntityNModel(); TEQueueModel qModel = translator.TransformAtoB(item, new TEQueueModel()); qModel.UserProfile = db.UserProfiles.Where(x => x.UserId == item.Admin).FirstOrDefault(); result.Add(qModel); } //UserProfile AdminName = db.UserProfiles.Where(x => x.- == item.admin).FirstOrDefault(); //UserProfile AdminName = db.u //qModel. #region Commented due to entity change //if (item.PROJECTID != null) //{ // TEProject proj = db.TEProjects.Find(item.PROJECTID.Value); // if (proj != null) // qModel.TEProject = new TEProject() // { // Uniqueid = proj.Uniqueid, // ProjectCode = proj.ProjectCode, // ProjectName = proj.ProjectName, // ProjectShortName = proj.ProjectShortName // }; //} //if (qModel.TEProject == null) //{ // qModel.TEProject = new TEProject(); //} #endregion // result.Add(AdminName); } 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); }
// GET api/<controller> public IEnumerable <TEProjectTowerModel> Get() { db.Configuration.ProxyCreationEnabled = false; List <TEProjects_TOWER> list = db.TEProjects_TOWER.Where(x => x.IsDeleted == false).ToList(); List <TEProjectTowerModel> result = new List <TEProjectTowerModel>(); foreach (var item in list) { TEProjectTowerModel model = new TEProjectTowerModel(); TETransformEntityNModel translator = new TETransformEntityNModel(); model = translator.TransformAtoB(item, model); #region Commented due to entity change //if (item.PROJECT_ID!=null) //{ // 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, // }; //} //if (model.TowerInProject == null) //{ // model.TowerInProject = new TEProject(); //} #endregion result.Add(model); } return(result); }
public TEQueue GetQueuebyId(int id) { TEQueue item = db.TEQueues.Find(id); TEQueueModel qModel = new TEQueueModel(); TETransformEntityNModel translator = new TETransformEntityNModel(); qModel = translator.TransformAtoB(item, qModel); #region Commented due to entity change //if (item.PROJECTID != null) //{ // TEProject proj = db.TEProjects.Find(item.PROJECTID.Value); // qModel.TEProject = new TEProject() // { // Uniqueid = proj.Uniqueid, // ProjectCode = proj.ProjectCode, // ProjectName = proj.ProjectName, // ProjectShortName = proj.ProjectShortName // }; //} #endregion return(qModel); }
public List <TEQueueModel> GetQueueListinternal() { List <TEQueue> listOfQueue = db.TEQueues.Where(x => (x.IsDeleted == false && x.PROJECTID == null)).ToList(); //&&(x.PROJECTID == null)).ToList(); List <TEQueueModel> result = new List <TEQueueModel>(); foreach (var item in listOfQueue) { TEQueueModel qModel = new TEQueueModel(); TETransformEntityNModel translator = new TETransformEntityNModel(); qModel = translator.TransformAtoB(item, qModel); qModel.UserProfile = null; #region Commented due to entity change //if (item.PROJECTID != null) //{ // TEProject proj = db.TEProjects.Find(item.PROJECTID.Value); // if (proj != null) // qModel.TEProject = new TEProject() // { // Uniqueid = proj.Uniqueid, // ProjectCode = proj.ProjectCode, // ProjectName = proj.ProjectName, // ProjectShortName = proj.ProjectShortName // }; //} //if (qModel.TEProject == null) //{ // qModel.TEProject = new TEProject(); //} #endregion result.Add(qModel); } return(result); }
// GET api/<controller> public IEnumerable <TEEscalationMatrixModel> Get() { db.Configuration.ProxyCreationEnabled = false; List <TEESCALATIONMATRIX> list = db.TEESCALATIONMATRIces.Where(x => x.IsDeleted == false).ToList(); List <TEEscalationMatrixModel> result = new List <TEEscalationMatrixModel>(); foreach (var item in list) { TEEscalationMatrixModel model = new TEEscalationMatrixModel(); TETransformEntityNModel translator = new TETransformEntityNModel(); model = translator.TransformAtoB(item, model); if (item.QueueID != null) { TEQueue q = db.TEQueues.Find(item.QueueID.Value); if (q != null) { model.Queue = new TEQueue { Uniqueid = q.Uniqueid, QueueName = q.QueueName, QueueID = q.QueueID, } } ; } if (model.Queue == null) { model.Queue = new TEQueue(); } if (item.ManagerID != null) { TEEmpBasicInfo mgr = db.TEEmpBasicInfoes.Find(item.ManagerID.Value); if (mgr != null) { model.Manager = new TEEmpBasicInfo { Uniqueid = mgr.Uniqueid, FirstName = mgr.FirstName, LastName = mgr.LastName, Mobile = mgr.Mobile, OfficialEmail = mgr.OfficialEmail, } } ; } if (model.Manager == null) { model.Manager = new TEEmpBasicInfo(); } if (item.Priority != null) { int picklistid = Convert.ToInt32(item.Priority); TEPickListItem p = db.TEPickListItems.Find(picklistid); if (p != null) { model.PriorityName = p.Description; } } result.Add(model); } return(result); }