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