public JsonResult DeleteEmployee(int taskId) { QTMEntities entities = new QTMEntities(); EmpTaskList deletedtedEmployee = (from c in entities.EmpTaskLists where c.TaskId == taskId select c).FirstOrDefault(); deletedtedEmployee.IsDeleted = 1; entities.SaveChanges(); return(Json("yes", JsonRequestBehavior.AllowGet)); }
public JsonResult List(string Task, string Type_Of_Task, string TaskDate) { QTMEntities db = new QTMEntities(); EmpTaskList obj = new EmpTaskList(); DateTime dt = DateTime.Parse(TaskDate, CultureInfo.InvariantCulture); obj.EmpId = Session["Empid"].ToString(); obj.TaskDate = dt; obj.Task = Task; obj.Type_Of_Task = Type_Of_Task; db.EmpTaskLists.Add(obj); db.SaveChanges(); return(Json("yes", JsonRequestBehavior.AllowGet)); }
public JsonResult UpdateStatus(EmployeeTaskModel employees) { QTMEntities entities = new QTMEntities(); EmpTaskList updatedEmployee = (from c in entities.EmpTaskLists where c.TaskId == employees.TaskId select c).FirstOrDefault(); updatedEmployee.Task = employees.Task; updatedEmployee.Type_Of_Task = employees.Type_Of_Task; //updatedEmployee.Start_Time = employees.Start_Time; //updatedEmployee.End_Time = employees.End_Time; updatedEmployee.Status_Percentage = employees.Status; entities.SaveChanges(); return(Json("yes", JsonRequestBehavior.AllowGet)); }
public JsonResult saveList(string ItemList, string TableName) { var main = ItemList.Split(','); QTMEntities db = new QTMEntities(); foreach (var itm in main) { EmpTaskList ob = db.EmpTaskLists.Single(x => x.TaskId.ToString() == itm); if (ob.Quadrant_Id == null) { ob.Quadrant_Id = TableName; db.SaveChanges(); } else { return(Json("no", JsonRequestBehavior.AllowGet)); } } return(Json("yes", JsonRequestBehavior.AllowGet)); }