public bool UpdateLogin(SecUsuario usuario) { using (var scope = _database.GetTransaction()) { _database.Update(usuario, new string[] { "lastlogin" }); scope.Complete(); } return(true); }
public bool Insert(SecUsuario usuario) { using (var scope = _database.GetTransaction()) { _database.Insert("SecUsuario", "id", true, usuario); PersistRoles(usuario); scope.Complete(); } return(true); }
public bool Update(SecUsuario usuario) { using (var scope = _database.GetTransaction()) { _database.Update(usuario, new string[] { "idnegocio", "idpais", "activo" }); _database.Execute("delete from SecRolUsuario where idsecusuario=@0", usuario.Id); PersistRoles(usuario); scope.Complete(); } return(true); }
private void PersistRoles(SecUsuario usuario) { if (usuario.Roles != null && usuario.Roles.Count > 0) { foreach (var rol in usuario.Roles) { if (!string.IsNullOrEmpty(rol.Codigo) && rol.Id != 0) { _database.Execute("insert into SecRolUsuario (idsecusuario, idsecrol) values (@0, @1)", usuario.Id, rol.Id); } else { throw new ApplicationException(string.Format("Usuario {0} con roles invalidos", usuario.Username)); } } } }
public SecRol Map(SecRol rol, SecUsuario usuario) { // Terminating call. Since we can return null from this function // we need to be ready for PetaPoco to callback later with null // parameters if (rol == null) { return(current); } // Is this the same tag as the current one we're processing if (current != null && current.Id == rol.Id) { // Yes, just add this usuario to the current tag's collection of articles if (usuario != null) { current.Usuarios.Add(usuario); } // Return null to indicate we're not done with this tag yet return(null); } // This is a different tag to the current one, or this is the // first time through and we don't have an tag yet // Save the current tag var prev = current; // Setup the new current tag current = rol; if (usuario != null && usuario.Id != int.MinValue) { current.Usuarios.Add(usuario); } return(prev); }
public SecUsuario Map(SecUsuario usuario, SecRol rol) { // Terminating call. Since we can return null from this function // we need to be ready for PetaPoco to callback later with null // parameters if (usuario == null) { return(current); } // Is this the same usuario as the current one we're processing if (current != null && current.Id == usuario.Id) { // Yes, just add this tag to the current usuario's collection of tags current.Roles.Add(rol); // Return null to indicate we're not done with this usuario yet return(null); } // This is a different author to the current one, or this is the // first time through and we don't have an author yet // Save the current author var prev = current; // Setup the new current author current = usuario; if (rol.Id != 0) { current.Roles.Add(rol); } //current.Tags = new List<Tag>(); //current.posts.Add(p); // Return the now populated previous author (or null if first time through) return(prev); }