public ActionResult _AddTask(string taskName, int groupId = 0) { var lastTask = _taskService.GetAllTasks() .OrderByDescending(x => x.DisplayOrder) .FirstOrDefault() ?? new tblTask(); var task = new tblTask { DisplayOrder = lastTask.DisplayOrder + 1, GroupId = groupId, InsertDate = DateTime.Now, InsertUserId = 0, IsCompleted = false, Name = taskName }; try { _taskService.AddTask(task); _unitOfWork.SaveChanges(); } catch (Exception ex) { var responseModel = CreateResponse(HttpStatusCode.InternalServerError, ex.GetBaseException().Message, ResponseStatusTypes.Danger); return(Json(responseModel, JsonRequestBehavior.AllowGet)); } return(PartialView("_TaskPartial", task)); }
public IHttpActionResult PutTask(int id, tblTask task) { if (id != task.ID) { return(BadRequest()); } db.Entry(task).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!TaskExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult put(tblTask item) { ProjectBAL obj = new ProjectBAL(); obj.UpdateTask(item); return(Ok("Record Updated")); }
public ActionResult EditTask(int TaskID) { Task model = new Task(); List <tblPriority> list = db.tblPriorities.ToList(); ViewBag.PriorityList = new SelectList(list, "PriorityID", "Priority"); int ID = Convert.ToInt32(Session["UserID"]); if (TaskID > 0) { tblTask objtblTask = db.tblTasks.SingleOrDefault(x => x.TaskID == TaskID && x.ID == ID); model.TaskID = objtblTask.TaskID; model.Title = objtblTask.Title; model.TaskDetail = objtblTask.TaskDetail; model.StartDate = objtblTask.StartDate; model.StartTime = objtblTask.StartTime; model.EndDate = objtblTask.EndDate; model.EndTime = objtblTask.EndTime; model.Completed = objtblTask.Completed; model.PriorityID = objtblTask.PriorityID; } return(PartialView("EditTaskPartial", model)); }
public IHttpActionResult post(tblTask item) { ProjectBAL obj = new ProjectBAL(); obj.AddTask(item); return(Ok("Record added")); }
protected void rptTaskFile_ItemCommand(object source, RepeaterCommandEventArgs e) { try { var DC = new DataClassesDataContext(); if (e.CommandName == "Download") { tblTask TaskData = DC.tblTasks.Single(ob => ob.TaskID == Convert.ToInt32(e.CommandArgument)); tblModule ModuleData = DC.tblModules.Single(ob => ob.ModuleID == TaskData.ModuleID); tblProject ProjectData = DC.tblProjects.Single(ob => ob.ProjectID == ModuleData.ProjectID); Response.Clear(); Response.ContentType = "application/zip"; Response.AddHeader("content-disposition", "filename=" + ProjectData.Title + "_" + ModuleData.Title + "_" + TaskData.Title + ".zip"); using (ZipFile zip = new ZipFile()) { zip.AddDirectory(Server.MapPath("UploadTaskFile/") + @TaskData.SubmittedFile); zip.Save(Response.OutputStream); } } } catch (Exception ex) { int session = Convert.ToInt32(Session["EmpID"].ToString()); string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath); string MACAddress = GetMacAddress(); AddErrorLog(ref ex, PageName, "Employee", session, 0, MACAddress); ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true); } }
public void UpdateTask(tblTask taskitem) { try { using (ProjectManagerDBEntities db1 = new ProjectManagerDBEntities()) { tblTask taskupdate = db1.tblTasks.SingleOrDefault(x => x.TaskId == taskitem.TaskId); tblProject projectupdate = db1.tblProjects.SingleOrDefault(x => x.ProjectId == taskupdate.ProjectId); projectupdate.Nooftasks = projectupdate.Nooftasks - 1; taskupdate.TaskName = taskitem.TaskName; taskupdate.TStartDate = taskitem.TStartDate; taskupdate.TEndDate = taskitem.TEndDate; taskupdate.TPriority = taskitem.TPriority; taskupdate.TStatus = taskitem.TStatus; taskupdate.ParentId = taskitem.ParentId; taskupdate.ProjectId = taskitem.ProjectId; taskupdate.UserId = taskitem.UserId; taskupdate.ParentTaskName = taskitem.ParentTaskName; tblProject projectupdate1 = db1.tblProjects.SingleOrDefault(x => x.ProjectId == taskitem.ProjectId); projectupdate1.Nooftasks = projectupdate1.Nooftasks + 1; db1.SaveChanges(); } } catch { } }
//[Route("UpdateTaskDetails")] public HttpResponseMessage Put(int id, [FromBody] tblTask newTask) { try { using (TaskDBEntities entities = new TaskDBEntities()) { var entity = entities.tblTask.FirstOrDefault(t => t.QuoteID == id); if (entity == null) { //return 404 not found return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Task with ID=" + id.ToString() + " is not found to update.")); } else { entity.QuoteType = newTask.QuoteType; entity.ContactID = newTask.ContactID; entity.TaskDescription = newTask.TaskDescription; entity.TaskDueDate = newTask.TaskDueDate; entity.TaskType = newTask.TaskType; entities.SaveChanges(); //return 200 OK return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public ActionResult CreateStudent(tblTask std) { db.tblTasks.Add(std); db.SaveChanges(); string msg = "Success"; return(Json(new { Message = msg, JsonRequestBehavior.AllowGet })); }
public void Getbytask() { ProjectBL obj = new ProjectBL(); List <tblTask> Ts = obj.GetTask(); tblTask count = obj.GetTaskbyId(Ts[0].TaskId); Assert.IsNotNull(count); }
public ActionResult DeleteConfirmed(int id) { tblTask tbltask = db.tblTasks.Find(id); db.tblTasks.Remove(tbltask); db.SaveChanges(); return(RedirectToAction("Index")); }
protected void LinkButton12_Click(object sender, EventArgs e) { var DC = new DataClassesDataContext(); tblTask TaskData = DC.tblTasks.Single(ob => ob.TaskID == Convert.ToInt32(ltrTaskID.Text)); tblModule ModuleData = DC.tblModules.Single(ob => ob.ModuleID == TaskData.ModuleID); Session["ModuleID"] = ModuleData.ModuleID; Response.Redirect("ModuleDetail.aspx"); }
public void Getbytask() { ProjectBAL obj = new ProjectBAL(); List <tblTask> Ts = obj.GetTask(); //Task count = obj.GetTaskbyId(1); tblTask count = obj.GetTaskbyId(Ts[0].TaskId); Assert.IsNotNull(count); // Assert.Greater(count, 0); }
public void AddTask(tblTask item) { using (FinalSBADBEntities db1 = new FinalSBADBEntities()) { var projectupdate = db1.tblProjects.Where(x => x.ProjectId == item.ProjectId).ToList(); projectupdate.ForEach(m => m.Nooftasks = m.Nooftasks + 1); item.TStatus = false; db1.tblTasks.Add(item); db1.SaveChanges(); } }
public void DeleteTask(int TaskId) { using (FinalSBADBEntities db1 = new FinalSBADBEntities()) { tblTask ts = db1.tblTasks.Where(d => d.TaskId == TaskId).FirstOrDefault(); var projectupdate = db1.tblProjects.Where(x => x.ProjectId == ts.ProjectId).ToList(); projectupdate.ForEach(m => m.completed = m.completed - 1); db1.tblTasks.Remove(ts); db1.SaveChanges(); } }
public void DeleteTask() { ProjectBL obj = new ProjectBL(); List <tblTask> Ts = obj.GetTask(); tblTask Taskgetbyid = obj.GetTaskbyId(Ts[0].TaskId); int count1 = obj.GetTask().Count(); obj.DeleteTask(Taskgetbyid.TaskId); int count2 = obj.GetTask().Count(); Assert.AreEqual(count2, count1 - 1); }
public void Endtask(int id) { using (ProjectManagerDBEntities db = new ProjectManagerDBEntities()) { tblTask ts = db.tblTasks.SingleOrDefault(x => x.TaskId == id); var projectupdate = db.tblProjects.Where(x => x.ProjectId == ts.ProjectId).ToList(); projectupdate.ForEach(m => m.Nooftasks = m.Nooftasks - 1); projectupdate.ForEach(m => m.completed = m.completed + 1); ts.TStatus = true; ts.TEndDate = DateTime.Now; db.SaveChanges(); } }
public void AddTask() { ProjectBL obje = new ProjectBL(); int count = obje.GetTask().Count(); tblTask T = (new tblTask { TaskName = "Working", TStartDate = DateTime.Now, TEndDate = DateTime.Now, TPriority = 10, TStatus = false, ParentTaskName = "Cleaning", UserId = 1 }); obje.AddTask(T); int count1 = obje.GetTask().Count(); Assert.AreEqual(count1, count + 1); }
public IHttpActionResult DeleteTask(int id) { tblTask objTask = db.tblTasks.Find(id); if (objTask == null) { return(NotFound()); } db.tblTasks.Remove(objTask); db.SaveChanges(); return(Ok(objTask)); }
public ActionResult Edit([Bind(Include = "TaskID,ProjectID,Title,EndUser,AssignedTo,OpenedBy,OpenedDate,StatusID,SubCategoryID,PriorityID,Description,ScheduledStart,ActualStart,ScheduledFinish,EstFinish,ActualFinish,EstDurationDays,DateModified,RelatedIssues,Comments,Publicity,PctComplete,GroupName,IISR,Atch")] tblTask tbltask) { if (ModelState.IsValid) { db.Entry(tbltask).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.PriorityID = new SelectList(db.tblPriorities, "PriorityID", "PriorityName", tbltask.PriorityID); ViewBag.ProjectID = new SelectList(db.tblProjects, "ProjectID", "ProjectName", tbltask.ProjectID); ViewBag.StatusID = new SelectList(db.tblStatus, "StatusID", "StatusName", tbltask.StatusID); ViewBag.SubCategoryID = new SelectList(db.tblSubCategories, "SubCategoryID", "SubCategoryName", tbltask.SubCategoryID); return(View(tbltask)); }
// GET: /Task/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblTask tbltask = db.tblTasks.Find(id); if (tbltask == null) { return(HttpNotFound()); } return(View(tbltask)); }
public void DeleteTask() { ProjectBAL obj = new ProjectBAL(); List <tblTask> Ts = obj.GetTask(); tblTask Taskgetbyid = obj.GetTaskbyId(Ts[0].TaskId); int count1 = obj.GetTask().Count(); //dynamic testtask = new (Task) list<Task>; //Task T = (new Task { TaskId = 1015, ParentName = "ParentTaskstest", TaskName = "Testtaskname", Priority = 15, SDate = DateTime.Now, EDate = DateTime.Now }); obj.DeleteTask(Taskgetbyid.TaskId); int count2 = obj.GetTask().Count(); Assert.AreEqual(count2, count1 - 1); }
public void AddTask_Service() { var obj = new ProjectManagerAPI.Controllers.TaskController(); tblTask Ts = (new tblTask { TaskName = "Cooking", TStartDate = DateTime.Now, TEndDate = DateTime.Now, TPriority = 10, TStatus = false, ParentTaskName = "Cleaning", UserId = 0 }); IHttpActionResult result = obj.post(Ts); var contentresult = result as OkNegotiatedContentResult <string>; IHttpActionResult result1 = obj.Get(); var contentresult1 = result1 as OkNegotiatedContentResult <List <tblTask> >; Assert.IsNotNull(contentresult); Assert.Greater(contentresult1.Content.Count, 0); }
public JsonResult DeleteTask(int TaskID) { bool result = false; tblTask objtblTask = db.tblTasks.SingleOrDefault(x => x.TaskID == TaskID); if (objtblTask != null) { result = true; db.tblTasks.Remove(objtblTask); db.SaveChanges(); } return(Json(result, JsonRequestBehavior.AllowGet)); }
public void AddTask() { ProjectBAL obje = new ProjectBAL(); int count = obje.GetTask().Count(); //dynamic testtask = new (Task) list<Task>; tblTask T = (new tblTask { TaskName = "Testtaskname", TStartDate = DateTime.Now, TEndDate = DateTime.Now, TPriority = 10, TStatus = false, ParentTaskName = "parenttask", UserId = 1 }); obje.AddTask(T); int count1 = obje.GetTask().Count(); Assert.AreEqual(count1, count + 1); }
public void UpdateTAsk() { var obj = new ProjectManagerAPI.Controllers.TaskController(); IHttpActionResult result = obj.Get(); var contentresult = result as OkNegotiatedContentResult <List <tblTask> >; // tblTask ts = new tblTask { TaskId = contentresult.Content[0].TaskId, TaskName = "Updated Task", ParentName = "Updated Parent", Priority = 10, SDate = DateTime.Now, EDate = DateTime.Now, flag = true }; tblTask Ts = (new tblTask { TaskId = contentresult.Content[0].TaskId, TaskName = "taskname", TStartDate = DateTime.Now, TEndDate = DateTime.Now, TPriority = 10, TStatus = false, ParentTaskName = "parenttask", UserId = 1 }); IHttpActionResult result1 = obj.put(Ts); IHttpActionResult result2 = obj.Get(); var contentresult1 = result2 as OkNegotiatedContentResult <List <tblTask> >; Assert.AreEqual(contentresult1.Content[0].TaskName, Ts.TaskName); }
public void AddTask_Service() { var obj = new ProjectManagerAPI.Controllers.TaskController(); //Task ts = new tblTask { TaskName = "Task added", ParentName = "Parent added", Priority = 10, SDate = DateTime.Now, EDate = DateTime.Now, flag = true }; tblTask Ts = (new tblTask { TaskName = "Testtaskname", TStartDate = DateTime.Now, TEndDate = DateTime.Now, TPriority = 10, TStatus = false, ParentTaskName = "parenttask", UserId = 0 }); IHttpActionResult result = obj.post(Ts); var contentresult = result as OkNegotiatedContentResult <string>; IHttpActionResult result1 = obj.Get(); var contentresult1 = result1 as OkNegotiatedContentResult <List <tblTask> >; Assert.IsNotNull(contentresult); Assert.Greater(contentresult1.Content.Count, 0); }
protected void Button1_Click(object sender, EventArgs e) { try { var DC = new DataClassesDataContext(); if (fileUploadTask.HasFiles) { tblTask TaskData = DC.tblTasks.Single(ob => ob.TaskID == Convert.ToInt32(ltrTaskID.Text)); if (TaskData.SubmittedFile == null) { string FolderName = DateTime.Now.ToString("ddMMyyyyHmmss"); string folderPath = Server.MapPath("UploadTaskFile/" + FolderName + "/"); //check whether directory (folder) exists. if (!Directory.Exists(folderPath)) { //if directory (folder) does not exists. create it. Directory.CreateDirectory(folderPath); } foreach (HttpPostedFile uploadedfile in fileUploadTask.PostedFiles) { //uploadedfile.SaveAs(System.IO.Path.Combine(Server.MapPath(folderPath), uploadedfile.FileName)); uploadedfile.SaveAs(folderPath + Path.GetFileName(uploadedfile.FileName)); lblFileName.Text += string.Format("<br />{0}", uploadedfile.FileName); } TaskData.SubmittedFile = FolderName; } else { foreach (HttpPostedFile uploadedfile in fileUploadTask.PostedFiles) { //uploadedfile.SaveAs(System.IO.Path.Combine(Server.MapPath(folderPath), uploadedfile.FileName)); uploadedfile.SaveAs(Server.MapPath("UploadTaskFile/" + TaskData.SubmittedFile + "/") + Path.GetFileName(uploadedfile.FileName)); lblFileName.Text += string.Format("<br />{0}", uploadedfile.FileName); } } } DC.SubmitChanges(); } catch (Exception ex) { int session = Convert.ToInt32(Session["EmpID"].ToString()); string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath); string MACAddress = GetMacAddress(); AddErrorLog(ref ex, PageName, "Employee", session, 0, MACAddress); ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true); } }
protected void rptTask_ItemCommand(object source, RepeaterCommandEventArgs e) { var DC = new DataClassesDataContext(); if (e.CommandName == "View") { Session["TaskID"] = e.CommandArgument; Response.Redirect("TaskDetail.aspx"); } else if (e.CommandName == "Delete") { tblTask TaskData = DC.tblTasks.Single(ob => ob.TaskID == Convert.ToInt32(e.CommandArgument)); TaskData.IsActive = false; DC.SubmitChanges(); } }
public void updateTask() { ProjectBL obj = new ProjectBL(); List <tblTask> Ts = obj.GetTask(); tblTask Taskgetbyid = obj.GetTaskbyId(Ts[0].TaskId); int count = obj.GetTask().Count(); tblTask T = (new tblTask { TaskId = Ts[0].TaskId, TaskName = "Cooking", TStartDate = DateTime.Now, TEndDate = DateTime.Now, TPriority = 10, TStatus = false, ParentTaskName = "Cleaning", UserId = 1 }); obj.UpdateTask(T); int count1 = obj.GetTask().Count(); List <tblTask> TS1 = obj.GetTask(); Assert.AreEqual(count1, count); }