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