public void AddPlan(int QntPlans) { QoalaEntities qe = new QoalaEntities(); qe.Entry(this).State = EntityState.Modified; qe.SaveChanges(); Plan p = qe.PLANS.Find(ID_PLAN); p.LEFT = p.LEFT - QntPlans; qe.Entry(p).State = EntityState.Modified; qe.SaveChanges(); }
public void Update(QoalaEntities db) { var info = findByKey(db, this.KEY); info.VALUE = this.VALUE; db.SaveChanges(); }
// this may should be on ACCESSCONTROL class public AccessControl doLogin(QoalaEntities context) { User user = findByEmail(context, EMAIL); if (user != null && user.PASSWORD.Equals(PASSWORD)) { AccessControl access = null; //ja teve sessões, busca uma ativa if (user.ACCESSCONTROLs.Count() > 0) { // melhoria: Adicionar Client ID. e cada tipo de aplicação deverá passar um ClientID para o login, e filtrar aqui. access = user.ACCESSCONTROLs.FirstOrDefault(ac => ac.EXPIRED_AT >= DateTime.Now); } if (access == null) { access = new AccessControl { USER = user }; access.Add(context); context.SaveChanges(); } return(access); } return(null); }
public void UserAdd() { using (var qe = new QoalaEntities()) { //USER.findByEmail(qe, "email").Delete(qe); //qe.SaveChanges(); User u = new User { NAME = "teste", EMAIL = "email", PASSWORD = "******" }; u.Add(qe); qe.SaveChanges(); //Assert.AreNotEqual(0m, u.ID_USER, "Usuario nao foi criado"); u.Delete(qe); qe.SaveChanges(); } }
public void Update() { using (QoalaEntities qe = new QoalaEntities()) { qe.Entry(this).State = System.Data.Entity.EntityState.Modified; qe.SaveChanges(); } }
public void Add() { using (QoalaEntities qe = new QoalaEntities()) { this.CREATED_AT = DateTime.Now; this.TOTAL = LEFT; qe.PLANS.Add(this); qe.SaveChanges(); } }
public bool Delete(QoalaEntities context) { this.Logger().Debug("delete ACCESSCONTROL(" + TOKEN + ") for user: " + this.USER.ToString()); // Do not remove this entity, just update with expired now //context.ACCESSCONTROLs.Remove(this); this.EXPIRED_AT = DateTime.Now; context.Entry(this).State = EntityState.Modified; context.SaveChanges(); return(find(context, TOKEN) == null); }
public AccessControl Add(QoalaEntities context) { this.Logger().Debug("add ACCESSCONTROL for user: "******"-" + USER.ID_USER.ToString(); // TODO: make the number to addDays configured by USER configuration ou SYSTEM configuration EXPIRED_AT = DateTime.Now.AddDays(7); CREATED_AT = DateTime.Now; context.ACCESSCONTROLs.Add(this); context.SaveChanges(); return(this); }
public void UserHasBeenTaken() { using (var qe = new QoalaEntities()) { var email = "abc@abc2"; User u = new User { NAME = "teste", EMAIL = email, PASSWORD = "******" }; u.Add(qe); qe.SaveChanges(); Assert.IsTrue(User.emailAlreadyExist(qe, email)); } }
public void UserDelete() { using (var qe = new QoalaEntities()) { User u = User.findByEmail(qe, "email"); if (u != null) { u.Delete(qe); qe.SaveChanges(); Assert.AreEqual(0, qe.USERS.Count(a => a.ID_USER == u.ID_USER)); } } }
public void UserUpdate() { using (var qe = new QoalaEntities()) { User u = User.findByEmail(qe, "email"); if (u != null) { u.NAME = "Teste Atualizado"; var ret = u.Update(qe); qe.SaveChanges(); Assert.AreNotEqual(0, u.ID_USER); } } }
public void UserDeletedWithSameEmailNotHasTaken() { using (var qe = new QoalaEntities()) { var email = "abcc@abcc"; User u = new User { NAME = "teste", EMAIL = email, PASSWORD = "******" }; u.Add(qe); qe.SaveChanges(); u.DELETED_AT = DateTime.Now; u.Update(qe); Assert.IsFalse(User.emailAlreadyExist(qe, email)); } }
public void Delete(QoalaEntities db) { db.INFOCOMPANies.Remove(this); db.SaveChanges(); }
public void Add(QoalaEntities db) { db.INFOCOMPANies.Add(this); db.SaveChanges(); }