public ActionResult Register(Employee obj) { if (ModelState != null) { QTMEntities data = new QTMEntities(); data.Employees.Add(obj); data.SaveChanges(); } ViewBag.Message = obj.FirstName + " " + obj.LastName + " " + "Successfully Registerd"; ModelState.Clear(); return(View()); }
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 ActionResult Login(Employee obj) { QTMEntities db = new QTMEntities(); var user = db.Employees.SingleOrDefault(u => u.EmpId == obj.EmpId && u.Password == obj.Password); if (user != null) { Session["Empid"] = user.EmpId.ToString(); Session["Fname"] = user.FirstName.ToString(); Session["Lname"] = user.LastName.ToString(); ViewBag.Message = "yes"; return(RedirectToAction("UserPage")); } else { ViewBag.Message = "Invalid Credentials"; } return(View()); }
// This method is used to display the list of tasks from the database corresponding to NotImportant and Urgent public ActionResult NIUTasks() { QTMEntities ob = new QTMEntities(); string empID = Session["Empid"].ToString(); List <EmployeeTaskModel> lis = (from log in ob.EmpTaskLists where (log.EmpId == empID && log.Quadrant_Id == "Q103") select log).Select(x => new EmployeeTaskModel { EmpId = x.EmpId, TaskDate = x.TaskDate, Task = x.Task, TaskId = x.TaskId, Type_Of_Task = x.Type_Of_Task, //Start_Time = x.Start_Time, //End_Time = x.End_Time, Status = x.Status_Percentage }).ToList(); return(PartialView("NIUList", lis)); }
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)); }
public ActionResult ParSearch(string PDate) { QTMEntities db = new QTMEntities(); string empID = Session["Empid"].ToString(); DateTime dt1 = DateTime.Parse(PDate, CultureInfo.InvariantCulture); List <EmployeeTaskModel> serData = (from log in db.EmpTaskLists where (EntityFunctions.TruncateTime(log.TaskDate) == (EntityFunctions.TruncateTime(dt1)) && log.EmpId == empID && log.IsDeleted == 0) select log).Select(x => new EmployeeTaskModel { EmpId = x.EmpId, TaskDate = x.TaskDate, Task = x.Task, TaskId = x.TaskId, Type_Of_Task = x.Type_Of_Task, //Start_Time = x.Start_Time, //End_Time = x.End_Time, Status = x.Status_Percentage }).ToList(); return(PartialView("TaskList", serData)); }