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