public IEnumerable <user> Get()
{
using (errorkbEntities1 entities = new errorkbEntities1())
{
return(entities.users.ToList());
}
}
public IHttpActionResult PutNewUser(string oldUsername, string newUsername, string newPriv)
{
using (errorkbEntities1 entities = new errorkbEntities1())
{
if (newPriv == "user" || newPriv == "admin")
{
var existingUser = entities.users.Where(s => s.username == oldUsername).FirstOrDefault();
if (existingUser != null)
{
existingUser.username = newUsername;
existingUser.privileges = newPriv;
entities.SaveChanges();
}
else
{
return(NotFound());
}
return(Ok());
}
return(Content(HttpStatusCode.BadRequest, "Any object"));
}
}
public user Get(string uname, string password)
{
using (errorkbEntities1 entities = new errorkbEntities1())
{
var user = entities.users.Where(e => e.username == uname && e.passwd == Encrypt(password)).FirstOrDefault();
return(user);
}
}
public IHttpActionResult DeleteUser(string username)
{
using (errorkbEntities1 entities = new errorkbEntities1())
{
var users = entities.users.Where(s => s.username == username).FirstOrDefault();
entities.Entry(users).State = System.Data.Entity.EntityState.Deleted;
entities.SaveChanges();
return(Ok());
}
}
public IHttpActionResult GetAllUsers()
{
IList <UserViewModel> entries = null;
using (errorkbEntities1 entities = new errorkbEntities1())
{
entries = entities.users.Select(e => new UserViewModel()
{
u_id = e.u_id,
username = e.username,
passwd = e.passwd,
privileges = e.privileges
}
).ToList <UserViewModel>();
}
if (entries.Count == 0)
{
return(NotFound());
}
return(Ok(entries));
}
public IHttpActionResult GetUser(string username, string password)
{
password = Encrypt(password);
IList <UserViewModel> entries = null;
using (errorkbEntities1 entities = new errorkbEntities1())
{
entries = entities.users.Select(e => new UserViewModel()
{
u_id = e.u_id,
username = e.username,
passwd = e.passwd,
privileges = e.privileges
}
).Where(e => e.username == username && e.passwd == password).ToList <UserViewModel>();
}
if (entries.Count == 0)
{
return(NotFound());
}
return(Ok(entries));
}
public IHttpActionResult PostNewUser(string username, string password, string priv)
{
using (errorkbEntities1 entities = new errorkbEntities1())
{
if (priv == "user" || priv == "admin")
{
password = Encrypt(password);
entities.users.Add(new user()
{
username = username,
passwd = password,
privileges = priv
});
entities.SaveChanges();
return(Ok());
}
else
{
return(Content(HttpStatusCode.BadRequest, "Any object"));
}
}
}
