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));
}
