public void Todo(Observer o) { int id = 1; Taskmodel model = null; if (!int.TryParse(o.body.ToString(), out id)) { return; } if (taskproxy.TryGethaveModel(id, out model)) { } else { ALLTaskmodel a; if (AllTask.TryGetModel(id, out a)) { model = new Taskmodel(taskproxy.getMaxid() + 1); model.HaveTid = a.id; taskproxy.addmodeltolist(model); if (a.ischoice) { AppFactory.instances.Todo(new Observer("rtask", "else")); } else { AppFactory.instances.Todo(new Observer("rtask", "main")); } } } }
public async Task <IHttpActionResult> GetTaskmodel(int id) { Taskmodel taskmodel = await db.Tasks.FindAsync(id); if (taskmodel == null) { return(NotFound()); } return(Ok(taskmodel)); }
public async Task <IHttpActionResult> DeleteTaskmodel(int id) { Taskmodel taskmodel = await db.Tasks.FindAsync(id); if (taskmodel == null) { return(NotFound()); } db.Tasks.Remove(taskmodel); await db.SaveChangesAsync(); return(Ok(taskmodel)); }
public async Task <IHttpActionResult> PostTaskmodel(TaskViewModel taskmodel) { //if (!ModelState.IsValid) //{ // return BadRequest(ModelState); //} Story story = db.Stories.FirstOrDefault(e => e.id == taskmodel.storyId); Taskmodel task = new Taskmodel(); task.story = story; task.name = taskmodel.name; task.description = taskmodel.description; task.priority = taskmodel.priority; task.estimate = taskmodel.estimate; task.status = taskmodel.status; task.createdAt = DateTime.Now; db.Tasks.Add(task); await db.SaveChangesAsync(); return(CreatedAtRoute("DefaultApi", new { id = task.id }, task)); }
public async Task <IHttpActionResult> PutTaskmodel(int id, TaskViewModel taskmodel) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != taskmodel.id) { return(BadRequest()); } Story story = db.Stories.FirstOrDefault(e => e.id == taskmodel.storyId); Taskmodel task = new Taskmodel(); task.story = story; task.name = taskmodel.name; task.description = taskmodel.description; task.priority = taskmodel.priority; task.estimate = taskmodel.estimate; task.status = taskmodel.status; db.Entry(task).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TaskmodelExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult AddTask(int ProjectId, int PhaseId, string PhaseName, int PhaseStatus, string TaskName, int Taskstatus, DateTime StartDate, DateTime EndDate, int Efforts) { try { DateTime startdate; DateTime enddate; //startdate = (DateTime)db.ProjectPhases.FirstOrDefault(x => x.Phase == PhaseName).StartDate; //enddate = (DateTime)db.ProjectPhases.FirstOrDefault(x => x.Phase == PhaseName).EndDate; startdate = (DateTime)db.ProjectPhases.Where(x => x.ProjectPhaseId == PhaseId).Select(o => o.StartDate).FirstOrDefault(); enddate = (DateTime)db.ProjectPhases.Where(x => x.ProjectPhaseId == PhaseId).Select(o => o.EndDate).FirstOrDefault(); string start = startdate.ToString("dd/MM/yyyy"); string end = enddate.ToString("dd/MM/yyyy"); var userId = (int)Session["UserId"]; var already = db.TS_Task.Where(x => x.StartDate == StartDate && x.EndDATE == EndDate && x.ProjectName == ProjectId && x.TaskName == TaskName && (x.IsDelete == false || x.IsDelete == null)).Select(o => o).FirstOrDefault(); var alreadyname = db.TS_Task.Where(x => x.ProjectName == ProjectId && x.TaskName == TaskName).Select(o => o).FirstOrDefault(); var exist = db.TS_Task.Where(x => (x.StartDate == StartDate || x.EndDATE == EndDate) && x.ProjectName == ProjectId && x.TaskName == TaskName && (x.IsDelete == false || x.IsDelete == null)).Select(o => o).FirstOrDefault(); var avail = db.TS_Task.Where(x => x.ProjectName == ProjectId && x.TaskName == TaskName && (x.IsDelete == false || x.IsDelete == null)).Select(o => o).FirstOrDefault(); bool overlapping = db.ProjectPhases.FirstOrDefault(x => EntityFunctions.TruncateTime(x.StartDate) <= EntityFunctions.TruncateTime(StartDate) && EntityFunctions.TruncateTime(x.EndDate) >= EntityFunctions.TruncateTime(EndDate) && x.Phase == PhaseName && x.IsACTIVE == true) != null; int y = 0; List <int> Total = new List <int>(); Total = db.TS_Task.Where(x => x.PhaseNameId == PhaseId && x.ISACTIVE == true).Select(o => o.NoOfEfforts).ToList(); for (int z = 0; z < Total.Count(); z++) { y += Total[z]; } if (!overlapping) { var result = new { message = "timeexceed", sdate = start, edate = end }; return(Json(new { message = "timeexceed", sdate = start, edate = end })); } if (already != null || alreadyname != null) { return(Json("AlreadyAssigned", JsonRequestBehavior.AllowGet)); } if (exist != null) { return(Json("exist", JsonRequestBehavior.AllowGet)); } if (avail != null) { return(Json("avail", JsonRequestBehavior.AllowGet)); } var value = db.ProjectPhases.Where(x => x.ProjectPhaseId == PhaseId && x.IsACTIVE == true).Select(o => o.NoOfEfforts).FirstOrDefault(); if ((y + Efforts) > value) { return(Json("greater", JsonRequestBehavior.AllowGet)); } else { var objtsk = db.TS_Task.CreateObject(); objtsk.UserId = userId; objtsk.ProjectName = ProjectId; objtsk.PhaseNameId = PhaseId; objtsk.PhaseName = PhaseName; objtsk.PhaseStatus = PhaseStatus; objtsk.TaskName = TaskName; objtsk.TaskStatus = Taskstatus; objtsk.StartDate = StartDate; objtsk.EndDATE = EndDate; objtsk.NoOfEfforts = Efforts; objtsk.ISACTIVE = true; objtsk.IsDelete = false; objtsk.IsOpened = true; db.TS_Task.AddObject(objtsk); db.SaveChanges(); } Taskmodel obj = new Taskmodel(); obj.newtask = 1; TempData["newtask"] = 1; } catch (Exception Ex) { string actionName = this.ControllerContext.RouteData.Values["action"].ToString(); string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName); } return(Json("Success", JsonRequestBehavior.AllowGet)); }
public ActionResult AssignNewTask(AssignTaskModel model) { try{ DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); var employeecount = model.SelectedEmpList.Count(); var name = model.Taskid; var Name = db.TS_Task.Where(x => x.TaskId == name).Select(o => o.TaskName).FirstOrDefault(); string UserName = ""; DateTime startdate; DateTime enddate; foreach (int id in model.SelectedEmpList) { UserName = db.Users.Where(o => o.UserID == id).Select(o => o.FirstName + " " + o.LastName ?? "").FirstOrDefault(); startdate = (DateTime)db.TS_Task.FirstOrDefault(x => x.TaskId == model.Taskid).StartDate; enddate = (DateTime)db.TS_Task.FirstOrDefault(x => x.TaskId == model.Taskid).EndDATE; string start = startdate.ToString("dd/MM/yyyy"); string end = enddate.ToString("dd/MM/yyyy"); string fdate = Convert.ToString(model.StartDate); string tdate = Convert.ToString(model.EndDate); var fromdate = DateTime.Parse(fdate); var todate = DateTime.Parse(tdate); bool overlapping = db.TS_Task.FirstOrDefault(x => EntityFunctions.TruncateTime(x.StartDate) <= EntityFunctions.TruncateTime(fromdate) && EntityFunctions.TruncateTime(x.EndDATE) >= EntityFunctions.TruncateTime(todate) && x.TaskId == model.Taskid && x.ISACTIVE == true) != null; var helpfromassign = db.TS_AssignedTask.Where(x => x.TaskName == model.Taskid).Select(o => o).FirstOrDefault(); var TaskName = db.TS_Task.Where(x => x.ProjectName == model.ProjectId && x.TaskName == model.Task).Select(o => o.TaskId).FirstOrDefault(); //startdateassign =(DateTime) db.TS_AssignedTask.FirstOrDefault(x => x.ProjectId == model.ProjectId).StartDate; //enddateassign = (DateTime)db.TS_AssignedTask.FirstOrDefault(x => x.ProjectId == model.ProjectId).EndDate; //string Start = startdateassign.ToString("dd/MM/yyyy"); //string End = enddateassign.ToString("dd/MM/yyyy"); //string Fdate = Convert.ToString(model.StartDate); //string Tdate = Convert.ToString(model.EndDate); //var Fromdate = DateTime.Parse(Fdate); //var Todate = DateTime.Parse(Tda var value = db.TS_Task.Where(x => x.TaskId == model.Taskid && x.ISACTIVE == true).Select(o => o.NoOfEfforts).FirstOrDefault(); int?y = 0; List <int?> Total = new List <int?>(); Total = db.TS_AssignedTask.Where(x => x.TaskName == model.Taskid && x.IsActive == true).Select(o => o.NoOfEfforts).ToList(); for (int z = 0; z < Total.Count(); z++) { y += Total[z]; } if ((employeecount * model.NumberOfEfforts) > value || (value < model.NumberOfEfforts) || (y + model.NumberOfEfforts) > value) { return(Json("Greater", JsonRequestBehavior.AllowGet)); } bool overlap = db.TS_AssignedTask.FirstOrDefault(x => EntityFunctions.TruncateTime(x.StartDate) <= EntityFunctions.TruncateTime(fromdate) && EntityFunctions.TruncateTime(x.EndDate) >= EntityFunctions.TruncateTime(todate) && x.Employees == id && x.IsActive == true && x.ProjectId == model.ProjectId && x.Task == model.Task) != null; if (!overlapping) { var result = new { message = "timeexceed", sdate = start, edate = end }; return(Json(new { message = "timeexceed", sdate = start, edate = end })); } if (overlap) { var result = new { message = "Already", name = UserName }; return(Json(new { message = "Already", name = UserName })); } } //foreach (int id in model.SelectedEmpList) //{ // var Assignobj = db.TS_AssignedTask.CreateObject(); // Assignobj.ProjectId = model.ProjectId; // Assignobj.PhaseName = model.ProjectphaseId; // Assignobj.TaskName = model.Taskid; // Assignobj.NoOfEfforts = model.NumberOfEfforts; // Assignobj.Employees = id; // Assignobj.StartDate = model.StartDate; // Assignobj.EndDate = model.EndDate; // Assignobj.IsActive = true; // Assignobj.ISdelete = false; // Assignobj.TaskStatus= model.tasktypeid; // Assignobj.Approved = false; // Assignobj.Isreject = false; // Assignobj.Task=model.Task; // db.TS_AssignedTask.AddObject(Assignobj); // db.SaveChanges(); //} var Assignobj = db.TS_AssignedTask.CreateObject(); Assignobj.ProjectId = model.ProjectId; Assignobj.PhaseName = model.ProjectphaseId; Assignobj.TaskName = model.Taskid; Assignobj.NoOfEfforts = model.NumberOfEfforts; Assignobj.SelectedEmployess = model.multiselectemployees; // Assignobj.Employees = Convert.ToInt32(model.SelectedEmpList[i]); Assignobj.StartDate = model.StartDate; Assignobj.EndDate = model.EndDate; Assignobj.IsActive = true; Assignobj.ISdelete = false; Assignobj.TaskStatus = model.tasktypeid; Assignobj.Approved = false; Assignobj.Isreject = false; Assignobj.Task = Name; Assignobj.flag = 0; Assignobj.Task = model.Task; db.TS_AssignedTask.AddObject(Assignobj); db.SaveChanges(); for (int i = 0; i < model.SelectedEmpList.Count(); i++) { DSRCManagementSystem.TS_AssignedTask obj = new DSRCManagementSystem.TS_AssignedTask(); obj.ProjectId = model.ProjectId; obj.PhaseName = model.ProjectphaseId; obj.TaskName = model.Taskid; obj.NoOfEfforts = model.NumberOfEfforts; obj.SelectedEmployess = model.multiselectemployees; obj.Employees = Convert.ToInt32(model.SelectedEmpList[i]); obj.StartDate = model.StartDate; obj.EndDate = model.EndDate; obj.Task = Name; obj.IsActive = true; obj.ISdelete = false; obj.TaskStatus = model.tasktypeid; obj.Approved = false; obj.Isreject = false; obj.flag = 1; obj.Task = model.Task; db.TS_AssignedTask.AddObject(obj); db.SaveChanges(); } Taskmodel oj = new Taskmodel(); oj.newassigntask = 1; TempData["newassigntask"] = 1; } catch (Exception Ex) { string actionName = this.ControllerContext.RouteData.Values["action"].ToString(); string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName); } return(Json("Success", JsonRequestBehavior.AllowGet)); }