//PUT public IHttpActionResult UpdateUser(User user) { if (!ModelState.IsValid) { return(BadRequest("Informacioni i deleguar eshte i pavlefshem. Kontrolloje dhe provo perseri!")); } using (XMCEntities db = new XMCEntities()) { var checkExistingUser = db.XMCUsers.Where(u => u.XMCUsers_Id == user.Id).FirstOrDefault <XMCUser>(); if (checkExistingUser != null) { checkExistingUser.Users_Full_Name = user.Full_Name; checkExistingUser.Users_Email = user.Email; checkExistingUser.Users_Username = user.Username; checkExistingUser.Users_Description = user.Description; checkExistingUser.Users_Password = user.Password; checkExistingUser.XMCPozicion_Id = user.PozicionId; db.SaveChanges(); } else { return(NotFound()); } return(Ok()); } }
public IHttpActionResult GetAllPositions() { IList <Pozicion> positions = null; using (XMCEntities db = new XMCEntities()) { positions = db.XMCPozicions.Select(p => new Pozicion() { Id = p.XMCPozicion_Id, Name = p.Pozicion_Name, Description = p.Pozicion_Description }).ToList <Pozicion>(); } return(Ok(positions)); }
//DELETE public IHttpActionResult DeleteUser(int id = 0) { if (id <= 0) { return(BadRequest("Ju lutem percaktoni id, perpara se te konsumoni kete sherbim!")); } using (XMCEntities db = new XMCEntities()) { var user = db.XMCUsers.Where(u => u.XMCPozicion_Id == id).FirstOrDefault(); db.Entry(user).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); } return(Ok()); }
//GET public IHttpActionResult GetAllUsers() { IList <User> users = null; using (XMCEntities db = new XMCEntities()) { users = db.XMCUsers.Select(u => new User() { Id = u.XMCUsers_Id, Full_Name = u.Users_Full_Name, Email = u.Users_Email, Description = u.Users_Description, Username = u.Users_Username, Password = u.Users_Password, PozicionId = u.XMCPozicion_Id } ).ToList <User>(); return(Ok(users)); } }
public IHttpActionResult GetAllTasks() { IList <Tasks> tasks = null; using (XMCEntities db = new XMCEntities()) { tasks = db.XMCTasks.Select(t => new Tasks() { XMCTask_Id = t.XMCTask_Id, Task_Name = t.Task_Name, Task_Description = t.Task_Description, Creator_Id = t.Creator_Id, Referencer_Id = t.Referencer_Id, XMCPune_Id = t.XMCPune_Id, XMCProjekt_Id = t.XMCProjekt_Id, XMCTipologjia_Id = t.XMCTipologjia_Id }).ToList <Tasks>(); return(Ok(tasks)); } }
public IHttpActionResult PostNewUser([FromBody] User user) { if (!ModelState.IsValid) { return(BadRequest("Invalid")); } try { using (XMCEntities db = new XMCEntities()) { db.XMCUsers.Add(new XMCUser() { Users_Full_Name = user.Full_Name, Users_Email = user.Email, Users_Username = user.Username, Users_Description = user.Description, Users_Password = user.Password, XMCPozicion_Id = user.PozicionId, }); db.SaveChanges(); } } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { System.Diagnostics.Debug.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } return(Ok()); }
public IHttpActionResult PostNewTask(Tasks tasks) { if (!ModelState.IsValid) { return(BadRequest("Invalid data!")); } try { using (XMCEntities db = new XMCEntities()) { db.XMCTasks.Add(new XMCTask() { Task_Name = tasks.Task_Name, Task_Description = tasks.Task_Description, Creator_Id = tasks.Creator_Id, Referencer_Id = tasks.Referencer_Id, XMCPune_Id = tasks.XMCPune_Id, XMCProjekt_Id = tasks.XMCProjekt_Id, XMCTipologjia_Id = tasks.XMCTipologjia_Id }); db.SaveChanges(); } } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { System.Diagnostics.Debug.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } return(Ok()); }
public IHttpActionResult GetUserTasks(int userId) { IList <Tasks> tasks = null; using (XMCEntities db = new XMCEntities()) { tasks = db.XMCTasks.Select(t => new Tasks() { XMCTask_Id = t.XMCTask_Id, Task_Name = t.Task_Name, Task_Description = t.Task_Description, Creator_Id = t.Creator_Id, Referencer_Id = t.Referencer_Id, XMCPune_Id = t.XMCPune_Id, XMCProjekt_Id = t.XMCProjekt_Id, XMCTipologjia_Id = t.XMCTipologjia_Id }).ToList <Tasks>(); var usersTasks = from t in tasks where t.Creator_Id == userId select t; return(Ok(usersTasks)); } }