/// <summary>
/// Get Tasks by Name
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public IHttpActionResult GetAllTasks(string name)
{
IList <TasksViewModel> tasks = null;
using (var model = new DataModelToDo())
{
if (!string.IsNullOrEmpty(name))
{
tasks = model.Tasks.Include("status").Include("users")
.Where(s => s.Name.Contains(name))
.Select(s => new TasksViewModel()
{
Id = s.Id,
Name = s.Name,
Description = s.Description,
Status = s.Status == null ? null : new StatusViewModel()
{
Id = s.Status.Id,
Name = s.Status.Name
},
Users = s.Users == null ? null : new UsersViewModel()
{
Id = s.Users.Id,
Name = s.Users.Name,
PhoneNumber = s.Users.PhoneNumber,
Email = s.Users.Email,
}
}).ToList <TasksViewModel>();
}
else
{
tasks = model.Tasks.Include("status").Include("users")
.Select(s => new TasksViewModel()
{
Id = s.Id,
Name = s.Name,
Description = s.Description,
Status = s.Status == null ? null : new StatusViewModel()
{
Id = s.Status.Id,
Name = s.Status.Name
},
Users = s.Users == null ? null : new UsersViewModel()
{
Id = s.Users.Id,
Name = s.Users.Name,
PhoneNumber = s.Users.PhoneNumber,
Email = s.Users.Email,
}
}).ToList <TasksViewModel>();
}
}
if (tasks.Count == 0)
{
return(NotFound());
}
return(Ok(tasks));
}
public IHttpActionResult GetAllStatus()
{
IList <StatusViewModel> status = null;
using (var model = new DataModelToDo())
{
status = model.Status
.Select(s => new StatusViewModel()
{
Id = s.Id,
Name = s.Name
}).ToList <StatusViewModel>();
}
if (status.Count == 0)
{
return(NotFound());
}
return(Ok(status));
}
/// <summary>
/// Create and Edit Task
/// </summary>
/// <param name="task"></param>
/// <returns></returns>
public IHttpActionResult PostTasks(TasksViewModel task)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data."));
}
using (var model = new DataModelToDo())
{
var existingtask = model.Tasks.Where(s => s.Id == task.Id).FirstOrDefault <Tasks>();
if (existingtask != null)
{
existingtask.Name = task.Name;
existingtask.Description = task.Description;
existingtask.idStatus = task.idStatus;
existingtask.idUsers = task.idUsers;
model.SaveChanges();
}
else if (task.Id == 0)
{
model.Tasks.Add(new Tasks()
{
Name = task.Name,
Description = task.Description,
idStatus = task.idStatus,
idUsers = task.idUsers
});
}
else
{
return(NotFound());
}
model.SaveChanges();
}
return(Ok());
}
/// <summary>
/// Get Users
/// </summary>
/// <returns></returns>
public IHttpActionResult GetAllUser()
{
IList <UsersViewModel> users = null;
using (var model = new DataModelToDo())
{
users = model.Users.Include("Users")
.Select(s => new UsersViewModel()
{
Id = s.Id,
Name = s.Name,
Email = s.Email,
PhoneNumber = s.PhoneNumber
}).ToList <UsersViewModel>();
}
if (users.Count == 0)
{
return(NotFound());
}
return(Ok(users));
}
/// <summary>
/// Create and Edit User
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public IHttpActionResult PostUser(UsersViewModel user)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data."));
}
using (var model = new DataModelToDo())
{
var existingUser = model.Users.Where(s => s.Id == user.Id).FirstOrDefault <Users>();
if (existingUser != null)
{
existingUser.Name = user.Name;
existingUser.Email = user.Email;
existingUser.PhoneNumber = user.PhoneNumber;
}
else if (user.Id == 0)
{
model.Users.Add(new Users()
{
Name = user.Name,
Email = user.Email,
PhoneNumber = user.PhoneNumber
});
}
else
{
return(NotFound());
}
model.SaveChanges();
}
return(Ok());
}
/// <summary>
/// Get User For Id
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public IHttpActionResult GetUserById(int id)
{
UsersViewModel user = null;
using (var model = new DataModelToDo())
{
user = model.Users
.Where(s => s.Id == id)
.Select(s => new UsersViewModel()
{
Id = s.Id,
Name = s.Name,
Email = s.Email,
PhoneNumber = s.PhoneNumber
}).FirstOrDefault <UsersViewModel>();
}
if (user == null)
{
return(NotFound());
}
return(Ok(user));
}
/// <summary>
/// Get Tasks by Id
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public IHttpActionResult GetAllTasks(int id)
{
TasksViewModel tasks = null;
using (var model = new DataModelToDo())
{
tasks = model.Tasks.Include("status").Include("users")
.Where(s => s.Id == id)
.Select(s => new TasksViewModel()
{
Id = s.Id,
Name = s.Name,
Description = s.Description,
idStatus = s.idStatus,
Status = s.Status == null ? null : new StatusViewModel()
{
Id = s.Status.Id,
Name = s.Status.Name
},
idUsers = s.idUsers,
Users = s.Users == null ? null : new UsersViewModel()
{
Id = s.Users.Id,
Name = s.Users.Name,
PhoneNumber = s.Users.PhoneNumber,
Email = s.Users.Email,
}
}).FirstOrDefault <TasksViewModel>();
}
if (tasks == null)
{
return(NotFound());
}
return(Ok(tasks));
}
