public object GetSearchConfiguration([FromUri] object param)
{
CommonFilters commfilters = new CommonFilters();
commfilters.DeserializeParameters(param);
db.Database.Log = s => System.Diagnostics.Debug.WriteLine(s);
var entryPoint = (from configs in db.Configurations
join wkitems in db.WorkItems on configs.work_item_id equals wkitems.work_item_id
join status in db.Statuses on configs.config_status_id equals status.status_id
join application in db.Applications on configs.application_id equals application.application_id
join scope in db.Scopes on wkitems.scope_id equals scope.scope_id
join sprint in db.Sprints on wkitems.sprint_id equals sprint.sprint_id
join config_type in db.Config_Types on configs.config_type_id equals config_type.config_type_id
where (String.IsNullOrEmpty(commfilters.work_item_nm) || commfilters.work_item_nm.Contains(wkitems.work_item_ext_id)) &&
(String.IsNullOrEmpty(commfilters.modified_usr_ids) || commfilters.modified_usr_ids.Contains(configs.modified_usr_id)) &&
((commfilters.startdate == null || configs.modified_dtm == null) || configs.modified_dtm >= commfilters.startdate) &&
((commfilters.enddate == null || configs.modified_dtm == null) || configs.modified_dtm <= commfilters.enddate)
select new
{
configs.config_id,
configs.config_nm,
configs.config_key,
configs.config_dev_int_value,
configs.config_qa_value,
configs.config_prod_value,
configs.config_status_id,
configs.config_type_id,
configs.application_id,
wkitems.sprint_id,
wkitems.work_item_ext_id,
wkitems.scope_id,
configs.is_pdf,
configs.pdfaction,
configs.comments,
application.application_nm,
scope.scope_nm,
sprint.sprint_nm,
status.status_nm,
config_type.config_type_nm
}).ToList();
//return db.Configurations.AsEnumerable();
db.Database.Log = s => System.Diagnostics.Debug.WriteLine(s);
// Apply filters
var filtereddata = (from dbdata in entryPoint
where ((commfilters.applications == null || commfilters.applications.Count == 0) || commfilters.applications.Any(cp => cp.application_id.Equals(dbdata.application_id))) &&
((commfilters.scopes == null || commfilters.scopes.Count == 0) || commfilters.scopes.Any(cp => cp.scope_id.Equals(dbdata.scope_id))) &&
((commfilters.sprints == null || commfilters.sprints.Count == 0) || commfilters.sprints.Any(cp => cp.sprint_id.Equals(dbdata.sprint_id)))
select dbdata);
return(filtereddata.ToArray());
}
public Array GetCheckListItemSummary([FromUri] object param)
{
CommonFilters commfilters = new CommonFilters();
commfilters.DeserializeParameters(param);
var entryPoint = (from checklist in db.CheckListActions
join chklistactionxref in db.CheckListActionsXref on checklist.checklist_action_id equals chklistactionxref.checklist_action_id
join refsubtype in db.SubTypes on checklist.sub_type_id equals refsubtype.sub_type_id into grefsubtype
from agrefsubtype in grefsubtype.DefaultIfEmpty()
where
(String.IsNullOrEmpty(commfilters.modified_usr_ids) || commfilters.modified_usr_ids.Contains(checklist.modified_usr_id)) &&
((commfilters.startdate == null || checklist.modified_dtm == null) || checklist.modified_dtm >= commfilters.startdate) &&
((commfilters.enddate == null || checklist.modified_dtm == null) || checklist.modified_dtm <= commfilters.enddate)
group chklistactionxref by new { agrefsubtype.sub_type_nm, checklist.created_usr_id, checklist.created_dtm, checklist.checklist_action_nm, chklistactionxref.checklist_action_id } into g
select new
{
NOTSTARTED = g.Count(chklistactionxref => chklistactionxref.status_id == (short)(CheckListStatus.NOTSTARTED)),
COMPLETED = g.Count(chklistactionxref => chklistactionxref.status_id == (short)(CheckListStatus.COMPLETED)),
INPROGRESS = g.Count(chklistactionxref => chklistactionxref.status_id == (short)(CheckListStatus.INPROGRESS)),
NOTAPPLICABLE = g.Count(chklistactionxref => chklistactionxref.status_id == (short)(CheckListStatus.NOTAPPLICABLE)),
g.Key.sub_type_nm,
g.Key.created_usr_id,
g.Key.created_dtm,
g.Key.checklist_action_nm,
g.Key.checklist_action_id,
}
).ToList();
// Apply filters
var filtereddata = (from dbdata in entryPoint
where (
(commfilters.search_for_options == null)
||
((commfilters.search_for_options["value"].ToString() == "COMPLETED" && (dbdata.INPROGRESS + dbdata.NOTSTARTED) == 0) ||
(commfilters.search_for_options["value"].ToString() == "INCOMPLETE" && (dbdata.INPROGRESS + dbdata.NOTSTARTED) > 0) ||
(commfilters.search_for_options["value"].ToString() == "ALL"))
)
select dbdata).ToList();
return(filtereddata.ToArray());
}
public object GetSearchWorkItem([FromUri] object param)
{
CommonFilters commfilters = new CommonFilters();
commfilters.DeserializeParameters(param);
var entryPoint = (from wkitems in db.WorkItems
join scope in db.Scopes on wkitems.scope_id equals scope.scope_id
join sprint in db.Sprints on wkitems.sprint_id equals sprint.sprint_id
where ((commfilters.startdate == null || wkitems.modified_dtm == null) || wkitems.modified_dtm >= commfilters.startdate) &&
((commfilters.enddate == null || wkitems.modified_dtm == null) || wkitems.modified_dtm <= commfilters.enddate)
//where (String.IsNullOrEmpty(commfilters.work_item_nm) || commfilters.work_item_nm.Contains(wkitems.work_item_ext_id))
//&& (String.IsNullOrEmpty(commfilters.modified_usr_ids) || commfilters.modified_usr_ids.Contains(wkitems.modified_usr_id))
////&& (commfilters.startdate == null || wkitems.modified_dtm >= commfilters.startdate)
//&& (commfilters.enddate == null || wkitems.modified_dtm <= commfilters.enddate)
select new
{
wkitems.work_item_id,
wkitems.sprint_id,
wkitems.work_item_ext_id,
wkitems.scope_id,
scope.scope_nm,
sprint.sprint_nm,
wkitems.work_item_title
}).ToList();
// Apply filters
var filtereddata = (from dbdata in entryPoint
where ((commfilters.scopes == null || commfilters.scopes.Count == 0) || commfilters.scopes.Any(cp => cp.scope_id.Equals(dbdata.scope_id))) &&
((commfilters.sprints == null || commfilters.sprints.Count == 0) || commfilters.sprints.Any(cp => cp.sprint_id.Equals(dbdata.sprint_id)))
select dbdata);
return(filtereddata.ToArray());
}
