public ActionResult _Create([Bind(Include = "TaskListID,Name,ListDetail,TaskTypeID,TaskPriorityID,TaskStatusID,ListDate")] TaskList tasklist, string[] EmployeeID) { tasklist.ListDate = DateTime.Now; tasklist.TaskStatusID = 1; ViewBag.Message = ""; ViewBag.Error = "Error"; try { db.TaskLists.Add(tasklist); db.SaveChanges(); foreach (string eid in EmployeeID) { TaskEmployee taskemployee = new TaskEmployee(); taskemployee.TaskListID = tasklist.TaskListID; taskemployee.EmployeeID = int.Parse(eid); db.TaskEmployees.Add(taskemployee); db.SaveChanges(); } ViewBag.Error = ""; ViewBag.Message = "Created Successfully, Please click REFRESH button to view"; } catch { } ViewBag.EmployeeID = new MultiSelectList(db.Employees.Where(e => e.EmployeeID > 1).OrderByDescending(e => e.Name), "EmployeeID", "Name"); ViewBag.TaskPriorityID = new SelectList(db.TaskPrioritys, "TaskPriorityID", "Name", tasklist.TaskPriorityID); ViewBag.TaskTypeID = new SelectList(db.TaskTypes, "TaskTypeID", "Name", tasklist.TaskTypeID); return(PartialView()); }
public ActionResult DeleteConfirmed(int id) { TaskEmployee taskemployee = db.TaskEmployees.Find(id); db.TaskEmployees.Remove(taskemployee); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "TaskEmployeeID,TaskListID,EmployeeID")] TaskEmployee taskemployee) { if (ModelState.IsValid) { db.Entry(taskemployee).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.EmployeeID = new SelectList(db.Employees, "EmployeeID", "Name", taskemployee.EmployeeID); ViewBag.TaskListID = new SelectList(db.TaskLists, "TaskListID", "Name", taskemployee.TaskListID); return(View(taskemployee)); }
public static TaskEmployee CreateFromServerToClient(this TaskEmployee source) { return(new TaskEmployee { TaskEmployeeId = source.TaskEmployeeId, TaskId = source.TaskId, EmployeeId = source.EmployeeId, RecCreatedBy = source.RecCreatedBy, RecCreatedDt = source.RecCreatedDt, RecLastUpdatedBy = source.RecLastUpdatedBy, RecLastUpdatedDt = source.RecLastUpdatedDt }); }
public static Models.TaskEmployee CreateFromServerToClient(this TaskEmployee source) { return(new Models.TaskEmployee { TaskEmployeeId = source.TaskEmployeeId, TaskId = source.TaskId, EmployeeId = source.EmployeeId, RecCreatedBy = source.RecCreatedBy, RecCreatedDt = source.RecCreatedDt, RecLastUpdatedBy = source.RecLastUpdatedBy, RecLastUpdatedDt = source.RecLastUpdatedDt, ProjectTask = source.ProjectTask.CreateFromServerToClientForEmployee() }); }
// GET: /TaskEmployee/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TaskEmployee taskemployee = db.TaskEmployees.Find(id); if (taskemployee == null) { return(HttpNotFound()); } return(View(taskemployee)); }
public async Task <TaskEmployee> Create(TaskEmployee taskEmployee) { try { await _baseContext.TaskEmployee.AddAsync(taskEmployee); await _baseContext.SaveChangesAsync(); return(taskEmployee); } catch (Exception e) { Debug.WriteLine(e); throw; } }
public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TaskEmployee taskemployee = db.TaskEmployees.Find(id); if (taskemployee == null) { return(HttpNotFound()); } ViewBag.EmployeeID = new SelectList(db.Employees, "EmployeeID", "Name", taskemployee.EmployeeID); ViewBag.TaskListID = new SelectList(db.TaskLists, "TaskListID", "Name", taskemployee.TaskListID); return(View(taskemployee)); }
public ActionResult EditMaintenance([Bind(Include = "TaskListID,Name,ListDetail,TaskTypeID,TaskPriorityID,TaskStatusID,ListDate")] TaskList tasklist, string[] EmployeeID) { Session["err"] = "Error"; Session["msg"] = ""; List <int> idList = new List <int>(); try { db.Entry(tasklist).State = EntityState.Modified; db.SaveChanges(); var taskemployeeList = db.TaskEmployees.Where(t => t.TaskListID == tasklist.TaskListID).ToList(); foreach (TaskEmployee te in taskemployeeList) { db.TaskEmployees.Remove(te); db.SaveChanges(); } foreach (string eid in EmployeeID) { TaskEmployee taskemployee = new TaskEmployee(); taskemployee.TaskListID = tasklist.TaskListID; taskemployee.EmployeeID = int.Parse(eid); db.TaskEmployees.Add(taskemployee); db.SaveChanges(); } taskemployeeList = db.TaskEmployees.Where(t => t.TaskListID == tasklist.TaskListID).ToList(); foreach (TaskEmployee te in taskemployeeList) { idList.Add(te.EmployeeID); } Session["msg"] = "Modified Successfully"; Session["err"] = ""; } catch { } ViewBag.EmployeeID = new MultiSelectList(db.Employees.Where(e => e.EmployeeID > 1).OrderBy(e => e.Name), "EmployeeID", "Name", idList); ViewBag.TaskStatusID = new SelectList(db.TaskStatuss, "TaskStatusID", "Name", tasklist.TaskStatusID); ViewBag.TaskPriorityID = new SelectList(db.TaskPrioritys, "TaskPriorityID", "Name", tasklist.TaskPriorityID); ViewBag.TaskTypeID = new SelectList(db.TaskTypes, "TaskTypeID", "Name", tasklist.TaskTypeID); return(RedirectToAction("EditMaintenance", "TaskList", new { id = tasklist.TaskListID })); }
public bool EditTaskByObj(JArray castObj, int id) { var items = castObj.ToObject <List <ItemGridSource> >(); var emp = db.Employees.Where(i => i.EmployeeID == id).First(); foreach (var item in items) { var ToItemDic = item.GetType().GetProperties(BindingFlags.Instance | BindingFlags.Public).ToDictionary(prop => prop.Name, prop => prop.GetValue(item, null)); ToItemDic.Remove("Id"); ToItemDic.Remove("Name"); foreach (var day in ToItemDic) { if (day.Value != null) { var daynum = ((int)Enum.Parse(typeof(DayOfWeek), day.Key)).ToString(); var Count = db.TimeSheets.Where(e => e.Employee.EmployeeID == id && e.Task.TaskID == item.Id && e.Day.Day == daynum).Count(); if (Count != 0) { try { var tasksheets = db.TimeSheets.Include(d => d.Day).Where(e => e.Employee.EmployeeID == id && e.Task.TaskID == item.Id); var sheets = tasksheets.Where(e => e.Day.Day == daynum).FirstOrDefault(); sheets.Hours = day.Value.ToString(); db.SaveChanges(); } catch (Exception ex) { throw; } } else { var task = db.Tasks.Include(t => t.TimeSheets).ThenInclude(d => ((TimeSheet)d).Day).Where(i => i.TaskID == item.Id).First(); var dayObj = db.Days.Where(d => d.Day == day.Key).FirstOrDefault(); if (dayObj == null) { dayObj = new Days { Day = ((int)Enum.Parse(typeof(DayOfWeek), day.Key)).ToString() }; } TimeSheet timeSheet = new TimeSheet { Day = dayObj, Hours = day.Value.ToString(), Employee = emp, Date = DateTime.Today.ToString() }; task.TimeSheets.Add(timeSheet); db.SaveChanges(); var taskEmp = db.TaskEmployees.Where(t => t.TaskID == task.TaskID && t.EmployeeID == emp.EmployeeID).FirstOrDefault(); if (taskEmp == null) { taskEmp = new TaskEmployee { Employee = emp, Task = task }; db.TaskEmployees.Add(taskEmp); db.SaveChanges(); } } } } } return(true); }