public IHttpActionResult AddPlansUser(int id, int plan_id, int qnt, string document)
{
QoalaEntities db = new QoalaEntities();
User u = DAO.User.findById(db, id);
if (u == null)
{
return(NotFound());
}
Plan plan = Plan.Find(plan_id);
if (plan == null)
{
return(NotFound());
}
if (plan.LEFT < qnt)
{
return(BadRequest());
}
u.ID_PLAN = plan_id;
u.DOCUMENT = document;
db.Entry(u).State = EntityState.Modified;
db.SaveChanges();
plan.LEFT = plan.LEFT - qnt;
db.Entry(plan).State = EntityState.Modified;
db.SaveChanges();
return(Ok(u.Serializer()));
}
public IHttpActionResult Update(decimal id, User user)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
using (QoalaEntities db = new QoalaEntities())
{
User u = DAO.User.findById(db, id);
if (u == null)
{
return(NotFound());
}
user.ID_USER = id;
if (user.EMAIL == null)
{
user.EMAIL = u.EMAIL;
}
if (user.NAME == null)
{
user.NAME = u.NAME;
}
if (user.PASSWORD == null)
{
user.PASSWORD = u.PASSWORD;
}
if (user.PERMISSION == 0)
{
user.PERMISSION = u.PERMISSION;
}
if (user.ADDRESS == null)
{
user.ADDRESS = u.ADDRESS;
}
if (user.DISTRICT == null)
{
user.DISTRICT = u.DISTRICT;
}
if (user.CITY == null)
{
user.CITY = u.CITY;
}
if (user.STATE == null)
{
user.STATE = u.STATE;
}
if (user.ZIPCODE == null)
{
user.ZIPCODE = u.ZIPCODE;
}
user.Update(db);
return(StatusCode(HttpStatusCode.NoContent));
}
}
public IHttpActionResult Create(INFOCOMPANY info)
{
using (var db = new QoalaEntities())
{
info.Add(db);
}
return(Created("", info));
}
public IHttpActionResult Update(string key, INFOCOMPANY info)
{
using (var db = new QoalaEntities())
{
info.Update(db);
return(StatusCode(HttpStatusCode.NoContent));
}
}
public void ConnectionEntity()
{
using (var data = new QoalaEntities())
{
//var i = data.Database.ExecuteSqlCommand("select sysdate from dual");
var i = data.Database.SqlQuery <DateTime>("select sysdate from dual");
var lista = i.ToList();
Assert.AreEqual(1, lista.Count());
}
}
public IHttpActionResult Get(decimal id)
{
using (QoalaEntities db = new QoalaEntities())
{
User user = DAO.User.findById(db, id);
if (user == null)
{
return(NotFound());
}
return(Ok(user.Serializer()));
}
}
public IHttpActionResult Delete(decimal id)
{
using (QoalaEntities db = new QoalaEntities())
{
User user = DAO.User.findById(db, id);
if (user == null)
{
return(NotFound());
}
user.Delete(db);
return(StatusCode(HttpStatusCode.NoContent));
}
}
public IHttpActionResult Delete(string key)
{
using (var db = new QoalaEntities())
{
INFOCOMPANY p = INFOCOMPANY.findByKey(db, key);
if (p == null)
{
return(NotFound());
}
p.Delete(db);
return(StatusCode(HttpStatusCode.NoContent));
}
}
public IHttpActionResult GetInfoCompany(string key)
{
using (var db = new QoalaEntities())
{
var info = INFOCOMPANY.findByKey(db, key);
if (info == null)
{
return(NotFound());
}
return(Ok(new
{
key = info.KEY,
value = info.VALUE,
}));
}
}
public IHttpActionResult GetUsers(int page = 1)
{
using (QoalaEntities db = new QoalaEntities())
{
var totalNumberPage = DAO.User.totalNumberPage(db);
var data = new
{
users = DAO.User.All(db, page),
pagination = new
{
total_number_pages = totalNumberPage,
next_page = totalNumberPage > page,
current_page = page,
previous_page = page > 1 && page <= totalNumberPage
}
};
return(Ok(data));
}
}
public IHttpActionResult GetInfos(int page = 1)
{
using (var db = new QoalaEntities())
{
List <object> infos = INFOCOMPANY.All(db, page);
var totalNumberPage = INFOCOMPANY.totalNumberPage(db);
return(Ok(
new
{
infos = infos,
pagination = new
{
total_number_pages = totalNumberPage,
next_page = totalNumberPage > page,
current_page = page,
previous_page = page > 1 && page <= totalNumberPage
}
}
));
}
}
