[System.Web.Http.Route("swi/PM_Tasks"), System.Web.Http.HttpPost] //Filters:ByTaskTypeId,ByTaskTypeKeyCode,ByPTaskId,ByTaskId,ByProjectId public HttpResponseMessage PM_Tasks(string filter, string pType, string pId, bool Resources = false, Int64 ProjectId = 0, Int64 TaskId = 0) { PM_TaskBL tb = new PM_TaskBL(); var result = tb.ToList(filter, pType, pId, ProjectId, TaskId); if (Resources) { PM_ProjectResourceBL prb = new PM_ProjectResourceBL(); foreach (var item in result) { item.ProjectResources = prb.ToList("byTaskId", item.TaskId.ToString(), ProjectId, TaskId); } } //return Json(rec, JsonRequestBehavior.AllowGet); if (result != null) { return(Request.CreateResponse(HttpStatusCode.OK, result)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Record for Id " + TaskId.ToString() + " not found")); } }
public ActionResult ToSingle(string filter, string value = "0", string value2 = "0") { PM_TaskBL tb = new PM_TaskBL(); var rec = tb.ToList(filter, value, value2).FirstOrDefault(); if (rec != null) { PM_ProjectResourceBL prb = new PM_ProjectResourceBL(); rec.ProjectResources = prb.ToList("byTaskId", rec.TaskId.ToString()); } return(Json(rec, JsonRequestBehavior.AllowGet)); }
public Response _Tasks(string filter = "", string value = "", string value2 = "", bool Resources = false, Int64 ProjectId = 0, Int64 TaskId = 0) { Response _res = new Response(); try { PM_TaskBL tb = new PM_TaskBL(); var rec = tb.ToList(filter, value, ProjectId.ToString(), ProjectId, TaskId); if (Resources) { PM_ProjectResourceBL prb = new PM_ProjectResourceBL(); foreach (var item in rec) { item.ProjectResources = prb.ToList("byTaskId", item.TaskId.ToString(), ProjectId, TaskId); } } if (filter == "ByTaskTypeKeyCode") { AD_DefinationBL db = new AD_DefinationBL(); List <AD_Defination> ProjectStatus = db.ToList("byDefinationType", "Project Task Status"); foreach (var item in rec) { var Splited = ProjectStatus.Where(x => x.DefinationId == item.StatusId).FirstOrDefault(); if (Splited != null) { var CurrentStatus = Splited.DefinationName.ToLower(); switch (CurrentStatus) { case "active": item.Status = "STATUS_ACTIVE"; break; case "suspended": item.Status = "STATUS_SUSPENDED"; break; case "completed": item.Status = "STATUS_DONE"; break; case "cancelled": item.Status = "STATUS_FAILED"; break; case "undefined": item.Status = "STATUS_UNDEFINED"; break; case "planned": item.Status = "STATUS_PLANNED"; break; //default : // item.StatusId = 0; } // item.Status = GanttStatusses.Where(x=>x.Split('_')[1].ToLower() == Splited.DefinationName.ToLower()).FirstOrDefault(); } if (item.Status == null || item.Status == "") { item.Status = "STATUS_PLANNED"; item.StatusId = ProjectStatus.Where(x => x.DefinationName == "Planned").FirstOrDefault().PDefinationId; } } } _res.Value = rec; _res.Message = "Ok"; _res.Status = "true"; return(_res); } catch (Exception _ex) { _res.Message = _ex.Message; _res.Status = "false"; return(_res); } }
public ActionResult ToList(string filter, string value, string value2, bool Resources = false, Int64 ProjectId = 0, Int64 TaskId = 0) { PM_TaskBL tb = new PM_TaskBL(); var rec = tb.ToList(filter, value, value2, ProjectId, TaskId); if (Resources) { PM_ProjectResourceBL prb = new PM_ProjectResourceBL(); foreach (var item in rec) { item.ProjectResources = prb.ToList("byTaskId", item.TaskId.ToString(), ProjectId, TaskId); } } if (filter == "ByTaskTypeKeyCode") { AD_DefinationBL db = new AD_DefinationBL(); List <AD_Defination> ProjectStatus = db.ToList("byDefinationType", "Project Task Status"); foreach (var item in rec) { var Splited = ProjectStatus.Where(x => x.DefinationId == item.StatusId).FirstOrDefault(); if (Splited != null) { var CurrentStatus = Splited.DefinationName.ToLower(); switch (CurrentStatus) { case "active": item.Status = "STATUS_ACTIVE"; break; case "suspended": item.Status = "STATUS_SUSPENDED"; break; case "completed": item.Status = "STATUS_DONE"; break; case "cancelled": item.Status = "STATUS_FAILED"; break; case "undefined": item.Status = "STATUS_UNDEFINED"; break; case "planned": item.Status = "STATUS_PLANNED"; break; //default : // item.StatusId = 0; } // item.Status = GanttStatusses.Where(x=>x.Split('_')[1].ToLower() == Splited.DefinationName.ToLower()).FirstOrDefault(); } if (item.Status == null || item.Status == "") { item.Status = "STATUS_PLANNED"; item.StatusId = ProjectStatus.Where(x => x.DefinationName == "Planned").FirstOrDefault().PDefinationId; } } } return(Json(rec, JsonRequestBehavior.AllowGet)); }