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