public IHttpActionResult PutTodo(int id, Todo todo)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != todo.ID)
{
return(BadRequest());
}
db.Entry(todo).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!TodoExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult SignUp([FromBody] SignUpRequest signUpUser)
{
try
{
//Check request body object
if (signUpUser == null)
{
return(BadRequest("Request bosy can not be empty!"));
}
//Check username
var user = db.User.FirstOrDefault(u => u.UserName == signUpUser.UserName.Trim());
if (user != null)
{
if (user.Status == (byte)StatusType.Active)
{
return(StatusCode(409, "The username is already using"));
}
else
{
user.Status = (byte)StatusType.Active;
user.FullName = signUpUser.UserName;
user.ModifierBy = signUpUser.UserName;
user.UpdatedDate = Utils.GetUnixTimeNow();
user.Password = Utils.EncodePassword(signUpUser.Password);
db.SaveChanges();
return(Ok(user));
}
}
else
{
//Create new user
var newUser = new User()
{
CreatedDate = Utils.GetUnixTimeNow(),
FullName = signUpUser.FullName,
ModifierBy = signUpUser.UserName,
OwnerBy = signUpUser.UserName,
Password = Utils.EncodePassword(signUpUser.Password),
Status = (byte)StatusType.Active,
UpdatedDate = Utils.GetUnixTimeNow(),
UserName = signUpUser.UserName
};
db.User.Add(newUser);
db.SaveChanges();
return(Ok(newUser));
}
}
catch (Exception ex)
{
return(StatusCode(500, ex.Message));
}
}
public IHttpActionResult PostCategory(Category category)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Categories.Add(category);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = category.ID }, category));
}
public bool remove(int id)
{
var results = todoListDBContext.Comment.Find(id);
todoListDBContext.Comment.Remove(results);
todoListDBContext.SaveChanges();
if (todoListDBContext.Comment.Find(id) == null)
{
return(true);
}
return(false);
}
public Work addEmployee(int idEmployee, int idWork)
{
WorkEmployee workEmployee = new WorkEmployee();
workEmployee.IdEmployee = idEmployee;
workEmployee.IdWork = idWork;
todoListDBContext.WorkEmployee.Add(workEmployee);
todoListDBContext.SaveChanges();
var result = todoListDBContext.Work.Find(idWork);
var workList = todoListDBContext.WorkList.Find(result.IdWorkList);
var workListEmployeeExist = from wle in todoListDBContext.WorkListEmployee
where wle.IdWorkList == result.IdWorkList && wle.IdEmployee == idEmployee
select wle;
if (workListEmployeeExist.Count() > 0)
{
return(result);
}
WorkListEmployee workListEmployee = new WorkListEmployee();
workListEmployee.IdWorkList = workList.Id;
workListEmployee.IdEmployee = idEmployee;
todoListDBContext.WorkListEmployee.Add(workListEmployee);
todoListDBContext.SaveChanges();
return(result);
}
public ActionResult AddListType([FromBody] ListType listType)
{
try
{
var token = new ClaimPrincipal(HttpContext.User);
BaseResponse response = new BaseResponse();
User user = db.User.FirstOrDefault(u => u.UserName == token.NameIdentifier);
if (user == null)
{
response.Message = "The user not found!";
return(NotFound(response));
}
//Create list type
var newListType = new ListType()
{
CreatedDate = Utils.GetUnixTimeNow(),
Description = listType.Description,
ModifierBy = user.UserName,
OwnerBy = user.UserName,
Status = (byte)StatusType.Active,
UpdatedDate = Utils.GetUnixTimeNow(),
Name = listType.Name
};
db.ListType.Add(newListType);
db.SaveChanges();
//Create user list type
var userListType = new UserListType()
{
ListTypeId = newListType.Id,
ModifierBy = user.UserName,
OwnerBy = user.OwnerBy,
Status = (byte)StatusType.Active,
UpdatedDate = Utils.GetUnixTimeNow(),
CreatedDate = Utils.GetUnixTimeNow(),
UserId = user.Id
};
db.UserListType.Add(userListType);
db.SaveChanges();
response.Message = "The list type added successfully";
return(Ok(response));
}
catch (Exception ex)
{
return(StatusCode(500, ex.Message));
}
}
public Employee save(Employee employee)
{
if (employee.Id == 0)
{
var result = todoListDBContext.Employee.Add(employee);
todoListDBContext.SaveChanges();
return(result.Entity);
}
else
{
Employee findResult = todoListDBContext.Employee.Find(employee.Id);
findResult.Password = employee.Password;
findResult.FullName = employee.FullName;
findResult.PhoneNumber = employee.PhoneNumber;
findResult.IdRole = employee.IdRole;
todoListDBContext.SaveChanges();
return(todoListDBContext.Employee.Find(employee.Id));
}
}
public WorkList addEmployee(int idWorkList, int idEmployee)
{
WorkListEmployee workListEmployee = new WorkListEmployee();
workListEmployee.IdWorkList = idWorkList;
workListEmployee.IdEmployee = idEmployee;
var result = todoListDBContext.WorkListEmployee.Add(workListEmployee);
todoListDBContext.SaveChanges();
return(todoListDBContext.WorkList.Find(idWorkList));
}
