private void BindData() { TaskBLL TaskBL = new TaskBLL(connectionString); List<TaskViewModel> tasks = TaskBL.GetTaskInventory(); Dictionary<int, string> CarID_Name = TaskBL.GetNameListFromCarTable(); Dictionary<int, string> EmployeeID_Name = TaskBL.GetNameListFromEmployeeTable(); string[] date_notime = new string[3]; foreach (TaskViewModel element in tasks) { date_notime = element.DateAssigned.Split(' '); element.DateAssigned = date_notime[0]; if (!String.IsNullOrEmpty(element.DateComplete)) { date_notime = element.DateComplete.Split(' '); element.DateComplete = date_notime[0]; } } SelectCar.DataSource = CarID_Name.Values; SelectCar.DataBind(); AssignedEmployee.DataSource = EmployeeID_Name.Values; AssignedEmployee.DataBind(); TaskList.DataSource = tasks; TaskList.DataBind(); }
public async Task <IHttpActionResult> PutAssignedEmployee(int id, AssignedEmployee assignedEmployee) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != assignedEmployee.Id) { return(BadRequest()); } db.Entry(assignedEmployee).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!AssignedEmployeeExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public async Task <IHttpActionResult> GetAssignedEmployee(int id) { AssignedEmployee assignedEmployee = await db.AssignedEmployees.FindAsync(id); if (assignedEmployee == null) { return(NotFound()); } return(Ok(assignedEmployee)); }
public async Task <IHttpActionResult> PostAssignedEmployee(AssignedEmployee assignedEmployee) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.AssignedEmployees.Add(assignedEmployee); await db.SaveChangesAsync(); return(CreatedAtRoute("DefaultApi", new { id = assignedEmployee.Id }, assignedEmployee)); }
private void BindData() { TaskBLL TaskBL = new TaskBLL(connectionString); Dictionary <int, string> CarID_Name = TaskBL.GetNameListFromCarTable(); Dictionary <int, string> EmployeeID_Name = TaskBL.GetNameListFromEmployeeTable(); SelectCar.DataSource = CarID_Name.Values; SelectCar.DataBind(); AssignedEmployee.DataSource = EmployeeID_Name.Values; AssignedEmployee.DataBind(); }
public async Task <IHttpActionResult> DeleteAssignedEmployee(int id) { AssignedEmployee assignedEmployee = await db.AssignedEmployees.FindAsync(id); if (assignedEmployee == null) { return(NotFound()); } db.AssignedEmployees.Remove(assignedEmployee); await db.SaveChangesAsync(); return(Ok(assignedEmployee)); }