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