public IEnumerable <LOGWEBAPP> Get()
{
using (knowhauEntities entities = new knowhauEntities())
{
return(entities.LOGWEBAPPs.ToList());
}
}
public List <HISTORIC> Get(String user)
{
using (knowhauEntities entities = new knowhauEntities())
{
return(entities.HISTORICs.Where(e => e.userMAIL == user).ToList());
}
}
public IEnumerable <HISTORIC> Get()
{
using (knowhauEntities entities = new knowhauEntities())
{
return(entities.HISTORICs.ToList());
}
}
public HttpResponseMessage Put(int contentID, [FromBody] CONTENT CONTENT)
{
try
{
using (knowhauEntities entities = new knowhauEntities())
{
CONTENT entity = new CONTENT();
entity = entities.CONTENTs.FirstOrDefault(e => e.contentID == contentID);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
"Content with id " + contentID.ToString() + " not found to update"));
}
else
{
entity.beaconID = CONTENT.beaconID;
entity.contentID = CONTENT.contentID;
entity.contentmsg = CONTENT.contentmsg;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage Put(String beaconID, [FromBody] BEACON BEACON)
{
try
{
using (knowhauEntities entities = new knowhauEntities())
{
BEACON entity = new BEACON();
entity = entities.BEACONs.FirstOrDefault(e => e.beaconID == beaconID);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
"Beacon with id " + beaconID.ToString() + " not found to update"));
}
else
{
entity.beaconID = BEACON.beaconID;
entity.majorvalue = BEACON.majorvalue;
entity.minorvalue = BEACON.minorvalue;
entity.model = BEACON.model;
entity.name = BEACON.name;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public USERM Get(String name)
{
using (knowhauEntities entities = new knowhauEntities())
{
return(entities.USERMs.FirstOrDefault(e => e.username == name));
}
}
public HttpResponseMessage Delete(int baID)
{
try
{
using (knowhauEntities entities = new knowhauEntities())
{
var entity = entities.BAs.FirstOrDefault(e => e.baID == baID);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
"baID = " + baID.ToString() + " not found to delete"));
}
else
{
entities.BAs.Remove(entity);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public IEnumerable <SUPERADMIN> Get()
{
using (knowhauEntities entities = new knowhauEntities())
{
return(entities.SUPERADMINs.ToList());
}
}
public IEnumerable <CONTENT> Get()
{
using (knowhauEntities entities = new knowhauEntities())
{
return(entities.CONTENTs.ToList());
}
}
public HttpResponseMessage Put(String beaconID, [FromBody] BA BA)
{
try
{
using (knowhauEntities entities = new knowhauEntities())
{
var entity = entities.BAs.FirstOrDefault(e => e.beaconID == beaconID);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
"Beacon with id " + beaconID.ToString() + " not found to update"));
}
else
{
entity.beaconID = BA.beaconID;
entity.adminemail = BA.adminemail;
entity.baID = BA.baID;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public IEnumerable <BA> Get()
{
using (knowhauEntities entities = new knowhauEntities())
{
return(entities.BAs.ToList());
}
}
public bool Get(String name, String passwd)
{
using (knowhauEntities entities = new knowhauEntities())
{
if (entities.SUPERADMINs.FirstOrDefault(e => e.email == name) != null)
{
if (entities.SUPERADMINs.FirstOrDefault(e => e.email == name).email == name && entities.SUPERADMINs.FirstOrDefault(e => e.email == name).password == passwd)
{
return(true);
}
else
{
return(false);
}
}
else if (entities.SUPERADMINs.FirstOrDefault(e => e.username == name) != null)
{
if (entities.SUPERADMINs.FirstOrDefault(e => e.username == name).username == name && entities.SUPERADMINs.FirstOrDefault(e => e.username == name).password == passwd)
{
return(true);
}
else
{
return(false);
}
}
return(false);
}
}
public HttpResponseMessage Put(String email, [FromBody] SUPERADMIN SUPERADMIN)
{
try
{
using (knowhauEntities entities = new knowhauEntities())
{
var entity = entities.SUPERADMINs.FirstOrDefault(e => e.email == email);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
"SUPERADMIN with email " + email.ToString() + " not found to update"));
}
else
{
entity.email = SUPERADMIN.email;
entity.name = SUPERADMIN.name;
entity.password = SUPERADMIN.password;
entity.username = SUPERADMIN.username;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public SUPERADMIN Get(String email)
{
using (knowhauEntities entities = new knowhauEntities())
{
return(entities.SUPERADMINs.FirstOrDefault(e => e.email == email));
}
}
public SUPERADMIN GetByName(String username)
{
using (knowhauEntities entities = new knowhauEntities())
{
return(entities.SUPERADMINs.FirstOrDefault(e => e.username == username));
}
}
public HttpResponseMessage Delete(String email)
{
try
{
using (knowhauEntities entities = new knowhauEntities())
{
var entity = entities.SUPERADMINs.FirstOrDefault(e => e.email == email);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
"SuperAdmin with email = " + email.ToString() + " not found to delete"));
}
else
{
entities.SUPERADMINs.Remove(entity);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public BEACON Get(String id)
{
using (knowhauEntities entities = new knowhauEntities())
{
return(entities.BEACONs.FirstOrDefault(e => e.beaconID == id));
}
}
/* public HttpResponseMessage Post(USERM utilizador)
* {
* HttpResponseMessage result;
* if (ModelState.IsValid)
* {
* using (knowhauEntities db = new knowhauEntities())
* {
* db.USERMs.Add(utilizador);
* db.SaveChanges();
* }
* result = Request.CreateResponse(HttpStatusCode.Created, utilizador);
* }
* else
* {
* result = Request.CreateResponse(HttpStatusCode.BadRequest, "Server failed to save data");
* }
* return result;
* }*/
public HttpResponseMessage Put(String email, [FromBody] USERM utilizador)
{
try
{
using (knowhauEntities entities = new knowhauEntities())
{
var entity = entities.USERMs.FirstOrDefault(e => e.email == email);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
"Utilizador with email " + email.ToString() + " not found to update"));
}
else
{
entity.birthdate = utilizador.birthdate;
entity.email = utilizador.email;
entity.genre = utilizador.genre;
entity.name = utilizador.name;
entity.password = utilizador.password;
entity.username = utilizador.username;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public CONTENT Get(int id)
{
using (knowhauEntities entities = new knowhauEntities())
{
return(entities.CONTENTs.FirstOrDefault(e => e.contentID == id));
}
}
public HttpResponseMessage Delete(String email)
{
try
{
using (knowhauEntities entities = new knowhauEntities())
{
var entity = entities.USERMs.FirstOrDefault(e => e.email == email);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
"User with email = " + email.ToString() + " not found to delete"));
}
else
{
var entity2 = entities.HISTORICs.FirstOrDefault(e => e.userMAIL == entity.email);
while (entity2 != null)
{
entities.HISTORICs.Remove(entity2);
entities.SaveChanges();
entity2 = entities.HISTORICs.FirstOrDefault(e => e.userMAIL == entity.email);
}
entities.USERMs.Remove(entity);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public IEnumerable <USERM> Get()
{
using (knowhauEntities entities = new knowhauEntities())
{
return(entities.USERMs.ToList());
}
}
public HttpResponseMessage Delete(String beaconID, string admin)
{
try
{
using (knowhauEntities entities = new knowhauEntities())
{
var entity = entities.BEACONs.FirstOrDefault(e => e.beaconID == beaconID);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
"beaconID = " + beaconID.ToString() + " not found to delete"));
}
else
{
var entity3 = entities.CONTENTs.FirstOrDefault(e => e.beaconID == entity.beaconID);
var entity4 = entities.HISTORICs.FirstOrDefault(e => e.contentID == entity3.contentID);
while (entity4 != null)
{
entities.HISTORICs.Remove(entity4);
entities.SaveChanges();
entity4 = entities.HISTORICs.FirstOrDefault(e => e.contentID == entity3.contentID);
}
while (entity3 != null)
{
entities.CONTENTs.Remove(entity3);
entities.SaveChanges();
entity3 = entities.CONTENTs.FirstOrDefault(e => e.beaconID == entity.beaconID);
}
var entity2 = entities.BAs.FirstOrDefault(e => e.beaconID == entity.beaconID);
while (entity2 != null)
{
entities.BAs.Remove(entity2);
entities.SaveChanges();
entity2 = entities.BAs.FirstOrDefault(e => e.beaconID == entity.beaconID);
}
entities.BEACONs.Remove(entity);
entities.SaveChanges();
BA id = new BA();
//id=entities.BAs.FirstOrDefault(e => e.beaconID == beaconID);
LOGWEBAPP web = new LOGWEBAPP();
web.date = DateTime.Now;
web.eventtype = "D";
web.username = admin;
entities.LOGWEBAPPs.Add(web);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage Post([FromBody] BA ba)
{
try
{
using (knowhauEntities entities = new knowhauEntities())
{
entities.BAs.Add(ba);
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, ba);
message.Headers.Location = new Uri(Request.RequestUri +
ba.baID.ToString());
return(message);
}
}
catch (DbEntityValidationException ex)
{
// Retrieve the error messages as a list of strings.
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
// Join the list to a single string.
var fullErrorMessage = string.Join("; ", errorMessages);
// Combine the original exception message with the new one.
var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage);
// Throw a new DbEntityValidationException with the improved exception message.
throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors);
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage Post([FromBody] BEACON beacon, String admin, String mensagem, int super)
{
try
{
HttpConfiguration config = GlobalConfiguration.Configuration;
config.Formatters.JsonFormatter
.SerializerSettings
.ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore;
using (knowhauEntities entities = new knowhauEntities())
{
LOGWEBAPP web = new LOGWEBAPP();
web.date = DateTime.Now;
web.eventtype = "I";
web.username = admin;
if (super == 0)
{
BA id = new BA();
id.beaconID = beacon.beaconID;
id.adminemail = admin;
entities.BAs.Add(id);
}
CONTENT cont = new CONTENT();
cont.beaconID = beacon.beaconID;
cont.contentmsg = mensagem;
entities.BEACONs.Add(beacon);
entities.CONTENTs.Add(cont);
entities.LOGWEBAPPs.Add(web);
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, beacon);
message.Headers.Location = new Uri(Request.RequestUri +
beacon.name.ToString());
return(message);
}
}
catch (DbEntityValidationException ex)
{
// Retrieve the error messages as a list of strings.
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
// Join the list to a single string.
var fullErrorMessage = string.Join("; ", errorMessages);
// Combine the original exception message with the new one.
var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage);
// Throw a new DbEntityValidationException with the improved exception message.
throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors);
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
